HomeMy WebLinkAbout2015-09-02 Special Meeting Budget Workshop agenda packet
BOARD OF DIRECTORS
Special Meeting
TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1
100 MUNICIPAL DRIVE
TROPHY CLUB, TEXAS 76262
September 2, 2015 10:00 A.M. Svore Municipal Boardroom
SPECIAL SESSION
CALL TO ORDER AND ANNOUNCE A QUORUM
SPECIAL SESSION
1. Consider and take appropriate action to approve bid and award a contract for the Solana
Waterline Relocation project and authorize General Manager to execute necessary documents.
2. Consider and take appropriate action to rescind contract offer for mowing services to Trophy
Lawns Inc. and award contract to D & D Commercial Landscape Management, and authorize
General Manager to execute all necessary documents.
attachment: Bid Summary – Lawn mowing
3. Consider and take appropriate action regarding insurance proposals from Texas Municipal League
and Texas Water Conservation Association.
attachment: Indemnification correspondence
FY 2016 Insurance Comparison
4. Consider and take appropriate action to approve Depository Pledge Agreement with Prosperity
Bank as depository bank and the Federal Home Loan Bank of Dallas as custodial bank.
attachment: Depository Pledge Agreement
5. Consider and take appropriate action regarding draft Fiscal Year 2016 budget.
attachment: Draft Budget FY2016
6. Adoption of the 2015 tax year proposed tax rates:
a. Adopt proposed District debt service tax rate;
b. Adopt proposed District maintenance and operation tax rate;
c. Authorize notice and public hearing related to adoption of final tax rates; and
d. Other action related thereto.
ADJOURN
CERTIFICATION
THE STATE OF TEXAS §
COUNTIES OF DENTON AND TARRANT §
THIS CERTIFIES THAT ON AUGUST 28, 2015 BY 4:00 P.M. A COPY OF THE ABOVE NOTICE OF TROPHY CLUB
MUNICIPAL UTILITY DISTRICT NO. 1, BOARD OF DIRECTORS SPECIAL MEETING TO BE HELD ON
Trophy Club Municipal Utility District No. 1 1 of 112 September 2, 2015 - Special Meeting
Agenda Packet
WEDNESDAY, SEPTEMBER 2. 2015 AT 10:00 A.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. A COPY OF THIS NOTICE 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 2 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Lawn Mowing Services
September 2015
SUMMARY
COMPANY NAME BID
Trophy Lawns Inc. ‐ UNABLE TO PROVIDE INSURANCE $24,050.00
D & D Commercial Landscape Management $24,510.00
SCOPE OF SERVICES:
Contract for services in accordance with the following schedule:
Month Number of Mowings
January None
February None
March One per month
April Bi‐weekly
May Bi‐weekly
June Bi‐weekly
July Bi‐weekly
August Bi‐weekly
September Bi‐weekly
October Bi‐weekly
November Bi‐weekly
December None
Contract for services will include 19 mowing events per year at the following sites:
Location
Water Plant
MUD Elevated Tank
PID Elevated Tank
Well #2
Well #4
Lift Station 1
Lift Station 2
Lift Station 3
Lift Station 5
Lift Station 6
Lift Station 7
Lift Station 8
Lift Station 9
Lift Station 20
Trophy Club Municipal Utility District No. 1 3 of 112 September 2, 2015 - Special Meeting
Agenda Packet
1
Laurie Slaght
From:Jennifer McKnight
Sent:Friday, August 28, 2015 8:24 AM
To:Laurie Slaght
Cc:Terri Sisk
Subject:Attachment for Item #3 with summary information attached from last meeting too
From: Talley, Drew [mailto:Drew.Talley@yorkrsg.com]
Sent: Thursday, August 27, 2015 4:22 PM
To: Terri Sisk <tsisk@tcmud.org>
Subject: RE: District Insurance Quote FY 2016
Terri,
I think we’ve found a way around the indemnification clause. It looks like with the combination of the Texas Tort Claims
Act, your Interlocal Agreement and what Patricia stated about the Texas Constitution you have some significant
protections built in if there is a large claim against the district.
We are waiting on the MVR’s to come back in case there is a driver with multiple accidents or speeding tickets, DWI’s
etc. If there is a driver with an issue, then we’ll need to discuss that but we’ll know more tomorrow once they come
back.
Also, have you received your most recent experience modifier from TML? I can’t remember if I asked you about that or
not. We’d like to have that for our file. If you’ve received your renewal quote it should be included in that
information. Please forward if you have, in fact, received it.
Thank you for all of your help Terri, I’m confident that we can make this work. Sorry for all the angst. You’ve been very
patient!
Drew
From: Terri Sisk [mailto:tsisk@tcmud.org]
Sent: Thursday, August 27, 2015 2:17 PM
To: Talley, Drew
Subject: FW: District Insurance Quote FY 2016
Drew,
As you can see below, The Town of Trophy Club is not going to give us the indemnification. As this point, we need to
know if this is a deal breaker. Because if it is, there is no point in us going further in this process. Thank you for all the
hard work you’ve put into this.
Thank you,
Terri Sisk
Administration Manager
Trophy Club Municipal Utility District No. 1
Trophy Club Municipal Utility District No. 1 4 of 112 September 2, 2015 - Special Meeting
Agenda Packet
2
100 Municipal Drive
Trophy Club, TX 76262
682‐831‐4618
Fax 682‐238‐5655
www.tcmud.org
From: Patricia Adams [mailto:padams@trophyclub.org]
Sent: Wednesday, August 26, 2015 4:24 PM
To: Jennifer McKnight <jmcknight@tcmud.org>; Stephen Seidel <sseidel@trophyclub.org>
Cc: Terri Sisk <tsisk@tcmud.org>
Subject: RE: District Insurance Quote FY 2016
Hi Jennifer,
As for the request for indemnification, the Texas Constitution prohibits the Town from indemnifying third parties, so the
Town cannot legally agree to provide indemnification to the MUD. Even if the Council did agree to provide that type of
indemnity, it would not be enforceable against the Town so would not be of benefit to you anyway. I believe that in the
past we have also been advised by MUD lawyers that the MUD can’t legally enter into an indemnification agreement
either, so I don’t know that y’all can agree to that either. Let me know if you want to discuss further.
Thanks,
Patricia
From: Jennifer McKnight [mailto:jmcknight@tcmud.org]
Sent: Wednesday, August 26, 2015 8:58 AM
To: Stephen Seidel; Patricia Adams
Cc: Terri Sisk
Subject: District Insurance Quote FY 2016
Stephen and Patricia:
We obtained a quote this year from another pool like TML called Texas Water Conservation Association Risk pool. Their
rates came in significantly lower than TML but they would require an indemnification from the Town since fire personnel
are Town employees. I asked for what they would need and they sent the following wording:
The Town of Trophy Club shall indemnify and hold Trophy Club MUD, its officers, officials, employees and volunteers
harmless from any and all claims, injuries, damages, losses or suits including attorney fees, arising out of the operation of
the Trophy Club Emergency Services Unit , except for injuries and damages caused by the sole negligence of the MUD to
the extent in which the MUD is legally liable. In turn Trophy Club MUD shall indemnify and hold the Town of Trophy Club,
its officers, employees and volunteers harmless from any and all claims, injuries, damages, losses or suits including
attorney fees, arising out of the operation of the Trophy Club Fire Department, except for injuries and damages caused by
the sole negligence of the MUD to the extent in which the MUD is legally liable.
The Town of Trophy Club agrees to provide Trophy Club MUD proof of coverage for General Liability, Auto Liability and
Workers Compensation. The Town of Trophy Club also agrees that any employee of the Town of Trophy Club who drives
district vehicles meet at least the minimum acceptable driver guidelines to the auto insurance carrier for the Trophy Club
MUD in consideration that the fire department is using MUD vehicles and real property for fire department operations.
Trophy Club Municipal Utility District No. 1 5 of 112 September 2, 2015 - Special Meeting
Agenda Packet
3
Is this something we could obtain from the Town? They said this could be added into the Fire Personnel ILA or could be
provided separately. The board requested I get confirmation that we could get an agreement with the Town before they
decide next Wednesday which way to go. Thank you.
Jennifer
-- Attention: Please note any correspondence, such as e-mail or letters, sent to Town staff or officials may
become a public record and made available for public/media review.
-- Public Officials: A "reply to all" of this e-mail may lead to violations of the Texas Open Meetings Act. Please
reply only to the sender. [020415]
Trophy Club Municipal Utility District No. 1 6 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Coverage TML TWCARMF
Property $1,000 deductible; Listed property value limit 45,835$ $1,000 deductible; Listed property value limit 20,956$
Boiler & Machinery $1,000 deductible; $100,000 per accident limit Included above in Property $1,000 deductible; Listed property value limit 10,832$
Mobile Equipment $500 deductible; Listed property value limit 1,414$ $1,000 deductible; Listed property value limit 213$
Crime $1,000 deductible; $100,000 per employee limit 222$ $1,000 deductible; $100,000 per occurrence limit 1,839$
Forgery or Alteration $1,000 deductible; $100,000 per occurrence limit 38$ $1,000 deductible; $100,000 per occurrence limit Included above in Crime
General Liability $5,000 deductible; $3,000,000 per occurrence limit; $6M total 3,290$ $1,000 deductible; $10,000,000 per occurrence limit; $10M total 3,767$
Errors & Omissions $5,000 deductible; $3,000,000 per occurrence limit; $6M total 1,511$ $1,000 deductible; $10,000,000 per occurrence limit; $10M total 5,783$
Auto Liability $0 deductible; $1,000,000 per occurrence limit; $25,000 medical payment limit each person 6,199$ $1,000 deductible; $10,000,000 per occurrence limit 7,390$
Auto Physical Damage $500 deductible per vehicle; $10,000 deductible each occurrence; liability per vehicle 7,304$ $500 deductible Comp; $500 deductible Collision; ACV limit 10,205$
Worker's Compensation Based on estimated payroll 23,844$ Based on estimated payroll 25,520$
Total 89,657$ 86,505$
* Contract must be put in place between the Town of Trophy Club and TCMUD for hold harmless and indemnification for claims arising from 3rd parties based on who is responsible.
FY 16 INSURANCE COMPARISON
1
Trophy Club Municipal Utility District No. 1 7 of 112 September 2, 2015 - Special Meeting
Agenda Packet
1
DEPOSITORY PLEDGE AGREEMENT
THE STATE OF TEXAS §
COUNTY OF DENTON §
COUNTY OF TARRANT §
This Depository Pledge Agreement (this “Agreement”) is dated this 2nd day of
September, 2015 by and among Prosperity Bank, duly organized and existing under the laws of
the State of Texas (the “Bank”); Federal Home Loan Bank of Dallas, Irving Texas, duly
organized and existing under the laws of the United States of America (the “Custodian”); and
Trophy Club Municipal Utility District No. 1, a political subdivision of the State of Texas,
organized and existing under the Constitution and the laws of the State of Texas (the “District”).
The District, through action of its Board of Directors, hereby designates the Bank as its depository
for banking services for a period of three (3) years commencing on October 1, 2015 through
September 30, 2018. At the discretion of the District, this Agreement may be extended for up to
an additional two (2) year term.
WITNESSETH
WHEREAS, the District has selected the Bank as a depository for certain funds of the
District in demand deposits and/or interest bearing time deposits;
WHEREAS, the Bank has agreed to serve as a depository of the District and has full power
and authority to perform and serve as depository;
WHEREAS, the District from time to time may deposit funds in one or more of the above
described accounts which exceeds the amount insured by the Federal Deposit Insurance
Corporation (the “FDIC”);
WHEREAS, the District is required by law to secure all deposits of funds in excess of the
amount insured by the FDIC. In order to anticipate market change and provide a level of security
for all funds, the Board of Directors of the District requires by policy that the collateralization level
be 102% of the market value of principal and accrued interest on the deposits or investments less
an amount insured by the FDIC;
WHEREAS, the Bank has agreed that all funds secured by a pledge of collateral by the
Bank to the District will be continuously secured by a valid pledge of collateral which under Texas
law can be used to secure deposits of the District;
WHEREAS, the Bank has agreed that the aggregate market value of the collateral shall, at
all times, be in an amount not less than 102% of: (i) the amount on deposit in the Bank increased
by the amount of the accrued interest and (ii) reduced by the amount that the United States or an
instrumentality of the United States insures the deposit;
Trophy Club Municipal Utility District No. 1 8 of 112 September 2, 2015 - Special Meeting
Agenda Packet
2
WHEREAS, the Bank has agreed to place any securities so pledged in a custodial account
for safekeeping at Federal Home Loan Bank of Dallas, Irving Texas, a Federal Reserve Bank,
the Texas Treasury Safekeeping Trust Company, or a state or national bank that is domiciled in
the State of Texas, has a capital stock and permanent surplus of $5,000,000 or more, and is not a
financial institution owned or controlled by the Bank or its holding company;
NOW, THEREFORE, in consideration of the mutual promises and covenants herein
contained, the District and the Bank agree as follows:
ARTICLE I.
PLEDGE OF SECURITIES
SECTION 1.01. PLEDGE OF SECURITIES. The Bank hereby agrees to pledge to the
District authorized investment securities, as hereinafter described, to secure all District funds on
deposit with the Bank in an amount not less than 102% of: (i) the amount on deposit in the Bank
increased by the amount of the accrued interest and (ii) reduced by the amount that the United
States or an instrumentality of the United States insures the deposit.
SECTION 1.02. AUTHORIZED INVESTMENT SECURITIES. Authorized Investment
Securities shall mean and shall only include:
1. obligations of the United States or its agencies and instrumentalities backed by the
full faith and credit of the United States;
2. direct obligations of the State of Texas or its agencies and instrumentalities;
3. collateralized mortgage obligations directly issued by a federal agency or
instrumentality of the United States, the underlying security for which is guaranteed
by an agency or instrumentality of the United States;
4. fixed-rate collateralized mortgage obligations that have an expected weighted
average life of 10 years or less and do not constitute “high-risk mortgage security”
under Chapter 2257.0025 of the Public Funds Collateral Act;
5. a floating-rate collateralized mortgage obligation that does not constitute a “high-
risk mortgage security” under Chapter 2257.0025 of the Public Funds Collateral
Act;
6. other obligations the principal and interest of which are unconditionally guaranteed
or backed by the full faith and credit of the State of Texas or of the United States
or their respective agencies and instrumentalities; and
7. obligations of states, agencies, counties, cities and other political subdivisions of
any state rated as to investment quality by a nationally recognized investment rating
firm of not less than A or its equivalent.
Trophy Club Municipal Utility District No. 1 9 of 112 September 2, 2015 - Special Meeting
Agenda Packet
3
Authorized Investment Securities shall not include:
1. obligations whose payment represents the coupon payments on the outstanding
principal balance of the underlying mortgage-backed security collateral and pays
no principal;
2. obligations whose payment represents the principal stream of cash flow from the
underlying mortgage-backed security collateral and bears no interest;
3. collateralized mortgage obligations that have a final stated maturity date of greater
than (10) years other than those listed herein in this section; and
4. collateralized mortgage obligations the interest rate of which is determined by an
index that adjusts opposite to the changes in a market index.
SECTION 1.03. SUBSTITUTION OF AUTHORIZED INVESTMENT SECURITIES.
The Bank shall have the right to purchase, sell, substitute or replace, any and all of the Authorized
Investment Securities pledged pursuant to this Agreement with like Authorized Investment
Securities, provided, however, that prior to any purchase, sale, substitution or replacement, the
Bank shall send a written notice stating the par value, maturity date and market value on the
proposed date of substitution to the District General Manager, District Finance Manager, and/or
the District Administration Manager or any of their successors. If approved by the District, the
substituted Authorized Investment Securities shall thereafter be subject to all the terms and
conditions of this Agreement.
SECTION 1.04. GRANT OF SECURITY INTEREST. The Bank hereby pledges and
grants to the District a security interest in the Authorized Investment Securities which are held,
now or hereafter, by the Custodian for the benefit of the District in accordance with the terms of
this Agreement. The security interest pledged and granted in the Authorized Investment Securities
is created, attaches and is perfected for all purposes from the time that the Custodian identifies the
Authorized Investment Securities on the Custodian’s books and records and issues the trust receipt.
The security interest in the Authorized Investment Securities remains perfected in the hands of a
subsequent custodian.
ARTICLE II.
DUTIES OF BANK
The Bank shall faithfully perform all of the duties and obligations required by the laws of
the State of Texas for depositories of the District, and shall upon presentation pay all checks drawn
on it by the duly authorized representatives of the District against collected funds of the District
on demand deposit in accordance with the Terms and Conditions of the depository account, and
shall at the expiration of the term for which it has been chosen as depository of the District release
to its successor all funds, property and things of value then on deposit for the District.
ARTICLE III.
Trophy Club Municipal Utility District No. 1 10 of 112 September 2, 2015 - Special Meeting
Agenda Packet
4
CUSTODIAN
SECTION 3.01. APPOINTMENT OF CUSTODIAN. Federal Home Loan Bank of
Dallas, Irving Texas is hereby appointed custodian (the “Custodian”) under the terms of this
Agreement. The Bank shall deposit with the Custodian for safekeeping the Authorized Investment
Securities pledged to the District, and the Custodian shall hold in trust the Authorized Investment
Securities pledged to the District to secure the District’s funds on deposit with the Bank.
SECTION 3.02. AUTHORITY OF CUSTODIAN. Authorized Investment Securities
pledged to the District shall be subject only to the joint written instructions of (a) authorized
individuals of the District as set forth in Exhibit A attached hereto and (b) authorized officers of
the Bank as set forth in Exhibit B attached hereto. The Custodian hereby agrees to hold all
Authorized Investment Securities pledged to the District and deposited with it pursuant to the terms
of this Agreement and to deliver them in accordance with the terms hereof. Additionally, the
Custodian agrees to serve as collateral agent for the District to the extent necessary to allow the
District to perfect its security interest granted herein in the Authorized investment Securities
pledged to the District.
SECTION 3.03. RECEIPTS. On receipt of Authorized Investment Securities pledged to
the District, the Custodian shall immediately identify on its books and records, by book entry or
another method, the Authorized Investment Securities pledged to the District and shall promptly
issue and deliver to the Bookkeeper for the District a receipt for the Authorized Investment
Securities pledged to the District. The Custodian shall identify on its records, by book entry or
other method, any Authorized Investment Security pledged to the District that is substituted and
shall promptly issue and deliver to the District’s Finance Manager a receipt evidencing the
substituted Authorized Investment Securities pledged to the District.
SECTION 3.04. BOOKS AND RECORDS OF CUSTODIAN. The Custodian shall
maintain a separate, accurate and complete record relating to all the Authorized Investment
Securities pledged to the District and each transaction relating to the Authorized Investment
Securities pledged to the District. The District or its agent may examine and verify at any
reasonable time the Authorized Investment Securities pledged to the District or any record that the
Custodian maintains under this Agreement. The District or its agent may inspect at any time the
Authorized Investment Securities pledged to the District evidenced by a trust receipt.
SECTION 3.05. CUSTODIAN AS BAILEE. The Custodian is for all purposes the bailee
or agent of the District.
SECTION 3.06. FEES OF CUSTODIAN. Any and all fees associated with the safekeeping
of Authorized Investment Securities pledged to the District which the Custodian shall charge shall
be borne by the Bank.
ARTICLE IV.
REPORTING REQUIREMENTS
Trophy Club Municipal Utility District No. 1 11 of 112 September 2, 2015 - Special Meeting
Agenda Packet
5
SECTION 4.01. MEMORANDUM DESCRIBING SECURITIES. Upon the execution of
this Agreement and at the time of the substitution or withdrawal of the Authorized Investment
Securities pledged to the District, the Bank shall execute and deliver to the Finance Manager or
the Administration Manager a Memorandum describing the Authorized Investment Securities
pledged to the District and deposited with the Custodian or the Authorized Investment Securities
pledged to the District which have been substituted or withdrawn from the Custodian and held
pursuant to this Agreement.
SECTION 4.02. MONTHLY STATEMENTS. The Bank agrees to furnish to the District
a monthly statement listing a description of the Authorized Investment Securities pledged to the
District held in safekeeping with the Custodian. The statement will include par value, market
value, and maturity date of the Authorized Investment Securities held by the Custodian. The Bank
shall keep such statement on file at all times at the Bank and such statements shall be available for
inspection at the Bank during regular business hours.
SECTION 4.03. DISCLOSURE OF FINANCIAL POSITION. The Bank will provide to
the District a quarterly statement of its financial position.
SECTION 4.04. ANNUAL AUDIT OF BANK. The Bank will provide to the District a
copy of its annual audit performed by an independent auditing firm inclusive of a statement as to
the “fair presentation” of the audit.
SECTION 4.05. DISTRICT AUDIT. As part of the District’s annual audit, the auditor for
the District shall examine and verify the Authorized Investment Securities pledged to the District
and records maintained pursuant to this Agreement all in accordance with Section 2257.025 and
Section 2257.046 of the Public Funds Collateral Act. The auditor shall report any significant or
material noncompliance of this Agreement or the Act to the District.
ARTICLE V.
SCOPE OF SERVICES
The Bank’s response to the District’s RFP, dated May 15th, 2015, (the “Response”) is
incorporated into this Agreement for all purposes, including service charges, time deposit,
demand deposit and loan rates, and attached as Exhibit E. If any provisions of the Response and
this Agreement are in conflict, this Agreement will control.
The Bank shall faithfully perform all of its duties and obligations required by the laws of
the State of Texas for public funds depositories and shall upon presentation pay all checks drawn
on it against collected funds on demand deposits, and shall, at the expiration of the Agreement,
turn over to its successor all funds, District-owned securities, property and things of value held
as depository.
The District shall have the power to determine and designate the character and amount of
the funds to be deposited in the Bank. The District may arrange for time deposits and Bank may
accept such deposits subject to the terms of the Bank’s Response.
Trophy Club Municipal Utility District No. 1 12 of 112 September 2, 2015 - Special Meeting
Agenda Packet
6
This Agreement, along with all Exhibits and other incorporated documents shall
constitute the entire Agreement between the parties.
ARTICLE VI.
REPRESENTATION BY THE BANK
The Bank represents to the District that:
(a) the Bank is the sole legal and actual owner of the Authorized Investment Securities
pledged to the District to collateralize the District’s deposits;
(b) no other security interest has been, nor will be, granted in the Authorized
Investment Securities pledged to the District to collateralize the District’s deposits;
and
(c) the Bank is covered for District deposits up to $250,000 under the Federal Deposit
Insurance Corporation, or such other amount as may be applicable from time to
time.
ARTICLE VII.
BANK COMPENSATION
Bank will be compensated for any and all services rendered to District under this
Agreement as proposed in Response submitted by Bank which indicates a monthly flat fee of
$0.00.
ARTICLE VIII.
DEFAULT
SECTION 8.01. DEFAULT. The Bank shall be in default if it fails to pay all or any part
of a demand deposit, a matured time deposit, or a matured certificate of deposit, including earned
interest, at the specified maturity date. The Bank shall also be in default if ruled “bankrupt”,
“insolvent” or “failed” by Federal Banking Regulators.
SECTION 8.02. TITLE TO SECURITIES. In the event of a default, failure or insolvency
of the Bank, (i) the District shall be deemed to have full vested title to all Authorized Investment
Securities pledged to the District pursuant to this Agreement and (ii) the District is hereby
authorized to take possession of and transfer to itself or sell any and all Authorized Investment
Securities pledged to the District pursuant to this Agreement. If the Authorized Investment
Security pledged to the District is transferred to the District in such circumstances, ownership of
the Authorized Investment Security pledged to the District will transfer entirely to the District. If
the Authorized Investment Security pledged to the District is liquidated, any proceeds over the
value of the defaulted amount of the matured investment, including accrued interest, plus expenses
related to the liquidation transaction, shall be returned to the Bank. This authorization is in addition
to any other remedy which the District may have under this Agreement and without prejudice to
Trophy Club Municipal Utility District No. 1 13 of 112 September 2, 2015 - Special Meeting
Agenda Packet
7
its right to maintain any suit in any court for redress of injuries sustained by the District under this
Agreement.
ARTICLE IX.
ASSIGNABILITY
This Agreement is not assignable in whole or in part but is binding on the parties hereto,
their successors and assigns. However, a merger or sale of all or substantially all of Bank’s assets
shall not constitute an assignment under this Agreement, and the resulting entity shall be
considered to be the Bank herein for all purposes.
ARTICLE X.
TERMINATION
This Agreement may be terminated by either the Bank, the District or the Custodian by
giving thirty (30) days prior written notice to the other parties.
ARTICLE XI.
GOVERNING LAW
All applicable provisions and requirements of the laws of the State of Texas governing
depositories for the District shall be a part of this Agreement.
ARTICLE XII.
DIRECTOR AUTHORIZATION
The Bank represents and warrants that this Agreement is made pursuant to and is duly
authorized by the Board of Directors of the Bank or its Loan Committee, which approval is
reflected in the minutes of the Board of Directors of the Bank or its Loan Committee as evidenced
in the excerpt of minutes attached hereto as Exhibit C for the Board of Directors of the Bank or
Exhibit D for the Loan Committee.
ARTICLE XIII
CHANGE IN DEPOSITS
Except in the event of emergencies that mandate immediate access to the funds, the
District will inform Bank of any significant change in the amount or activity of its deposits at
Bank not later than 72 hours before the change occurs.
WITNESS the execution hereof this ___ day of _________, ___________________.
“DISTRICT”
TROPHY CLUB MUNICIPAL UTILITY
DISTRICT NO. 1
Trophy Club Municipal Utility District No. 1 14 of 112 September 2, 2015 - Special Meeting
Agenda Packet
8
____________________________________
Jim Moss, President, Board of Directors
ATTEST:
____________________________________
Kevin R. Carr, Secretary, Board of Directors
“BANK”
Prosperity Bank
By: ________________________________
Name: ______________________________
Title: _______________________________
ATTEST:
By: ________________________________
Name: ______________________________
Title: _______________________________
“CUSTODIAN”
Federal Home Loan Bank of Dallas,
Irving, Texas
By: ________________________________
Name: ______________________________
Title: _______________________________
ATTEST:
By: ________________________________
Name: ______________________________
Title: _______________________________
Trophy Club Municipal Utility District No. 1 15 of 112 September 2, 2015 - Special Meeting
Agenda Packet
9
EXHIBIT A
The following individuals are authorized representatives of the District empowered to
direct Prosperity Bank (“Bank”) and Federal Home Loan Bank of Dallas, Irving, Texas
(“Custodian”) selected in accordance with Article III of the Depository Pledge Agreement as to
collateral pledges, releases and substitutions in the joint safekeeping account as well as authorized
to represent and act for the District in any and all matters including execution of agreements and
transfer of funds.
Authorized Representative’s Signature Name and Title
_______________________________________ Jennifer McKnight
General Manager
_______________________________________ Terri Sisk
Administration Manager
_______________________________________ _____________________
_____________________
By: _______________________________
Jim Moss, President, Board of Directors
ATTEST:
__________________________________
Kevin R. Carr, Secretary, Board of Directors
Trophy Club Municipal Utility District No. 1 16 of 112 September 2, 2015 - Special Meeting
Agenda Packet
10
EXHIBIT B
Prosperity Bank (“Bank”) has authorized the officers listed below to instruct Trophy Club
Municipal Utility District No. 1 (“District”) and Federal Home Loan Bank of Dallas, Irving, Texas,
(“Custodian”), selected in accordance with Article III of the Depository Pledge Agreement as to
collateral pledges, releases and substitutions in the joint safekeeping account. Such pledges,
releases and substitutions shall follow procedures set forth in the Depository Pledge Agreement.
Authorized Officer’s Signature Name and Title
_______________________________________ _____________________
_____________________
_______________________________________ _____________________
_____________________
_______________________________________ _____________________
_____________________
By: ________________________________
Name: ______________________________
Title: _______________________________
ATTEST:
By: ________________________________
Name: ______________________________
Title: _______________________________
Trophy Club Municipal Utility District No. 1 17 of 112 September 2, 2015 - Special Meeting
Agenda Packet
11
EXHIBIT C
CERTIFICATE RELATING TO MINUTES
THE STATE OF TEXAS §
COUNTY OF _______________ §
I, the undersigned Secretary of the Board of Directors (the “Board”) of
_________________________________ (the “Bank”), hereby certify as follows:
1. The Board convened on the ___ day of ___________, 20___, at which _____
members of the Board were present, thus constituting a quorum. Whereupon, among other
business, a Depository Pledge Agreement with _________________________________ was duly
introduced for the consideration of the Board. It was then duly moved and seconded that the
Depository Pledge Agreement be approved; and, after due discussion, such motion, carrying with
it the approval of such Agreement, prevailed.
2. A true, full, and correct copy of the aforesaid Agreement approved at the meeting
described in the above and foregoing paragraph is attached to and follows this Certificate; such
Agreement has been duly recorded in said Board’s minutes of such meeting; the above and
foregoing paragraph is a true, full, and correct excerpt from the Board’s minutes of such meeting
pertaining to the approval of such Agreement; the undersigned is the duly chosen, qualified, and
acting Secretary and member of the Board as indicated therein; each of the officers and members
of the Board was duly and sufficiently notified officially and personally, in advance of the time,
place, and purpose of such meeting and that such Agreement would be introduced and considered
for approval at such meeting and each of such officers and members consented, in advance, to the
holding of such meeting for such purpose.
SIGNED AND SEALED the ___ day of ___________, 20___.
__________________________________
Secretary, Board of Directors
(SEAL)
Trophy Club Municipal Utility District No. 1 18 of 112 September 2, 2015 - Special Meeting
Agenda Packet
12
EXHIBIT D
CERTIFICATE RELATING TO MINUTES
THE STATE OF TEXAS §
COUNTY OF _______________ §
I, the undersigned Secretary of the Loan Committee (the “Loan Committee”) of
_________________________________ (the “Bank”), hereby certify as follows:
1. The Loan Committee convened on the ___ day of ___________, 20___, at which
_____ members of the Loan Committee were present, thus constituting a quorum. Whereupon,
among other business, a Depository Pledge Agreement with
_______________________________ was duly introduced for the consideration of the Loan
Committee. It was then duly moved and seconded that the Depository Pledge Agreement be
approved; and, after due discussion, such motion, carrying with it the approval of such Agreement,
prevailed.
2. A true, full, and correct copy of the aforesaid Agreement approved at the meeting
described in the above and foregoing paragraph is attached to and follows this Certificate; such
Agreement has been duly recorded in said Loan Committee’s minutes of such meeting; the above
and foregoing paragraph is a true, full, and correct excerpt from the Loan Committee’s minutes of
such meeting pertaining to the approval of such Agreement; I am the duly chosen, qualified, and
acting Secretary and member of the Loan Committee as indicated therein; each of the officers and
members of the Loan Committee was duly and sufficiently notified officially and personally, in
advance of the time, place, and purpose of such meeting and that such Agreement would be
introduced and considered for approval at such meeting and each of such officers and members
consented, in advance, to the holding of such meeting for such purpose.
SIGNED AND SEALED the ___ day of ___________, 20___.
__________________________________
Secretary, Loan Committee
(SEAL)
Trophy Club Municipal Utility District No. 1 19 of 112 September 2, 2015 - Special Meeting
Agenda Packet
13
EXHIBIT E
Bank Response to RFP
Trophy Club Municipal Utility District No. 1 20 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club Municipal Utility District No. 121 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 122 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 123 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 124 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 125 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 126 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 127 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 128 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 129 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 130 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 131 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 132 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 133 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 134 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 135 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 136 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 137 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 138 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 139 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 140 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 141 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 142 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 143 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 144 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 145 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 146 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 147 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 148 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 149 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 150 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 151 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 152 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 153 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 154 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 155 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 156 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 157 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 158 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 159 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 160 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 161 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 162 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 163 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 164 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 165 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 166 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 167 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 168 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 169 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 170 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 171 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 172 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 173 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 174 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 175 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 176 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 177 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 178 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 179 of 112September 2, 2015 - Special Meeting Agenda Packet
Trophy Club Municipal Utility District No. 180 of 112September 2, 2015 - Special Meeting Agenda Packet
General Fund Fire Fund Tax Debt Service Fund Revenue Debt Service Fund
Revenue 7,835,458 Revenue 71,075 Revenue 214,519 Revenue 444,838
FY 2016 Tax Collections 58,181 FY 2016 Tax Collections 889,963 FY 2016 Tax Collections 671,998
FY 2016 PID Surcharges 146,125 FY 2016 PID Assessment 404,346 PID Surcharge 119,706
Reserve Funds 8,020 Reserve Funds 0
Total Revenue 8,047,784 Total Revenue 1,365,384 Total Revenue 1,006,223 Total Revenue 444,838
Water Expense 4,475,834 Fire Expense 1,365,384 Debt Service Expense 1,004,533 Debt Service Expense 444,838
Wastewater Expense 1,912,109
Board of Directors Expense 26,573
Administration Expense 1,210,322
Non-Departmental Expense 422,945
Total Expense 8,047,784 Total Expense 1,365,384 Total Expense 1,004,533 Total Expense 444,838
Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 0 Net Budget Surplus/Deficit 1,690 Net Budget Surplus/Deficit 0
2016 Property Value Summary Tax Rate Summary
MUD Tarrant Co.299,983,661 2015 2016
MUD Denton Co.932,292,617 O&M (General Fund) Tax 0.01486 0.00472
PID 559,559,219 I & S (Debt Service) Tax 0.04126 0.05420
Out of District & PID 313,864 Fire Tax 0.07727 0.07222
Total Value:1,792,149,361 Total Tax Rate:0.13339 0.13114
Increase/Decrease:-0.00225
PID Fire Assessment Rate 0.07727 0.07222
Reduction:-0.00505
Budget Summary
TROPHY CLUB M.U.D. NO. 1
FY 2016 BUDGET
DRAFT SEPTEMBER 02, 2015
1Trophy Club Municipal Utility District No. 1 81 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
GENERAL FUND
Account Description Original Amend #2 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15 Comments
General Fund Revenues
135-40000-000-000 Property Taxes 167,857 167,857 58,181 166,927 SEE SCHEDULE TAX_ASSESS
135-40002-000-000 Property Taxes/Delinquent 0 0 0 424
135-40015-000-000 Property Taxes/P & I 900 900 650 602
135-40025-000-000 PID Surcharges 133,997 133,997 146,125 104,709 SEE SCHEDULE TAX_ASSESS
135-47000-000-000 Water 5,286,045 4,747,789 5,080,244 2,086,645 SEE SCHEDULE GF-D
135-47005-000-000 Sewer 2,270,982 2,270,982 2,413,776 1,407,508 SEE SCHEDULE GF-E
135-47025-000-000 Penalties 63,416 80,000 90,985 65,132 SEE SCHEDULE GF-D
135-47030-000-000 Service Charges (Disconnect Fees)8,000 10,000 9,000 7,974 SEE SCHEDULE GF-D
135-47035-000-000 Plumbing Inspections 2,000 2,000 2,000 1,700
135-47045-000-000 Sewer Inspections 5,000 5,000 5,500 5,100
135-47070-000-000 TCCC Effluent Charges 86,815 86,815 61,330 18,418 SEE SCHEDULE GF-E
135-48005-000-000 Utility Fees 184,000 184,000 69,000 188,600 SEE SCHEDULE GF-D
135-49010-000-000 Interest Income 5,000 5,000 6,000 4,523 ADDITIONAL INTEREST DUE TO BOND PROCEEDS
135-49016-000-000 Cell Tower Revenue 10,164 10,164 10,926 8,195 $910.53 PER MONTH
135-49018-000-000 Building Rent Income 7,000 7,000 7,000 5,250 $583.33 PER MONTH: COLLECTION BARN RENT FROM TOWN
135-49030-000-000 Vending Revenue 350 0 0 0 NO LONGER PROVIDING VENDING AT WWTP
135-49035-000-000 Prior Year Reserves 0 929,603 8,020 0 STW SERVER UPGRADE REQUIRED DUE TO NO LONGER SUPPORTING EXISTING - FUNDS FROM 137
135-49036-000-000 GASB Reserves 74,706 74,706 0 74,706 UNNECESSARY ACCOUNT LEFT FROM WHEN USED TOWN IT: EXPENSE SHOWN IN HARDWARE
135-49075-000-000 Oversize Meter Reimbursement 84,000 42,000 15,778 44,776 SEE SCHEDULE GF-D
135-49141-000-000 Interfund Transfer In 0 19,607 0 36,767
135-49900-000-000 Miscellaneous Income 54,000 68,994 63,249 104,732 INCLUDES $3108 FROM TOWN FOR JANITORIAL; PID LOC INTEREST
135-49901-000-000 Records Management Revenue 100 100 20 12 REDUCED REVENUE
135-49903-000-000 Recovery of Prior Year Expense 0 0 0 0
Total 8,444,333 8,846,514 8,047,784 4,332,698
General Fund Expenses
Water & Distribution
135-50005-010-000 Salaries & Wages 301,101 244,578 265,614 146,657 SEE SCHEDULE GF-H
135-50010-010-000 Overtime 19,500 19,500 19,500 10,323 SEE SCHEDULE GF-H
135-50016-010-000 Longevity 5,343 2,705 2,945 2,705 SEE SCHEDULE GF-H
135-50017-010-000 Certification 4,800 3,900 4,200 2,050 SEE SCHEDULE GF-H
135-50020-010-000 Retirement 29,349 23,987 25,558 14,442 SEE SCHEDULE GF-J
135-50026-010-000 Medical Insurance 44,988 51,487 51,398 23,679 SEE SCHEDULE GF-I
135-50027-010-000 Dental Insurance 3,288 4,188 3,999 1,909 SEE SCHEDULE GF-I
135-50028-010-000 Vision Insurance 834 990 910 446 SEE SCHEDULE GF-I
135-50029-010-000 Life Insurance & Other 3,074 3,074 2,803 1,569 SEE SCHEDULE GF-I
135-50030-010-000 Social Security Taxes 21,135 17,192 18,563 9,882 SEE SCHEDULE GF-H
135-50035-010-000 Medicare Taxes 4,943 4,021 4,341 2,311 SEE SCHEDULE GF-H
135-50040-010-000 Unemployment Taxes 1,242 1,242 1,242 18 SEE SCHEDULE GF-H
135-50045-010-000 Workman's Compensation 16,020 16,020 14,754 6,401 TML INVOICE AMOUNT
135-50060-010-000 Pre-emp Physicals/Testing 1,000 1,300 1,300 1,037
135-50070-010-000 Employee Relations 300 300 300 148
135-55005-010-000 Engineering 10,000 10,000 5,000 -2,090
135-55080-010-000 Maintenance & Repairs 71,242 81,113 85,000 54,929 ADDITIONAL MAINTENANCE FY 16
135-55090-010-000 Vehicle Maintenance 8,000 8,000 8,000 5,523
135-55105-010-000 Maintenance-Heavy Equipment 3,500 3,500 3,500 3,463
2
Trophy Club Municipal Utility District No. 1 82 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
Account Description Original Amend #2 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15 Comments
135-55135-010-000 Lab Analysis - MUD 5,500 5,500 5,500 3,290 TCEQ ESTIMATE + MONTHLY BAC T & REDUCED FOR PID PORTION
135-60010-010-000 Communications/Pagers/Mobiles 4,913 4,913 5,400 2,803 INCREASE IN COSTS
135-60020-010-000 Electricity 170,765 160,765 166,823 84,680 SEE SCHEDULE GF-K
135-60066-010-000 Publications/Books/Subscripts 500 500 500 739
135-60070-010-000 Dues & Memberships 500 500 500 0
135-60080-010-000 Schools & Training 4,138 4,138 5,773 1,173 SEE SCHEDULE GF-G
135-60090-010-000 Safety Program 400 400 400 0
135-60100-010-000 Travel & per diem 1,500 1,500 1,400 99 SEE SCHEDULE GF-G
135-60105-010-000 Rent/Lease Equipment 1,500 1,500 1,500 0 EMERGENCY EQUIPMENT RENTAL IF NEEDED
135-60135-010-000 TCEQ Fees & Permits - MUD 49,275 49,275 49,275 20,657 REG. ASSESSMENT ($22,500), WATER SYSTEM FEES ($6,775) & NTGW WELL FEES ($20,000)
135-60150-010-000 Wholesale Water 2,928,308 2,928,308 2,948,742 1,039,926 SEE SCHEDULE GF-C
135-60245-010-000 Miscellaneous Expenses 200 200 200 0
135-60280-010-000 Property Maintenance 3,500 3,500 3,500 1,265
135-60285-010-000 Lawn Equipment & Maintenance 250 250 250 0
135-60360-010-000 Furniture/Equipment < $5000 3,500 3,500 2,500 925
135-65005-010-000 Fuel & Lube 29,173 19,173 35,947 9,035 SEE SCHEDULE GF-M
135-65010-010-000 Uniforms 3,620 3,620 4,608 3,075 SEE SCHEDULE GF-F
135-65030-010-000 Chemicals 7,000 10,000 12,000 7,568 MORE WATER TREATED
135-65035-010-000 Small Tools 1,200 1,200 1,200 290
135-65040-010-000 Safety Equipment 1,000 1,000 1,000 457
135-65050-010-000 Meter Expense 161,500 165,000 115,000 92,664
135-65053-010-000 Meter Change Out Program 0 0 50,000 0 FY 16 SCHEDULED METER REPLACEMENTS: 148 RESIDENTIAL METERS & 7 COMMERCIAL METERS
135-69005-010-000 Capital Outlays 1,089,006 1,457,597 201,000 234,151 SEE SCHEDULE GF-A
135-69006-010-000 Long Term Debt Payment from Water Sales 0 0 0 0 SEE SCHEDULE GF-B: FUNDS TO TRANSER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS
135-69008-010-000 Short Term Debt-Principal 129,000 129,000 130,720 129,000 SEE SCHEDULE GF-B
135-69009-010-000 Short Term Debt-Interest 3,612 3,612 1,209 2,416 SEE SCHEDULE GF-B
135-69195-010-000 Gasb34/Reserve for Replacement 75,000 75,000 75,000 75,000 1/10 MAJOR MAINTENANCE COST TOWN'S ELEVATED STORAGE TANK $45,000
135-69281-010-000 Tank Inspection Contract 151,507 151,507 126,958 126,958 ANNUAL MAINTENANCE CONTRACT
135-55135-010-001 Lab Analysis - PID 5,000 5,000 5,000 2,514 PID PORTION
135-60135-010-001 TCEQ Fees & Permits- PID 5,000 5,000 5,000 2,419 WATER SYSTEM FEES ($2.15/CONNECTION) AND OTHER
Subtotal Water 5,386,025 5,688,555 4,475,834 2,126,506
135-50005-020-000 Salaries & Wages 305,744 307,875 351,671 212,670 SEE SCHEDULE GF-H
135-50010-020-000 Overtime 19,500 24,500 19,500 21,297 SEE SCHEDULE GF-H
135-50016-020-000 Longevity 5,617 5,617 6,125 5,615 SEE SCHEDULE GF-H
135-50017-020-000 Certification 6,600 6,600 7,200 4,950 SEE SCHEDULE GF-H
135-50020-020-000 Retirement 29,948 30,317 33,652 21,840 SEE SCHEDULE GF-J
135-50026-020-000 Medical Insurance 61,001 56,244 65,989 41,678 SEE SCHEDULE GF-I
135-50027-020-000 Dental Insurance 4,146 3,696 4,184 2,665 SEE SCHEDULE GF-I
135-50028-020-000 Vision Insurance 990 912 972 618 SEE SCHEDULE GF-I
135-50029-020-000 Life Insurance & Other 3,194 3,194 3,655 2,556 SEE SCHEDULE GF-I
135-50030-020-000 Social Security Taxes 21,680 21,812 24,665 13,693 SEE SCHEDULE GF-H
135-50035-020-000 Medicare Taxes 5,070 5,101 5,768 3,188 SEE SCHEDULE GF-H
135-50040-020-000 Unemployment Taxes 1,242 1,242 1,449 14 SEE SCHEDULE GF-H
135-50045-020-000 Workman's Compensation 16,020 16,020 9,317 6,401 TML INVOICE AMOUNT
135-50060-020-000 Pre-emp Physicals/Testing 150 300 300 126
135-50070-020-000 Employee Relations 550 650 650 451
135-55070-020-000 Independent Labor 0 0 50,000 0 ENGINEERING FEES FOR PERMIT RENEWAL
Wastewater
3
Trophy Club Municipal Utility District No. 1 83 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
Account Description Original Amend #2 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15 Comments
135-55080-020-000 Maintenance & Repairs 58,000 72,600 72,600 71,631
135-55090-020-000 Vehicle Maintenance 3,000 3,000 5,000 3,325 REPLACE TIRES ON GAP VAX; REPLACE WINDSHIELD ON ON CALL TRUCK
135-55105-020-000 Maintenance-Heavy Equipment 500 500 500 129
135-55125-020-000 Dumpster Services 55,000 55,000 55,000 36,716
135-55135-020-000 Lab Analysis 25,000 25,000 35,000 18,680 INCREASE FOR PERMIT RENEWAL TESTING
135-60010-020-000 Communications/Pagers/Mobiles 4,662 4,662 5,400 3,992 INCREASE IN COSTS
135-60020-020-000 Electricity 149,292 139,292 161,582 94,077 SEE SCHEDULE GF-K
135-60066-020-000 Publications/Books/Subscripts 400 400 400 135
135-60070-020-000 Dues & Memberships 250 250 300 307
135-60080-020-000 Schools & Training 4,065 3,065 3,771 1,326 SEE SCHEDULE GF-G
135-60090-020-000 Safety Program 550 550 550 0
135-60100-020-000 Travel & per diem 1,600 2,000 1,600 1,797 SEE SCHEDULE GF-G
135-60105-020-000 Rent/Lease Equipment 9,000 7,500 9,000 1 EMERGENCY EQUIPMENT RENTAL IF NEEDED
135-60135-020-000 TCEQ Fees & Permits 17,150 17,150 37,150 9,019 REG. ASSESSMENT($8,550), ANNUAL FEE ($8,600), PERMIT RENEWAL ($20,000)
135-60243-020-000 Prior Year Expense 0 0 0 0
135-60245-020-000 Miscellaneous Expenses 300 300 300 0
135-60285-020-000 Lawn Equipment & Maintenance 500 500 500 273
135-60331-020-000 Interfund Transfer Out-Tax I&S 0 65,255 119,706 0 TRANSFER OF PID SURCHARGE
135-60332-020-000 Interfund Transfer Out- Revenue I&S 0 136,989 444,831 0 SEE SCHEDULE GF-B2: FUNDS TO TRANSFER TO DEBT SERVICE BUDGET TO COVER REVENUE BONDS
13560333-020-000 Interfund Transfer Out-Reserve 0 71,946 123,336 41,112 TRANSFER FOR BOND RESERVE
135-60360-020-000 Furniture/Equipment < $5000 0 0 0 0
135-65005-020-000 Fuel & Lube 36,328 20,328 32,021 14,026 SEE SCHEDULE GF-M
135-65010-020-000 Uniforms 2,778 2,778 4,241 2,598 SEE SCHEDULE GF-F
135-65030-020-000 Chemicals 30,000 24,000 27,000 14,086 INCREASE IN CHEMICALS NEEDED
135-65035-020-000 Small Tools 2,000 1,500 2,000 879
135-65040-020-000 Safety Equipment 750 750 750 626
135-65045-020-000 Lab Supplies 13,000 13,000 13,000 10,151
135-69005-020-000 Capital Outlays 150,000 142,000 150,000 118,396 SEE SCHEDULE GF-A
135-69007-020-000 Long Term Debt Payment from WW Sales 357,538 0 0 0
135-69008-020-000 Short Term Debt-Principal 56,991 56,991 21,280 21,000 SEE SCHEDULE GF-B
135-69009-020-000 Short Term Debt-Interest 2,011 2,011 197 393 SEE SCHEDULE GF-B
Subtotal Wastewater 1,462,115 1,353,397 1,912,109 802,434
Board of Directors
135-50005-026-000 Salaries & Wages 10,000 10,000 12,500 9,400 MORE MEETINGS
135-50030-026-000 Social Security Taxes 620 620 775 583 MORE MEETINGS
135-50035-026-000 Medicare Taxes 145 145 181 136 MORE MEETINGS
135-50040-026-000 Unemployment Taxes 230 230 230 62 MORE MEETINGS
135-50045-026-000 Workman's Compensation 36 36 37 26 TML INVOICE AMOUNT
135-60066-026-000 Publications/Books/Subscripts 150 150 150 0
135-60070-026-000 Dues & Memberships 500 500 500 35
135-60075-026-000 Meetings 1,200 950 1,200 176 MORE MEETINGS
135-60080-026-000 Schools & Training 4,000 4,000 4,000 1,330
135-60100-026-000 Travel & per diem 5,000 4,250 5,000 2,558
135-60245-026-000 Miscellaneous Expenses 1,000 2,000 2,000 1,625
Subtotal Board of Directors 22,881 22,881 26,573 15,931
Administration
135-50005-030-000 Salaries & Wages 477,578 470,732 488,508 324,012 SEE SCHEDULE GF-H
135-50010-030-000 Overtime 1,000 1,000 1,000 495 SEE SCHEDULE GF-H
4
Trophy Club Municipal Utility District No. 1 84 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
Account Description Original Amend #2 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15 Comments
135-50016-030-000 Longevity 3,283 3,283 3,823 3,283 SEE SCHEDULE GF-H
135-50020-030-000 Retirement 42,840 42,184 43,202 29,274 SEE SCHEDULE GF-H
135-50026-030-000 Medical Insurance 65,015 62,000 68,196 43,544 SEE SCHEDULE GF-I (Updated with Board approved plan rates)
135-50027-030-000 Dental Insurance 4,944 4,494 4,807 2,517 SEE SCHEDULE GF-I
135-50028-030-000 Vision Insurance 1,158 1,116 1,114 726 SEE SCHEDULE GF-I
135-50029-030-000 Life Insurance & Other 4,333 4,333 4,431 3,277 SEE SCHEDULE GF-I
135-50030-030-000 Social Security Taxes 30,079 29,654 30,823 19,167 SEE SCHEDULE GF-I
135-50035-030-000 Medicare Taxes 7,422 7,317 7,599 4,482 SEE SCHEDULE GF-H
135-50040-030-000 Unemployment Taxes 1,449 1,449 1,449 144 SEE SCHEDULE GF-H
135-50045-030-000 Workman's Compensation 1,636 1,636 1,554 786 TML INVOICE AMOUNT
135-50060-030-000 Pre-emp Physicals/Testing 500 500 500 38
135-50070-030-000 Employee Relations 5,000 5,000 5,000 2,462
135-55030-030-000 Software & Support 75,588 121,635 78,483 101,224 SEE SCHEDULE GF-L
135-55070-030-000 Independent Labor 8,000 32,550 12,000 30,114
135-55080-030-000 Maintenance & Repairs 4,500 4,500 29,500 440 INCLUDES MOWING CONTRACT $25,000
135-55100-030-000 Building Maint & Supplies 6,500 6,500 7,000 5,447 INCREASE IN COSTS
135-55120-030-000 Cleaning Services 8,100 8,100 10,125 5,020 CLEANING CONTRACT INCREASE
135-55160-030-000 Professional Outside Services 58,000 61,950 61,075 16,600 M3 IT SERVICES $51,075 -SEE SCHEDULE GF-L
135-55161-030-000 Town Personnel Contract 6,170 26,170 0 26,170 SERVICES NET ZERO THIS YEAR
135-55165-030-000 Collection Fees 200 200 200 0
135-55205-030-000 Utility Billing Contract 8,200 8,200 8,200 4,915 COST FOR PRINTING MONTHLY STATEMENTS
135-60005-030-000 Telephone 13,360 13,360 16,349 9,084 SEE SCHEDULE GF-L AND $2,500 AFTER HOURS ANSWERING SERVICE
135-60010-030-000 Communications/Mobiles 4,057 4,057 4,150 3,077 INCREASE IN COSTS
135-60020-030-000 Electricity 14,978 12,000 10,768 5,113 SEE SCHEDULE GF-K
135-60025-030-000 Water 1,500 1,500 1,500 601
135-60035-030-000 Postage 28,500 28,500 28,932 21,309 INCREASE OF $432 FOR POSTAGE MACHINE RENTAL
135-60040-030-000 Bank Service Charges & Fees 32,000 32,000 44,000 31,998 CREDIT CARD FEES CONTINUING TO INCREASE
135-60050-030-000 Bad Debt Expense 6,200 6,200 3,500 1,712
135-60055-030-000 Insurance 48,751 48,751 52,797 36,921 TML INVOICE AMOUNT
135-60066-030-000 Publications/Books/Subscripts 1,000 1,600 1,600 1,224
135-60070-030-000 Dues & Memberships 5,000 6,000 6,000 4,335
135-60075-030-000 Meetings 400 400 400 60
135-60079-030-000 Public Education 5,000 4,079 5,000 3,385
135-60080-030-000 Schools & Training 10,235 10,235 9,935 2,938 SEE SCHEDULE GF-G
135-60100-030-000 Travel & per diem 5,400 5,400 5,400 1,546 SEE SCHEDULE GF-G
135-60110-030-000 Physicals/Testing 200 200 200 0
135-60115-030-000 Elections 0 0 7,500 0 ELECTION TO BE HELD IN FY 16
135-60125-030-000 Advertising 2,500 2,500 7,500 5,631 INCREASED ADVERTISING
135-60235-030-000 Security 1,350 1,350 1,350 60 SEE SCHEDULE GF-L
135-60245-030-000 Miscellaneous Expenses & DM Discretionary 17,500 17,500 17,500 6,088
135-60270-030-000 4th of July Celebration 10,000 10,000 0 0
135-60336-030-000 Intergov Trans Out (MUD I&S)0 14,000 0 0
135-60344-030-000 Intergov Trans Out (Fire Dept.)0 0 0 0
135-60360-030-000 Furniture/Equipment < $5000 10,475 10,475 2,500 5,036
135-65010-030-000 Uniforms 1,855 1,855 1,855 1,043 SEE SCHEDULE GF-F
135-65055-030-000 Hardware IT 75,966 35,226 29,594 34,203 SEE SCHEDULE GF-L
135-65085-030-000 Office Supplies 9,000 9,000 9,000 5,970 ALL DEPARTMENTS COMBINED.
135-65090-030-000 Printer Supplies & Maintenance 4,732 4,732 4,003 2,730 SEE SCHEDULE GF-L
135-65095-030-000 Maintenance Supplies 5,000 5,000 5,000 3,272
5
Trophy Club Municipal Utility District No. 1 85 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
Account Description Original Amend #2 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15 Comments
135-65097-030-000 Vending Machine Supplies 200 200 0 0 NO LONGER PROVIDING VENDING AT WWTP
135-65105-030-000 Printing 4,800 4,800 4,800 1,333 ADDITIONAL PRINTING FOR CUSTOMER PUBLICATIONS
135-69005-030-000 Capital Outlays 125,000 62,000 56,000 61,822 SEE SCHEDULE GF-A
135-69170-030-000 Copier Lease Installments 4,236 4,236 4,600 3,027 SEE SCHEDULE GF-L
135-69195-030-000 Gasb34/Reserve for Replacement IT 16,329 16,329 0 16,329 UNNECESSARY ACCOUNT LEFT FROM WHEN USED TOWN IT: EXPENSE SHOWN IN HARDWARE
Subtotal Administration 1,287,018 1,277,988 1,210,322 893,982
Non Departmental
135-55045-039-000 Legal 250,000 467,403 386,130 433,588 PLAN FOR RATE CHALLENGE
135-55055-039-000 Auditing 22,491 22,491 22,750 16,836 FY 16 CONTRACT PRICE
135-55060-039-000 Appraisal 10,000 10,000 10,265 7,964
135-55065-039-000 Tax Admin Fees 3,800 3,800 3,800 2,456
Subtotal Non Departmental 286,291 503,694 422,945 460,845
Total General Fund Revenues 8,444,333 8,846,514 8,047,784
Total General Fund Expenses 8,444,333 8,846,514 8,047,784
Net Budget Surplus (Deficit)0 0 0
6
Trophy Club Municipal Utility District No. 1 86 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
FIRE DEPARTMENT
Account Description Original Amend #2 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15
Revenues
122-40001-000-000 Assessment - Emerg Svcs 357,462 357,462 404,346 356,068 SEE SCHEDULE TAX_ASSESS
122-40003-000-000 Emer Svcs Assessmen/Delinquent 0 0 0 8,402
122-40010-000-000 Property Taxes/MUD Fire 872,859 872,859 889,963 867,999 SEE SCHEDULE TAX_ASSESS
122-40011-000-000 Property Taxes/Fire-Delinquent 0 0 0 3,879
122-40015-000-000 Property Taxes/Assessments P&I 750 750 750 3,295
122-40020-000-000 Property Taxes/Fire P&I 4,500 4,500 4,500 3,585
122-42014-000-000 Fire Permits/Sprinkler 6,000 6,000 5,000 5,200
122-43400-000-000 Fire Inspections 700 950 825 975
122-43415-000-000 Denton/Tarrant Cty Pledge-Fire 10,000 10,000 10,000 10,000
122-49035-000-000 Prior Year Reserves 125,670 171,030 0 0
122-49900-000-000 Miscellaneous Income 6,000 9,000 50,000 10,404 $40,000 FROM SALE OF 1996 LADDER TRUCK
Total 1,383,940 1,432,551 1,365,384 1,269,808
Expenses
122-50005-045-000 Salaries & Wages 469,067 469,067 508,226 327,853 SEE SCHEDULE GF-H
122-50010-045-000 Overtime 46,745 46,745 48,735 27,604 SEE SCHEDULE GF-H
122-50011-045-000 Holiday Pay 14,930 14,930 15,852 14,526 SEE SCHEDULE GF-H
122-50016-045-000 Longevity 5,505 5,505 5,761 5,319 SEE SCHEDULE GF-H
122-50017-045-000 Certification 4,800 4,800 4,200 3,732 SEE SCHEDULE GF-J
122-50020-045-000 Retirement 91,396 75,327 75,571 51,854 SEE SCHEDULE GF-I
122-50026-045-000 Medical Insurance 59,169 59,169 65,546 40,769 SEE SCHEDULE GF-I
122-50027-045-000 Dental Insurance 4,390 4,390 4,885 3,140 SEE SCHEDULE GF-I
122-50028-045-000 Vision Insurance 811 811 859 546 SEE SCHEDULE GF-I
122-50029-045-000 Life Insurance & Other 4,030 4,030 4,585 2,762 SEE SCHEDULE GF-I
122-50030-045-000 Social Security Taxes 33,421 33,421 36,132 21,591 SEE SCHEDULE GF-H
122-50035-045-000 Medicare Taxes 7,292 7,292 8,450 5,048 SEE SCHEDULE GF-H
122-50040-045-000 Unemployment Taxes 1,657 1,657 1,724 -293 SEE SCHEDULE GF-H
122-50045-045-000 Workman's Compensation 8,692 8,692 9,379 5,931 SEE SCHEDULE GF-H
122-50060-045-000 Pre-employment Physicals/Test 250 250 250 148
122-50075-045-000 Tuition Reimbursement 300 300 0 0 MUD FY 2016 SHARE
122-55030-045-000 Software & Support 7,378 7,378 6,661 2,818 SEE SCHEDULE GF-L
122-55045-045-000 Legal 1,500 1,500 2,000 1,800
122-55080-045-000 Maintenance & Repairs 18,552 18,552 16,370 6,565 INCLUDES FIRE EXTINGUISHERS & MISC OF $1260
122-55090-045-000 Vehicle Maintenance 12,000 12,000 10,000 9,833
122-60005-045-000 Telephone 50 50 50 51
122-60010-045-000 Communications/Mobiles 5,000 6,413 6,653 3,861 ACTIVE 911 $240
122-60020-045-000 Electricity/Gas 9,026 9,026 7,412 3,857 SEE SCHEDULE GF-K: 50% PAID BY TOWN
122-60025-045-000 Water 1,200 1,200 1,200 965 50% PAID BY TOWN
122-60026-045-000 Cable 1,920 1,920 1,920 1,388
122-60030-045-000 Rent And/Or Usage 211,829 211,829 214,379 211,829 SEE SCHEDULE FD-B
122-60035-045-000 Postage 100 100 50 16
122-60055-045-000 Insurance 12,179 12,179 14,077 8,461 TML INVOICE
7
Trophy Club Municipal Utility District No. 1 87 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
Account Description Original Amend #2 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15
122-60066-045-000 Publications/Books/Subscrips 200 220 350 219 AERIAL TRAINING BOOK
122-60070-045-000 Dues & Memberships 15,180 15,689 15,582 15,419 SEE SCHEDULE FD-A
122-60080-045-000 Schools & Training 4,280 4,280 7,880 2,513 SEE SCHEDULE FD-A
122-60096-045-000 Emergency Management 1,400 1,400 1,000 220
122-60100-045-000 Travel & per diem 13,577 13,577 4,081 5,194 SEE SCHEDULE FD-A
122-60110-045-000 Physicals/Testing 2,000 2,000 4,700 0 ALL STAFF WILL DO PHYSICALS AND 2 HAZMAT FIT FOR DUTY
122-60125-045-000 Advertising 5,100 5,100 500 124 VOLUNTEER PROGRAM ADVERTISMENT
122-60160-045-000 Programs & Special Projects 4,500 4,500 7,500 1,325 $2750 FIRE EDUCATION SCHOOL; $3000 FIRE CAMP & CFA; EVENT COVERAGE
122-60180-045-000 Fire Inspection/Enforcement 1,000 1,000 500 194
122-60195-045-000 Flags & Repair 2,000 2,000 3,184 -110 ADDITIONAL POLE MAINTENANCE
122-60243-045-000 Prior Year Expense 0 0 0 0
122-60245-045-000 Miscellaneous Expense 1,000 1,000 1,000 574
122-65005-045-000 Fuel & Lube 10,454 10,454 15,122 4,184 SEE SCHEDULE GF-M
122-65010-045-000 Uniforms 2,000 3,000 3,140 2,049
122-65015-045-000 Protective Clothing 5,200 35,200 9,000 14,777 TWO SETS OF GEAR & ADVANCED CLEANING
122-65030-045-000 Chemicals 200 200 600 134 FOAM FOR NEW TRUCK
122-65035-045-000 Small Tools 2,500 2,500 2,000 849
122-65055-045-000 Hardware 9,000 9,000 750 0 SEE SCHEDULE GF-L REPLACEMENT
122-65085-045-000 Office Supplies 500 500 500 80
122-65105-045-000 Printing 548 548 498 38 SEE SCHEDULE GF-L
122-69005-045-000 Capital Outlays 0 250,000 0 1,057,316
122-69008-045-000 Short Term Debt -Principal 158,262 0 0 0
122-69009-045-000 Short Term Debt -Interest 50,000 0 0 0
122-69050-045-000 Radios 23,500 23,500 8,000 0 CONTINUATION OF RADIO REPLACEMENTS
122-69195-045-000 GASB34/Reserve for Replacement 17,950 17,950 81,420 17,950 1/10 COST OF NEW FIRE ENGINE; $40,000 FUNDED FROM SALE OF 1996 LADDER TRUCK
122-69255-045-000 Airpacks 20,400 10,400 0 10,235 REPLACEMENT PROGRAM FOR NFPA STANDARDS; 4 REPLACED PER YEAR ON 3 YEAR CYCLE
122-69305-045-000 Capital Leases 0 0 127,149 0 LEASE PAYMENT NO. 1 OF 7 FOR LADDER TRUCK
Total 1,383,940 1,432,551 1,365,384 1,895,258
Total Fire Revenues 1,383,940 1,432,551 1,365,384
Total Fire Expenses 1,383,940 1,432,551 1,365,384
Net Budget Surplus (Deficit)0 0 0
8
Trophy Club Municipal Utility District No. 1 88 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
TAX DEBT SERVICE FUND (I&S)
Account Description Original Amend #2 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15 Comments
Debt Service Revenues
533-40000-000-000 Property Taxes 466,019 466,019 667,898 463,487
533-40002-000-000 Property Taxes/Delinquent 2,500 2,500 2,300 1,750
533-40015-000-000 Property Taxes/P & I 1,600 1,600 1,800 1,665
533-48005-000-000 Reserve Funds (PID Utility Fees/Other)100,000 14,000 0 0
533-48015-000-000 WW Sales Revenue Transfer for Debt 357,538 0 0 0 SEE DEBT SVC I&S REVENUE
533-49010-000-000 Interest Income 375 375 140 3,441
533-49015-000-000 Lease/Rental Income 211,829 211,829 214,379 211,829 SEE SCHEDULE FD-B
533-49110-000-000 Premium on Bonds Sold 0 0 0 4,958
533-49141-000-000 Interfund Transfer In-PID Surchg 0 65,255 119,706 0
Total 1,139,861 761,578 1,006,223 687,129
Debt Service Expenses
533-70005-051-000 Paying Agent Fee 2,550 2,550 2,550 1,250
533-70025-051-000 Bond Interest Expense-Tax 403,103 283,984 316,983 89,254 SEE SCHEDULE GF-B1 (LONG TERM DEBT)
533-70035-051-000 Bond Principal Payment-Tax 440,000 440,000 685,000 0 SEE SCHEDULE GF-B1 (LONG TERM DEBT)
533-70040-051-000 Bond Interest Expense-Rev Bonds 292,283 0 0 0 SEE DEBT SVC I&S REVENUE
533-70045-051-000 Bond Principal Payment-Rev Bonds 0 0 0 0 SEE DEBT SVC I&S REVENUE
Total 1,137,936 726,534 1,004,533 90,504
Total Debt Service Fund Revenues 1,139,861 761,578 1,006,223
Total Debt Service Fund Expenses 1,137,936 726,534 1,004,533
Net Budget Surplus (Deficit)1,925 35,044 1,690
9
Trophy Club Municipal Utility District No. 1 89 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Trophy Club MUD No.1
DRAFT FY 2016 Budget
09/02/2015
REVENUE DEBT SERVICE FUND (I&S)
Account Description Original Amend #1 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15 Comments
Debt Service Revenues
534-49010-000-000 Interest Income 0 0 7 10,440
534-49110-000 Bond Premium 0 0 0 4,615
534-49142-000-000 Interfund Transfer In-Water Sales 0 0 0 0 Water Sales Revenue Transfer for Revenue Debt Payment
534-49143-000-000 Interfund Transfer In- WW Sales 0 136,989 444,831 0 WW Sales Revenue Transfer for Revenue Debt Payment
Total 0 136,989 444,838 0
Debt Service Expenses
534-70040-051-000 Bond Interest Expense-Rev Bonds 0 136,989 234,838 0 See Schedule GF-B2 (Long Term Debt)
534-70045-051-000 Bond Principal Payment-Rev Bonds 0 0 210,000 0 See Schedule GF-B2 (Long Term Debt)
Total 0 136,989 444,838 0
Total Debt Service Fund Revenues 0 136,989 444,838
Total Debt Service Fund Expenses 0 136,989 444,838
Net Budget Surplus (Deficit)0 0 0
10
Trophy Club Municipal Utility District No. 1 90 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Debt Reserve Fund*
Account Description Original Amend #1 PROPOSED YTD Total
Budget Budget FY 2016 thru 6/30/15 Comments
Debt Reserve Revenues
528-49141-000-000 Interfund transfer In-General Fund 0 71,946 123,336 41,112 $10,278 FOR 12 MONTHS
Total 0 71,946 123,336 41,112
Debt Reserve Expenses
0 0 0 0
Total 0 0 0 0
*Revenue bond covenants require 1 year debt service in reserves; usually allow 5 years from issuance date to accumulate the reserve.
Total Debt Service Fund Revenues 0 71,946 123,336 41,112
Total Debt Service Fund Expenses 0 0 0 0
Net Budget Surplus (Deficit)0 71,946 123,336 41,112
11
Trophy Club Municipal Utility District No. 1 91 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE TAX_ASSESS
TAX RATE AND PID ASSESSMENT & SURCHARGE CALCULATIONS
FIRE TAX/ASSESSMENT RATE OVERALL TAX RATE FY 2016:$0.13114
NET TAX VALUE
TARRANT COUNTY:299,983,661 7/30/2015
DENTON COUNTY:932,292,617 7/30/2015
DENTON CO. PID:559,559,219 7/30/2015
OUT OF DISTRICT & PID 313,864 8/27/2015
REQUIRED REVENUE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100
FIRE Vals/100 =17,921,493.61
FY 2016 Tax/Assess Rate =0.07222
1,294,309 TAX COMPARISON TO FY 2015
Revenue from MUD Tax =889,963$ 2015 2016
Revenue from PID Assess =404,346$ O&M (General Fund) Tax 0.0148601 0.00472
Total:1,294,309$ I & S (Debt Service) Tax 0.0412559 0.05420
Fire Tax 0.0772727 0.07222
O&M TAX/SURCHARGE RATE Total Tax Rate:0.13339 0.13114
NET TAX VALUE Increase/Decrease:-0.00225
TARRANT COUNTY:299,983,661
DENTON COUNTY:932,292,617 PID Fire Assessment Rate 0.07727 0.07222
DENTON CO. PID:559,559,219 Reduction:-0.00505
REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100
O&M Vals/100 =17,918,354.97
FY 2015 Tax/Surcharge Rate =0.00472
84,600
Revenue from MUD Tax =58,181$
Revenue from PID Surcharge =26,419$
Total:84,600$
I&S TAX/SURCHARGE RATE
NEW DEBT: CALCULATE AMOUNT DUE FROM PID
NET TAX VALUE
TARRANT COUNTY:299,983,661
DENTON COUNTY:932,292,617
DENTON CO. PID:559,559,219
REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100
TAX NEW DEBT (I&S)Vals/100 =17,918,354.97
FY 2015 PID Surcharge Rate =0.02139 NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE
383,325
Revenue from MUD Tax =263,619$
Revenue from PID Surcharge =119,706$
Total:383,325$
MUD DEBT: CALCULATE MUD TAX
NET TAX VALUE
TARRANT COUNTY:299,983,661
DENTON COUNTY:932,292,617
REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100
I&S MUD DEBT Vals/100 =12,322,762.78
FY 2016 Tax Rate =0.05420
667,898 Revenue from MUD Tax =667,898$
Revenue from PID = N/A -$
Total:667,898$
12Trophy Club Municipal Utility District No. 1 92 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE FD-A
Fire Department Dues, Training, and Travel
Account Description FY 2016 Budget Detail
122-60070 Dues & Memberships
Texas Commission on Fire Protection $1,445 $85.00 per FF X 17 Annual fee
TCFP Training Facility $170 Annual fee
SFFMA (Volunteer) $275 $100 per dept, $35 per FF (5)
NEFDA $12,997
Annual fee increase due to equipment
replacement
Denton County Chiefs $280 Annual fee
Tarrant County Chiefs $100 Annual fee
Texas Fire Chiefs $150 Annual fee
International Fire Chiefs $165 Annual fee
TOTAL:$15,582
122-60080 Schools and Training
TCCC Live Fire Training $700 TCFP Annual
Certification classes TCCC / NFA $2,000 8 NFA classes
TCFP / TEEX / NFA on site classes $500 Instructor cost
Haz-Mat Certification $1,480 (2) staff cert
Conference regestration $1,700 SFR / Homeland / FMC / FDIC
Office Management Classes(Excel, Access)$1,500
TOTAL:$7,880
122-60100 Travel and Per Diem
Southwest Fire / Rescue (Chief Conf)$720 Chief or training officer conference.
Homeland Security Conference $800 EMC and Training officer (1)
Texas Fire Marshal Conference $840 Fire Marshal
Fire Department Instructor Conf (FDIC)
International Fire Chiefs $1,721 Chief or Training Officer
TOTAL:$4,081
13
Trophy Club Municipal Utility District No. 1 93 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE FD-B RENT CALCULATION FOR FIRE STATION
FY Bond Payment Reimburse Reserve ($933,700)*Total Rent
2016 146,283 68,096 214,379
2017 148,658 68,096 216,754
2018 150,858 68,096 218,954
2019 147,883 68,096 215,979
2020 149,908 68,096 218,004
2021 151,758 68,096 219,854
2022 153,433 68,096 221,529
2023 153,433 68,096 221,529
2024 153,183 68,096 221,279
2025 152,683 68,096 220,779
2026 148,083 68,096 216,179
2027 153,368 68,096 221,464
2028 153,243 68,096 221,339
2029 152,783 68,096 220,879
2030 152,113 68,096 220,209
2031 151,163 68,096 219,259
*Based on ave. rate of 3.9% for 20 years
14
Trophy Club Municipal Utility District No. 1 94 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF - A
FY 16 CAPITAL OUTLAYS
WATER - PURCHASES WATER - MAINTENANCE & REPAIRS ADMINISTRATION - PURCHASES
DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT
1/2 Ton Truck 27,000 Valley Wood Looping Water Line 35,000
Catepillar 416F Backhoe 63,000 Transfer Switch Water Plant 26,000
Cost of $77,000 less projected trade in of $14,000 FY 16 Valve Replacements 30,000
Refurnish Pump Housings Water Plant 20,000
Total:90,000 Total:111,000 Total:0
WASTEWATER - PURCHASES WASTEWATER - MAINTENANCE & REPAIRS ADMINISTRATION - MAINTENANCE & REPAIRS
DESCRIPTION AMOUNT DESCRIPTION AMOUNT DESCRIPTION AMOUNT
Portable generator 55,000 Lift Station Control Panels 35,000 RESTROOM ADA REMODEL 56,000
Lift Station Pumps - LS#3 & LS#5 45,000
Fence 15,000
Total:55,000 Total:95,000 Total:56,000
15
Trophy Club Municipal Utility District No. 1 95 of 112 September 2, 2015 - Special Meeting
Agenda Packet
LONG TERM TAX DEBT
MUD/PID Paid Par Principle FY 16 Interest 3/01 Interest 9/01 Subtotal Interest Total Maturity Date First Callable Date Project/Reason
Series 2010 (Tax)MUD $2,000,000 $75,000 $35,641 $35,641 $71,283 $146,283 9/1/2031 9/1/2020
Trophy Club Fire Station and costs related to
the issuance of the Bonds.
Series 2012 (Tax)MUD $2,355,000 $200,000 $24,675 $24,675 $49,350 $249,350 9/1/2023 9/1/2020
Refund MUD #2 Unlimited Tax Bonds, 2002
and costs related to the issuance of the
Bonds.
Series 2013 (Tax)MUD $1,905,000 $175,000 $24,013 $24,013 $48,025 $223,025 9/1/2023 9/1/2023
Refund MUD #2 Unlimited Tax Bonds Series
2003 and MUD #2 Unlimited Tax Refunding
Bonds Series 2005 and costs related to the
issuance of the Bonds.
SUBTOTAL MUD-ONLY TAX BONDS:$6,260,000 $450,000 $84,329 $84,329 $168,658 $618,658
Series 2014 (Tax) MUD/PID $5,765,000 $235,000 $74,163 $74,163 $148,325 $383,325 9/1/2035 9/1/2024
Tax Bonds for Wastewater Plant Expansion
Issued 10/1/2014
SUBTOTAL ALL MUD/PID TAX BONDS:$5,765,000 $235,000 $74,163 $74,163 $148,325 $383,325
TOTAL ALL BONDS:$12,025,000 $685,000 $158,491 $158,491 $316,983 $1,001,983
SCHEDULE GF - B1
TAX DEBT PAYMENTS
16Trophy Club Municipal Utility District No. 1 96 of 112 September 2, 2015 - Special Meeting
Agenda Packet
LONG TERM REVENUE DEBT
MUD/PID Paid Par Principle FY 16 Interest 3/01 Interest 9/01 Subtotal Interest Total Maturity Date First Callable Date Project/Reason
Series 2015 (Revenue)$9,230,000 $210,000 $117,419 $117,419 $234,838 $444,838 9/1/2035 9/1/2024 Revenue Bonds for WWTP Expansion
SUBTOTAL REVENUE BONDS:$9,230,000 $210,000 $117,419 $117,419 $234,838 $444,838
TOTAL ALL BONDS:$9,230,000 $210,000 $117,419 $117,419 $234,838 $444,838
SHORT TERM REVENUE DEBT
Original PAR Outstanding Debt Principle FY 15 Interest 3/01 Interest 9/01 Subtotal Interest Total Payoff Date Project/Reason Department
2013 Revenue Note $445,000 $152,000 $152,000 $1,406 $0 $1,406 $153,406 9/1/2016 2013 Capital Projects 86% WATER & 14% WW
Total:$445,000 $152,000 $152,000 $1,406 $0 $1,406 $153,406
SCHEDULE GF - B2
REVENUE DEBT PAYMENTS
17Trophy Club Municipal Utility District No. 1 97 of 112 September 2, 2015 - Special Meeting
Agenda Packet
ANNUALIZE GROWTH IN WATER METERS =2.00%
PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2015 =4,500
ITEM MONTH PROJECTED AVERAGE PROJECTED
NO.EOM AND AVERAGE WATER USE MONTHLY
ANNUAL NO. OF PER METER WATER
WATER FOR LAST USE PER
METERS 3 YEARS MONTH
(GALLONS)(GALLONS)
3892 84,661,333 1 OCT 4,508 21,751 98,041,696
3911 59,494,000 2 NOV 4,515 15,212 68,682,218
3941 41,381,667 3 DEC 4,523 10,500 47,487,983
3955 37,389,667 4 JAN 4,530 9,453 42,822,686
3978 35,620,000 5 FEB 4,538 8,953 40,627,619
4021 44,318,000 6 MAR 4,545 11,021 50,091,256
4030 57,479,000 7 APR 4,553 14,263 64,935,057
4075 81,762,333 8 MAY 4,560 20,066 91,508,087
4095 101,693,333 9 JUN 4,568 24,834 113,438,398
4113 115,294,000 10 JUL 4,576 28,029 128,250,047
4146 132,760,000 11 AUG 4,583 32,019 146,747,592
4135 113,284,333 12 SEP 4,591 27,394 125,762,310
AVERAGE 4,549 18,625
TOTAL 1,018,394,947
CALCULATED AVERAGE WATER USE PER METER PER MONTH =(GALS/METER/MN)18,625
PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY16 =(METERS)91
Growth Rate
Meters set June 2014
through May 2015:15 per month
Growth Rate = Ave.
New Meters Set/Total
Meters at May 2015 (15*12)/4268 x 100% =4.2%
2.0% recommended ONLY 46 PID METERS LEFT 6/15
Purchased Water (gallons):1,018,394,947
$2.2542 per 1000 gals $2,295,666 7.34% Increase
$54,398 per month $652,776 1.90% Increase
$25 per month $300
Total:$2,948,742
METERS FOR LAST THREE
YEARS COMBINED
WATER USE FOR LAST THREE
YEARS COMBINED
Service Charge
SCHEDULE GF-C PROJECTED WATER USE
PROJECTED RETAIL WATER SALES
Purchased Water Expense (Projected Fort Worth Costs)
Out of District Volumetric Charge
Rate of Use Charge
18
Trophy Club Municipal Utility District No. 1 98 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-D
PROJECTED WATER REVENUE
FY 2012
Beginning End Block Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption
Block Block Value Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block
- 1,000 1,000 172 61,000 3,449,000 4.06%261 99,000 3,438,000 6.32%314 105,000 3,451,000 8.37%409 175,000 3,443,000 11.05%381 149,000 3,476,000 10.83%377 144,000 3,533,000 9.85%310 108,000 3,555,000 7.49%210 58,000 3,655,000 4.30%195 45,000 3,683,000 3.19%200 32,000 3,690,000 2.63%118 31,000 3,793,000 2.54%189 75,000 3,760,000 3.41%3,136 1,082,000 42,926,000 4.63%
1,000 2,000 1,000 67 134,000 3,388,000 3.99%187 374,000 3,339,000 6.14%198 396,000 3,346,000 8.11%273 546,000 3,268,000 10.48%282 564,000 3,327,000 10.37%254 508,000 3,389,000 9.44%171 342,000 3,447,000 7.26%87 174,000 3,597,000 4.23%51 102,000 3,638,000 3.15%40 80,000 3,658,000 2.61%41 82,000 3,762,000 2.51%66 132,000 3,685,000 3.35%1,717 3,434,000 41,844,000 4.51%
2,000 3,000 1,000 100 300,000 3,321,000 3.91%245 735,000 3,152,000 5.80%268 804,000 3,148,000 7.63%398 1,194,000 2,995,000 9.61%380 1,140,000 3,045,000 9.49%370 1,110,000 3,135,000 8.74%267 801,000 3,276,000 6.90%75 225,000 3,510,000 4.13%67 201,000 3,587,000 3.11%41 123,000 3,618,000 2.58%46 138,000 3,721,000 2.49%88 264,000 3,619,000 3.29%2,345 7,035,000 40,127,000 4.33%
3,000 4,000 1,000 105 420,000 3,221,000 3.79%292 1,168,000 2,907,000 5.35%328 1,312,000 2,880,000 6.98%478 1,912,000 2,597,000 8.33%484 1,936,000 2,665,000 8.30%446 1,784,000 2,765,000 7.71%297 1,188,000 3,009,000 6.34%88 352,000 3,435,000 4.04%61 244,000 3,520,000 3.05%52 208,000 3,577,000 2.55%35 140,000 3,675,000 2.46%81 324,000 3,531,000 3.21%2,747 10,988,000 37,782,000 4.07%
4,000 5,000 1,000 90 450,000 3,116,000 3.67%234 1,170,000 2,615,000 4.81%381 1,905,000 2,552,000 6.19%435 2,175,000 2,119,000 6.80%419 2,095,000 2,181,000 6.80%370 1,850,000 2,319,000 6.46%275 1,375,000 2,712,000 5.71%107 535,000 3,347,000 3.94%66 330,000 3,459,000 3.00%56 280,000 3,525,000 2.52%48 240,000 3,640,000 2.43%86 430,000 3,450,000 3.13%2,567 12,835,000 35,035,000 3.78%
5,000 6,000 1,000 112 672,000 3,026,000 3.56%243 1,458,000 2,381,000 4.38%322 1,932,000 2,171,000 5.26%348 2,088,000 1,684,000 5.40%377 2,262,000 1,762,000 5.49%339 2,034,000 1,949,000 5.43%267 1,602,000 2,437,000 5.13%102 612,000 3,240,000 3.81%83 498,000 3,393,000 2.94%36 216,000 3,469,000 2.48%35 210,000 3,592,000 2.40%89 534,000 3,364,000 3.06%2,353 14,118,000 32,468,000 3.50%
6,000 7,000 1,000 101 707,000 2,914,000 3.43%227 1,589,000 2,138,000 3.93%278 1,946,000 1,849,000 4.48%285 1,995,000 1,336,000 4.29%270 1,890,000 1,385,000 4.32%257 1,799,000 1,610,000 4.49%226 1,582,000 2,170,000 4.57%87 609,000 3,138,000 3.69%79 553,000 3,310,000 2.87%49 343,000 3,433,000 2.45%43 301,000 3,557,000 2.38%84 588,000 3,275,000 2.97%1,986 13,902,000 30,115,000 3.25%
7,000 8,000 1,000 115 920,000 2,813,000 3.31%177 1,416,000 1,911,000 3.52%245 1,960,000 1,571,000 3.81%198 1,584,000 1,051,000 3.37%224 1,792,000 1,115,000 3.47%221 1,768,000 1,353,000 3.77%208 1,664,000 1,944,000 4.10%107 856,000 3,051,000 3.59%90 720,000 3,231,000 2.80%45 360,000 3,384,000 2.41%58 464,000 3,514,000 2.35%79 632,000 3,191,000 2.90%1,767 14,136,000 28,129,000 3.03%
8,000 9,000 1,000 130 1,170,000 2,698,000 3.18%171 1,539,000 1,734,000 3.19%193 1,737,000 1,326,000 3.21%148 1,332,000 853,000 2.74%169 1,521,000 891,000 2.78%171 1,539,000 1,132,000 3.15%186 1,674,000 1,736,000 3.66%149 1,341,000 2,944,000 3.46%90 810,000 3,141,000 2.72%69 621,000 3,339,000 2.38%48 432,000 3,456,000 2.31%103 927,000 3,112,000 2.83%1,627 14,643,000 26,362,000 2.84%
9,000 14,000 5,000 634 7,644,000 11,608,000 13.66%619 7,266,000 6,415,000 11.80%582 6,725,000 4,242,000 10.28%399 4,536,000 2,475,000 7.94%424 4,874,000 2,548,000 7.94%517 6,001,000 3,568,000 9.94%686 8,070,000 6,216,000 13.10%608 7,334,000 12,797,000 15.05%537 6,475,000 14,212,000 12.31%368 4,481,000 15,679,000 11.19%355 4,283,000 16,353,000 10.93%510 6,176,000 14,081,000 12.79%6,239 73,865,000 110,194,000 11.88%
14,000 17,000 3,000 395 6,311,000 5,398,000 6.35%228 3,626,000 2,582,000 4.75%155 2,470,000 1,488,000 3.61%101 1,605,000 806,000 2.59%85 1,336,000 785,000 2.45%144 2,292,000 1,176,000 3.28%283 4,509,000 2,290,000 4.82%402 6,417,000 6,144,000 7.23%332 5,335,000 7,233,000 6.26%289 4,621,000 8,414,000 6.00%268 4,313,000 8,916,000 5.96%372 5,956,000 7,129,000 6.47%3,054 48,791,000 52,361,000 5.65%
17,000 20,000 3,000 339 6,428,000 4,265,000 5.02%188 3,561,000 1,949,000 3.58%104 1,970,000 1,078,000 2.61%51 958,000 553,000 1.77%58 1,094,000 573,000 1.79%94 1,786,000 806,000 2.25%191 3,630,000 1,553,000 3.27%382 7,249,000 4,964,000 5.84%350 6,653,000 6,199,000 5.37%332 6,321,000 7,520,000 5.37%302 5,747,000 8,062,000 5.39%360 6,832,000 6,013,000 5.46%2,751 52,229,000 43,535,000 4.69%
20,000 25,000 5,000 383 8,799,000 5,224,000 6.15%188 4,312,000 2,252,000 4.14%116 2,631,000 1,191,000 2.89%54 1,223,000 643,000 2.06%49 1,114,000 664,000 2.07%77 1,725,000 830,000 2.31%162 3,710,000 1,610,000 3.39%489 11,217,000 6,007,000 7.07%496 11,325,000 8,085,000 7.00%535 12,294,000 10,324,000 7.37%533 12,243,000 11,333,000 7.57%512 11,781,000 7,816,000 7.10%3,594 82,374,000 55,979,000 6.04%
25,000 29,000 4,000 238 6,486,000 2,852,000 3.36%88 2,405,000 1,213,000 2.23%36 988,000 648,000 1.57%13 350,000 373,000 1.20%18 498,000 400,000 1.25%20 548,000 484,000 1.35%52 1,423,000 827,000 1.74%259 7,074,000 3,219,000 3.79%298 8,152,000 4,854,000 4.20%347 9,536,000 6,457,000 4.61%387 10,664,000 7,241,000 4.84%315 8,642,000 4,527,000 4.11%2,071 56,766,000 33,095,000 3.57%
29,000 34,000 5,000 198 6,303,000 2,466,000 2.90%75 2,382,000 1,092,000 2.01%26 833,000 649,000 1.57%18 572,000 395,000 1.27%16 501,000 397,000 1.24%27 858,000 485,000 1.35%44 1,394,000 778,000 1.64%204 6,473,000 2,812,000 3.31%326 10,403,000 4,509,000 3.91%389 12,408,000 6,177,000 4.41%378 12,037,000 7,000,000 4.68%284 9,023,000 4,067,000 3.69%1,985 63,187,000 30,827,000 3.32%
34,000 39,000 5,000 105 3,869,000 1,679,000 1.98%37 1,359,000 801,000 1.47%14 518,000 542,000 1.31%6 222,000 333,000 1.07%10 372,000 342,000 1.07%15 548,000 373,000 1.04%32 1,182,000 594,000 1.25%132 4,863,000 1,970,000 2.32%191 7,019,000 3,130,000 2.71%270 9,951,000 4,471,000 3.19%296 10,919,000 5,300,000 3.54%185 6,833,000 2,898,000 2.63%1,293 47,655,000 22,433,000 2.42%
39,000 44,000 5,000 61 2,538,000 1,234,000 1.45%24 1,002,000 646,000 1.19%12 509,000 481,000 1.17%7 292,000 299,000 0.96%8 343,000 301,000 0.94%7 290,000 317,000 0.88%12 508,000 480,000 1.01%92 3,838,000 1,385,000 1.63%125 5,216,000 2,321,000 2.01%178 7,451,000 3,319,000 2.37%226 9,472,000 3,973,000 2.66%124 5,167,000 2,066,000 1.88%876 36,626,000 16,822,000 1.81%
44,000 50,000 6,000 41 1,943,000 1,183,000 1.39%20 939,000 635,000 1.17%10 477,000 505,000 1.22%4 185,000 321,000 1.03%3 139,000 313,000 0.98%7 334,000 344,000 0.96%17 804,000 482,000 1.02%65 3,050,000 1,162,000 1.37%120 5,670,000 2,046,000 1.77%176 8,370,000 2,942,000 2.10%192 9,087,000 3,465,000 2.32%100 4,724,000 1,806,000 1.64%755 35,722,000 15,204,000 1.64%
50,000 59,000 9,000 44 2,400,000 1,370,000 1.61%15 832,000 811,000 1.49%16 874,000 632,000 1.53%4 217,000 449,000 1.44%8 454,000 441,000 1.37%6 332,000 455,000 1.27%13 724,000 596,000 1.26%42 2,290,000 1,270,000 1.49%93 5,058,000 2,055,000 1.78%122 6,641,000 2,917,000 2.08%149 8,093,000 3,541,000 2.37%85 4,618,000 1,826,000 1.66%597 32,533,000 16,363,000 1.76%
59,000 69,000 10,000 22 1,399,000 1,181,000 1.39%11 708,000 759,000 1.40%8 516,000 584,000 1.42%5 325,000 460,000 1.48%9 559,000 368,000 1.15%7 461,000 448,000 1.25%8 506,000 534,000 1.13%31 2,010,000 1,071,000 1.26%44 2,807,000 1,601,000 1.39%78 4,974,000 2,232,000 1.59%105 6,705,000 2,680,000 1.79%40 2,559,000 1,419,000 1.29%368 23,529,000 13,337,000 1.44%
69,000 +108 26,009,000 18,557,000 21.84%70 16,426,000 11,596,000 21.33%54 10,641,000 6,915,000 16.76%43 7,686,000 4,719,000 15.14%34 7,462,000 5,116,000 15.94%40 8,174,000 5,414,000 15.09%50 10,668,000 7,218,000 15.21%89 18,441,000 12,300,000 14.47%139 37,838,000 28,247,000 24.47%186 50,837,000 38,003,000 27.12%217 54,013,000 39,040,000 26.09%122 33,892,000 25,474,000 23.14%1,152 282,087,000 202,599,000 21.84%
3,560 84,963,000 84,963,000 100.00%3,600 54,366,000 54,366,000 100.00%3,660 41,249,000 41,249,000 100.00%3,677 31,172,000 31,172,000 100.00%3,708 32,095,000 32,095,000 100.00%3,766 35,885,000 35,885,000 100.00%3,757 47,464,000 47,464,000 100.00%3,807 85,018,000 85,018,000 100.00%3,833 115,454,000 115,454,000 100.00%3,858 140,148,000 140,148,000 100.00%3,880 149,614,000 149,614,000 100.00%3,874 110,109,000 110,109,000 100.00%44,980 927,537,000 927,537,000 100.00%
FY 2013
Beginning End Block Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption
Block Block Value Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block
- 1,000 1,000 225 88,000 3,786,000 4.42%211 87,000 3,799,000 5.09%282 151,000 3,810,000 7.88%273 124,000 3,795,000 9.40%357 187,000 3,796,000 10.87%306 136,000 3,838,000 8.83%245 104,000 3,889,000 6.72%240 83,000 3,929,000 5.00%206 75,000 3,967,000 4.48%217 53,000 3,978,000 3.60%184 53,000 4,035,000 3.05%186 57,000 4,036,000 3.49%2,932 1,198,000 46,658,000 5.12%
1,000 2,000 1,000 104 208,000 3,698,000 4.32%96 192,000 3,712,000 4.97%238 476,000 3,659,000 7.57%198 396,000 3,671,000 9.10%343 686,000 3,609,000 10.33%200 400,000 3,702,000 8.52%160 320,000 3,785,000 6.54%112 224,000 3,846,000 4.89%77 154,000 3,892,000 4.39%76 152,000 3,925,000 3.55%59 118,000 3,982,000 3.01%44 88,000 3,979,000 3.44%1,707 3,414,000 45,460,000 4.99%
2,000 3,000 1,000 118 354,000 3,594,000 4.20%132 396,000 3,616,000 4.84%287 861,000 3,421,000 7.08%292 876,000 3,473,000 8.61%467 1,401,000 3,266,000 9.35%324 972,000 3,502,000 8.06%199 597,000 3,625,000 6.27%117 351,000 3,734,000 4.75%111 333,000 3,815,000 4.31%62 186,000 3,849,000 3.48%56 168,000 3,923,000 2.96%73 219,000 3,935,000 3.40%2,238 6,714,000 43,753,000 4.80%
3,000 4,000 1,000 125 500,000 3,476,000 4.06%155 620,000 3,484,000 4.67%337 1,348,000 3,134,000 6.48%381 1,524,000 3,181,000 7.88%606 2,424,000 2,799,000 8.01%405 1,620,000 3,178,000 7.31%261 1,044,000 3,426,000 5.92%155 620,000 3,617,000 4.60%126 504,000 3,704,000 4.18%62 248,000 3,787,000 3.43%69 276,000 3,867,000 2.92%60 240,000 3,862,000 3.34%2,742 10,968,000 41,515,000 4.56%
4,000 5,000 1,000 160 800,000 3,351,000 3.92%177 885,000 3,329,000 4.46%367 1,835,000 2,797,000 5.79%432 2,160,000 2,800,000 6.94%457 2,285,000 2,193,000 6.28%409 2,045,000 2,773,000 6.38%274 1,370,000 3,165,000 5.47%161 805,000 3,462,000 4.40%147 735,000 3,578,000 4.04%78 390,000 3,725,000 3.37%63 315,000 3,798,000 2.87%63 315,000 3,802,000 3.29%2,788 13,940,000 38,773,000 4.26%
5,000 6,000 1,000 150 900,000 3,191,000 3.73%180 1,080,000 3,152,000 4.22%309 1,854,000 2,430,000 5.03%443 2,658,000 2,368,000 5.87%361 2,166,000 1,736,000 4.97%330 1,980,000 2,364,000 5.44%270 1,620,000 2,891,000 5.00%164 984,000 3,301,000 4.20%148 888,000 3,431,000 3.87%73 438,000 3,647,000 3.30%64 384,000 3,735,000 2.82%64 384,000 3,739,000 3.23%2,556 15,336,000 35,985,000 3.95%
6,000 7,000 1,000 159 1,113,000 3,041,000 3.55%176 1,232,000 2,972,000 3.98%282 1,974,000 2,121,000 4.39%387 2,709,000 1,925,000 4.77%272 1,904,000 1,375,000 3.94%311 2,177,000 2,034,000 4.68%277 1,939,000 2,621,000 4.53%169 1,183,000 3,137,000 3.99%148 1,036,000 3,283,000 3.71%81 567,000 3,574,000 3.24%49 343,000 3,671,000 2.77%93 651,000 3,675,000 3.18%2,404 16,828,000 33,429,000 3.67%
7,000 8,000 1,000 152 1,216,000 2,882,000 3.37%175 1,400,000 2,796,000 3.74%259 2,072,000 1,839,000 3.80%311 2,488,000 1,538,000 3.81%211 1,688,000 1,103,000 3.16%232 1,856,000 1,723,000 3.97%242 1,936,000 2,344,000 4.05%154 1,232,000 2,968,000 3.77%136 1,088,000 3,135,000 3.54%102 816,000 3,493,000 3.16%60 480,000 3,622,000 2.74%84 672,000 3,582,000 3.10%2,118 16,944,000 31,025,000 3.41%
8,000 9,000 1,000 136 1,224,000 2,730,000 3.19%178 1,602,000 2,621,000 3.51%215 1,935,000 1,580,000 3.27%209 1,881,000 1,227,000 3.04%144 1,296,000 892,000 2.55%206 1,854,000 1,491,000 3.43%251 2,259,000 2,102,000 3.63%206 1,854,000 2,814,000 3.58%158 1,422,000 2,999,000 3.39%97 873,000 3,391,000 3.07%76 684,000 3,562,000 2.69%106 954,000 3,498,000 3.02%1,982 17,838,000 28,907,000 3.17%
9,000 14,000 5,000 713 8,543,000 11,531,000 13.47%828 9,891,000 10,514,000 14.08%711 8,366,000 5,237,000 10.83%621 7,190,000 3,586,000 8.89%368 4,258,000 2,846,000 8.15%663 7,723,000 4,866,000 11.20%777 9,055,000 7,432,000 12.85%841 10,110,000 11,376,000 14.47%828 9,922,000 12,535,000 14.15%626 7,634,000 15,340,000 13.89%446 5,423,000 16,609,000 12.55%598 7,179,000 15,767,000 13.63%8,020 95,294,000 117,639,000 12.91%
14,000 17,000 3,000 396 6,323,000 5,234,000 6.12%389 6,175,000 4,407,000 5.90%201 3,190,000 1,735,000 3.59%122 1,952,000 1,069,000 2.65%120 1,903,000 1,003,000 2.87%207 3,286,000 1,633,000 3.76%290 4,638,000 2,930,000 5.07%400 6,371,000 4,872,000 6.19%399 6,346,000 5,602,000 6.32%412 6,591,000 7,591,000 6.87%325 5,244,000 8,839,000 6.68%440 7,055,000 7,957,000 6.88%3,701 59,074,000 52,872,000 5.80%
17,000 20,000 3,000 340 6,446,000 4,101,000 4.79%301 5,684,000 3,342,000 4.48%107 2,015,000 1,234,000 2.55%64 1,211,000 756,000 1.87%60 1,141,000 721,000 2.06%98 1,844,000 1,129,000 2.60%198 3,749,000 2,141,000 3.70%332 6,266,000 3,727,000 4.74%373 7,066,000 4,448,000 5.02%401 7,617,000 6,365,000 5.76%376 7,143,000 7,768,000 5.87%406 7,708,000 6,650,000 5.75%3,056 57,890,000 42,382,000 4.65%
20,000 25,000 5,000 362 8,273,000 4,948,000 5.78%340 7,768,000 3,893,000 5.21%127 2,887,000 1,442,000 2.98%68 1,539,000 894,000 2.22%73 1,636,000 811,000 2.32%138 3,119,000 1,254,000 2.89%237 5,385,000 2,390,000 4.13%375 8,571,000 4,371,000 5.56%429 9,761,000 5,241,000 5.92%589 13,501,000 8,051,000 7.29%579 13,318,000 10,538,000 7.96%632 14,499,000 8,439,000 7.29%3,949 90,257,000 52,272,000 5.74%
25,000 29,000 4,000 207 5,678,000 2,807,000 3.28%152 4,169,000 2,101,000 2.81%61 1,671,000 778,000 1.61%32 885,000 529,000 1.31%18 497,000 483,000 1.38%47 1,280,000 633,000 1.46%114 3,122,000 1,212,000 2.10%186 5,075,000 2,321,000 2.95%252 6,862,000 2,802,000 3.16%324 8,903,000 4,571,000 4.14%373 10,229,000 6,452,000 4.87%347 9,547,000 4,748,000 4.10%2,113 57,918,000 29,437,000 3.23%
29,000 34,000 5,000 181 5,763,000 2,489,000 2.91%122 3,848,000 1,865,000 2.50%41 1,305,000 701,000 1.45%20 641,000 516,000 1.28%21 661,000 492,000 1.41%30 939,000 579,000 1.33%69 2,200,000 1,029,000 1.78%163 5,186,000 2,014,000 2.56%195 6,180,000 2,350,000 2.65%295 9,363,000 4,043,000 3.66%398 12,651,000 6,054,000 4.57%305 9,692,000 4,167,000 3.60%1,840 58,429,000 26,299,000 2.89%
34,000 39,000 5,000 107 3,952,000 1,754,000 2.05%90 3,305,000 1,350,000 1.81%15 556,000 556,000 1.15%13 476,000 424,000 1.05%9 327,000 416,000 1.19%19 701,000 470,000 1.08%44 1,610,000 724,000 1.25%101 3,739,000 1,355,000 1.72%102 3,757,000 1,604,000 1.81%195 7,198,000 2,828,000 2.56%265 9,730,000 4,340,000 3.28%196 7,201,000 2,877,000 2.49%1,156 42,552,000 18,698,000 2.05%
39,000 44,000 5,000 73 3,037,000 1,265,000 1.48%49 2,067,000 1,016,000 1.36%8 338,000 496,000 1.03%10 420,000 370,000 0.92%13 549,000 372,000 1.06%11 461,000 392,000 0.90%19 793,000 567,000 0.98%51 2,122,000 928,000 1.18%72 3,012,000 1,159,000 1.31%130 5,457,000 1,997,000 1.81%184 7,697,000 3,221,000 2.43%136 5,681,000 2,037,000 1.76%756 31,634,000 13,820,000 1.52%
44,000 50,000 6,000 60 2,851,000 1,141,000 1.33%32 1,505,000 937,000 1.25%9 425,000 539,000 1.12%9 420,000 378,000 0.94%4 196,000 392,000 1.12%12 560,000 392,000 0.90%15 715,000 583,000 1.01%26 1,229,000 883,000 1.12%48 2,252,000 998,000 1.13%92 4,364,000 1,696,000 1.54%168 7,955,000 2,795,000 2.11%92 4,347,000 1,739,000 1.50%567 26,819,000 12,473,000 1.37%
50,000 59,000 9,000 32 1,749,000 1,256,000 1.47%32 1,743,000 1,115,000 1.49%10 551,000 726,000 1.50%5 283,000 519,000 1.29%10 554,000 522,000 1.49%8 439,000 507,000 1.17%17 942,000 731,000 1.26%38 2,064,000 1,019,000 1.30%40 2,176,000 1,103,000 1.25%64 3,513,000 1,807,000 1.64%134 7,284,000 2,726,000 2.06%73 3,961,000 1,814,000 1.57%463 25,259,000 13,845,000 1.52%
59,000 69,000 10,000 18 1,160,000 1,148,000 1.34%17 1,079,000 986,000 1.32%13 849,000 702,000 1.45%5 307,000 502,000 1.24%2 130,000 512,000 1.47%4 248,000 492,000 1.13%10 624,000 644,000 1.11%14 898,000 882,000 1.12%13 850,000 983,000 1.11%45 2,869,000 1,424,000 1.29%73 4,683,000 2,026,000 1.53%42 2,683,000 1,455,000 1.26%256 16,380,000 11,756,000 1.29%
69,000 +105 25,404,000 18,159,000 21.22%91 19,940,000 13,661,000 18.30%62 13,680,000 9,402,000 19.45%49 10,218,000 6,837,000 16.94%50 9,047,000 5,597,000 16.02%48 9,813,000 6,501,000 14.96%61 13,811,000 9,602,000 16.60%81 19,678,000 14,089,000 17.91%90 24,169,000 17,959,000 20.27%121 29,741,000 21,392,000 19.36%165 38,198,000 26,813,000 20.26%125 32,580,000 23,955,000 20.70%1,048 246,279,000 173,967,000 19.10%
3,923 85,582,000 85,582,000 100.00%3,923 74,668,000 74,668,000 100.00%3,941 48,339,000 48,339,000 100.00%3,944 40,358,000 40,358,000 100.00%3,966 34,936,000 34,936,000 100.00%4,008 43,453,000 43,453,000 100.00%4,030 57,833,000 57,833,000 100.00%4,086 78,645,000 78,645,000 100.00%4,098 88,588,000 88,588,000 100.00%4,142 110,474,000 110,474,000 100.00%4,166 132,376,000 132,376,000 100.00%4,165 115,713,000 115,713,000 100.00%48,392 910,965,000 910,965,000 100.00%
FY 2014
Beginning End Block Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption Number of Consumption % Consumption
Block Block Value Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block Accounts Reported Total By Block
- 1,000 1,000 213 73,000 4,054,000 4.86%310 129,000 4,029,000 8.15%390 182,000 4,014,000 11.62%342 133,000 4,036,000 9.93%359 147,000 4,049,000 10.17%294 131,000 4,127,000 7.70%260 103,000 4,146,000 6.18%233 104,000 4,202,000 5.15%184 66,000 4,236,000 4.19%170 62,000 4,232,000 4.44%170 56,000 4,279,000 3.68%172 64,000 4,259,000 3.73%3,097 1,250,000 49,663,000 5.66%
1,000 2,000 1,000 104 208,000 3,981,000 4.77%230 460,000 3,900,000 7.89%318 636,000 3,832,000 11.09%224 448,000 3,903,000 9.60%265 530,000 3,902,000 9.80%183 366,000 3,996,000 7.45%166 332,000 4,043,000 6.02%105 210,000 4,098,000 5.02%85 170,000 4,170,000 4.13%91 182,000 4,170,000 4.38%56 112,000 4,223,000 3.63%56 112,000 4,195,000 3.68%1,883 3,766,000 48,413,000 5.52%
2,000 3,000 1,000 140 420,000 3,877,000 4.65%344 1,032,000 3,670,000 7.42%501 1,503,000 3,514,000 10.17%365 1,095,000 3,679,000 9.05%435 1,305,000 3,637,000 9.13%307 921,000 3,813,000 7.11%236 708,000 3,877,000 5.77%138 414,000 3,993,000 4.89%85 255,000 4,085,000 4.04%113 339,000 4,079,000 4.28%72 216,000 4,167,000 3.58%64 192,000 4,139,000 3.63%2,800 8,400,000 46,530,000 5.31%
3,000 4,000 1,000 137 548,000 3,737,000 4.48%439 1,756,000 3,326,000 6.73%586 2,344,000 3,013,000 8.72%515 2,060,000 3,314,000 8.15%483 1,932,000 3,202,000 8.04%354 1,416,000 3,506,000 6.54%284 1,136,000 3,641,000 5.42%154 616,000 3,855,000 4.72%116 464,000 4,000,000 3.96%122 488,000 3,966,000 4.16%85 340,000 4,095,000 3.52%80 320,000 4,075,000 3.57%3,355 13,420,000 43,730,000 4.99%
4,000 5,000 1,000 171 855,000 3,600,000 4.31%391 1,955,000 2,887,000 5.84%532 2,660,000 2,427,000 7.02%495 2,475,000 2,799,000 6.89%500 2,500,000 2,719,000 6.83%402 2,010,000 3,152,000 5.88%258 1,290,000 3,357,000 5.00%155 775,000 3,701,000 4.53%110 550,000 3,884,000 3.84%126 630,000 3,844,000 4.04%92 460,000 4,010,000 3.45%102 510,000 3,995,000 3.50%3,334 16,670,000 40,375,000 4.60%
5,000 6,000 1,000 178 1,068,000 3,429,000 4.11%348 2,088,000 2,496,000 5.05%443 2,658,000 1,895,000 5.48%467 2,802,000 2,304,000 5.67%468 2,808,000 2,219,000 5.57%357 2,142,000 2,750,000 5.13%288 1,728,000 3,099,000 4.62%182 1,092,000 3,546,000 4.34%105 630,000 3,774,000 3.74%140 840,000 3,718,000 3.90%100 600,000 3,918,000 3.37%71 426,000 3,893,000 3.41%3,147 18,882,000 37,041,000 4.22%
6,000 7,000 1,000 199 1,393,000 3,251,000 3.90%303 2,121,000 2,148,000 4.34%314 2,198,000 1,452,000 4.20%384 2,688,000 1,837,000 4.52%318 2,226,000 1,751,000 4.40%283 1,981,000 2,393,000 4.46%276 1,932,000 2,811,000 4.19%169 1,183,000 3,364,000 4.12%115 805,000 3,669,000 3.63%142 994,000 3,578,000 3.76%102 714,000 3,818,000 3.28%108 756,000 3,822,000 3.35%2,713 18,991,000 33,894,000 3.87%
7,000 8,000 1,000 166 1,328,000 3,052,000 3.66%226 1,808,000 1,845,000 3.73%244 1,952,000 1,138,000 3.29%303 2,424,000 1,453,000 3.58%273 2,184,000 1,433,000 3.60%288 2,304,000 2,110,000 3.94%207 1,656,000 2,535,000 3.78%169 1,352,000 3,195,000 3.91%128 1,024,000 3,554,000 3.52%144 1,152,000 3,436,000 3.61%87 696,000 3,716,000 3.20%95 760,000 3,714,000 3.26%2,330 18,640,000 31,181,000 3.56%
8,000 9,000 1,000 156 1,404,000 2,886,000 3.46%180 1,620,000 1,619,000 3.27%156 1,404,000 894,000 2.59%225 2,025,000 1,150,000 2.83%198 1,782,000 1,160,000 2.91%237 2,133,000 1,822,000 3.40%209 1,881,000 2,328,000 3.47%179 1,611,000 3,026,000 3.71%128 1,152,000 3,426,000 3.39%162 1,458,000 3,292,000 3.46%108 972,000 3,629,000 3.12%116 1,044,000 3,619,000 3.17%2,054 18,486,000 28,851,000 3.29%
9,000 14,000 5,000 803 9,598,000 12,006,000 14.39%662 7,768,000 5,695,000 11.52%435 4,983,000 2,583,000 7.47%562 6,467,000 3,224,000 7.93%598 6,845,000 3,283,000 8.24%776 9,053,000 6,114,000 11.40%793 9,496,000 8,989,000 13.39%935 11,132,000 12,277,000 15.04%775 9,341,000 14,981,000 14.83%869 10,428,000 13,912,000 14.60%685 8,295,000 16,310,000 14.03%731 8,838,000 16,119,000 14.14%8,624 102,244,000 115,493,000 13.17%
14,000 17,000 3,000 425 6,806,000 5,362,000 6.43%237 3,785,000 2,087,000 4.22%90 1,431,000 810,000 2.34%123 1,960,000 958,000 2.36%116 1,834,000 954,000 2.40%236 3,765,000 2,180,000 4.07%346 5,532,000 3,628,000 5.40%491 7,827,000 5,216,000 6.39%519 8,314,000 7,060,000 6.99%514 8,191,000 6,236,000 6.55%468 7,531,000 8,083,000 6.95%488 7,837,000 7,857,000 6.89%4,053 64,813,000 50,431,000 5.75%
17,000 20,000 3,000 356 6,701,000 4,087,000 4.90%167 3,173,000 1,453,000 2.94%47 887,000 586,000 1.70%56 1,054,000 654,000 1.61%67 1,271,000 675,000 1.69%178 3,351,000 1,510,000 2.82%255 4,842,000 2,682,000 3.99%383 7,244,000 3,847,000 4.71%441 8,371,000 5,563,000 5.51%431 8,138,000 4,759,000 5.00%422 7,989,000 6,653,000 5.72%491 9,323,000 6,355,000 5.57%3,294 62,344,000 38,824,000 4.43%
20,000 25,000 5,000 411 9,325,000 4,780,000 5.73%136 3,098,000 1,563,000 3.16%52 1,178,000 708,000 2.05%52 1,181,000 801,000 1.97%59 1,337,000 767,000 1.93%141 3,193,000 1,643,000 3.06%269 6,123,000 3,023,000 4.50%376 8,571,000 4,361,000 5.34%527 12,044,000 6,684,000 6.62%482 11,065,000 5,595,000 5.87%638 14,570,000 8,350,000 7.18%584 13,295,000 7,660,000 6.72%3,727 84,980,000 45,935,000 5.24%
25,000 29,000 4,000 220 6,024,000 2,584,000 3.10%66 1,802,000 836,000 1.69%16 437,000 429,000 1.24%27 734,000 479,000 1.18%32 865,000 425,000 1.07%70 1,916,000 902,000 1.68%140 3,825,000 1,589,000 2.37%225 6,139,000 2,262,000 2.77%307 8,415,000 3,656,000 3.62%228 6,225,000 2,949,000 3.10%358 9,828,000 4,678,000 4.02%323 8,842,000 4,311,000 3.78%2,012 55,052,000 25,100,000 2.86%
29,000 34,000 5,000 183 5,841,000 2,194,000 2.63%43 1,373,000 766,000 1.55%17 545,000 457,000 1.32%22 706,000 483,000 1.19%13 411,000 419,000 1.05%50 1,570,000 790,000 1.47%107 3,420,000 1,362,000 2.03%145 4,592,000 1,847,000 2.26%231 7,363,000 3,154,000 3.12%202 6,433,000 2,595,000 2.72%288 9,160,000 4,118,000 3.54%273 8,706,000 3,854,000 3.38%1,574 50,120,000 22,039,000 2.51%
34,000 39,000 5,000 85 3,111,000 1,456,000 1.74%19 691,000 590,000 1.19%11 412,000 388,000 1.12%10 374,000 399,000 0.98%13 483,000 361,000 0.91%15 552,000 637,000 1.19%50 1,844,000 939,000 1.40%89 3,272,000 1,261,000 1.54%147 5,427,000 2,184,000 2.16%124 4,576,000 1,760,000 1.85%199 7,298,000 2,847,000 2.45%170 6,214,000 2,649,000 2.32%932 34,254,000 15,471,000 1.76%
39,000 44,000 5,000 63 2,632,000 1,095,000 1.31%16 676,000 517,000 1.05%10 422,000 332,000 0.96%8 332,000 345,000 0.85%7 289,000 301,000 0.76%14 591,000 570,000 1.06%24 1,007,000 746,000 1.11%44 1,816,000 895,000 1.10%94 3,925,000 1,544,000 1.53%84 3,532,000 1,236,000 1.30%127 5,319,000 2,046,000 1.76%109 4,569,000 1,988,000 1.74%600 25,110,000 11,615,000 1.32%
44,000 50,000 6,000 38 1,800,000 1,004,000 1.20%12 556,000 514,000 1.04%9 421,000 331,000 0.96%7 331,000 371,000 0.91%6 276,000 318,000 0.80%9 420,000 600,000 1.12%21 995,000 755,000 1.12%38 1,796,000 850,000 1.04%62 2,944,000 1,386,000 1.37%43 2,013,000 1,039,000 1.09%82 3,859,000 1,775,000 1.53%103 4,871,000 1,725,000 1.51%430 20,282,000 10,668,000 1.22%
50,000 59,000 9,000 24 1,307,000 1,205,000 1.44%9 479,000 677,000 1.37%7 383,000 429,000 1.24%8 430,000 480,000 1.18%4 209,000 432,000 1.08%21 1,143,000 768,000 1.43%21 1,153,000 940,000 1.40%20 1,090,000 999,000 1.22%59 3,193,000 1,467,000 1.45%33 1,802,000 1,232,000 1.29%79 4,290,000 1,915,000 1.65%61 3,319,000 1,799,000 1.58%346 18,798,000 12,343,000 1.41%
59,000 69,000 10,000 23 1,481,000 1,114,000 1.34%14 888,000 642,000 1.30%4 256,000 420,000 1.22%9 584,000 463,000 1.14%9 575,000 424,000 1.06%14 901,000 685,000 1.28%13 825,000 858,000 1.28%18 1,162,000 930,000 1.14%30 1,936,000 1,226,000 1.21%17 1,089,000 1,116,000 1.17%51 3,299,000 1,530,000 1.32%38 2,428,000 1,506,000 1.32%240 15,424,000 10,914,000 1.24%
69,000 +99 21,516,000 14,685,000 17.60%58 12,190,000 8,188,000 16.56%40 7,665,000 4,905,000 14.19%41 10,336,000 7,507,000 18.47%38 10,020,000 7,398,000 18.57%61 13,757,000 9,548,000 17.81%80 17,312,000 11,792,000 17.56%83 19,626,000 13,899,000 17.03%106 24,649,000 17,335,000 17.16%103 25,623,000 18,516,000 19.44%124 30,686,000 22,130,000 19.03%132 31,605,000 22,497,000 19.73%965 224,985,000 158,400,000 18.06%
4,194 83,439,000 83,439,000 100.00%4,210 49,448,000 49,448,000 100.00%4,222 34,557,000 34,557,000 100.00%4,245 40,639,000 40,639,000 100.00%4,261 39,829,000 39,829,000 100.00%4,290 53,616,000 53,616,000 100.00%4,303 67,140,000 67,140,000 100.00%4,331 81,624,000 81,624,000 100.00%4,354 101,038,000 101,038,000 100.00%4,340 95,260,000 95,260,000 100.00%4,393 116,290,000 116,290,000 100.00%4,367 114,031,000 114,031,000 100.00%51,510 876,911,000 876,911,000 100.00%
PROJECTED REVENUE
Projected Number of Meters - Oct 1st 4,498
Projected Growth Rate 2.00%
Projected Accounts 4,505 4,513 4,521 4,529 4,537 4,545 4,553 4,561 4,569 4,577 4,585 4,593 4,601
Projected Average Con per Account 21,859 15,293 10,574 9,428 8,937 10,956 14,196 20,142 24,981 28,316 32,269 27,439 18,823
Projected Consumption 98,473,756 69,019,457 47,803,352 42,698,963 40,548,411 49,795,242 64,633,132 91,867,519 114,140,041 129,601,659 147,953,812 126,026,974 86,605,993
Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue Dist %Dist (Gal)Rate Revenue
- 1,000 1,000 4.44%4,376,930 3.03 13,262$ 6.31%4,356,592 3.03 13,200$ 9.08%4,341,559 3.03 13,155$ 10.05%4,291,632 3.03 13,004$ 10.59%4,295,794 3.03 13,016$ 8.65%4,306,344 3.03 13,048$ 6.72%4,344,184 3.03 13,163$ 4.80%4,414,219 3.03 13,375$ 3.90%4,446,927 3.03 13,474$ 3.44%4,458,919 3.03 13,511$ 3.04%4,497,531 3.03 13,628$ 3.55%4,470,330 3.03 13,545$ 52,600,962 3.03 159,381$
1,000 2,000 1,000 4.36%4,290,857 3.03 13,001 6.14%4,234,780 3.03 12,831 8.73%4,172,902 3.03 12,644 9.67%4,127,184 3.03 12,505 10.14%4,112,518 3.03 12,461 8.34%4,152,412 3.03 12,582 6.54%4,226,115 3.03 12,805 4.71%4,322,459 3.03 13,097 3.84%4,377,339 3.03 13,263 3.40%4,403,838 3.03 13,344 3.00%4,445,524 3.03 13,470 3.49%4,397,648 3.03 13,325 51,263,577 3.03 155,329
2,000 3,000 1,000 4.25%4,184,235 3.03 12,678 5.85%4,036,402 3.03 12,230 8.12%3,882,566 3.03 11,764 9.05%3,862,621 3.03 11,704 9.31%3,774,804 3.03 11,438 7.86%3,913,837 3.03 11,859 6.25%4,039,828 3.03 12,241 4.58%4,208,602 3.03 12,752 3.77%4,297,649 3.03 13,022 3.34%4,326,275 3.03 13,109 2.97%4,387,573 3.03 13,294 3.44%4,336,091 3.03 13,138 49,250,484 3.03 149,229
3,000 4,000 1,000 4.11%4,045,433 3.03 12,258 5.44%3,757,589 3.03 11,385 7.27%3,475,942 3.03 10,532 8.11%3,461,018 3.03 10,487 8.11%3,288,345 3.03 9,964 7.11%3,538,933 3.03 10,723 5.84%3,776,704 3.03 11,443 4.45%4,085,007 3.03 12,378 3.68%4,199,252 3.03 12,724 3.28%4,245,340 3.03 12,863 2.92%4,322,935 3.03 13,098 3.37%4,252,654 3.03 12,886 46,449,152 3.03 140,741
4,000 5,000 1,000 3.96%3,903,141 3.03 11,827 4.95%3,414,971 3.03 10,347 6.26%2,994,231 3.03 9,073 6.88%2,937,983 3.03 8,902 6.64%2,691,464 3.03 8,155 6.20%3,087,624 3.03 9,356 5.35%3,461,104 3.03 10,487 4.28%3,936,318 3.03 11,927 3.58%4,085,890 3.03 12,380 3.21%4,156,911 3.03 12,595 2.87%4,252,725 3.03 12,886 3.31%4,170,701 3.03 12,637 43,093,064 3.03 130,572
5,000 6,000 1,000 3.80%3,739,912 3.03 11,332 4.50%3,104,835 3.03 9,408 5.23%2,501,354 3.03 7,579 5.67%2,419,515 3.03 7,331 5.35%2,169,336 3.03 6,573 5.31%2,645,304 3.03 8,015 4.89%3,158,623 3.03 9,571 4.11%3,777,891 3.03 11,447 3.47%3,965,046 3.03 12,014 3.13%4,059,490 3.03 12,300 2.82%4,177,314 3.03 12,657 3.24%4,077,624 3.03 12,355 39,796,244 3.03 120,583
6,000 7,000 1,000 3.62%3,569,317 3.53 12,600 4.07%2,806,688 3.53 9,908 4.37%2,087,799 3.53 7,370 4.54%1,940,637 3.53 6,850 4.22%1,711,715 3.53 6,042 4.54%2,261,037 3.53 7,981 4.41%2,849,395 3.53 10,058 3.93%3,610,102 3.53 12,744 3.36%3,839,338 3.53 13,553 3.06%3,966,190 3.53 14,001 2.77%4,103,389 3.53 14,485 3.17%3,994,558 3.53 14,101 36,740,163 3.53 129,693
7,000 8,000 1,000 3.44%3,391,355 3.53 11,971 3.67%2,533,676 3.53 8,944 3.66%1,751,256 3.53 6,182 3.60%1,538,653 3.53 5,431 3.42%1,385,385 3.53 4,890 3.90%1,942,312 3.53 6,856 3.96%2,557,409 3.53 9,028 3.76%3,450,926 3.53 12,182 3.25%3,711,385 3.53 13,101 2.98%3,864,271 3.53 13,641 2.72%4,031,322 3.53 14,231 3.09%3,888,872 3.53 13,728 34,046,821 3.53 120,185
8,000 9,000 1,000 3.27%3,223,474 3.53 11,379 3.35%2,310,161 3.53 8,155 3.06%1,463,230 3.53 5,165 2.88%1,229,552 3.53 4,340 2.75%1,116,732 3.53 3,942 3.34%1,664,785 3.53 5,877 3.58%2,311,151 3.53 8,158 3.58%3,289,878 3.53 11,613 3.14%3,578,942 3.53 12,634 2.90%3,755,234 3.53 13,256 2.67%3,955,168 3.53 13,962 3.01%3,793,199 3.53 13,390 31,691,506 3.53 111,871
9,000 14,000 5,000 13.84%13,626,292 3.53 48,101 12.68%8,748,760 3.53 30,883 9.72%4,644,601 3.53 16,395 8.28%3,534,487 3.53 12,477 8.12%3,292,519 3.53 11,623 10.94%5,448,660 3.53 19,234 13.13%8,484,839 3.53 29,951 14.86%13,651,645 3.53 48,190 13.68%15,611,760 3.53 55,110 12.99%16,835,603 3.53 59,430 12.37%18,303,656 3.53 64,612 13.53%17,045,846 3.53 60,172 129,228,669 3.53 456,177
14,000 17,000 3,000 6.30%6,201,136 3.53 21,890 5.09%3,509,713 3.53 12,389 3.25%1,552,950 3.53 5,482 2.53%1,078,428 3.53 3,807 2.57%1,040,462 3.53 3,673 3.75%1,868,529 3.53 6,596 5.13%3,316,423 3.53 11,707 6.62%6,079,383 3.53 21,460 6.52%7,443,346 3.53 26,275 6.43%8,333,682 3.53 29,418 6.49%9,598,349 3.53 33,882 6.75%8,507,905 3.53 30,033 58,530,305 3.53 206,612
17,000 20,000 3,000 4.90%4,828,232 4.09 19,747 3.78%2,607,922 4.09 10,666 2.33%1,115,906 4.09 4,564 1.75%747,248 4.09 3,056 1.84%747,144 4.09 3,056 2.59%1,290,255 4.09 5,277 3.70%2,389,863 4.09 9,775 5.11%4,695,866 4.09 19,206 5.31%6,064,672 4.09 24,805 5.39%6,985,889 4.09 28,572 5.65%8,352,028 4.09 34,160 5.60%7,052,405 4.09 28,844 46,877,431 4.09 191,729
20,000 25,000 5,000 5.89%5,797,135 4.09 23,710 4.32%2,980,704 4.09 12,191 2.69%1,286,488 4.09 5,262 2.08%889,998 4.09 3,640 2.10%850,735 4.09 3,480 2.80%1,395,873 4.09 5,709 4.07%2,632,373 4.09 10,766 6.01%5,520,208 4.09 22,578 6.56%7,486,372 4.09 30,619 6.93%8,981,536 4.09 36,734 7.59%11,226,555 4.09 45,917 7.04%8,868,349 4.09 36,272 57,916,325 4.09 236,878
25,000 29,000 4,000 3.25%3,195,946 4.75 15,181 2.33%1,604,816 4.75 7,623 1.49%714,287 4.75 3,393 1.23%525,700 4.75 2,497 1.22%496,325 4.75 2,358 1.52%756,176 4.75 3,592 2.10%1,359,853 4.75 6,459 3.18%2,922,089 4.75 13,880 3.71%4,232,176 4.75 20,103 4.04%5,237,169 4.75 24,877 4.61%6,824,494 4.75 32,416 4.00%5,038,068 4.75 23,931 32,907,099 4.75 156,309
29,000 34,000 5,000 2.81%2,771,784 4.75 13,166 2.09%1,439,694 4.75 6,839 1.46%695,805 4.75 3,305 1.24%530,649 4.75 2,521 1.22%496,325 4.75 2,358 1.39%694,378 4.75 3,298 1.84%1,187,810 4.75 5,642 2.72%2,499,244 4.75 11,871 3.28%3,746,179 4.75 17,794 3.71%4,801,768 4.75 22,808 4.31%6,379,087 4.75 30,301 3.56%4,482,568 4.75 21,292 29,725,291 4.75 141,195
34,000 39,000 5,000 1.92%1,895,545 4.75 9,004 1.54%1,059,952 4.75 5,035 1.20%572,200 4.75 2,718 1.03%440,050 4.75 2,090 1.05%424,609 4.75 2,017 1.11%554,304 4.75 2,633 1.31%845,973 4.75 4,018 1.87%1,717,598 4.75 8,159 2.27%2,588,242 4.75 12,294 2.62%3,394,399 4.75 16,123 3.14%4,638,695 4.75 22,034 2.48%3,123,854 4.75 14,838 21,255,420 4.75 100,963
39,000 44,000 5,000 1.42%1,393,453 4.75 6,619 1.22%842,625 4.75 4,002 1.05%504,044 4.75 2,394 0.90%385,996 4.75 1,833 0.91%369,588 4.75 1,756 0.96%479,024 4.75 2,275 1.04%672,055 4.75 3,192 1.31%1,201,495 4.75 5,707 1.65%1,879,637 4.75 8,928 1.89%2,455,028 4.75 11,661 2.32%3,432,493 4.75 16,304 1.79%2,258,713 4.75 10,729 15,874,150 4.75 75,402
44,000 50,000 6,000 1.31%1,290,320 4.75 6,129 1.17%806,662 4.75 3,832 1.11%529,458 4.75 2,515 0.95%407,313 4.75 1,935 0.96%388,181 4.75 1,844 1.00%500,372 4.75 2,377 1.06%682,176 4.75 3,240 1.18%1,084,266 4.75 5,150 1.45%1,657,403 4.75 7,873 1.64%2,127,167 4.75 10,104 2.02%2,984,857 4.75 14,178 1.55%1,954,263 4.75 9,283 14,412,437 4.75 68,459
50,000 59,000 9,000 1.51%1,485,341 5.52 8,199 1.46%1,006,587 5.52 5,556 1.44%688,103 5.52 3,798 1.29%551,205 5.52 3,043 1.31%529,338 5.52 2,922 1.30%647,937 5.52 3,577 1.31%849,721 5.52 4,690 1.34%1,231,457 5.52 6,798 1.52%1,730,358 5.52 9,552 1.72%2,231,708 5.52 12,319 2.05%3,039,465 5.52 16,778 1.60%2,016,933 5.52 11,133 16,008,153 5.52 88,365
59,000 69,000 10,000 1.36%1,334,907 5.52 7,369 1.34%923,059 5.52 5,095 1.37%656,913 5.52 3,626 1.27%542,450 5.52 2,994 1.22%494,807 5.52 2,731 1.22%608,611 5.52 3,360 1.18%763,137 5.52 4,213 1.18%1,079,772 5.52 5,960 1.25%1,425,441 5.52 7,868 1.38%1,788,064 5.52 9,870 1.57%2,316,561 5.52 12,787 1.29%1,624,226 5.52 8,966 13,557,950 5.52 74,840
69,000 +20.24%19,929,010 5.52 110,008 18.74%12,933,269 5.52 71,392 17.09%8,171,757 5.52 45,108 16.99%7,256,642 5.52 40,057 16.95%6,872,284 5.52 37,935 16.14%8,038,534 5.52 44,373 16.59%10,724,399 5.52 59,199 16.42%15,089,094 5.52 83,292 20.83%23,772,690 5.52 131,225 22.53%29,193,178 5.52 161,146 22.09%32,684,092 5.52 180,416 21.16%26,672,168 5.52 147,230 201,337,117 5.52 1,111,381
100.00%98,473,756 399,431$ 100.00%69,019,457 271,913$ 100.00%47,803,352 182,025$ 100.00%42,698,963 160,505$ 100.00%40,548,411 152,232$ 100.00%49,795,242 188,597$ 100.00%64,633,132 249,808$ 100.00%91,867,519 363,766$ 100.00%114,140,041 468,611$ 100.00%129,601,659 541,683$ 100.00%147,953,812 625,496$ 100.00%126,026,974 521,828$ 1,022,562,319 4,125,893$
Total Base Projected Revenue Summary:
Base Charges Rates Projected Revenue Rate Current Meter Monthly Volumetric Revenue 4,125,893$
5/8" x 3/4"12.99 54,588 709,098$ Increment Count Revenue Base Charge Revenue
1"20.39 7.40 1,650 12,210$ Base 709,098$
1 1/2"32.23 19.24 19 366 Increment (x 12)245,253
2"46.43 33.44 104 3,478 Base Subtotal954,351$
3"79.58 66.59 28 1,865
4"126.93 113.94 16 1,823
6"245.29 232.30 3 697 Total Projected Revenue 5,080,244$
20,438$
TABLE GF-D 2
A B C D E
MONT
H
SHUTOF
FS FOR
NON-
PAYMEN
T
NEW
METER
S SET
(TAP
FEES)
LATE FEES
($/Month)
PID MUD $9,000 SERVICE CHGS
Jan-15
26 0 12 7881.32 $90,985 PENALTIES
Feb-15
35 0 3 7049.42 $15,778
Mar-15
30 0 2 5199.87 $69,000
Apr-15
22 0 5 5449.08
May-15
29 0 3 7979.14
Jun-14
28 0 2 4078.88
Jul-14
33 5 3 8881.23
Aug-14
27 5 2 10281.2
Sep-14 36 5 2 7896.83
Oct-14
37 5 6 9480.95
Nov-14 33 5 3 11438.62
Dec-14
25 5 3 5368.81
Total 361 30 61 $90,985
Average
Per
Month
30 3 4 $7,582
REVENUE FOR MUD TAP
FEES:
REVENUE FOR PID UTILITY
FEES:
GROWTH RATE : 2.00% recommended
OTHER REVENUE SOURCES
REVENUE FOR SHUTOFFS
(MO. AVE. X 12 x $25):
TOTAL LATE FEES:
Increment Above Base
APRIL MAY JUNE JULYOCTOBERNOVEMBERDECEMBERJANUARYFEBURARYMARCH TOTALAUGUSTSEPTEMBER
APRIL MAY JUNEOCTOBERNOVEMBERDECEMBERJANUARYFEBURARYMARCH TOTALJULYAUGUSTSEPTEMBER
APRIL MAY JUNEOCTOBERNOVEMBERDECEMBERJANUARYFEBURARYMARCH TOTALJULYAUGUSTSEPTEMBER
TOTALAPRILMAYJUNEJULYAUGUSTSEPTEMBERMARCHOCTOBERNOVEMBERDECEMBERJANUARYFEBURARY
ϭϵTrophy Club Municipal Utility District No. 1 99 of 112 September 2, 2015 - Special Meeting
Agenda Packet
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage Accounts Usage
0 to 1,000 235 4,376,930 301 4,356,592 377 4,341,559 391 4,291,632 417 4,295,794 368 4,306,344 307 4,344,184 255 4,414,219 218 4,446,927 218 4,458,919 174 4,497,531 203 4,470,330
1,000 to 2,000 106 4,290,857 197 4,234,780 288 4,172,902 265 4,127,184 338 4,112,518 240 4,152,412 187 4,226,115 113 4,322,459 79 4,377,339 77 4,403,838 58 4,445,524 61 4,397,648
2,000 to 3,000 138 4,184,235 277 4,036,402 404 3,882,566 403 3,862,621 487 3,774,804 377 3,913,837 264 4,039,828 123 4,208,602 98 4,297,649 80 4,326,275 64 4,387,573 83 4,336,091
3,000 to 4,000 142 4,045,433 341 3,757,589 478 3,475,942 524 3,461,018 598 3,288,345 454 3,538,933 317 3,776,704 148 4,085,007 113 4,199,252 88 4,245,340 70 4,322,935 82 4,252,654
4,000 to 5,000 162 3,903,141 308 3,414,971 489 2,994,231 520 2,937,983 523 2,691,464 445 3,087,624 304 3,461,104 158 3,936,318 120 4,085,890 96 4,156,911 75 4,252,725 93 4,170,701
5,000 to 6,000 170 3,739,912 297 3,104,835 411 2,501,354 480 2,419,515 458 2,169,336 387 2,645,304 311 3,158,623 167 3,777,891 125 3,965,046 92 4,059,490 73 4,177,314 83 4,077,624
6,000 to 7,000 177 3,569,317 272 2,806,688 334 2,087,799 403 1,940,637 327 1,711,715 321 2,261,037 293 2,849,395 159 3,610,102 127 3,839,338 101 3,966,190 72 4,103,389 106 3,994,558
7,000 to 8,000 167 3,391,355 222 2,533,676 286 1,751,256 310 1,538,653 269 1,385,385 279 1,942,312 247 2,557,409 160 3,450,926 132 3,711,385 108 3,864,271 76 4,031,322 96 3,888,872
8,000 to 9,000 163 3,223,474 203 2,310,161 216 1,463,230 222 1,229,552 194 1,116,732 231 1,664,785 243 2,311,151 199 3,289,878 140 3,578,942 122 3,755,234 86 3,955,168 120 3,793,199
9,000 to 14,000 829 13,626,292 811 8,748,760 661 4,644,601 604 3,534,487 528 3,292,519 737 5,448,660 850 8,484,839 890 13,651,645 796 15,611,760 691 16,835,603 548 18,303,656 681 17,045,846
14,000 to 17,000 469 6,201,136 328 3,509,713 171 1,552,950 132 1,078,428 122 1,040,462 221 1,868,529 346 3,316,423 482 6,079,383 465 7,443,346 451 8,333,682 391 9,598,349 481 8,507,905
17,000 to 20,000 399 4,828,232 252 2,607,922 99 1,115,906 65 747,248 70 747,144 139 1,290,255 243 2,389,863 409 4,695,866 433 6,064,672 432 6,985,889 405 8,352,028 465 7,052,405
20,000 to 25,000 446 5,797,135 255 2,980,704 113 1,286,488 66 889,998 69 850,735 134 1,395,873 252 2,632,373 463 5,520,208 540 7,486,372 596 8,981,536 645 11,226,555 640 8,868,349
25,000 to 29,000 257 3,195,946 118 1,604,816 43 714,287 27 525,700 26 496,325 52 756,176 115 1,359,853 250 2,922,089 319 4,232,176 333 5,237,169 412 6,824,494 365 5,038,068
29,000 to 34,000 217 2,771,784 92 1,439,694 32 695,805 23 530,649 19 496,325 40 694,378 83 1,187,810 191 2,499,244 280 3,746,179 329 4,801,768 392 6,379,087 319 4,482,568
34,000 to 39,000 115 1,895,545 56 1,059,952 15 572,200 11 440,050 12 424,609 18 554,304 47 845,973 120 1,717,598 164 2,588,242 218 3,394,399 280 4,638,695 204 3,123,854
39,000 to 44,000 76 1,393,453 34 842,625 11 504,044 10 385,996 11 369,588 12 479,024 21 672,055 70 1,201,495 108 1,879,637 145 2,455,028 198 3,432,493 137 2,258,713
44,000 to 50,000 54 1,290,320 25 806,662 11 529,458 8 407,313 5 388,181 11 500,372 20 682,176 48 1,084,266 86 1,657,403 115 2,127,167 163 2,984,857 109 1,954,263
50,000 to 59,000 39 1,485,341 22 1,006,587 13 688,103 6 551,205 8 529,338 13 647,937 19 849,721 37 1,231,457 71 1,730,358 81 2,231,708 133 3,039,465 81 2,016,933
59,000 to 69,000 24 1,334,907 16 923,059 10 656,913 7 542,450 8 494,807 9 608,611 12 763,137 24 1,079,772 32 1,425,441 52 1,788,064 84 2,316,561 44 1,624,226
69,000 ++120 19,929,010 84 12,933,269 60 8,171,757 51 7,256,642 46 6,872,284 56 8,038,534 72 10,724,399 94 15,089,094 125 23,772,690 152 29,193,178 187 32,684,092 140 26,672,168
WASTEWATER RATES FOR ALL METER SIZES
Gallons Included in Minimum Bill =0
% of Sewer Meters not Subject to Cap 2.25%$ Amount of Minimum Bill =15.35
MIN BILL =$15.35
0 to 6,999 $2.63
7,000 to 18,000 $2.63
Oct 10 Nov 11 Dec 12 Jan 1 Feb 2 Mar 3 Apr 4 May 5 Jun 6 Jul 7 Aug 8 Sep 9
Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Base * Accts Usage Accounts Usage Accounts Usage Accounts Usage
0 to 1,000 $3,612 $11,511 $4,617 $11,458 $5,788 $11,418 $5,999 $11,287 $6,401 $11,298 $5,650 $11,326 $4,711 $11,425 $3,912 $11,609 $3,340 $11,695 $3,342 $11,727 $2,671 $11,829 $3,109 $11,757
1,000 to 2,000 $1,629 $11,285 $3,029 $11,137 $4,426 $10,975 $4,072 $10,854 $5,193 $10,816 $3,684 $10,921 $2,873 $11,115 $1,741 $11,368 $1,216 $11,512 $1,179 $11,582 $883 $11,692 $943 $11,566
2,000 to 3,000 $2,120 $11,005 $4,257 $10,616 $6,198 $10,211 $6,181 $10,159 $7,481 $9,928 $5,789 $10,293 $4,058 $10,625 $1,890 $11,069 $1,501 $11,303 $1,230 $11,378 $984 $11,539 $1,279 $11,404
3,000 to 4,000 $2,173 $10,639 $5,231 $9,882 $7,343 $9,142 $8,050 $9,102 $9,179 $8,648 $6,968 $9,307 $4,867 $9,933 $2,274 $10,744 $1,730 $11,044 $1,344 $11,165 $1,069 $11,369 $1,256 $11,184
4,000 to 5,000 $2,493 $10,265 $4,735 $8,981 $7,513 $7,875 $7,980 $7,727 $8,029 $7,079 $6,830 $8,120 $4,665 $9,103 $2,423 $10,353 $1,844 $10,746 $1,480 $10,933 $1,149 $11,185 $1,426 $10,969
5,000 to 6,000 $2,606 $9,836 $4,552 $8,166 $6,304 $6,579 $7,370 $6,363 $7,037 $5,705 $5,933 $6,957 $4,769 $8,307 $2,566 $9,936 $1,918 $10,428 $1,418 $10,676 $1,126 $10,986 $1,273 $10,724
6,000 to 7,000 $2,718 $9,387 $4,168 $7,382 $5,130 $5,491 $6,187 $5,104 $5,018 $4,502 $4,921 $5,947 $4,503 $7,494 $2,434 $9,495 $1,952 $10,097 $1,549 $10,431 $1,098 $10,792 $1,620 $10,506
7,000 to 8,000 $2,564 $8,919 $3,413 $6,664 $4,391 $4,606 $4,757 $4,047 $4,131 $3,644 $4,285 $5,108 $3,798 $6,726 $2,463 $9,076 $2,021 $9,761 $1,657 $10,163 $1,160 $10,602 $1,466 $10,228
8,000 to 9,000 $2,499 $8,478 $3,123 $6,076 $3,311 $3,848 $3,410 $3,234 $2,982 $2,937 $3,551 $4,378 $3,734 $6,078 $3,058 $8,652 $2,147 $9,413 $1,867 $9,876 $1,313 $10,402 $1,847 $9,976
9,000 to 14,000 $12,732 $35,837 $12,452 $23,009 $10,143 $12,215 $9,269 $9,296 $8,111 $8,659 $11,311 $14,330 $13,041 $22,315 $13,654 $35,904 $12,217 $41,059 $10,607 $44,278 $8,408 $48,139 $10,451 $44,831
14,000 to 17,000 $7,201 $16,309 $5,042 $9,231 $2,618 $4,084 $2,027 $2,836 $1,873 $2,736 $3,395 $4,914 $5,312 $8,722 $7,405 $15,989 $7,136 $19,576 $6,918 $21,918 $6,003 $25,244 $7,388 $22,376
17,000 to 20,000 $6,129 $1,312 $3,873 $803 $1,514 $320 $1,002 $212 $1,080 $225 $2,140 $435 $3,723 $765 $6,283 $1,330 $6,645 $1,472 $6,627 $1,523 $6,224 $1,537 $7,143 $1,614
20,000 to 25,000 $6,846 $1,490 $3,920 $833 $1,732 $366 $1,019 $223 $1,056 $227 $2,059 $427 $3,862 $802 $7,102 $1,516 $8,289 $1,831 $9,144 $2,063 $9,901 $2,323 $9,820 $2,169
25,000 to 29,000 $3,938 $849 $1,807 $398 $663 $153 $422 $102 $397 $96 $792 $177 $1,769 $377 $3,837 $816 $4,893 $1,070 $5,118 $1,167 $6,326 $1,463 $5,598 $1,236
29,000 to 34,000 $3,328 $721 $1,417 $323 $493 $124 $352 $90 $292 $78 $619 $145 $1,272 $283 $2,932 $639 $4,293 $941 $5,044 $1,129 $6,020 $1,386 $4,899 $1,086
34,000 to 39,000 $1,759 $407 $862 $207 $235 $73 $170 $54 $187 $56 $283 $80 $728 $172 $1,844 $411 $2,512 $574 $3,353 $762 $4,300 $995 $3,131 $709
39,000 to 44,000 $1,167 $278 $525 $138 $176 $59 $146 $47 $163 $49 $185 $59 $318 $93 $1,071 $250 $1,661 $389 $2,232 $519 $3,038 $712 $2,097 $485
44,000 to 50,000 $823 $214 $378 $111 $164 $59 $117 $44 $76 $36 $162 $57 $306 $92 $739 $188 $1,313 $318 $1,771 $422 $2,501 $595 $1,676 $396
50,000 to 59,000 $592 $187 $331 $115 $194 $73 $100 $49 $128 $53 $202 $72 $295 $100 $573 $169 $1,096 $286 $1,247 $341 $2,048 $523 $1,245 $328
59,000 to 69,000 $373 $141 $248 $96 $147 $63 $111 $51 $117 $49 $145 $60 $179 $75 $361 $124 $497 $168 $797 $239 $1,296 $354 $682 $210
69,000 ++$1,848 $1,489 $1,293 $982 $916 $637 $779 $560 $712 $526 $862 $620 $1,104 $820 $1,449 $1,136 $1,912 $1,727 $2,334 $2,118 $2,863 $2,414 $2,154 $1,939
REVENUE:$69,152 $150,560 $69,275 $116,606 $69,397 $88,372 $69,520 $81,442 $69,643 $77,347 $69,766 $93,735 $69,889 $115,421 $70,011 $150,772 $70,134 $165,410 $70,257 $174,412 $70,380 $186,079 $70,503 $175,692
PROJECTED ANNUAL REVENUE GENERATED FROM PROPOSED RATES =$0
AMOUNT FROM BASE:$837,926
AMOUNT FROM USAGE:$1,575,850
TOTAL:$2,413,776
TROPHY CLUB COUNTRY CLUB EFFLUENT REVENUE
Month Mil Gals Charges
Jul-14 17.924 $12,547
Aug-14 19.676 $13,773
Sep-14 23.703 $16,592
Oct-14 10.225 $7,158
Nov-14 7.211 $5,048
Dec-14 0.847 $593
Jan-15 0.401 $281
Feb-15 1.252 $876
Mar-15 0.843 $590
Apr-15 1.891 $1,324
May-15 0 $0
Jun-15 3.641 $2,549
TOTAL:87.614 $61,330
SCHEDULE GF-E
PROJECTED RETAIL WASTEWATER SALES FY 15
WATER USE
CATEGORY
PROJECTED FY 2015 RETAIL WASTEWATER REVENUES
Usage Groups
20Trophy Club Municipal Utility District No. 1 100 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-F
UNIFORMS
WATER
ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL
UNIFORM SHIRTS 6 10 60 $14 $810
POLO SHIRTS 6 4 24 $17 $408
SWEATSHIRTS 6 5 30 $18 $540
PANTS 6 7 42 $25 $1,050
BOOTS 6 1 6 $175 $1,050
JACKET 5 1 5 $150 $750
TOTAL:$4,608
WASTEWATER
ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL
UNIFORM SHIRTS 7 6 42 $18 $756
POLO SHIRTS 1 4 4 $35 $140
SWEATSHIRTS 7 5 35 $27 $945
PANTS 7 5 35 $25 $875
BOOTS 7 1 7 $175 $1,225
JACKET 2 1 2 $150 $300
TOTAL:$4,241
ADMINISTRATION
ITEM NUMBER EMPLOYEES NUMBER PER EMPLOYEE TOTAL # TO PURCHASE COST EACH SUBTOTAL
POLO SHIRTS 7 5 35 $35 $1,225
(Director) SHIRTS 5 2 10 $35 $350
SWEATER 7 1 7 $40 $280
PANTS 0 0 0 $25 $0
TOTAL:$1,855
21
Trophy Club Municipal Utility District No. 1 101 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-G
TRAVEL & TRAINING
Training
Number to
Attend
Estimated Class
Cost/Person Total Training
Estimated Travel & Per
Diem Cost Per Person
Total Travel &
Per Diem
Total Dept.
Cost
WATER
Water/WW Classes 12 $325 $3,900 $50 $300
CSI Class 0 $170 $0 $50 $0
CSI Renewals 0 $111 $0 $50 $0
Management Classes 0 $350 $0 $100 $0
Management Conferences 1 $350 $350 $400 $400
License Renewal 8 $111 $888 $100 $400
CDL Renewal 1 $75 $75 $0 $0
Miscellaneous Mileage/Travel (Miles)1,000 $0.56 $560 $0 $300
$5,773 $1,400 $7,173
WASTEWATER
Wastewater/Distribution Classes 8 $325 $2,600 $50 $400
Management Classes 0 $350 $0 $200 $400
Management Conferences 1 $350 $350 $400 $400
License Renewal 1 $111 $111 $100 $100
CDL Renewal 2 $75 $150 $0 $0
Miscellaneous Mileage/Travel (Miles)1,000 $0.56 $560 $0 $300
$3,771 $1,600 $5,371
ADMINISTRATION
Management Classes 2 $350 $700 $300 $600
Management Conferences 4 $350 $1,400 $400 $1,600
Elections Training 2 $350 $700 $400 $800
Public Funds Inv. Training 2 $300 $600 $100 $200
Govmt Accounting Conference 2 $350 $700 $400 $800
Software Training 4 $300 $1,200 $50 $200
Photoshop 1 $975 $975 $100 $100
Customer Service Conferences 2 $350 $700 $400 $800
CPA/CFE Classes/Renewal 1 $900 $900 $0 $0
Miscellaneous Mileage/Travel (Miles)1,000 $0.56 $560 $0 $300
Miscellaneous Travel (Legal)3 $500 $1,500 $0 $0
$9,935 $5,400 $15,335
22
Trophy Club Municipal Utility District No. 1 102 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-H
SALARY WITHOUT FIRE STIPEND WORKSHEET
COLA Merit 50% Town Total Social TWC WORKERS
Base Pay Base Pay Pay Pay Stipend Salaries OT Holiday Longevity Certification Security Medi UNEMP COMP
FIRE DEPARTMENT %No Split With Split 0.0%4%*($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%2.3% TO $4500
(9/year)
Fire Chief 50.00%106,318 53,159 0 1,605 0 54,765 0 0 728 728 0 0 3,441 805 104 1,015
Fire Captain 50.00%69,334 34,667 0 1,047 0 35,714 3,304 1,301 439 439 600 600 2,564 600 104 662
Fire Captain 50.00%78,263 39,132 0 1,182 0 40,313 3,738 1,468 874 874 450 450 2,904 679 104 747
Fire Captain 50.00%74,602 37,301 0 1,126 0 38,427 3,556 1,399 563 563 600 600 2,762 646 104 712
Fire Fighter/EMT-P 50.00%51,680 25,840 0 780 0 26,620 2,475 969 368 368 450 450 1,915 448 104 494
Fire Fighter/EMT-P 50.00%50,724 25,362 0 766 0 26,128 2,383 951 281 281 0 0 1,844 431 104 484
Engineer - Fire Fighter/EMT-P 50.00%64,018 32,009 0 967 0 32,976 3,061 1,201 593 593 450 450 2,373 555 104 611
Engineer - Fire Fighter/EMT-P 50.00%62,690 31,345 0 947 0 32,292 2,990 1,178 435 435 450 450 2,315 542 104 600
Engineer - Fire Fighter/EMT-P 50.00%62,792 31,396 0 948 0 32,344 3,007 1,178 473 473 600 600 2,331 545 104 600
Fire Fighter/EMT-P 50.00%57,602 28,801 0 870 0 29,671 2,743 1,081 473 473 300 300 2,125 497 104 550
Fire Fighter/EMT-P 50.00%54,123 27,062 0 817 0 27,879 2,575 1,015 390 390 300 300 1,994 466 104 517
Fire Fighter/EMT-P 50.00%49,171 24,586 0 246 0 24,832 2,250 887 0 0 0 0 1,734 406 104 483
Fire Fighter/EMT-P 50.00%50,356 25,178 0 760 0 25,938 2,349 945 0 90 0 0 1,818 425 104 481
Fire Fighter/EMT-P 50.00%49,706 24,853 0 751 0 25,604 2,317 933 58 58 0 0 1,792 419 104 475
Fire Fighter/EMT-P 50.00%49,171 24,586 0 246 0 24,832 2,250 887 0 0 0 0 1,734 406 104 462
Fire Fighter/EMT-P NEW 50.00%35,780 17,890 0 179 0 18,069 1,537 459 0 0 0 0 1,244 291 104 266
Part-Time Staff 50.00%23,646 11,823 0 0 0 11,823 0 0 0 0 0 0 733 171 68 220
FTO 50.00%0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
50.00%0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 0 0
50.00%0 0 0 0 0 N/A 0 0 0 0 0 0 0 0 0 0
Special Event OT 50.00%0 0 0 0 0 N/A 8,200 0 0 0 0 0 508 119 0 0
TOTAL:989,977 494,988 0 13,237 0 508,226 48,735 15,852 5,761 4,200 36,132 8,450 1724 9,379
* Merit up to 2% 10/1/16 and up to 2% 4/01/16 Total w/OT:
** New position funded 3/4 of a year
COLA Merit Merit Total Social TWC UNEMP WORKERS
Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 2.30%COMP
ADMINISTRATION %Base Pay Base Pay 2.5%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000
General Manager 100%110,591 110,591 2,765 0 1,500 114,856 0 0 210 210 0 0 7,147 1,772 207 222
District Secretary 100%75,000 75,000 1,875 0 1,100 77,975 0 0 450 450 0 0 4,890 1,208 207 222
Administration Manager 100%82,500 82,500 2,063 0 1,100 85,663 0 0 180 180 0 0 5,333 1,322 207 222
Finance Manager 100%86,741 86,741 2,169 0 1,100 90,009 0 0 2,000 2,000 0 0 5,829 1,419 207 222
Utility Billing Clerk 100%43,617 43,617 1,090 0 1,040 45,747 0 0 668 668 0 0 2,919 715 207 222
Reception/Utility Billing Clerk 100%27,540 27,540 689 0 1,040 29,269 0 0 60 60 0 0 1,822 452 207 222
Communications Specialist 100%41,902 41,902 1,048 0 1,040 43,989 0 0 255 255 0 0 2,759 682 207 222
Overtime Pay 1,000 62 15
DM Discretionary 1,000 62 15
TOTAL:467,890 467,890 11,697 0 7,920 488,508 1,000 0 3,823 0 30,823 7,599 1,449 1,554
556,961
23
Trophy Club Municipal Utility District No. 1 103 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-H
SALARY WORKSHEET
COLA Merit Merit Total Social TWC UNEMP WORKERS
Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 2.30%COMP
WATER & DISTRIBUTION %Base Pay Base Pay 2.5%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000
Water Superintendent 100%71,000 71,000 1,775 0 1,500 74,275 0 0 1553 1553 0 0 4,798 1,122 207 2,459
Crew Leader 100%47,625 47,625 1,191 0 1,040 49,856 0 0 1253 1253 1500 1500 3,432 803 207 2,459
Utility Field Worker 100%36,811 36,811 920 0 1,040 38,771 0 0 140 140 900 900 2,533 592 207 2,459
Utility Field Worker 100%37,440 37,440 0 0 1,040 38,480 0 0 0 0 600 600 2,460 575 207 2,459
Utility Field Worker 100%33,280 33,280 832 0 1,040 35,152 0 0 0 0 900 900 2,291 536 207 2,459
Utility Field Worker 100%27,040 27,040 0 0 1,040 28,080 0 0 0 0 300 300 1,778 416 207 2,459
Overtime Pay 19,500 1,209 283
DM Discretionary 1,000 62 15
TOTAL:253,196 253,196 4,718 0 6,700 265,614 19,500 0 2,945 4,200 18,563 4,341 1,242 14,754
COLA Merit Merit Total Social TWC UNEMP WORKERS
Pay Pay Pay Salaries OT Holiday Longevity Certification Security Medicare 2.30%COMP
WASTEWATER & COLLECTIONS %Base Pay Base Pay 2.5%0%($)& Wages Pay Pay Rate Longevity Rate Certification 6.2%1.45%UP TO $9000
Wastewater Superintendent 100%71,300 71,300 1,782.50 0 1,400 74,483 0 0 200 200 - - 4,643 1,086 207 1,331
Wastewater Shift Supervisor 100%28,500 28,500 - 0 28,500 0 0 0 0 600 600 1,841 431 207 1,331
Crew Leader 100%55,248 55,248 1,381.21 0 1,040 57,669 0 0 1583 1,583 1,800 1,800 3,995 934 207 1,331
Utility Field Worker 100%49,243 49,243 1,231.08 0 1,040 51,514 0 0 1193 1,193 1,800 1,800 3,565 834 207 1,331
Utility Field Worker 100%39,183 39,183 979.58 0 1,040 41,203 0 0 683 683 1,200 1,200 2,788 652 207 1,331
Crew Leader 100%53,504 53,504 1,337.60 0 1,040 55,881 0 0 1,665 1,665 1,200 1,200 3,820 893 207 1,331
Utility Field Worker 100%39,395 39,395 984.88 0 1,040 41,420 0 0 803 803 600 600 2,742 641 207 1,331
Overtime Pay 19,500 - 0 0 - - 1,209 283
DM Discretionary 1,000 - - 0 0 - - 62 15
TOTAL:336,374 336,374 7,697 0 6,600 351,671 19,500 0 6,125 7,200 24,665 5,768 1,449 9,317
24
Trophy Club Municipal Utility District No. 1 104 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-H.1
FIRE SALARY WORKSHEET
COLA Merit Merit Merit
Base Pay Base Pay Pay Pay Pay Pay Total
FIRE DEPARTMENT %No Split With Split 0.0%2.0%1.0%Total Salary
10/1/2015 4/1/2016 For FY 16 FY 16 100.0%Town's SS
Fire Chief 50.00%106,318 53,159 0 1,063 542 1,605 54,765 109,529 109,117
Fire Captain 50.00%69,334 34,667 0 693 354 1,047 35,714 71,428 71,187
Fire Captain 50.00%78,263 39,132 0 783 399 1,182 40,313 80,627 80,337
Fire Captain 50.00%74,602 37,301 0 746 380 1,126 38,427 76,855 76,589
Fire Fighter/EMT-P 50.00%51,680 25,840 0 517 264 780 26,620 53,241 53,053
Fire Fighter/EMT-P 50.00%50,724 25,362 0 507 259 766 26,128 52,256 52,061
Engineer - Fire Fighter/EMT-P 50.00%64,018 32,009 0 640 326 967 32,976 65,951 65,731
Engineer - Fire Fighter/EMT-P 50.00%62,690 31,345 0 627 320 947 32,292 64,584 64,463
Engineer - Fire Fighter/EMT-P 50.00%62,792 31,396 0 628 320 948 32,344 64,688 64,463
Fire Fighter/EMT-P 50.00%57,602 28,801 0 576 294 870 29,671 59,342 59,144
Fire Fighter/EMT-P 50.00%54,123 27,062 0 541 276 817 27,879 55,758 55,561
Fire Fighter/EMT-P 50.00%49,171 24,586 0 0 246 246 24,831 49,663 49,663
Fire Fighter/EMT-P 50.00%50,356 25,178 0 504 257 760 25,938 51,877 51,703
Fire Fighter/EMT-P 50.00%49,706 24,853 0 497 254 751 25,604 51,207 51,041
Fire Fighter/EMT-P 50.00%49,171 24,586 0 246 246 24,831 49,663 49,663
Fire Fighter/EMT-P NEW 50.00%35,780 17,890 0 0 179 179 18,069 36,138 0
TOTAL:966,331 483,165 0 8,322 4,915 13,237 496,403 992,805 953,776
25
Trophy Club Municipal Utility District No. 1 105 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-I
BENEFITS WORKSHEET
Added Benefits for New Fire Position-Family
FIRE DEPARTMENT ADMINISTRATION
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share
@ 50%)
DISTRICT ANNUAL
COST PROJECTED
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT
ANNUAL COST
PROJECTED
Employee Only 3 $207 $621 No coverage 0 $0 $0
Employee & Spouse 3 $283 $849 Employee Only 2 $463 $925
Employee & Children 1 $291 $291 Employee & Spouse 2 $635 $1,271
Family 8.75 $357 $3,124 Employee & Children 1 $724 $724
Family 2 $944 $1,887
TOTAL 15.75 $4,885 TOTAL 7 $4,807
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share
@ 50%)
DISTRICT ANNUAL
COST PROJECTED
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT
ANNUAL COST
PROJECTED
Employee Only 8 $41 $324 No coverage 0 $0 $0
Employee and Family 7.75 $69 $535 Employee Only 2 $119 $239
Employee & Spouse 2 $161 $323
Employee & Children 1 $156 $156
Family 2 $198 $396
TOTAL 15.75 $859 TOTAL 7 $1,114
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share
@ 50%)
DISTRICT ANNUAL
COST PROJECTED
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT
ANNUAL COST
PROJECTED
Employee Only 5 $2,868 $14,340 No coverage 0 $ - $0
Employee & Spouse 4 $4,475 $17,900 Employee Only 3 8,247$ $24,741
Employee & Children 1 $3,728 $3,728 Employee & Spouse 2 11,564$ $23,127
Family 5.75 $5,144 $29,578 Employee & Children 2 10,164$ $20,327
Family 0 13,480$ $0
TOTAL 15.75 $65,546 TOTAL 7 $68,196
DISTRICT ANNUAL
COST PROJECTED
DISTRICT
ANNUAL COST
PROJECTED
TOTAL $4,585 TOTAL $4,431
VISION
DENTAL DENTAL
MEDICAL MEDICAL
LIFE & OTHER LIFE & OTHER
VISION
26
Trophy Club Municipal Utility District No. 1 106 of 112 September 2, 2015 - Special Meeting
Agenda Packet
BENEFITS WORKSHEET
WATER WASTEWATER
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT ANNUAL
COST PROJECTED
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT
ANNUAL COST
PROJECTED
No coverage 0 $0 $0 No coverage 0 $0 $0
Employee Only 3 $463 $1,388 Employee Only 2.5 $463 $1,156
Employee & Spouse 0 $635 $0 Employee & Spouse 1 $635 $635
Employee & Children 1 $724 $724 Employee & Children 2 $724 $1,449
Family 2 $944 $1,887 Family 1 $944 $944
TOTAL 6 $3,999 TOTAL 6.5 $4,184
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT ANNUAL
COST PROJECTED
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT
ANNUAL COST
PROJECTED
No coverage 0 $0 $0 No coverage 0 $0 $0
Employee Only 3 $119 $358 Employee Only 2.5 $119 $299
Employee & Spouse 0 $161 $0 Employee & Spouse 1 $161 $161
Employee & Children 1 $156 $156 Employee & Children 2 $156 $313
Family 2 $198 $396 Family 1 $198 $198
TOTAL 6 $910 TOTAL 6.5 $971
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT ANNUAL
COST PROJECTED
NO.
EMPLOYEES
ANNUAL RATE
(TCMUD Share)
DISTRICT
ANNUAL COST
PROJECTED
No coverage 0 $0 $0 No coverage 0 $0 $0
Employee Only 5 8,247$ $41,235 Employee Only 2.5 8,247$ $20,617
Employee & Spouse 0 11,564$ $0 Employee & Spouse 1 11,564$ $11,564
Employee & Children 1 10,164$ $10,164 Employee & Children 2 10,164$ $20,327
Family 0 13,480$ $0 Family 1 13,480$ $13,480
TOTAL 6 $51,398 TOTAL 6.5 $65,989
DISTRICT ANNUAL
COST PROJECTED
DISTRICT
ANNUAL COST
PROJECTED
TOTAL $2,803 TOTAL $3,655
VISION
FOR ALL DEPARTMENTS (EXCLUDING FIRE) A 10% INCREASE IN EMPLOYEE BENEFITS WAS BUDGETED AS RENEWAL IS NOT UNTIL DECEMBER 2015
LIFE & OTHER
DENTAL
VISION
MEDICALMEDICAL
LIFE & OTHER
DENTAL
27
Trophy Club Municipal Utility District No. 1 107 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-J
RETIREMENT WORKSHEET
FIRE DEPARTMENT Oct-Dec Jan-Sept
TMRS TMRS TMRS
TOTAL FY 2016 SALARY 13.62%12.75%FY 16 Total WATER Oct-Dec Jan-Sept
Fire Chief 55,492 1890 5306 7196 TCDRS TCDRS TCDRS
Fire Lieutenant 41,358 1408 3955 5363 TOTAL FY 2016 SALARY 8.91%8.73%FY 16 Total
Fire Lieutenant 46,843 1595 4479 6074 Water Superintendent 75,828 1689 4965 6654
Fire Lieutenant 44,545 1517 4260 5776 Crew Leader 52,608 1172 3445 4616
Fire Fighter/EMT-P 30,882 1052 2953 4005 Utility Field Worker 39,811 887 2607 3493
Fire Fighter/EMT-P 29,743 1013 2844 3857 Utility Field Worker 39,080 871 2559 3429
Engineer - Fire Fighter/EMT-P 38,280 1303 3661 4964 Utility Field Worker 36,052 803 2361 3164
Engineer - Fire Fighter/EMT-P 37,345 1272 3571 4843 Utility Field Worker 28,380 632 1858 2490
Engineer - Fire Fighter/EMT-P 37,602 1280 3596 4876 Overtime Pay 19,500 434 1277 1711
Fire Fighter/EMT-P 34,267 1167 3277 4444 TOTAL:291,259 6,488 19,070 25,558
Fire Fighter/EMT-P 32,159 1095 3075 4170
Fire Fighter/EMT-P 27,969 952 2674 3627
Fire Fighter/EMT-P 29,322 998 2804 3802
Fire Fighter/EMT-P 28,911 984 2765 3749
Fire Fighter/EMT-P 27,969 952 2674 3627 WASTEWATER Oct-Dec Jan-Sept
Fire Fighter/EMT-P NEW 20,065 683 1919 2602 TCDRS TCDRS TCDRS
Part-Time Staff 11,823 403 1131 1533 TOTAL FY 2016 SALARY 8.91%8.73%FY 16 Total
0 0 0 0 Wastewater Superintendent 74,683 1,664 4890 6553
Overtime Pay (Total)8,200 279 784 1063 Wastewater Shift Supervisor 29,100 648 1905 2554
TOTAL:582,774 19,843 55,728 75,571 Crew Leader 61,052 1,360 3997 5357
Utility Field Worker 54,507 1,214 3569 4783
Utility Field Worker 43,085 960 2821 3781
Crew Leader 58,746 1,309 3846 5155
Utility Field Worker 42,823 954 2804 3758
ADMINISTRATION Oct-Dec Jan-Sept Overtime Pay 19,500 434 1277 1711
TCDRS TCDRS TCDRS TOTAL:383,496 8,542 25,109 33,652
TOTAL FY 2016 SALARY 8.91%8.73%FY 16 Total
General Manager 115,066 2,563 7,534 10,097
District Secretary 78,425 1,747 5,135 6,882
Administration Manager 85,843 1,912 5,621 7,533
Finance Manager 92,009 2,050 6,024 8,074
Utility Billing Clerk 46,415 1,034 3,039 4,073
Reception/Utility Billing Clerk 29,329 653 1,920 2,574
Communications Specialist 44,244 986 2,897 3,882
Overtime Pay 1,000 22 65 88
TOTAL:492,330 10,967 32,235 43,202
28Trophy Club Municipal Utility District No. 1 108 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-K
Electricity & Gas Analysis for FY 2015-2016
Hudson Energy FY 2016
ESID #Expense Acct Location KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed KWH Ttl Billed Total KWH
Annual
Total $Cost per KWH
5%
INCREASE
2836193 135-60020-010 Water Well #1, Well #3 94,800 $7,361 87,360 $6,884 151,625 $12,073 38,215 $2,997 64080 $5,450 13680 $2,214 13440 $1,472 12480 1587 12,000 $1,369 13,920 $1,907 19920 $2,376 33600 $3,150 555,120 48,840 0.087980491 $51,282
2770721 135-60020-010 Elevated Tank-TW King 145 $23 185 $27 312 $45 83 $11 216 $29 661 $71 927 $88 1011 $94 1,160 $108 999 $94 860 $82 834 $80 7,393 751 0.101609631 $789
2828381 135-60020-010 Paluxy Well #4 13,600 $1,052 12,240 $964 20,591 $1,646 5,329 $418 12320 $977 12720 $1,002 11440 $835 12560 $881 12,320 $863 13,360 $921 11120 $795 12720 $891 150,320 11,244 0.074803552 $11,807
2829590 135-60020-010 Paluxy Well #2 15,762 $1,223 15,150 $1,175 24,128 $1,921 6,253 $487 14475 $922 15006 $1,410 16123 $1,127 15236 $1,054 14,758 $1,030 16,081 $1,112 13622 $975 15398 $1,072 181,992 13,508 0.074224746 $14,184
2836131 135-60020-010 Water Plant/Water Barn 1,753 $237 1,677 $232 2,988 $1,679 624 $96 1298 $329 4030 $531 6462 $657 4944 $661 6,443 $726 1,832 $291 1177 $228 1314 $183 34,542 5,850 0.169361357 $6,143
2836162 135-60020-010 Water plant pump station 33,600 $5,885 34,800 $6,021 40,907 $8,080 3,493 $1,136 4400 $1,544 4400 $613 5800 $824 5000 $1,461 6,800 $1,604 2,400 $1,275 9600 $2,459 39600 $4,901 190,800 35,802 0.187644025 $37,593
8644641 135-60020-010 100 Municipal Dr, Unit B 34600 $3,815 33100 $3,717 78953 $7,784 24047 $2,243 45700 $4,593 32600 $3,718 27800 $3,218 26000 $2,796 24100 $2,907 35000 $3,534 23400 $2,856 300 $593 385,600 41,775 0.108337085 $43,864
9130039 135-60020-010 2901 Bobcat Unit A, Elev Tank 754 $80 683 $73 1095 $117 274 $29 724 $77 702 $75 703 $69 795 $76 1507 $137 1523 $138 1369 $125 1206 $112 11,335 1,108 0.097775033 $1,164
TOTAL: $166,823
2828536 135-60020-020 Sewer Plant 131,898 $10,423 121,322 $9,710 211,950 $16,910 56014 $4,434 128748 $10,386 134459 $10,723 130929 $9,321 118297 $8,465 127,224 $17,464 134,108 $9,296 119940 $8,695 128970 $17,856 1,543,859 133,683 0.086590045 $140,367
TOTAL:$140,367
8611313 135-60020-021 Maintenance Barn 493 $89 173 $61 336 $102 104 $27 213 $140 5146 $474 7787 $584 4582 $397 6,766 $912 1,582 $228 412 $138 378 $250 27,972 3,401 0.121599814 $3,571
8251800 135-60020-021 310 Skyline-Lift Sta #6 600 $164 500 $97 956 $253 244 $52 400 $84 400 $92 600 $108 800 $167 700 $287 700 $112 500 $179 600 $290 7,000 1,884 0.269167143 $1,978
5437067 135-60020-021 Lift Sta #2 Guard Light 70 $13 70 $13 112 $21 28 $5 70 $13 70 $13 70 $13 70 $13 70 $25 70 $13 70 $13 70 $25 840 181 0.214904762 $190
2820941 135-60020-021 Lift Station Trophy 20 424 $49 244 $32 362 $49 92 $12 223 $30 262 $34 277 $33 240 $30 285 $63 301 $35 309 $36 431 $83 3,450 486 0.140918841 $510
6245046 135-60020-021 Lift Station #2 1,632 $373 1,437 $210 2,298 $353 597 $103 1309 $382 1306 $195 1458 $184 1269 $192 1,374 $540 1,370 $290 1383 $224 1449 $536 16,882 3,582 0.212201161 $3,761
9215255 135-60020-021 Lift Station #1 800 $192 700 $125 1116 $164 284 $42 700 $103 700 $143 900 $109 800 $127 900 $242 900 $108 1000 $144 1000 $294 9,800 1,793 0.182982653 $1,883
9843774 135-60020-021 Lift Station #7 204 $28 158 $24 330 $46 69 $10 193 $27 189 $27 238 $29 245 $30 203 $57 226 $29 252 $31 276 $64 2,583 402 0.155520712 $422
8306586 135-60020-021 PID Lift Station #8 557 $61 509 $57 928 $102 236 $26 617 $67 571 $62 601 $61 716 $70 567 $57 633 $63 672 $66 634 $63 7,241 755 0.104297749 $793
0051720 135-60020-021 PID Lift Station #9 300 $40 300 $40 401 $48 81 $12 300 $40 300 $40 200 $29 400 $46 200 $28 400 $47 300 $38 300 $38 3,482 448 0.128546812 $470
0199280 135-60020-021 Lift Station #4 (new)850 $96 650 $76 1195 $156 305 $35 700 $80 850 $95 1000 $102 1000 $101 900 $93 950 $97 1000 $102 1000 $102 10,400 1,134 0.109075962 $1,191
TOTAL:$14,770
8797254 122-60020-045 Fire Station 7241 $623 6710 $585 10966 $932 2425 $213 4385 $411 4339 $410 4885 $399 4315 $365 4,432 $378 4858 $394 9070 $758 5595 $456 69,221 5,925 0.085590644 $6,221
MUD SHARE ONLY MUD SHARE ONLY TOTAL:$6,221
Direct Energy (Split with Town) MUD 1/2 usage
2836100 135-60020-030 MUD & PW Bldgs 10,950 $916 10,230 $877 5,576 $499 3,814 $341 7,560 $888 11,880 $1,073 14,220 $1,204 12,000 $1,050 12,090 $1,149 8,280 $750 7,440 $695 8,527 $813 112,567 10,256 0.091106008 $10,768
TOTAL:$10,768
Tri-County
Meter #
165775 135-60020-021 Lift Station 3 3689 $405 3380 $364 3322 $341 2827 $294 2878 $306 3053 $308 2584 $245 2653 $250 2806 $263 3459 $328 3792 $357 4437 $357 38,880 3,818 0.098200874 $4,009
170037 135-60020-021 Lift Station 5 2020 $233 1776 $204 1650 $182 1383 $157 1394 $162 1390 $154 1143 $123 1209 $128 1232 $130 1545 $161 1708 $175 2074 $175 18,524 1,984 0.107091341 $2,083
170038 135-60020-021 Lift Station 5 (Backup)24 $28 24 $28 28 $28 23 $28 24 $28 28 $28 24 $28 24 $28 23 $28 27 $28 25 $28 26 $28 300 336 1.119266667 $353
TOTAL:$6,444
Atmos - Gas @ Fire Station (Measures by Thousand Cubic Feet)
MUD 1/2 usage
Meter S/N
11N375438122-60020-045 Fire Station 22 $37 24 $39 29 $51 15 $25 96 $91 199 $166 415 $311 188 $137 330 $155 37 $38 11 $25 31 $59 1,397 1,134 0.811911238 $1,191
TOTAL:$1,191
Jun-15 Jul-14 Aug-14 Sept-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15
29Trophy Club Municipal Utility District No. 1 109 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-L
INFORMATION TECHNOLOGY
Account Description Amount
135-55160-030
Professional Outside Services M3- It & Cell Phone Support $51,075
Totals:51,075$
135-55030-030
Software & Support Used R For Recurring, NR For Non-Recurring.
R-Internet Connectivity-WSC 15,600$
R-Internet Connectivity-ATT (Backup & WWTP)1,560$
R-E-Fax 96$
R-STW-Annual Support 36,133$
R-Clear Rec Annual Maintenance 600$
R-Web Hosting 360$
R-Web Maintenance (Domains, SSL Cert, etc)70$
R-Mail Chimp 240$
R-Photoshop 120$
R- Timeclock Plus Support 487$
Replacement for Connect CTY 3,650$
R-Annual Support for Website-Four Man Furnace 2,000$
R-Automatic Meter Reading -Badger 3,950$
R-Pipelogix Maintenance 1,980$
R-AudioTel Remit Plus Annual Support 1,802$
R-AudioTel Annual Scanner Support 585$
ORS software for Meter Reading 9,250$
Totals:78,483$
135-60005-030
Telephone Main Phone Numbers & Long Distance 50% Shared 4,817$
WWTP Phone Service 5,784$
Phone System Maintenance, 50% Shared.2,248$
Repairs (Non-Maintenance), 50% Shared.1,000$
Totals:13,849$
135-60235-030
Security R-Access Control System, 50% Shared 1350
Totals:1,350$
122-55030-045 Description Amount
Software & Support - Fire Dept.R-Firehouse Support and Maintenance 263$
R-Denton County RMS Bandwidth, 50% shared 5,700$
R-Web Maintenance (Domains, SSL Cert, etc) 50% shared -$
R-Symantec Image Maintenance, 50% shared -$
30
Trophy Club Municipal Utility District No. 1 110 of 112 September 2, 2015 - Special Meeting
Agenda Packet
R-Anti-Virus Maintenance and Support, 50% shared.80$
R-Malware-Bytes Maintenance and Support, 50% shared.48$
R-Hosted Exchange, 50% shared 510$
R-Web Hosting, 50% shared 60$
Totals:6,661$
122-65055-045 Description Amount
Hardware R-Repair and Maintenance 750$
NR-Replacement Computers -$
NR-Replacement Copiers & Printers -$
NR-Replacement First Responders MDT, 50% shared
Totals:750$
135-65055-030 Description Amount
Hardware R-A/V Miscellaneous Equipment, 50% Shared.1,200$
Meter Reading Laptop per MM 16,000$
Replacement Hardware 12,394$
Totals:29,594$
122-65105-045 annual costs. We take the average toner yield
Printing and divide it by the page counts to determine
the amount of toner needed per device. We
have also included a few maintenance kits for
the older printers.
It does include all the plotter supplies.498$
Totals:498$
We use the following formula to determine the
135-65090-030 annual costs. We take the average toner yield
Printer Supplies and divide it by the page counts to determine
the amount of toner needed per device. We
have also included a few maintenance kits for
the older printers.
It does include all the plotter supplies.4,003$
Totals:4,003$
135-69170-030
Copier Rental/Lease Description Amount
Monthly lease for the following copiers.4,600$
Totals:4,600$
135-69195-030
Transfer to Future Replacment Reserve Description Amount
Information Systems Replacement Fund -$
($50,893 Total Assets)
Totals:-$
31
Trophy Club Municipal Utility District No. 1 111 of 112 September 2, 2015 - Special Meeting
Agenda Packet
SCHEDULE GF-M
FUEL & ROUTINE VEHICLE & GENERATOR MAINTENANCE COSTS
Water Department Gallons Price Average Price /Gallon No. Vehicles No./Year Total/Year Cost Each Total Amt.
OIL CHANGES 7 4 28 $50 $1,400
MISC Gas 100.00 $280.00 $2.80 Generator Maint.2 2 2 2,500$ $5,000
MISC Diesel 300.00 $1,023.00 $3.41
2001 Ford F650 300.00 $882.00 $2.94
2007 Dodge 1,085.35 $2,712.50 $2.50
2002 Ford F150 1,800.00 $4,500.00 $2.50
2011 Ford F150 750.00 $1,875.00 $2.50
2012 Ford F150 850.00 $2,125.00 $2.50
2015 Ford F350 1,133.00 $2,923.88 $2.58
2015 Ford Escape 450.00 $1,125.00 $2.50
Portable Generators 100.00 $300.00 $3.00
Caterpillar Generator 750.00 $2,250.00 $3.00
350 kw Generator 1,200.00 $3,600.00 $3.00 Total Fuel and Lube:$35,947
Average:8818.35 $23,596.38 $2.77
9700.19 $29,547 $3.05 10% Increase
Wastewater Department
MISC Gas 142.51 $356.28 $2.50
MISC Diesel 826.08 $2,326.07 $2.82
2013 Chevy C1500 1,490.37 $3,725.90 $2.50
2013 Chevy C1500 1,576.58 $3,941.50 $2.50
2009 Gap Vax 692.19 $1,803.31 $2.61 No. Vehicles No./Year Total/Year Cost Each Total Amt.
2001 GMC Camera Van 70.34 $175.85 $2.50 OIL CHANGES 6 4 24 $50 $1,200
2002 Ford F350 580.64 $1,451.60 $2.50 OIL- GAP VAX 1 1 1 $1,200 $1,200
2015 Chevy 3500 667.60 $1,845.36 $2.76 Generator Maint.2 2 2 2000 $4,000
58 kW Portable Generator 300.00 $900.00 $3.00
41 kw Generator @ Lift Station #1 500.00 $1,500.00 $3.00
600 kw Generator 1,000.00 $3,000.00 $3.00 Total Fuel and Lube:$32,021
AVERAGE:7846.31 $21,025.87 $2.70
8630.94 $25,621 $2.97 10% Increase
Fire Department
MISC Gas 7.74 $21.86 $2.82 No. Vehicles No./Year Total/Year Cost Each Total Amt.
Vehicle U681-2011 Ford 150 448.83 $1,122.10 $2.50 OIL CHANGES-Gas 1 1 1 $60 $60
Vehicle Q681-1996 Ladder Truck 303.16 $835.26 $2.76 OIL CHANGES-Diesel 1 1 1 $120 $120
Vehicle BRUS 681- 2001 Ford Brush 160.98 $430.50 $2.67 Pierce Fire Engine 1 1 1 $1,295 $1,295
Vehicle ENG 681- 2007 Fire Engine 1,054.10 $2,876.43 $2.73 1995 Ladder Truck 1 1 1 $1,295 $1,295
160 kW Generator 750.00 $2,250.00 $3.00 2015 Ladder Truck 1 1 1 $1,295 $1,295
AVERAGE:2724.81 $7,536.15 $2.75 Generator Maint.1 1 1 $2,000 $2,000
2997.29 $9,057 $3.02 10% Increase
Total Fuel and Lube:$15,122
32
Trophy Club Municipal Utility District No. 1 112 of 112 September 2, 2015 - Special Meeting
Agenda Packet