Loading...
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