Loading...
R-03-01-09-9C1 - 1/9/2003C CITY OF ROUND ROCK AGREEMENT FOR CONSULTING SERVICES WITH BLACK & VEATCH CORPORATION THIS AGREEMENT is made and entered into on this the 13th day of the month of January, 2003, by and between the City of Round Rock, a Texas home -rule municipal corporation, whose offices are located at 221 East Main Street, Round Rock, Texas 78664 -5299 (hereinafter referred to as the "City"), and Black & Veatch Corporation, whose offices are located at 14100 San Pedro Avenue, Suite 310, Pacific Plaza Building, San Antonio, TX 787232 (hereinafter referred to as "Consultant "). WHEREAS, City desires to contract for Consultant's assistance in Water and Wastewater Cost of Service and Rate Design Study, and WHEREAS, the parties desire to enter into this Agreement to set forth in writing their respective rights, duties and obligations hereunder; NOW, THEREFORE, WITNESSETH: RECITALS: That for and in consideration of the mutual promises contained herein and other good and valuable consideration, the sufficiency and receipt of which are hereby acknowledged, it is mutually agreed between the parties as follows: 1.01 EFFECTIVE DATE, DURATION, AND TERM This Agreement shall be effective on the date it has been signed by every party hereto, and shall remain in full force and effect unless and until it expires by operation of the term indicated herein, or is terminated or extended as provided herein. The term of this Agreement shall be for one hundred fifty (150) calendar days from the effective date hereof. 1.02 GENERAL CONDITIONS The General Conditions contained herein shall apply to the Scope of Services, attached hereto as Exhibit "A" and made a part hereof of all appropriate purposes. This Agreement and such Scope of Services is entered into by and between the City of Round Rock or its subsidiaries or affiliates (collectively "City") and Black & Veatch Corporation or any entity directly or indirectly owned or controlled by same (collectively "Black "). 0,wdunWORAuagmvd'o00.11574 WPDIme 1.03 PROPOSAL FOR SERVICES For purposes of this Agreement, Consultant has issued its Scope of Services for the assignment(s) delineated therein. Such Scope of Services is appended to this Agreement and is labeled as Exhibit "A." Such Scope of Services shall be deemed to incorporate the General Conditions contained herein. Except with respect to the description of specific services and fees for the assignment(s) delineated therein, the General Conditions of this Agreement and this Agreement itself shall prevail over any conflicting terms therein. Taken together with the appended Scope of Services, the General Conditions contained in this Agreement shall evidence the entire understanding and agreement between the parties and supersede any prior proposals, correspondence or discussions. 1.04 SCOPE OF SERVICES Consultant shall satisfactorily provide all services described under this "Scope of Services" category and under Exhibit "A." Consultant's undertakings shall be limited to performing services for City and/or advising City concerning those matters on which Consultant has been specifically engaged. Consultant shall perform its services in accordance with these General Conditions and this Agreement, in accordance with the appended Scope of Services, in accordance with due care, and in accordance with prevailing consulting industry standards for comparable services. 1.05 PAYMENT FOR SERVICES; SUPPLEMENTAL AGREEMENTS Payment for Basic Services: In consideration for the consulting services to be performed by Consultant, City agrees to pay Consultant the following sum(s) as stated herein: Basic Services $67,800.00 Reimbursable Expenses Not to exceed $ 7,200.00 Unless subsequently changed by additional Supplemental Agreement to this Agreement, duly authorized by City Council Resolution, Consultant's total compensation hereunder shall not exceed $75,000.00 including any Reimbursable Expenses. This amount represents the absolute limit of City's liability to Consultant hereunder unless same shall be changed by additional Supplemental Agreement hereto. Deductions. No deductions shall be made from Consultant's compensation on account of penalty, liquidated damages or other sums withheld from payments to Consultant. Additions. No additions shall be made to Consultant's compensation based upon Project claims, whether paid by City or denied. 2 Supplemental Agreements. The terms of this Agreement may be modified by written Supplemental Agreement hereto, duly authorized by City Council Resolution, if City determines that there has been a significant change in (1) the scope, complexity, or character of the services to be performed; or (2) the duration of the work. Any such Supplemental Agreement must be executed by both parties within the period specified as the term of this Agreement, that being one hundred fifty (150) calendar days from the effective date hereof. Consultant shall not perform any work or incur any additional costs prior to the execution, by both parties, of such Supplemental Agreement. Consultant shall make no claim for extra work done or materials famished unless and until there is full execution of any Supplemental Agreement, and City shall not be responsible for actions by Consultant nor for any costs incurred by Consultant relating to additional work not directly authorized by Supplemental Agreement. 1.06 TIMETABLES Unless otherwise indicated to Consultant in writing by City, or unless Consultant is unreasonably delayed in the orderly progress of its work by forces beyond Consultant's control, the following timetable structure and deliverable due dates shall apply: one hundred fifty (150) calendar days from date of execution hereof. 1.07 TERMS OF PAYMENT; REIMBURSABLE EXPENSES Invoices. To receive payment for services, Consultant shall prepare and submit a series of monthly invoices in a form acceptable to City. Each invoice for professional services shall track the "Scope of Services" category herein, and shall state and detail the services performed, along with documentation for each such service performed. All payments to Consultant shall be made on the basis of the invoices submitted by Consultant and approved by City. Such invoices shall conform to the schedule of services and costs in connection therewith. All Reimbursable Expenses shall be clearly shown. Should additional backup material be requested by City, Consultant shall comply promptly with such request. In this regard, should City determine it necessary, Consultant shall make all records and books relating to this Agreement available to City for inspection and auditing purposes. Payment of Invoices. City reserves the right to correct any error that may be discovered in any invoice that may have been paid to Consultant and to adjust same to meet the requirements of this Agreement. Following approval of invoices, City shall endeavor to pay Consultant promptly, but no later than the time period required under the Texas Prompt Payment Act described in Section 1.08 herein. Under no circumstances shall Consultant be entitled to receive interest on payments which are late because of a good faith dispute between Consultant and City or because of amounts which City has a right to withhold under this Agreement or state law. City shall be responsible for any sales, gross receipts or similar taxes applicable to the services, but not for taxes based upon Consultant's net income. 3 Offsets. City may, at its option, offset any amounts due and payable under this Agreement against any debt (including taxes) Lawfully due to City from Consultant, regardless of whether the amount due arises pursuant to the terms of this Agreement or otherwise and regardless of whether or not the debt due to City has been reduced to judgment by a court. Reimbursable Expenses. Payment for customary reimbursable expenses hereunder shall not exceed the maximum sum of $7,200.00. City shall pay Consultant for reimbursable expenses on a monthly basis, as invoiced and documented, at actual cost. Customary reimbursable expenses shall include such items as the following: a. Reprographic Services; b. Postal/delivery services (as necessary to complete services in a timely manner); c. Non -local transportation at the rate of $0.36 per mile; d. Long distance telecommunications; e. Cost of maps, surveys, drawings, and reports necessary to complete services; f. Cost of obtaining permits, if any; and g. Computer time and charges. 1.08 PROMPT PAYMENT POLICY In accordance with Chapter 2251, V.T.C.A., Texas Government Code, payment to Consultant will be made within thirty (30) days of the day on which City receives the performance, or within thirty (30) days of the day on which the performance of services was complete, or within thirty (30) days of the day on which City receives a correct invoice for the performance or services, whichever is later. Consultant may charge a late fee (fee shall not be greater than that which is permitted by Texas law) for payments not made in accordance with this Prompt Payment Policy; however, this policy does not apply to payments made by City in the event: 1. There is a bona fide dispute between City and Consultant concerning the services performed that causes the payment to be late; or 2. The terms of a federal contract, grant, regulation, or statute prevent City from making a timely payment with federal funds; or 3. There is a bona fide dispute between Consultant and a subcontractor or between a subcontractor and its supplier concerning the services performed which causes the payment to be late; or 4. The invoice is not mailed to City in strict accordance with instructions, if any, on any purchase order or this Agreement. 4 1.09 NON - APPROPRIATION This Agreement is a commitment of City's current revenues only. It is understood and agreed that City shall have the right to terminate this Agreement at the end of any City fiscal year if the goveming body of City does not appropriate funds sufficient to purchase the services as determined by City's budget for the fiscal year in question. City may effect such termination by giving Consultant a written notice of termination at the end of its then - current fiscal year. 1.10 TERMINATION OR DEFAULT Termination. In connection with the work outlined in this Agreement, it is agreed and fully understood by Consultant that City may cancel or indefinitely suspend further work hereunder or terminate this Agreement either for cause or for the convenience of City, upon fifteen (15) days' written notice to Consultant, with the understanding that immediately upon receipt of said notice all work and labor being performed under this Agreement shall cease. Consultant shall invoice City for all work satisfactorily completed and shall be compensated in accordance with the terms of this Agreement for all work accomplished prior to the receipt of said notice. No amount shall be due for lost or anticipated profits. Unless otherwise specified herein, all plans, field surveys, maps, cross sections and other data, designs and work related to the Project shall become the property of City upon termination of this Agreement, and shall be promptly delivered to City in a reasonably organized form without restriction on future use. Should City subsequently contract with a new consultant for continuation of services on the Project, Consultant shall cooperate in providing information for an additional fee. Default. Nothing contained in the preceding paragraph shall require City to pay for any work which is unsatisfactory as determined by City or which is not submitted in compliance with the terms of this Agreement. City shall not be required to make any payments to Consultant when Consultant is in default under this Agreement, nor shall this paragraph constitute a waiver of any right, at law and at equity, which City may have if Consultant is in default, including the right to bring legal action for damages or to force specific performance of this Agreement. 1.11 CITY'S RESPONSIBILITIES Full information. City shall provide full information regarding Project requirements. City shall have the responsibility of providing Consultant with such documentation and information as is reasonably required, if any, to enable Consultant to provide the services called for. City shall cause its employees and any third parties who are otherwise assisting, advising or representing City to cooperate on a timely basis with Consultant in the provision of its services. Consultant may rely upon written information provided by City and its employees and agents as accurate and complete. Consultant may rely upon any written directions provided by City and its employees and agents concerning provision of services. Designate representatives. City shall designate, when necessary, representatives authorized to act in its behalf. City shall examine documents submitted by Consultant and render decisions 5 pertaining thereto promptly to avoid unreasonable delay in the orderly progress of Consultant's work. Survey. City shall furnish, or direct Consultant to obtain at City's expense, a certified survey of the site, giving, as required, grades and lines of streets, alleys, pavements and adjoining property; rights -of -way, restrictions, easements, encroachments, zoning, deed restrictions, boundaries, contours and other data pertaining to existing buildings or adjacent to the site, other improvements and trees; and full information as to available service and utility lines, both public and private, and test borings, pits, reports and soil bearing values and other necessary operations for determining subsoil conditions. Tests and inspections. City shall furnish or pay for structural, mechanical, chemical, soil mechanics, and other tests, reports and inspections as required by law or Project documents. 1.12 INDEPENDENT CONTRACTOR STATUS Consultant is an independent contractor, not City's employee. Consultant's employees or subcontractors are not City's employees. This Agreement does not create a partnership relationship. Neither party has authority to enter into contracts as agent for the other party. Consultant and City agree to the following rights consistent with an independent contractor relationship: 1. Consultant has the right to perform services for others during the term of this Agreement; and 2. Consultant has the sole right to control and direct the means, manner and method by which services required by this Agreement will be performed; and 3. Consultant has the right to hire assistants as subcontractors, or to use employees to provide the services required by this Agreement; and 4. Consultant or Consultant's employees or subcontractors shall perform the services required by this Agreement. City shall not hire, supervise, or pay any assistants to help Consultant; and 5. Neither Consultant nor Consultant's employees or subcontractors shall receive any training from City in the skills necessary to perform the services required by this Agreement; and 6. City shall not require Consultant or Consultant's employees or subcontractors to devote full time to performing the services required by this Agreement; and 7. Neither Consultant nor Consultant's employees or subcontractors are eligible to participate in any employee pension, health, vacation pay, sick pay, or other fringe benefit plan of City. 6 1.13 CONFIDENTIALITY; DISPOSITION OF MATERIALS Each party shall take reasonable measures to preserve the confidentiality of any proprietary or confidential information provided to it in connection with this engagement, provided that no claim may be made for any failure to protect information that occurs more than two (2) years after the termination or expiration of this Agreement. At the conclusion of the engagement, upon written request, each party shall return to the other all materials, data and documents that have been provided to the other party, except that Consultant may retain one (1) copy of City's materials for its archival purposes, subject to Consultant's confidentiality obligations hereunder. City shall retain ownership of all data and materials provided by it to Consultant. Original drawings shall remain the property of Consultant. Consultant shall provide City with one (1) signed set ofreproducibles and one (1) full set of digital file copies. 1.14 LIMITATION OF LIABILITY Should any of Consultant's services not conform to the requirements of this Agreement and the appended Scope of Services, then and in that event City shall give written notification to Consultant; thereafter, Consultant shall either (a) promptly re- perform such services to City's satisfaction at no additional charge, or (b) promptly refund the portion of the fees paid with respect to such services. In the event that re- performance of services or refund of applicable fees would not provide an adequate remedy to City for damages arising from the performance, nonperformance or breach of this Agreement and the appended Scope of Services, then and in that event Consultant's maximum total liability, including that of any employee, affiliate, agent or contractor, relating to its services, regardless of the cause of action, shall be limited to direct damages in an amount not to exceed the total fees payable under this Agreement. The foregoing limitation of liability shall not apply to the extent that any liability arises from the gross negligence or willful misconduct of Consultant, its employees, affiliates, agents or contractors, or from bodily injury, death of any person, or damage to any real or tangible personal property. Neither party shall be liable for any indirect, special or consequential damages. 1.15 INDEMNIFICATION Consultant agrees to hold harmless, defend, and indemnify City for and from any third party claim or liability (including reasonable defense costs and attorneys' fees) to the extent arising from or in connection with the negligence of Consultant or its employees or agents in the course of performing services. The limitation of liability set forth in Section 1.14 herein applies to Consultant's indemnity obligations pursuant to this Section 1.15, but the limitation shall not apply to the extent that any liability arises from the gross negligence or willful misconduct of Consultant, 7 its employees, affiliates, agents or contractors or from bodily injury, death of any person, of damage to any real or tangible personal property. Except to the extent that Consultant is obligated to indemnify City, City shall indemnify and hold Consultant, its employees, affiliates or agents harmless from any third party claim or liability (including reasonable defense costs and attorneys' fees) to the extent arising from or in connection with the services performed by Consultant or City's use thereof. 1.16 INSURANCE Insurance. Consultant, at Consultant's sole cost, shall have and maintain during the term of this Agreement professional liability insurance coverage in the minimum amount of $1,000,000.00 Dollars from a company authorized to do insurance business in Texas and otherwise acceptable to City. Subconsultant Insurance. Without limiting any of the other obligations or liabilities of Consultant, Consultant shall require each subconsultant performing work under this Agreement to maintain during the term of the Agreement, at the subconsultant's own expense, the same stipulated minimum insurance required in the immediately preceding paragraph, including the required provisions and additional policy conditions as shown below. As an alternative, Consultant may include its subconsultants as additional insureds on its own coverages as prescribed under these requirements. Consultant's certificate of insurance shall note in such event that the subconsultants are included as additional insureds. Consultant shall obtain and monitor the certificates of insurance from each subconsultant in order to assure compliance with the insurance requirements. Consultant must retain the certificates of insurance for the duration of this Agreement, and shall have the responsibility of enforcing these insurance requirements among its subconsultants. City shall be entitled, upon request and without expense, to receive copies of these certificates of insurance. Insurance Policy Endorsements. Each insurance policy hereunder shall include the following conditions by endorsement to the policy: (1) Each policy shall require that thirty (30) days prior to the expiration, cancellation, non - renewal or any material change in coverage, a notice thereof shall be given to City by certified mail to: City Manager, City of Round Rock 221 East Main Street Round Rock, Texas 78664 Consultant shall also notify City, within 24 hours of receipt, of any notices of expiration, cancellation, non - renewal, or material change in coverage it receives from its insurer. 8 (2) Companies issuing the insurance policies shall have no recourse against City for payment of any premiums or assessments for any deductibles which all are at the sole responsibility and risk of Consultant. (3) Terms "City" or "City of Round Rock" shall include all authorities, boards, commissions, departments, and officers of City and individual members, employees and agents in their official capacities, or while acting on behalf of the City of Round Rock. (4) The policy clause "Other Insurance" shall not apply to any insurance coverage currently held by City, to any future coverage, or to City's Self Insured Retentions of whatever nature. Cost of Insurance. The cost of all insurance required herein to be secured and maintained by Consultant shall be borne solely by Consultant, with certificates of insurance evidencing such minimum coverage in force to be filed with the City. Such Certificates of Insurance are evidenced as Exhibit `B" entitled "Certificates of Insurance." 1.17 COMPLIANCE WITH LAWS, CHARTER AND ORDINANCES Compliance with Laws. Consultant, its consultants, agents, employees and subcontractors shall use best efforts to comply with all applicable federal and state laws, the Charter and Ordinances of the City of Round Rock, as amended, and with all applicable rules and regulations promulgated by local, state and national boards, bureaus and agencies. Consultant shall further obtain all permits and licenses required in the performance of the services contracted for herein. Taxes. Consultant will pay all taxes, if any, required by law arising by virtue of the services performed hereunder. City is qualified for exemption pursuant to the provisions of Section 151.309 of the Texas Limited Sales, Excise, and Use Tax Act. 1.18 FINANCIAL INTEREST PROHIBITED Consultant covenants and represents that Consultant, its officers, employees, agents, consultants and subcontractors will have no financial interest, direct or indirect, in the purchase or sale of any product, materials or equipment that will be recommended or required for the construction of the Project. 1.19 ASSIGNMENT AND DELEGATION The parties each hereby bind themselves, their successors, assigns and legal representatives to each other with respect to the terms of this Agreement. Neither party shall assign, sublet or transfer any interest in this Agreement without prior written authorization of the other party. 1.20 LOCAL, STATE AND FEDERAL TAXES 9 Consultant shall pay all income taxes, and FICA (Social Security and Medicare taxes) incurred while performing services under this Agreement. City will not do the following: 1. Withhold FICA from Consultant's payments or make FICA payments on Consultant's behalf; or 2. Make state and/or federal unemployment compensation contributions on Consultant's behalf; or 3. Withhold state or federal income tax from Consultant's payments. 1.21 NOTICES All notices and other communications in connection with this Agreement shall be in writing and shall be considered given as follows: 1. When delivered personally to the recipient's address as stated in this Agreement; or 2. Three (3) days after being deposited in the United States mail, with postage prepaid to the recipient's address as stated in this Agreement. Notice to Consultant: Black & Veatch 14100 San Pedro Avenue, Suite 310 Pacific Plaza Building San Antonio, TX 78232 Notice to City: City Manager 221 East Main Street Round Rock, TX 78664 AND TO: Nothing contained herein shall be construed to restrict the transmission of routine communications between representatives of City and Consultant. 1.22 APPLICABLE LAW; ENFORCEMENT AND VENUE 10 City Attorney 309 East Main Street Round Rock, TX 78664 This Agreement shall be enforceable in Round Rock, Williamson County, Texas, and if legal action is necessary by either party with respect to the enforcement of any or all of the terms or conditions herein, exclusive venue for same shall lie in Williamson County, Texas. This Agreement shall be governed by and construed in accordance with the laws and court decisions of the State of Texas. 1.23 EXCLUSIVE AGREEMENT This document, and all appended documents, constitutes the entire Agreement between Consultant and City. This Agreement may only be amended or supplemented by mutual agreement of the parties hereto in writing. 1.24 DISPUTE RESOLUTION If a dispute or claim arises under this Agreement, the parties agree to first try to resolve the dispute or claim by appropriate intemal means, including referral to each party's senior management. If the parties cannot reach a mutually satisfactory resolution, then and in that event any such dispute or claim will be sought to be resolved with the help of a mutually selected mediator. If the parties cannot agree on a mediator, City and Consultant shall each select a mediator and the two mediators shall agree upon a third mediator. Any costs and fees, other than attorney fees, associated with the mediation shall be shared equally by the parties. City and Consultant hereby expressly agree that no claims or disputes between the parties arising out of or relating to this Agreement or a breach thereof shall be decided by any arbitration proceeding, including without limitation, any proceeding under the Federal Arbitration Act (9 USC Section 1 - 14) or any applicable state arbitration statute. 1.25 SEVERABILITY The invalidity, illegality, or unenforceability of any provision of this Agreement or the occurrence of any event rendering any portion or provision of this Agreement void shall in no way affect the validity or enforceability of any other portion or provision of this Agreement. Any void provision shall be deemed severed from this Agreement, and the balance of this Agreement shall be construed and enforced as if this Agreement did not contain the particular portion or provision held to be void. The parties further agree to amend this Agreement to replace any stricken provision with a valid provision that comes as close as possible to the intent of the stricken provision. The provisions of this section shall not prevent this entire Agreement from being void should aprovision which is of the essence of this Agreement be determined void. 1.26 MISCELLANEOUS PROVISIONS Time is of the Essence. Consultant understands and agrees that time is of the essence and that any failure of Consultant to complete the services for each phase of this Agreement within the agreed Project schedule will constitute a material breach ofthis Agreement. Consultant shall be fully responsible for its delays or for failures to use best efforts in accordance with the terms of this Agreement. Where damage is caused to City due to Consultant's failure to perform in these circumstances, City may withhold, to the extent of such damage, Consultant's payments hereunder without waiver of any of City's additional legal rights or remedies. City shall render decisions pertaining to Consultant's work promptly to avoid unreasonable delays in the orderly progress of Consultant's work. 11 Force Majeure. Neither City nor Consultant shall be deemed in violation of this Agreement if it is prevented from performing any of its obligations hereunder by reasons for which it is not responsible or circumstances beyond its control. However, notice of such impediment or delay in performance must be timely given, and all reasonable efforts undertaken to mitigate its effects. Opinions. Consultant's opinions, estimates, projections, forecasts of current and future costs, revenues, other levels of any sort, and events shall be made on the basis of available information and Consultant's expertise and qualifications as a professional. Consultant does not warrant or guarantee that its opinions, estimates, projections or forecasts of current and future levels and events will not vary from City's estimates or forecasts or from actual outcomes. IN WITNESS WHEREOF, City and Consultant have executed this Agreement on the dates indicated. CITY OF ROUND ROC Bv: axwell, Mayor ate Signed: i /4 BLACK & VEATCH CORPORATION By: ATTACHMENTS Exhibit "A ": Scope of Services Exhibit "B ": Certificates of Insurance 12 ATTEST: Christine R. Martinez, City Secretary Date Signed: / /1.0 — 03 Exhibit "A" Scope of Services Scope of Services The scope of services includes but is not limited to the following: (1) Financial Condition (7) Review current service and customer class rate schedules to determine financial condition of the City's water and wastewater utility operation. (2) Revenue Requirements Identify and project revenue requirements needed over the next 10 -year planning period after identifying all expenses, e.g. operation, maintenance, depreciation, and all other related expenses incurred. (3) Capital Costs Project capital project cash flows over the next 10 -year planning period including ongoing equipment replacement. (4) Allocation of Shared Costs Allocate shared costs of the systems between water and wastewater. Allocate each year's costs to each utility between customer classes, including large and wholesale customers, in an equitable manner. (5) Rate Design Provide a recommended rate design that indicates projected revenue requirements for the next 10 -year planning periods. Clearly identify components of the base rates and volume charges. (6) Wholesale Customers The City has eight (8) wholesale /MUD customers as well as other outside -the- city -limit customers. The rate model will include separate calculations for each of these customers according to their respective contracts. Alternative Methodologies Provide altemative methodologies that equitably recover the costs of each customer class. -1- (8) Rate Structures Rate structures shall be acceptable to the State of Texas and Federal regulatory agencies. Consultant shall defend the new rate calculation methodology if challenged. The fee for this will be negotiated at a later date if required. (9) Computer Model Provide the City with a computer model for use in the future rate adjustment calculations in an agreed upon software application format. The computer model will be used to study various scenarios by factoring in capital improvements, additional personnel, infrastructure maintenance, operating costs, and debt service. The model shall include the ability for the City to enter various budgets by the rate component categories, consumption levels, customer counts by customer class, weather conditions, growth patterns, with the model calculating the rate required by service and customer class to generate the needed revenues. (10) Cost Allocation Evaluate the City Water and Wastewater Utility's existing indirect Cost Allocation to the General Fund, including General and Administrative Services charges and in -lieu of tax payments. (11) Classes of Services Evaluate existing classes of services for appropriate rate structures for both inside and outside city limits customers. (12) Re - use Water Rate Recommend a methodology for calculating a fair rate for re -use effluent that will be supplied from the regional wastewater plant to City's Departments and potential outside buyers. (13) Training Provide a minimum of two (2) training sessions on the computer model for up to five (5) City staff members to perform changes and updates to the base data. (14) Reporting Prepare a written report documenting the findings of the study. (15) Presentation Present the findings of the study to the City Council. It is anticipated that this will include two (2) evening meetings. -2- EXHIBIT `B" CERTIFICATES OF INSURANCE 14 A ACORD CERTIFICATE OF LIABILITY INSURANCE DATE(MMlDIXTY) 11/01/2003 1 -13 -2003 PRODUCER Lockton Companies 444 W.47111 Street. Suite 900 Kansas Gty Mo 64112 -1906 (816)960-9000 INSURED 1007194 BLACK & VEATCH CORPORATION PO. BOX 0405 KANSAS CITY MO 64114 Peart, Larry . AS A MATTER F INFO 1 HIS CERTIFICATE IS ISSUED RMAI ION HOLDER. THIS CERTIFICATE S NOT AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. INSURERS AFFORDING COVERAGE INSURER AI CONTINENTAL CASUALTY INSURER (VICTORO. SCHINNERER) INSURER C: INSURER D: INSURER E COVERAGES PC THE PCIJCIES OF INSURANCE LISTED BELOW -HAVE BEEN ISSUED TO 71-1E INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDMON OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN. THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT 76 ALL THE TERMS, EXCLUSIONS ANDCONDMONS OF SUCH POLICIES. AGGREGATE LIMIT'S SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. . . • INSR LIR TYPE OF INSURANCE GENERAL UABILRY COMMERCIAL GENERAL LABILITY ICIAIMS MADE ❑ OCCUR GENL AGGREGATE L LIMIT APPUES PER I POLICY I I� * I I LOC AUTOMOBILE LABILITY ANY AUTO ALL OWNED AUTOS SCHEDIILEDAUTOS HIRED AUTOS NON-OWNED AUTOS GARAGE LIABILITY R ANY AUTO E%CESS LIABILITY R OCCUR 0 CAMAS MADE DURRELL% R DEDUCIBLE El FORM RETENTION F WORKERS COMPENSATION AND EMPLOYERS' LIABILITY OTHER PROFESSIONAL LIABILITY CERTIFICATE HOLDER POLICY NUMBER NOT APPLICABLE NOT APPLICABLE NOT APPLICABLE NOT APPLICABLE NOT APPLICABLE PLN 114079627 DESCRIPTION OF DPI ATIONs/LOCARONSNENICLE UCLUSIONSADDED BYENDORSEMENDSPECIAL PROVLOIONS B &V Project No 83124.1800 Water and Wastewater Cost of Service and Rate Design Study City Manager, City of Round Rock 221 East Main Street Round Rock, TX 78664 OATS LU E 11/01/2002 ADDITIONAL INSURED; INSURERLEITER: CANCELLATION Pa 11/01/2003 LIMITS EACH OCCURRENCE XJOCCO X' FIRE DAMAGE(Any one 0reLi MOO= LIED ET (Any one pawn) S )0000CX PERSONAL & ADV INJURY $ XXXXXXX GENERAAL AGGREGATE • XXXXXXX PRODUCTS - OOMPIOPAGG3 XXXXXXX CO CO C BWED uurT S )COI fPer P.N,N) ((PeerD1dent) P AMAGE D EACH OCCURRENCE AGGREGATE OILY IAIMRR I I EL EACH ACCIDENT EL DISEASE - EA EMPLOYEE 01,000,000. EACH CLAIM AND IN THE ANNUAL AGGREGATE FOR ALL PROJECTS $ XXXXX00c X 0000IX AUTO ONLY- EA ACCIDENT $ XXXXXXX OTHER THAN EA ACC $ X ( AUTO ONLY: AOG $ XXXXXXX XXX:C00( JCJCC}CCC( XXXXXXX XXXXXXX )0000 XX XXXXXXX XXJ70C0: ELDISEASE- POLICYLIMIT $ XXXXXXX SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, THE ISSUING NSURERWILL ENDEAVOR TO MAIL 30 DAYS WRITTEN NOTICE TO THE CERTIFICATE HOLDER NAMED TO THE LEFT,BUT FAILURE TO DO SO SHALL IMPOSE NO OBLIGATION OR LIAORJTY OF ANY PRO UPON THE INSURER. us AGENTS OR RTFRESEHFATNES. AUMOREED REPRESFMATNE ACORD 25S (7/97) ACORD — • ORATION 1988 RESOLUTION NO. R- 03- 01- 09 -9C1 WHEREAS, the City of Round Rock desires to retain consulting services for the development of a water and wastewater rate study, and WHEREAS, Black & Veatch Corporation has submitted an Agreement for Consulting Services to provide said services, and WHEREAS, the City Council desires to enter into said agreement with Black & Veatch Corporation, Now Therefore BE IT RESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK, TEXAS, That the Mayor is hereby authorized and directed to execute on behalf of the City an Agreement for Consulting Services with Black & Veatch Corporation, for the development of a water and wastewater rate study, a copy of said Agreement being attached hereto as Exhibit "A" and incorporated herein for all purposes. The City Council hereby finds and declares that written notice of the date, hour, place and subject of the meeting at which this Resolution was adopted was posted and that such meeting was open to the public as required by law at all times during which this Resolution and the subject matter hereof were discussed, considered and formally acted upon, all as required by the Open Meetings Act, Chapter 551, Texas Government Code, as amended. RESOLVED this 9th day of January, -- �_►�� �. I / iL. /A ATTEST CHRISTINE R. MARTINEZ, City Secretary ODMA\ WORLDOX\ 01 \WDOX \RESOLOTI \E30109C1.WPD /sC LL, Mayor Cit of Round Rock, Texas CITY OF ROUND ROCK AGREEMENT FOR CONSULTING SERVICES WITH BLACK & VEATCH CORPORATION THIS AGREEMENT is made and entered into on this the 13th day of the month of January, 2003, by and between the City of Round Rock, a Texas home -rule municipal corporation, whose offices are located at 221 East Main Street, Round Rock, Texas 78664 -5299 (hereinafter referred to as the "City "), and Black & Veatch Corporation, whose offices are located at 14100 San Pedro Avenue, Suite 310, Pacific Plaza Building, San Antonio, TX 787232 (hereinafter referred to as "Consultant "). RECITALS: WHEREAS, City desires to contract for Consultant's assistance in Water and Wastewater Cost of Service and Rate Design Study, and WHEREAS, the parties desire to enter into this Agreement to set forth in writing their respective rights, duties and obligations hereunder; NOW, THEREFORE, WITNESSETH: That for and in consideration of the mutual promises contained herein and other good and valuable consideration, the sufficiency and receipt of which are hereby acknowledged, it is mutually agreed between the parties as follows: 1.01 EFFECTIVE DATE, DURATION, AND TERM This Agreement shall be effective on the date it has been signed by every party hereto, and shall remain in full force and effect unless and until it expires by operation of the term indicated herein, or is terminated or extended as provided herein. The term of this Agreement shall be for one hundred fifty (150) calendar days from the effective date hereof. 1.02 GENERAL CONDITIONS The General Conditions contained herein shall apply to the Proposal for Services, attached hereto as Exhibit "A" and made a part hereof of all appropriate purposes. This Agreement and such Proposal for Services is entered into by and between the City of Round Rock or its subsidiaries or affiliates (collectively "City ") and Black & Veatch Corporation or any entity directly or indirectly owned or controlled by same (collectively "Black "). O\ d,ACORR ngrn,.Z O4I574 WPDIme EXHIBIT nAu 1.03 PROPOSAL FOR SERVICES For purposes of this Agreement, Consultant has issued its Proposal for Services for the assignment(s) delineated therein. Such Proposal for Services is appended to this Agreement and is labeled as Exhibit "A." Such Proposal for Services shall be deemed to incorporate the General Conditions contained herein. Except with respect to the description of specific services and fees for the assignment(s) delineated therein, the General Conditions of this Agreement and this Agreement itself shall prevail over any conflicting terms therein. Taken together with the appended Proposal for Services, the General Conditions contained in this Agreement shall evidence the entire understanding and agreement between the parties and supersede any prior proposals, correspondence or discussions. 1.04 SCOPE OF SERVICES Consultant shall satisfactorily provide all services described under this "Scope of Services" category and under Exhibit "A." Consultant's undertakings shall be limited to performing services for City and/or advising City concerning those matters on which Consultant has been specifically engaged. Consultant shall perform its services in accordance with these General Conditions and this Agreement, in accordance with the appended Proposal for Services, in accordance with due care, and in accordance with prevailing consulting industry standards for comparable services. 1.05 PAYMENT FOR SERVICES; SUPPLEMENTAL AGREEMENTS Payment for Basic Services: In consideration for the consulting services to be performed by Consultant, City agrees to pay Consultant the following sum(s) as stated herein: . Basic Services $67,800.00 Reimbursable Expenses Not to exceed $ 7,200.00 Unless subsequently changed by additional Supplemental Agreement to this Agreement, duly authorized by City Council Resolution, Consultant's total compensation hereunder shall not exceed $75,000.00 including any Reimbursable Expenses. This amount represents the absolute limit of City's liability to Consultant hereunder unless same shall be changed by additional Supplemental Agreement hereto. Deductions. No deductions shall be made from Consultant's compensation on account of penalty, liquidated damages or other sums withheld from payments to Consultant. Additions. No additions shall be made to Consultant's compensation based upon Project claims, whether paid by City or denied. Supplemental Agreements. The terms of this Agreement may be modified by written Supplemental Agreement hereto, duly authorized by City Council Resolution, if City determines that 2 there has been a significant change in (1) the scope, complexity, or character of the services to be performed; or (2) the duration of the work. Any such Supplemental Agreement must be executed by both parties within the period specified as the term of this Agreement, that being one hundred fifty (150) calendar days from the effective date hereof. Consultant shall not perform any work or incur any additional costs prior to the execution, by both parties, of such Supplemental Agreement. Consultant shall make no claim for extra work done or materials furnished unless and until there is full execution of any Supplemental Agreement, and City shall not be responsible for actions by Consultant nor for any costs incurred by Consultant relating to additional work not directly authorized by Supplemental Agreement. 1.06 TIMETABLES Unless otherwise indicated to Consultant in writing by City, or unless Consultant is unreasonably delayed in the orderly progress of its work by forces beyond Consultant's control, the following timetable structure and deliverable due dates shall apply: ninety (90) calendar days from date of execution hereof. 1.07 TERMS OF PAYMENT; REIMBURSABLE EXPENSES Invoices. To receive payment for services, Consultant shall prepare and submit a series of monthly invoices in a form acceptable to City. Each invoice for professional services shall track the "Scope of Services" category herein, and shall state and detail the services performed, along with documentation for each such service performed. All payments to Consultant shall be made on the basis of the invoices submitted by Consultant and approved by City. Such invoices shall conform to the schedule of services and costs in connection therewith. All Reimbursable Expenses shall be clearly shown. Should additional backup material be requested by City, Consultant shall comply promptly with such request. In this regard, should City determine it necessary, Consultant shall make all records and books relating to this Agreement available to City for inspection and auditing purposes. Payment of Invoices. City reserves the right to correct any error that may be discovered in any invoice that may have been paid to Consultant and to adjust same to meet the requirements of this Agreement. Following approval of invoices, City shall endeavor to pay Consultant promptly, but no later than the time period required under the Texas Prompt Payment Act described in Section 1.08 herein. Under no circumstances shall Consultant be entitled to receive interest on payments which are late because of a good faith dispute between Consultant and City or because of amounts which City has a right to withhold under this Agreement or state law. City shall be responsible for any sales, gross receipts or similar taxes applicable to the services, but not for taxes based upon Consultant's net income. Offsets. City may, at its option, offset any amounts due and payable under this Agreement against any debt (including taxes) lawfully due to City from Consultant, regardless of whether the 3 amount due arises pursuant to the terms of this Agreement or otherwise and regardless of whether or not the debt due to City has been reduced to judgment by a court. Reimbursable Expenses. Payment for customary reimbursable expenses hereunder shall not exceed the maximum sum of $7,200.00. City shall pay Consultant for reimbursable expenses on a monthly basis, as invoiced and documented, at actual cost. Customary reimbursable expenses shall include such items as the following: a. Reprographic Services; b. Postal/delivery services (as necessary to complete services in a timely manner); c. Non -local transportation at the rate of $0.36 per mile; d. Long- distance telecommunications; e. Cost of maps, surveys, drawings, and reports necessary to complete services; f. Cost of obtaining permits, if any; and g. Computer time and charges. 1.08 PROMPT PAYMENT POLICY In accordance with Chapter 2251, V.T.C.A., Texas Govemment Code, payment to Consultant will be made within thirty (30) days of the day on which City receives the performance, or within thirty (30) days of the day on which the performance of services was complete, or within thirty (30) days of the day on which City receives a correct invoice for the performance or services, whichever is later. Consultant may charge a late fee (fee shall not be greater than that which is permitted by Texas law) for payments not made in accordance with this Prompt Payment Policy; however, this policy does not apply to payments made by City in the event: 1. There is a bona fide dispute between City and Consultant concerning the services performed that causes the payment to be late; or 2. The terms of a federal contract, grant, regulation, or statute prevent City from making a timely payment with federal funds; or 3. There is a bona fide dispute between Consultant and a subcontractor or between a subcontractor and its supplier concerning the services performed which causes the payment to be late; or 4. The invoice is not mailed to City in strict accordance with instructions, if any, on any purchase order or this Agreement. 1.09 NON - APPROPRIATION This Agreement is a commitment of City's current revenues only. It is understood and agreed that City shall have the right to terminate this Agreement at the end of any City fiscal year if the 4 governing body of City does not appropriate funds sufficient to purchase the services as determined by City's budget for the fiscal year in question. City may effect such termination by giving Consultant a written notice of termination at the end of its then - current fiscal year. 1.10 TERMINATION OR DEFAULT Termination. In connection with the work outlined in this Agreement, it is agreed and fully understood by Consultant that City may cancel or indefinitely suspend further work hereunder or terminate this Agreement either for cause or for the convenience of City, upon fifteen (15) days' written notice to Consultant, with the understanding that immediately upon receipt of said notice all work and labor being performed under this Agreement shall cease. Consultant shall invoice City for all work satisfactorily completed and shall be compensated in accordance with the terms of this Agreement for all work accomplished prior to the receipt of said notice. No amount shall be due for lost or anticipated profits. Unless otherwise specified herein, all plans, field surveys, maps, cross sections and other data, designs and work related to the Project shall become the property of City upon termination of this Agreement, and shall be promptly delivered to City in a reasonably organized form without restriction on future use. Should City subsequently contract with a new consultant for continuation of services on the Project, Consultant shall cooperate in providing information for an additional fee. Default. Nothing contained in the preceding paragraph shall require City to pay for any work which is unsatisfactory as determined by City or which is not submitted in compliance with the terms of this Agreement. City shall not be required to make any payments to Consultant when Consultant is in default under this Agreement, nor shall this paragraph constitute a waiver of any right, at law and at equity, which City may have if Consultant is in default, including the right to bring legal action for damages or to force specific performance of this Agreement. 1.11 CITY'S RESPONSIBILITIES Full information. City shall provide full information regarding Project requirements. City shall have the responsibility of providing Consultant with such documentation and information as is reasonably required, if any, to enable Consultant to provide the services called for. City shall cause its employees and any third parties who are otherwise assisting, advising or representing City to cooperate on a timely basis with Consultant in the provision of its services. Consultant may rely upon written information provided by City and its employees and agents as accurate and complete. Consultant may rely upon any written directions provided by City and its employees and agents concerning provision of services. Designate representatives. City shall designate, when necessary, representatives authorized to act in its behalf. City shall examine documents submitted by Consultant and render decisions pertaining thereto promptly to avoid unreasonable delay in the orderly progress of Consultant's work. 5 Survey. City shall furnish, or direct Consultant to obtain at City's expense, a certified survey of the site, giving, as required, grades and lines of streets, alleys, pavements and adjoining property; rights -of -way, restrictions, easements, encroachments, zoning, deed restrictions, boundaries, contours and other data pertaining to existing buildings or adjacent to the site, other improvements and trees; and full information as to available service and utility lines, both public and private, and test borings, pits, reports and soil bearing values and other necessary operations for determining subsoil conditions. Tests and inspections. City shall furnish or pay for structural, mechanical, chemical, soil mechanics, and other tests, reports and inspections as required by law or Project documents. 1.12 INDEPENDENT CONTRACTOR STATUS Consultant is an independent contractor, not City's employee. Consultant's employees or subcontractors are not City's employees. This Agreement does not create a partnership relationship. Neither party has authority to enter into contracts as agent for the other party. Consultant and City agree to the following rights consistent with an independent contractor relationship: 1. Consultant has the right to perform services for others during the term of this Agreement; and 2. Consultant has the sole right to control and direct the means, manner and method by which services required by this Agreement will be performed; and 3. Consultant has the right to hire assistants as subcontractors, or to use employees to provide the services required by this Agreement; and 4. Consultant or Consultant's employees or subcontractors shall perform the services required by this Agreement. City shall not hire, supervise, or pay any assistants to help Consultant; and 5. Neither Consultant nor Consultant's employees or subcontractors shall receive any training from City in the skills necessary to perform the services required by this Agreement; and 6. City shall not require Consultant or Consultant's employees or subcontractors to devote full time to performing the services required by this Agreement; and 7. Neither Consultant nor Consultant's employees or subcontractors are eligible to participate in any employee pension, health, vacation pay, sick pay, or other fringe benefit plan of City. 6 1.13 CONFIDENTIALITY; DISPOSITION OF MATERIALS Each party shall take reasonable measures to preserve the confidentiality of any proprietary or confidential information provided to it in connection with this engagement, provided that no claim may be made for any failure to protect information that occurs more than two (2) years after the termination or expiration of this Agreement. At the conclusion of the engagement, upon written request, each party shall return to the other all materials, data and documents that have been provided to the other party, except that Consultant may retain one (1) copy of City's materials for its archival purposes, subject to Consultant's confidentiality obligations hereunder. City shall retain ownership of all data and materials provided by it to Consultant. Original drawings shall remain the property of Consultant. Consultant shall provide City with one (1) signed set ofreproducibles and one (1) full set of digital file copies. 1.14 LIMITATION OF LIABILITY Should any of Consultant's services not conform to the requirements of this Agreement and the appended Proposal for Services, then and in that event City shall give written notification to Consultant; thereafter, Consultant shall either (a) promptly re- perform such services to City's satisfaction at no additional charge, or (b) promptly refund the portion of the fees paid with respect to such services. In the event that re- performance of services or refund of applicable fees would not provide an adequate remedy to City for damages arising from the performance, nonperformance or breach of this Agreement and the appended Proposal for Services, then and in that event Consultant's maximum total liability, including that of any employee, affiliate, agent or contractor, relating to its services, regardless of the cause of action, shall be limited to direct damages in an amount not to exceed the total fees payable under this Agreement. The foregoing limitation of liability shall not apply to the extent that any liability arises from the gross negligence or willful misconduct of Consultant, its employees, affiliates, agents or contractors, or from bodily injury, death of any person, or damage to any real or tangible personal property. Neither party shall be liable for any indirect, special or consequential damages. 1.15 INDEMNIFICATION Consultant agrees to hold harmless, defend, and indemnify City for and from any third party claim or liability (including reasonable defense costs and attorneys' fees) to the extent arising from or in connection with the negligence of Consultant or its employees or agents in the course of performing services. The limitation of liability set forth in Section 1.14 herein applies to Consultant's indemnity obligations pursuant to this Section 1.15, but the limitation shall not apply to the extent that any liability arises from the gross negligence or willful misconduct of Consultant, 7 its employees, affiliates, agents or contractors or from bodily injury, death of any person, of damage to any real or tangible personal property. Except to the extent that Consultant is obligated to indemnify City, City shall indemnify and hold Consultant, its employees, affiliates or agents harmless from any third party claim or liability (including reasonable defense costs and attomeys' fees) to the extent arising from or in connection with the services performed by Consultant or City's use thereof. 1.16 INSURANCE Insurance. Consultant, at Consultant's sole cost, shall have and maintain during the term of this Agreement professional liability insurance coverage in the minimum amount of$1,000,000.00 Dollars from a company authorized to do insurance business in Texas and otherwise acceptable to City. Subconsultant Insurance. Without limiting any of the other obligations or liabilities of Consultant, Consultant shall require each subconsultant performing work under this Agreement to maintain during the term of the Agreement, at the subconsultant's own expense, the same stipulated minimum insurance required in the immediately preceding paragraph, including the required provisions and additional policy conditions as shown below. As an alternative, Consultant may include its subconsultants as additional insureds on its own coverages as prescribed under these requirements. Consultant's certificate of insurance shall note in such event that the subconsultants are included as additional insureds. Consultant shall obtain and monitor the certificates of insurance from each subconsultant in order to assure compliance with the insurance requirements. Consultant must retain the certificates of insurance for the duration of this Agreement, and shall have the responsibility of enforcing these insurance requirements among its subconsultants. City shall be entitled, upon request and without expense, to receive copies of these certificates of insurance. Insurance Policy Endorsements. Each insurance policy hereunder shall include the following conditions by endorsement to the policy: (1) Each policy shall require that thirty (30) days prior to the expiration, cancellation, non - renewal or any material change in coverage, a notice thereof shall be given to City by certified mail to: City Manager, City of Round Rock 221 East Main Street Round Rock, Texas 78664 Consultant shall also notify City, within 24 hours of receipt, of any notices of expiration, cancellation, non - renewal, or material change in coverage it receives from its insurer. 8 (2) Companies issuing the insurance policies shall have no recourse against City for payment of any premiums or assessments for any deductibles which all are at the sole responsibility and risk of Consultant. (3) Terms "City" or "City of Round Rock" shall include all authorities, boards, commissions, departments, and officers of City and individual members, employees and agents in their official capacities, or while acting on behalf of the City of Round Rock. (4) The policy clause "Other Insurance" shall not apply to any insurance coverage currently held by City, to any future coverage, or to City's Self-Insured Retentions of whatever nature. Cost of Insurance. The cost of all insurance required herein to be secured and maintained by Consultant shall be borne solely by Consultant, with certificates of insurance evidencing such minimum coverage in force to be filed with the City. Such Certificates of Insurance are evidenced as Exhibit "B" entitled "Certificates of Insurance." 1.17 COMPLIANCE WITH LAWS, CHARTER AND ORDINANCES Compliance with Laws. Consultant, its consultants, agents, employees and subcontractors shall use best efforts to comply with all applicable federal and state laws, the Charter and Ordinances of the City of Round Rock, as amended, and with all applicable rules and regulations promulgated by local, state and national boards, bureaus and agencies. Consultant shall further obtain all permits and licenses required in the performance of the services contracted for herein. Taxes. Consultant will pay all taxes, if any, required by law arising by virtue of the services performed hereunder. City is qualified for exemption pursuant to the provisions of Section 151.309 of the Texas Limited Sales, Excise, and Use Tax Act. 1.18 FINANCIAL INTEREST PROHIBITED Consultant covenants and represents that Consultant, its officers, employees, agents, consultants and subcontractors will have no financial interest, direct or indirect, in the purchase or sale of any product, materials or equipment that will be recommended or required for the construction of the Project. 1.19 ASSIGNMENT AND DELEGATION The parties each hereby bind themselves, their successors, assigns and legal representatives to each other with respect to the terms of this Agreement. Neither party shall assign, sublet or transfer any interest in this Agreement without prior written authorization of the other party. 9 1.20 LOCAL, STATE AND FEDERAL TAXES Consultant shall pay all income taxes, and FICA (Social Security and Medicare taxes) incurred while performing services under this Agreement. City will not do the following: 1. Withhold FICA from Consultant's payments or make FICA payments on Consultant's behalf; or 2. Make state and/or federal unemployment compensation contributions on Consultant's behalf; or 3. Withhold state or federal income tax from Consultant's payments. 1.21 NOTICES All notices and other communications in connection with this Agreement shall be in writing and shall be considered given as follows: 1. When delivered personally to the recipient's address as stated in this Agreement; or 2. Three (3) days after being deposited in the United States mail, with postage prepaid to the recipient's address as stated in this Agreement. Notice to Consultant: Black & Veatch 14100 San Pedro Avenue, Suite 310 Pacific Plaza Building San Antonio, TX 78232 Notice to City: City Manager 221 East Main Street Round Rock, TX 78664 AND TO: City Attorney 309 East Main Street Round Rock, TX 78664 Nothing contained herein shall be construed to restrict the transmission of routine communications between representatives of City and Consultant. 1.22 APPLICABLE LAW; ENFORCEMENT AND VENUE This Agreement shall be enforceable in Round Rock, Williamson County, Texas, and iflegal action is necessary by either party with respect to the enforcement of any or all of the terms or conditions herein, exclusive venue for same shall lie in Williamson County, Texas. This Agreement 10 shall be governed by and construed in accordance with the laws and court decisions of the State of Texas. 1.23 EXCLUSIVE AGREEMENT This document, and all appended documents, constitutes the entire Agreement between Consultant and City. This Agreement may only be amended or supplemented by mutual agreement of the parties hereto in writing. 1.24 DISPUTE RESOLUTION If a dispute or claim arises under this Agreement, the parties agree to first try to resolve the dispute or claim by appropriate intemal means, including referral to each party's senior management. If the parties cannot reach a mutually satisfactory resolution, then and in that event any such dispute or claim will be sought to be resolved with the help of a mutually selected mediator. If the parties cannot agree on a mediator, City and Consultant shall each select a mediator and the two mediators shall agree upon a third mediator. Any costs and fees, other than attorney fees, associated with the mediation shall be shared equally by the parties. City and Consultant hereby expressly agree that no claims or disputes between the parties arising out of or relating to this Agreement or a breach thereof shall be decided by any arbitration proceeding, including without limitation, any proceeding under the Federal Arbitration Act (9 USC Section 1 - 14) or any applicable state arbitration statute. 1.25 SEVERABILITY The invalidity, illegality, or unenforceability of any provision of this Agreement or the occurrence of any event rendering any portion or provision of this Agreement void shall in no way affect the validity or enforceability of any other portion or provision of this Agreement. Any void provision shall be deemed severed from this Agreement, and the balance of this Agreement shall be construed and enforced as if this Agreement did not contain the particular portion or provision held to be void. The parties further agree to amend this Agreement to replace any stricken provision with a valid provision that comes as close as possible to the intent of the stricken provision. The provisions of this section shall not prevent this entire Agreement from being void should a provision which is of the essence of this Agreement be determined void. 1.26 MISCELLANEOUS PROVISIONS Time is of the Essence. Consultant understands and agrees that time is of the essence and that any failure of Consultant to complete the services for each phase of this Agreement within the agreed Project schedule will constitute amaterial breach of this Agreement. Consultant shall be fully responsible for its delays or for failures to use best efforts in accordance with the terms of this Agreement. Where damage is caused to City due to Consultant's failure to perform in these circumstances, City may withhold, to the extent of such damage, Consultant's payments hereunder 11 without waiver of any of City's additional legal rights or remedies. City shall render decisions pertaining to Consultant's work promptly to avoid unreasonable delays in the orderly progress of Consultant's work. Force Majeure. Neither City nor Consultant shall be deemed in violation of this Agreement if it is prevented from performing any of its obligations hereunder by reasons for which it is not responsible or circumstances beyond its control. However, notice of such impediment or delay in performance must be timely given, and all reasonable efforts undertaken to mitigate its effects. Opinions. Consultant's opinions, estimates, projections, forecasts of current and future costs, revenues, other levels of any sort, and events shall be made on the basis of available information and Consultant's expertise and qualifications as a professional. Consultant does not warrant or guarantee that its opinions, estimates, projections or forecasts of current and future levels and events will not vary from City's estimates or forecasts or from actual outcomes. IN WITNESS WHEREOF, City and Consultant have executed this Agreement on the dates indicated. CITY OF ROUND ROCK, TEXAS ATTEST: By: Nyle Maxwell, Mayor Christine R. Martinez, City Secretary Date Signed: Date Signed: BLACK & VEATCH CORPORATION By: Date Signed: ATTACHMENTS Exhibit "A ": Proposal for Services Exhibit `B ": Certificates of Insurance 12 EXHIBIT "A" PROPOSAL FOR SERVICES 13 EXHIBIT `B" CERTIFICATES OF INSURANCE 14 ACORD CERTIFICATE OF LIABILITY INSURANCE 11/01/2003 1ATE (MM1UDDIYY) 1 -13 -2003 PRODUCER Lockton Companies 444 W. 47th Street, Suite 900 Kansas City Mo 64112 -1906 (816)960-9000 THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. INSURERS AFFORDING COVERAGE INSURED 1007194 BLACK & VEATCH CORPORATION P.O. BOX 8405 KANSAS CITY MO 64114 Peart, Larry - 1 - -- INSURER A: CONTINENTAL CASUALTY INSURER B: (VICTOR O. SCHINNERER) INSURER C: INSURER D: INSURER E: - City Manager, City of Round Rock 221 East Main Street Round Rock, TX 78664 SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, THE ISSUING INSURER WILL ENDEAVOR TO MAIL 3 DAYS WRITTEN NOTICE TO THE CERTIFICATE HOLDER NAMED TO THE LEFT,BUT FAILURE TO DO SO SHALL IMPOSE NO OBLIGATION OR LIABILITY OF ANY KIND UPON THE INSURER, ITS AGENTS OR REPRESENTATIVES. AUTHORIZED REPRESENTATIVE THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR COND TON OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN. THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS. EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. AGGREGATE LIMBS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. .. -• INSR ,LTR TYPE OF INSURANCE POUCY NUMBER POUC EFFECTIVE DATE(MM)DDIYY) POLICY EXPIRATION DATE(MM/DDIYY) OMITS GENERAL UABILTTY COMMERCIAL GENERAL LIABILITY NOT APPLICABLE - - _ - - - EACH OCCURRENCE $ XXXXXXX FIRE DAMAGE (Any one fire) $ XXXXXXX 1 CLAIMS MADE OCCUR MED EXP (Any one person) $ XXXXXXX PERSONALAADV INJURY XXXXXXX __.$ GENERAL AGGREGATE $ XXXXXXX GEN'L AGGREGATE LIMIT APPLIES PER — I POLICY I I JE T 7 Loc PRODUCTS- COMP /OP AGj X XXXXXX • -.r AUTOM081LE LIABILITY — ANY AUTO ALL OWNED AUTOS SCHEDULED AUTOS HIRED AUTOS NON -OWNED AUTOS NOT APPLICABLE COMBINED SINGLE LIMIT (Eaacadenl) s )00000{X BODILY (Per Ms..) INJURY $ XXXXXXX BODILY INJURY (Per accident) $ XX}OCX)CX $ XXXXXXX PROPERTY DAMAGE (Per acddenh) GARAGE LIABILITY — 1 ANY AUTO NOT APPLICABLE AUTO ONLY - EA ACCIDENT j $ XXXXXXX XXXXXXX EA ACC AUTO ONLY. AUTO ONLY. AGG $ XXXXXXX EXCESSLIABILTTY 7 OCCUR u CLAIMS MADE s NOT APPLICABLE - EACH OCCURRENCE $ XXXXXXX AGGREGATE $ XXXXXXX y XXXXXXX UMII ■ BRC DEDUCTIBLE ■ FORM XXXXXXX RETENTION $ _ $ XXXXXXX WORKERS COMPENSATION AND EMPLOYERS' LIABILTTY NOT APPLICABLE To l i i iT OTH- TORYIIMRR (ER E L EACH ACCIDENT $ XXXXXXX EL DISEASE- EA EMPLOYEE $ XXXXXXX E L. DISEASE - POLICY LIMIT $ XXXXXXX A OTHER PROFESSIONAL LIABILITY PLN 114079627 I 11/01/2002 11/01/2003 S1,000,000 EACH CLAIM AND IN THE ANNUAL AGGREGATE FOR ALL PROJECTS DESCRIPTION OF OPERATIONSILOCATIONSNEHICLES /EXCLUSIONS ADDED BY ENDORSEMENT /SPECIAL PROVISIONS B &V Project No 83124.1800 Water and Wastewater Cost of Service and Rate Design Study COVERAGES PC CERTIFICATE HOLDER I I ADDMONAL INSURED ;INSURER LETTER: CANCELLATION °••^ DACORD CORPORATION 1988 IMPORTANT If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must be endorsed. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). DISCLAIMER The Certificate of Insurance on the reverse side of this form does not constitute a contract between the issuing insurer(s), authorized representative or producer, and the certificate holder, nor does it affirmatively or negatively amend, extend or alter the coverage afforded by the policies listed thereon. ACURD 25S (7/97) DATE: January 2, 2003 SUBJECT: City Council Meeting — January 9, 2003 ITEM: 9.C.1. Consider a resolution authorizing the Mayor to execute a contract with Black & Veatch Corporation for the water and wastewater rate study. Resource: Bill White, Finance Director History: As Round Rock has grown, so have the capital and operational needs of the water and wastewater utilities. It has been a number of years since we have performed a formal rate study for the utilities. We recently sent requests for proposals to a number of reputable rate consulting firms for the purpose of performing such a study. The study will provide us with a powerful tool for financial planning. After reviewing the proposals, we narrowed the field to three finalists for interview. Representatives from both the utilities and the Finance Department participated in these interviews. Of the three finalists, Black & Veatch Corporation were thought to be the best - qualified firm. We recommend negotiating a contract for rate consulting services with Black & Veatch Corporation. Funding: Water and Wastewater Utility Fund Cost: Up to $75,000 Source of Funds: Water and Wastewater Utility Fund Outside Resources: N/A Impact/Benetit: The study will provide us with a powerful tool for financial planning. Public Comment: N/A Sponsor: Finance Department Council Members Alan McGraw Carrie Pitt Scot Knight Isabel Gallahan Gary Coe City Manager Jim Nuse City Attorney Stephan L Sheets ROUND ROCK, TEXAS PURPOSE. PASSION. PROSPERITY. February 13, 2003 Mr. Larry Peart Black & Veatch Corporation 14100 San Pedro Avenue, Suite 310 Pacific Plaza Building San Antonio, TX 78232 Dear Mr. Peart: The Round Rock City Council approved Resolution No. R- 03- 01 -09- 9C1 at their regularly scheduled meeting on January 9, 2003. This resolution approves the agreement for consulting services for the development of a water and wastewater rate study. Enclosed is a copy of the resolution and original agreement for your files. If you have any questions, please do not hesitate to contact Bill White at 218 -3295. n erely, Mayor Nyle Maxwell Christine R. Martinez Mayor Pro -tent City Secretary Tom Nielson Enclosure CITY OF ROUND ROCK Administrative Dept., 22t East Main Street - Round Rock, Texas 78664 Phone: 512 218.5400 • Fax 512 2r8 7097 • www.ci round - rock.tx.us Water= arrdtWastewAater;Utilit of Service and-Rates $ . ACK & VEATCH : -J . 4 4I V i d 4dd4t��l�(. Vq& Prepared for ROUND ROCK, TEXAS PURPOSE PASSION. PROSPERITY. 2003 bmldm1 a world aI diH.,e c... BLACK & VEATCH 14100 San Pedro Avenue Suite 310 Pacific Plaza Building San Antonio, Texas 78232 USA Tel (210) 404-1330 Fax: (210) 404-1370 Mrs. Cindy Demers Finance Director City of Round Rock 221 East Main Street Round Rock, TX 78664 Dear Mrs. Demers: Presented herein is our "Report on Water and Wastewater Utility Revenue Requirements, Cost of Service, and Rate Design Study" for the City of Round Rock. The report presents the forecast of revenue and revenue requirements for the City's water and wastewater utilities for the ten fiscal year period 2003 -04 through 2012 -13. Costs of service analyses were performed which indicate the adequacy of water and wastewater rates to derive revenue from respective users of the utility systems based upon expected financial conditions for the fiscal year 2003- 04. Schedules of proposed water and wastewater rate adjustments were then developed to recover each utility's total cost in an equitable and practical manner from all users served. We wish to express our appreciation to Mrs. Noelle Jones, C.P.A., for her invaluable assistance in the conduct of the study. It is a pleasure to be of service to the City of Round Rock in this matter. dbb Enclosure BLACK & VEATCH building a world of dheerencolo Sincerely, Black & Veatch Larry A. Peart Senior Consultant Black & Veatch Corporation 2- 03- 01 -D9- gcI August 13, 2003 REPORT ON WATER AND WASTEWATER UTILITY REVENUE REQUIREMENTS, COST OF SERVICE, AND RATES FOR CITY OF ROUND ROCK, TEXAS 1.0 INTRODUCTION 1 1.1 Purpose 1 1.2 Scope 1 2.0 REVENUE AND REVENUE REQUIREMENTS 1 2.1 Customer Growth and Revenue Forecasts 1 Customer Growth 2 Billable Sales Volume 2 Projected Revenues 3 2.2 Operation and Maintenance Expenses 4 2.3 Capital Improvement Program and Financing Plan 5 Capital Improvement Program 5 Capital Financing Plan 5 2.4 Debt Service Requirements 7 2.4 Projected Financial Plan and Future Rc.venue Adjustment Needs 7 Bey Financial Policies 7 Revenue Adjustments Required 8 3.0 COST OF SERVICE ANALYSIS 9 3.1 Cost of Service Elements 9 3.2 Allocation of Costs to Functional Cost Components 9 3.3 Units of Service and Unit Costs 10 3.4 Distribution of Costs to Customer Classes 11 4.0 PROPOSED RATE ADJUSTMENTS 12 4.1 Rate Design Considerations 12 Existing Rates 12 Proposed Water Rates 12 Proposed Wastewater Utility Rates 12 4.2 Comparison of Typical Bills 13 4.3 Comparison of Costs of Service with Revenue Under Proposed Rates 14 5.0 REUSE WATER RATES 14 5.1 Reuse Rate Methodology 14 TC -1 WATER Table W -1 Historical and Projected Average Number of Customer Accounts Table W -2 Historical and Projected Water Sales Volume Table W -3 Historical and Projected Water Service Revenue by Class Table W -4 Historical and Projected Operation and Maintenance Expense Table W -5 Projected Major Capital Improvement Program Table W -6 Capital Improvement Program Financing Plan Table W -7 Existing and Proposed Debt Service Table W -8 Comparison of Projected Revenue and Revenue Requirements Under Increased Revenue Table W - Test Year Cost of Service Table W -10 Allocation of Net Plant Investment and Capital Costs to Functional Cost Components Table W -11 Allocation of Operation and Maintenance Expense to Functional Cost Components Table W -12 Units of Service Table W -13 Unit Costs of Service Table W -14 Allocation of Cost of Service to Customer Classes Table W -15 Allocation of Cost of Service to Customer Classes (Cont.) Table W -16 Comparison of Cost of Service with Revenue Under Existing Rates Table W -17 Existing and Proposed Ratess Table W -18 Comparison of Typical Bills Under Existing and Proposed Rates Table W -19 Comparison of Adjusted Cost of Service with Revenue Under Proposed and Existing Rates WASTEWATER TABLES Table S -1 Historical and Projected Average Number of Customer Accounts Table S -2 Historical and Projected Wastewater Sales Volume Table S -3 Historical and Projected Wastewater Revenue by Class Table S -4 Historical and Projected Operation and Maintenance Expense Table S -5 Projected Major Capital Improvement Program Table S -6 Capital Improvement Financing Plan Table S -7 Existing and Proposed Debt Service Table S -8 Comparison of Projected Revenue and Revenue Requirements Under Increased Revenue Table S -9 Test Year Cost of Service Table S -10 Allocation of Net Plant Investment and Capital Costs to Functional Cost Components Table S -11 Allocation of Operation and Maintenance Expense to Functional Cost Components Table S -12 Estimated Units of Service Table S -13 Unit Costs of Service Table S -14 Allocation of Cost of Service to Customer Classes Table S -15 Allocation of Cost of Service to Customer Classes (Cont.) TC -2 Table S -16 Comparison of Allocated Costs with Revenue Under Existing Rates Table.S -17 Existing and Proposed Ratess Table S -18A Option A Comparison of Typical Bills Under Existing and Proposed Rates Table S -18B Option B Comparison of Typical Bills Under Existing and Proposed Rates Table S -18C Option C Comparison of Typical Bills Under Existing and Ptoposed Rates Table S -19A Option A Comparison of Adjusted Cost of Service with Revenue Under Proposed and Existing Rates Table S -19B Option B Comparison of Adjusted Cost of Service with Revenue Under Proposed and Existing Rates Table S - 19C Option C Comparison of Adjusted Cost of Service with Revenue Under Proposed and Existing Rates COMBINED UTILITIES Table C - Historical and Projected Operation and Maintenance Expenses Table C -2 Capital Improvement Program Financing Plans Table C -3 Comparison of Projected Revenue and Revenue Requirements Under Increased Revenue Table C -4A Option A Comparison of Combined Typical Bills Under Existing and Proposed Rates ' Table C -4B Option B Comparison of Combined Typical Bills Under Existing and Proposed Rates Table C -4C Option C Comparison of Combined Typical Bills Under Existing and Proposed Rates APPENDIX Wholesale Contract's Summary TC -3 1.2 Scope REPORT ON WATER AND WASTEWATER UTILITY REVENUE REQUIREMENTS, COST OF SERVICE, AND RATES FOR CITY OF ROUND ROCK, TEXAS 1.0 INTRODUCTION 1.1 Purpose This report presents the results of Black & Veatch's study of the revenue and revenue requirements, costs of providing service, and design of rates for the water and wastewater utilities of City of Round Rock, Texas ( "City"). A computer financial planning and rate model has also been developed as a part of study efforts that will permit City staff to perform future annual updates for determining revenue needs and the design of rates. 'Included in the report are the results of comprehensive studies of projected revenue under existing rates and revenue requirements for a ten year period; the determination of customer costs of service based on accepted industry cost allocation methodologies; and the design of rates for water and wastewater service. Report findings are based upon industry accepted methodologies from the American Water Works Association's (AWWA) Principles of Water Rates, Fees, and Charges Manual MI, and the Water Environment Federation's (WEF) Financing and Charges manual. The comparison of projected revenue requirements with revenue under existing rates as developed and shown in the attached cash flows is indicative of the overall level of adequacy of those rates to meet projected costs. The costs to be met during an initial period of adequacy are allocated to classes of customers and types of service, and rates adequate to meet those costs are designed. The proposed rates will provide sufficient overall revenue to meet utility system needs and reasonably provide for charging each class of customer its proportionate share of system costs. The following discussion presents key assumptions, study findings, and certain recommendations regarding changes to the City's basic rate schedules. The City's fiscal year (FY) reporting period begins October 1 and ends September 30. Report tables are enclosed and shown separately for the water and wastewater utilities that summarize these matters. Table designations headed with: a "W" are related to the water utility; an "S" are related to the wastewater (sewer) utility; and a "C" are related to the two utilities combined. 2.0 REVENUE AND REVENUE REQUIREMENTS 2.1 Customer Growth and Revenue Forecasts A summary of the projected average number of active customer accounts, water and wastewater sale volumes, and revenues under existing rates are presented in this section. Based on an analysis of historical customer growth, average usage per customer account by class, and the 1 application of existing rates to projected billing units, our revenue forecast assumptions and findings are as follows. Customer Growth. Tables W -1 and S -1 present a summary of the historical and projected average number of customers by class for the fiscal years 2000 through 2013. The City, including The Meadows at Chandler Creek MUD is estimated to be currently serving approximately 22,559 and 22,213 individual retail water and wastewater customers, respectively. The City also currently has contracts to provide service to 9 and 3 wholesale water and wastewater customer accounts, respectively. The proportion of customers by class estimated to be served during FY 2004 are: Class Water Percent Wastewater Percent Inside City Customers Residential 20,425 88.0% 20,392 89.2% Commercial 1,125 4.8% 950 4.2% Industrial 7 0.0% 8 0.0% Apartments 300 1.3% 283 1.2% , Government 35 0.2% 22 0.0% City 93 0.4% 69 0.3% Bulk Water 78 0.3% 0 0.0% Total Inside City 22,063 95.0% 21,724 94.9% Chandler Creek Residential 1,125 - 4.8% 1,125 4.9% Chandler Creek Commercial 6 0.0% 3 0.0% Outside City Customers 15 0.0% 4 0.0% Wholesale Customers 9 0.0% 3 0.0% Total 23,218 100.0% 22,859 100.0% Based on growth estimates provided by City staff, inside City customer growth is projected to be approximately 3.0% per year for FY 2004 through FY 2013 resulting in an average of approximately 738 new inside city customers being added to the water system each year. Wastewater customer growth is assumed to grow at a rate of 3.0% per year also and is forecasted to add an average of approximately 732 new inside City customers from FY 2004 through FY 2013. Billable Sales Volume. Water and wastewater sales volumes have been projected as shown in Tables W -2 and S -2. Billable water sales volumes are estimated based on a constant or uniform usage per customer account based on recent historical experience. Water sales volumes are projected to increase at an approximate 2.8% annual rate for FY 2004 through FY 2005 based upon normalized weather and usage conditions. In January 2006, the City expects that its largest wholesale customer, Brushy Creek, will no longer purchase water from the City due to the expected completion of their water treatment plant. The expected billable annual water loss due to this departure from Round Rock's water system is an estimated 712 million gallons. Total system billable water volume is projected to decrease from 5.76 billion gallons in FY 2005 to an estimated 5.37 billion gallons in FY 2007 due to the loss of Brushy Creek as a wholesale customer. Billable water sales 2 volume is expected to increase at an average rate of 2.28% from FY 2006 to FY 2013 at which point the City is projected to sell 6.29 billion gallons. Billable wastewater sales volumes are also estimated based upon the same methodology used for water. Sales volumes are projected to increase at an approximate 2.88% for FY 2004 through FY 2013. Currently, the City bills all wastewater customers on their winter average consumption. The winter average billing basis is derived by averaging a customer's December, January, and February water consumption. Once this data has been compiled a customer's monthly wastewater bill for the ensuing year is computed on this consumption until the next winter average cycle is performed for the following December — February period. Winter average consumption is an industry recognized method of billing residential customers because it closely associates a residential customer's actual contributed volume discharged to the wastewater system. For non - residential customers, winter average consumption is generally not used because it does not necessarily correlate with a non - residential customer's quantity of wastewater returned to the sewer system. The industry norm to calculate non - residential customer wastewater is to use actual water consumption or a percent of actual water consumption as an estimate of their wastewater volume discharge. It is recommended that the City convert its non- residential customers from the winter average consumption approach to a percent of actual water use approach for determining billable wastewater volume. For the purpose of forecasting ,revenues under existing rates, Tables S - 2 and Table S - 3 continue to use winter average consumption to project wastewater sales volume and wastewater revenue by class, respectively. Tables detailing the effects of moving non - residential customers from the winter average method will be discussed later in this report. Projected Revenues. The City receives revenues to fund its utility enterprise operations from monthly service charges, volume charges, connection charges, and various miscellaneous sources. Projected revenues by customer class are shown in Tables W - 3 and S - 3. The City's existing schedule of rates provide for a monthly base or service charge and a volume charge for use of the system. The City's existing rates have been used to develop projected revenues in Tables W -3 and S -3. The existing schedule of rates has been in effect since being approved by the City Council in January 2001. Service charge revenue forecasts are based upon the projected growth in customers and sale volumes, and the existing schedule of rates. Projected water and wastewater revenues under existing rates are: Fiscal Water Wastewater Combined Year Revenue Revenue Revenue • 2004 $ 14,623,400 $ 7,601,100 $ 22,224,500 2005 15,029,500 7,811,300 22,840,800 2006 14,619,200 8,040,400 22,659,200 2007 14,743,800 8,273,900 23,017,700 2008 15,156,400 8,511,600 23,668,000 2009 15,593,500 ' 8,751,700 24,345,200 2010 16,037,100 8,995,700 25,032,800 2011 16,490,300 9,246,100 25,736,400 2012 16,953,400 9,500,600 26,454,000 2013 17,425,900 9,760,900 27,186,800 3 2.2 Operation and Maintenance Expenses Historical and projected operation and maintenance expenses are shown in Tables W-4 and S-4. Projected operating expenses reflect the effects of future price escalation and increased sales volumes due to customer growth as well as additions to the infrastructure that will require additional funding to maintain and operate them. Annual inflationary allowances have been incorporated into the expenditure forecasts amounting to 3.0% for personnel expenses, supplies, maintenance, materials, purchased services, etc. In addition to annual inflation adjustments, annual cost escalation of 2.8% for the water utility has been recognized for increased raw water, power & light, and chemical costs due to additional water sales. The City forecasts that a portion of its raw and reserve water costs will increase at an annual escalation rate of 15% from FY 2004 to FY 2006. There after it is expected that these costs will moderate to an annual escalation rate of 5 %. The costs for power & light and chemicals for the wastewater utility recognize an escalation rate of 3.3% due to increased wastewater sales volumes attributable to growth. It is noted that the wastewater utility is expecting to incur very large annual increases for the capital portion of its payments to the BRA/LCRA Regional Wastewater System which treats the City's wastewater. As shown in Table W-4, costs for water treatment that include the reservation of raw water are forecast to total $4,853,800 in FY 2004 and to represent approximately 46.1% of the total water utility operating expenses. Costs for water system support total $1,335,200 in FY 2004 representing approximately 12.7% of the total water utility operating expenses. Costs for water lines maintenance total $2,026,800 in FY 2004 representing 19.3% of water utility operating expenses. Remaining operating expenses from the environmental services, utility billing & collections, transfers department, and utility administration total $2,305,800 which represents the remaining 21.9% of operating expenses. As shown in Table S4, the cost of wastewater treatment totaling $4,870,000 in FY 2004 is indicated to account for approximately 64.0% of the wastewater utility's total operating expenses. The cost for wastewater treatment primarily consists of an operations and capital component that the City pays to the BRA/LCRA Regional Wastewater System. Over the forecasted ten -year period these payments are projected to grow substantially according to the financial forecast provided by BRA/LCRA. Projected operation and capital charges paid to BRA/LCRA for the next 10 years are as follows: Fiscal Operation Capital Total Year Expense Charge Charge 2004 $ 2,167,000 $ 2,567,000 $ 4,734,000 2005 2,015,557 4,234,892 6,250,449 2006 2,082,867 5,000,603 7,083,470 2007 2,150,811 5,803,602 7,954,413 2008 2,221,074 6,542,762 8,763,836 2009 2,060,030 6,797,036 8,857,066 2010 2,106,800 7,046,011 9,152,811 2011 2,154,436 7,429,156 9,583,592 2012 2,202,362 8,018,011 10,220,373 2013 2,253,302 8,469,699 10,723,001 4 Costs for wastewater systems support total $480,500 in FY 2004 representing 6.3% of the wastewater utility's total operating expenses. Costs for the wastewater lines maintenance total $1,571,100 in FY 2004 representing 20.6% of the wastewater utility's total operating expenses. Environment services and utility billings & collections represent the remainder of the wastewater utility expense of $688,900 for FY 2004 or 9.1% of the total. Non - operating expenditure items included in the City's budget for routine annual equipment renewals and replacements have been excluded from the operating expenses shown for each utility. These expenditure items are classified as routine capital costs and are reflected in subsequent operating cash flow statements for each utility. Similarly, transfers to the general fund and debt payments have also been excluded from the operating expenses shown for each utility and subsequently shown in the operating cash flow statements. 2.3 Capital Improvement Program and Financing Plan A summary of each utility's major capital improvement program is shown in Tables W -5 and S- 5, and the proposed financing plan is shown in Tables W -6 and S -6. Capital Improvement Program. The FY 2003 and the projected ten -year capital improvement ,programs (CIP), for the water and wastewater systems that show project descriptions and estimated cost were provided by City staff. The total CIP costs for FY 2003 to FY 2014 for the water and wastewater utilities are: Water CIP $ 70,953,600 Wastewater CIP - 41,970,800 Total $112,924,400 Significant water projects include a 20 MGD water treatment plant expansion, additional transmission mains, ground water treatment at Lake Creek, Barton Hill elevated water storage and various line extensions, replacements, and upgrades. The majority of capital expenditures for wastewater projects include the wastewater collection system inspections /rehabilitations, Chandler Creek Interceptor, and various other collection system expansions. Capital Financing Plan. Tables W -6 and S -6 show the source and application of capital funds and indicate the proportion of available funds, bond proceeds, impact fees, interest income, and operating fund transfers (pay -as- you -go financing) that are to be used to meet each year's capital program requirement. A summary of the proposed capital financing sources over the planning period for each utility is shown below. As of October 1, 2003 the City had $19,867,700 available for construction projects of which $10,533,300 and $9,334,400 was available to the water and wastewater utility, respectively. In addition to this amount, $23,000,000 was available for capital improvement projects from the sale of the City's wastewater treatment plant. To cash finance some of the capital improvement projects $10,000,000 and $8,000,000 of funds available from the sale of the wastewater treatment plant have been allocated to the water and wastewater utility capital fund. .The difference between the total funding sources and scheduled expenditures over the planning period provides for an uncommitted ending balance of $5,486,400 and $35,100 for the water and wastewater utilities, respectively. Available beginning fund balances are anticipated to be drawn down to minimize the issuance of bonds. Construction financing for the study period is shown below: 5 Construction Financing Source of Funds Item Water Wastewater Percent Beginning Fund Balance $20,533,300 $17,334,400 31.7% Operating Fund Transfers 7,150,000 2,300,000 7.9% Bond Proceeds 18,250,000 13,500,000 26.6% Impact Fees 29,700,000 8,800,000 32.2% Interest Income 1,445,500 544,100 1.7% Total $77,078,800 $42,478,400 100.0% Construction Financing Use of Funds Item Water Wastewater Percent Capital Improvements $ 70,953,600 $ 41,970,900 99.0% Debt Issuance Expense 456,300 337,500 0.7% Surety Bond Expense 182,500 135.000 0.3% Total $ 71,592,400 $ 42,443,400 100.0% It is assumed that all proposed revenue bonds are to be issued at the beginning of the fiscal year. A portion of the bond proceeds are used to pay for issuance costs estimated at 2.5% of the total bonds as shown above. Surety bonds are-expected to be used to cover any debt service reserve requirements. It is assumed that surety bond expense will total 1.0% of the total issuance price. It is anticipated that the bonds will be issued as follows: Approximate Issue Date Water Wastewater Total 2004 $ 13,900,000 $ 0 $ 13,900,000 2005 3,500,000 500,000 4,000,000 2006 850,000 3,000,000 3,850,000 2007 0 3,300,000 3,300,000 2008 0 2,900,000 2,900,000 2009 0 1,100,000 1,100,000 2010 0 800,000 800,000 2011 0 1,000,000 1,000,000 2012 0 900,000 900,000 2013 0 0 0 Total $ 18,250,000 $ 13,500,000 $ 31,750,000 Additional non -debt funding sources expected to be available include transfers from the operating fund, impact fees, and interest earnings °on the investment of available fund balances. Net revenues from system operations or pay -as- you -go funds are expected to assist in funding a portion of. each utility's capital improvement program amounting to $7,150,000 in water operating funds, and $2,300,000 in wastewater operating funds. In addition to pay -as- you -go cash financing of the capital improvement program the City estimates that it will collect 6 $29,700,000 for the water utility and $17,600,000 for the wastewater utility in impact fees. Of the impact fee money collected for the wastewater utility only $8,800,000 will be available for the wastewater capital improvement program. The remaining balance of the impact fees will be applied to the BRA/LCRA capital charge. 2.4 Debt Service Requirements A summary of the water and wastewater utilities' total existing and proposed debt service requirements are shown in Tables W -7 and S -7. The City is forecasted to make the following General Obligation and Revenue Bond payments as detailed below: Fiscal Year Water Utility Related Wastewater Utility Related Combined General Revenue General Revenue Total Obligation Bond Obligation Bond Payments 2003 $ 114,200 $ 1,085,000 $ 283,900 $ 307,400 $ 1,790,500 2004 188,000 2,158,500 467,500 252,300 3,006,300 2005 201,300 2,241,200 500,600 231,100 3,174,200 2006 64,100 1,659,400 159,500 394,500 2,277,500 2007 66,900 1,484,800 166,400 553,300 2,271,400 2008 64,000 1,484,800 159,100 789,200 2,497,100 2009 46,400 1,484,800 115,500 878,700 2,525,400 2010 25,600 1,484,800- 63,700 943,800 2,517,900 2011 0 1,484,800 0 1,025,200 2,510,000 2012 0 1,484,800 0 1,098,400 2,583,200 2013 0 1,484,800 0 1,098,400 2,583,200 Projected debt service (principal and interest) payments for the proposed Revenue Bond issues are estimated based on a 20 year payback schedule and effective interest rates of 5.25% for all issues. The new debt payments correspond directly to the water and wastewater utilities based on capital financing needs as previously shown in Tables W -6 and S -6. As shown above, total debt service payments are expected to increase from $1,790,500 in FY 2003 to $2,583,200 in FY 2013. Total debt payments increase in FY 2004 due to new revenue bonds being issued while existing revenue bond debt subsequently is paid off in FY 2006. 2.5 Projected Financial Plan and Future Revenue Adjustment Needs A comparison of the projected revenue and revenue requirements for the water and wastewater utilities is shown in Tables W -8 and S -8, respectively; with a combined utility comparison shown in Table C -3. The cash flow statements present the results of the utility's projected operations and ability to meet key financial goals under current and proposed rate adjustments. Key Financial Policies. It is assumed that the water and wastewater utilities as enterprise operations will be financially self such that adequate revenue will be generated to meet respective annual cash obligations and contribute adequate net revenues to maintain desired debt service coverage ratios and working capital balances. 7 The City will partially finance its capital improvement program requirements through the use of annual revenues from operating funds through a pay -as- you -go transfer to the capital fund. These transfer amounts are shown on Lines 3 of Tables W -6, S -6, and C -2. The City is required to maintain net revenues (gross revenue less operating expense) each year to produce a debt service coverage ratio of 1.25 or 125 %. As shown on Line 34 of Table C -3, if the indicated rate increases are implemented revenue bond debt service coverage is forecasted to equal or exceed 1.25 for the study period. A target operating or cash reserve ratio of 90 days (ending balance expressed as number of days of operating expense) is recommended to be maintained to provide adequate annual operating or working capital funds to permit bills to be paid when due and otherwise provide funds for emergency /contingency purposes. A cash reserve ratio of this magnitude not only meets but exceeds the AWWA standard utility practice in this regard. As indicated on line 35 of Table C -3, the utility is expected to meet its target operating reserve if the indicated rate increases are implemented. Revenue Adjustments Required The key findings and recommendations from the analysis of the utility's future financial operations are shown in Tables W -8 and S -8. Indicated revenue increases are assumed to be effective on January 1 during the corresponding fiscal year. The projected cash flow analyses shown in Table W -8 indicates that annual revenues under existing rates will be sufficient to meet on -going water utility financial obligations for FY 2004 but the water utility will need slight increases of 2.5% in FY 2005 & FY 2006. As shown in Table S -8, the wastewater utility will need additional revenues from rate increases to meet increasing financial obligations primarily due to increased operation and capital charges paid to BRA/LCRA for wastewater treatment/disposal purposes. These charges are expected to increase from $4,473,000 in FY 2003 to $10,723,000 in FY 2013. Proposed revenue increases and revenue generated by the increase necessary to meet the key financial goals of the wastewater utility are shown on Lines 3 through 12 of Table S -8. Based on a review of the adequacy of revenues under existing rates to meet the water and wastewater utility's annual revenue requirements, the following rate increases are indicated to be required. Fiscal Year Water Wastewater Combined 2004 0.0% 9.0% 3.1% 2005 2.5% 9.0% 4.9% 2006 2.5% 9.0% 5.0% • 2007 0.0% 8.5% 3.5% 2008 0.0% 8.5% 3.6% 2009 0.0% 0.0% 0.0% 2010 0.0% 0.0% 0.0% 2011 0.0% 0.0% 0.0% 2012 0.0% 4:0% 1.8% 2013 0.0% 0.0% 0.0% The combined water and wastewater increases are indicated to range from 3.1% to 5.0% over the first five years of the planning period. 8 The cash flow analyses shown in Tables W -8, S -8, and Table C -3 indicate that annual revenues under the proposed revenue adjustments will be sufficient in meeting annual expenditure requirements as well as maintaining adequate operating reserve and debt service coverage targets. It is important to highlight that while the wastewater utility is expecting some large rate increases, the overall rate increases on a combined basis are relatively small and generally correspond with historical annual inflation. It is recommended that the City monitor its actual revenue and revenue requirements in coming years against those forecasted herein to verify the need and magnitude for future revenue/rate adjustments. The need for future revenue /rate adjustments will be directly affected by actual system growth, the cost of capital improvement projects, changes in the BRA/LCRA projected payments, and inflation trends on operating expenditures. 3.0 COST OF SERVICE ANALYSIS 3.1 Cost of Service Elements The total revenue requirements to be derived from rates for water and wastewater service are ,synonymous with, and are the definition of, the total cost of service. Tables W -9 and S -9 show the determination of revenue requirements (costs of service) to be allocated to functional cost components for the purpose of further distributing these costs to customer classes. Costs for FY 2004 (test year) are separated on a cash basis of revenue requirement determination consisting of operation and maintenance-expense and capital related costs. Revenues derived from non -rate related sources are deducted from the total revenue requirements to arrive at the overall amount to be recovered from rates. 3.2 Allocation of Costs to Functional Cost Components The allocation of utility revenue requirements, or cost of service, to functional cost components on a cost - causative basis are shown in Tables W -10, W -11, and S -10, S -11. Capital costs are assigned to cost components on the basis of the allocation of plant investment in physical system facilities, whereas operating expenses are assigned d to cost components. Cost assignments to functional cost components are based upon the industry accepted rate - making methodologies endorsed in the American Water Works Association's (AWWA) Principles of Water Rates, Fees, and Charges Manual Ml, and the Water Environment Federation's (WEF) Financing and Charges manual. Water utility cost of service allocations are based on the "base -extra capacity" method of allocation and recognize the elements of base, or average rate of use; extra capacity for maximum day and maximum hour demand in excess of average use; customer meter /service and billing related costs; and direct fire protection. Costs allocated to the base and extra capacity Components reflect the City's historical maximum to average usage demand relationships. Due to various service delivery conditions applicable to the water and wastewater system, it is necessary to recognize several expanded categories of cost in order to properly assign the costs of providing water and wastewater service to the various customer classes the City serves i.e. 9 wholesale customers. In this expansion of cost categories, costs assigned to the basic functional cost components are classified as one of the following: • Common to All (Wholesale & Retail) • Retail Only (Applicable to Inside & Outside City & Chandler Creek) The Common to All category was established in order to properly allocate the costs related to facilities which are jointly shared by all customers exclusive of those facilities which are allocable directly to a specific customer group. Water facilities included in this category include source of supply, production/treatment, pump stations, transmission mains, storage facilities, and customer billing. Wastewater facilities include lift stations and all mains greater than 12 -inch in diameter. The water and wastewater facilities included in the Retail Only cost category include the water distribution network and the smaller collection mains that are used principally for the retail customer class. Also included for the water utility are meters and direct fire protection related to retail service. Wastewater utility cost of service allocations are based on the "proportionate use method of ,allocation and recognize the elements of volume /capacity; wastewater strength for biochemical oxygen demand (BOD) and total suspended solids (TSS); and customer related costs for billing services. Treatment costs allocated to the volume and strength components reflect design/operational considerations for the treatment plant facilities. It is noted that general plant investment and administrative and general overhead costs have been assigned to cost parameters on the basis of the total direct costs previously assigned to each category. • 3.3 Units of Service and Unit Costs Customer service requirements, or units of service, and resultant unit costs of service are shown in Tables W -12, S -12, and W -13, S -13. Units of service are used to distribute the functional costs of service to customer classes based upon their relative use of the water and wastewater systems. For the water system, annual water usage is based on the forecasted water sales for each customer class, and capacity requirements are based on estimates of the maximum day and maximum hour demands, or capacity, that each place on the system. Since the water system is sized and incurs capacity related costs for fire protection, a separate fire protection customer class has been identified to determine the cost of service responsibility for this service. For the wastewater system, volume units of service have been assigned based upon the contributed, or billable wastewater volume, of each class and assigned infiltration/inflow (I/I) volume to the system. It is estimated that approximately 22.6% of the total flow to City treatment/disposal facilities is from 1/1. 1/1 responsibility is assigned to customer classes based .upon two- thirds (67 %) being related to the customer connections and one -third (33 %) being related to the contributed volume of each class. 10 Wastewater strength units have been assigned to customer classes based on an analysis of normal domestic strength concentrations which average 205 milligrams per liter (mg/1) for BOD and 272 mg/1 for TSS. Unit costs were developed for the Common to All category and the Retail Only category. It is necessary to separately identify costs of the system for the Common to All category because it is assumed that all customers will share in these costs. Retail Only unit costs apply only to those customers that should share in those costs. Retail Only customers are also allocated their respective Common to All costs. Unit costs of service by cost component for each utility are developed by dividing the total applicable costs by the number of service units to arrive at a cost per 1,000 gallons (Mgal.), a cost per 1,000 gallons per day (Mgd), a cost per pound, a cost per bill, etc. 3.4 Distribution of Costs to Customer Classes The allocation of costs of service to customer classes is shown in Tables W -14, W -15, S -14 and S -15, and a comparison of the resultant allocated cost to revenue under existing rates by customer class is shown in Tables W -16 and S -16. The cost to revenue comparison indicates the degree of over or under recovery of revenues needed from each class and serves as a guide for making adjustments in the subsequent design of rates. For the water utility, the costs of public fire protection is redistributed to all inside and outside City customer classes to be recovered from those classes as shown in column 2 on Table W -16. The water utility also provides free water to other City departments. The costs for this service has also been reallocated to the inside and outside City customer classes to be recovered from each as shown in column 3 on Table W -16. Based on a revenue neutral situation for the water utility, it is indicated that the revenue generated from residential class rates is 3.1% more than the indicated cost of service for that class. The commercial class indicates approximately a 1.0% under recovery of cost of service. The apartment and government class are over recovering revenue of 8.9% and 9.2 %, respectively. The total inside City category is over recovering revenue by approximately 2.5% or $286,600. In the outside City customer group, Chandler Creek residential and commercial customer groups are over recovering their respective cost of service by 9.9% and 8.1 %, respectively. The total outside City category is over recovering is cost of service 7.8% or $37,100. The water wholesale customer group indicates that in total the class is under recovering their respective cost of service by 12.7% or $323,700. Based upon the need for a 9.0% overall increase for the wastewater utility, it is indicated that residential rates under recover by 7.6% compared to cost of service, commercial class rates under recover by 17.2 %, industrial class under recover by 22.9 %, apartment class under recover by 6.8 %, and the surcharge class under recover by 12.9 %. The total inside City category under recovers its associated cost of service by 10.2 %, or $722,200. The total outside City category is indicated to be under recovering by 4.2% or $11,900. The wastewater wholesale customer group indicates that in total that the class is over recovering their respective cost of service by 17.5% or $50,000. It is important to note that resultant cost of service findings should not be used as literal answers, but as a guide to how adjustments might be made in subsequent rate design. 11 4.0 PROPOSED RATE ADJUSTMENTS 4.1 Rate Design Considerations A primary consideration in the derivation of rate schedules is the establishment of equitable charges to customers commensurate with the costs of providing that service. The only method of assessing entirely equitable rates would be the determination of each customer's bill, based on his particular service requirements. Since this is obviously impractical, if not impossible, when dealing with thousands of customers, rates are normally designed to fit average conditions for groups of customers (customer classes) having similar service requirements. Existing Rates. The City's existing schedule of water rates provide for assessment of a fixed monthly charge that varies by meter size, and a volume charge per 1,000 gallons for all water used as shown in Table W -17. Existing wastewater rates are presented in Table S -17 and are composed of a fixed monthly charge that varies by customer class and a volume charge per 1,000 gallons for all wastewater volume. Proposed Water Rates. The schedule of proposed water rates shown in Table W -17 are the ,same as existing rates for all water customers as it is recommended that no changes be made at this time inasmuch as an overall revenue adjustment (increase /decrease) is not warranted at this time. Currently, wholesale customer water rates are generally over recovering their respective cost of service and it is suggested that these rates-remain unchanged similar to the retail rates. The rates are shown as follows and should be reevaluated in FY 2005 to determine if inequities still exist. A summary of the contract provisions associated with the rates are shown in the appendix section to this report. Wholesale Water Rates Base Rate Volume Rate $ $ /1,000 gal. Fern Bluff 10.48 1.76 Brushy Creek 34,619 0.93 Vista Oaks 10.52 1.76 Williamson County MUD 10 0 2.36 Williamson County MUD 11 0 2.36 Aqua Source 4,185 1.30 RR Joint Venture 850 1.27 Manville Water Supply 117.80 1.91 Williamson County Park 238.46 1.91 Proposed Wastewater Rates. Proposed wastewater rates are shown in Table S -17. Since the wastewater utility will require an overall revenue increase of 9.0 %, it is suggested that the City . adjust its current billing basis for its non - residential customer class. Presented in Table S -17 are three proposed wastewater rates labeled Option A, B, & C. Each option incorporates a different billing basis for non - residential customers. Option A maintains the City's current billing basis using the winter average approach. All other options assume that residential customers remain on the winter average billing basis with Options B & C assuming all non - residential customers 12 are billed on 70% and 80% of their actual water consumption, respectively. Billing non- residential customers on a percent of their actual water consumption will better associate a customer's actual wastewater returned to the sewer system thus providing more equitable cost recovery from these customer groups. As indicated on Table S -17, Options A & B include no change in the City's monthly meter charge with the rate increases having been incorporated into the volume charge per 1,000 gallons. Option A's proposed volume rate is $2.18 per 1,000 gallons versus the existing rate of $1.89 per 1,000 gallons. Option B's proposed volume rate is $2.12 per 1,000 gallons. The difference in the volume rate for Option A & B is due to changing the billing basis for non - residential customers from a winter average in Option A to 70% of actual water consumption for Option B. The 70% of actual water consumption for Option B increases the number of billing units for recovery of volume related costs which results in an overall lower volume rate. Proposed Option C rates were developed to reflect a 80% of actual water consumption to bill non - residential customers. To mitigate some cost of service inequities among classes under this scenario some of the monthly charges for meters have been increased and other larger meters have been reduced. For Option C, the 5/8" and 3/4" monthly meter charges have been increased to $9.41 and $11.85 from $8.60 and $11.40, respectively. Monthly meter charges for meters sized 2" to 10" have been slightly reduced. The effect of changing these meter charges helped correct some 1 class inequities that would have existed if the meter charges had been left at the same levels as in Option A & B. With the meter charge changes and the effects of a larger billing basis for non- residential customers, the indicated volume rate for Option C is $1.93 per 1,000 gallons. Similar to wholesale water rates, it is proposed that wholesale wastewater rates remain at their current levels. With a series of projected rate increases needed for the wastewater utility over the next five years, the wholesale customer group's cost of service will likely increase where current rate /revenue levels will better match their allocated cost of service. The current wholesale wastewater rates are shown as follows, and a summary of the contract provisions associated with the rates are presented in the appendix section to this report. Wholesale Wastewater Rates Vista Oaks Williamson County MUD 10 Williamson County MUD 11 RR Joint Venture Volume Rate $ /1,000 gal. 2.83 3.03 3.03 3.03 4.2 Comparison of Typical Bills A comparison of typical bills by customer class for varying monthly water use under existing and proposed rates is shown in Tables W -18, S -18A, S -18B, and S -18C. Tables S -18A — 18C represents a customer's typical bill under the three different options. A comparison of combined water and wastewater typical bills by customer class for varying monthly usage may be found in Tables C-4A, C -4B, and C -4C. Because customers pay a fixed monthly service charge and a volume charge for consumptive use, the indicated typical bills vary depending upon the proposed rate adjustments incorporated into the design of each charge component, and further according to volume of water use. 13 Since there was no change in the schedule of water rates, there is no impact or change on customer water bills in Table W -18. However, typical wastewater bills for all classes are going to very dependent upon which option is chosen. For Option A in Table S -18A, the typical wastewater bill for a residential customer using 5,000 gallons will increase $1.45 from $18.05 to $19.50 per month resulting in a 8.0% increase. The average commercial customer using 50,000 gallons per month will experience an increase of 13.0% or $14.50 per month from their current bill under existing rates. As indicated for Option B in Table S -18B, the typical wastewater bill for a residential customer using 5,000 gallons is expected to increase 6.4% or $1.15. The average commercial customer will experience an increase of 17.9% or $19.98 per month. Option C in Table S -18C indicates that the typical wastewater bill for a residential customer will rise by 5.6% or $1.01 per month. Under this option the average commercial customer bill will increase by 22.6% or $25.16 per month. A comparison of combined typical water and wastewater bills are shown on Tables C-4A, C -4B, ,and C -4C. Since, there was no rate increases warranted for the water utility the combined typical customers will experience a less overall rate increase when compared with the rate increases for the wastewater utility. As shown in Table C-4A for Option A, a residential customer using 10,000 gallons of water and 5,000 gallons of wastewater will experience an overall bill increase of 3.0% or $1.45 per month. The typical commercial customer using 85,000 gallons of water and 50,000 gallons of wastewater will receive an increase of 4.8% or $14.50 per month. Option B is presented in Table C-4B and indicates that a residential customer using 10,000 gallons of water and 5,000 gallons of wastewater per month will see an increase of 2.4% or $1.15. The typical commercial customer using 85,000 gallons of water and 60,000 gallons of wastewater per month will experience an increase of 10.9% or $32.70. As indicated in Table C-4C for Option C a residential customer's bill will increase 2.1% or $1.01 per month. The typical commercial customer using 85,000 gallons of water and 68,000 gallons of wastewater per month will experience an increase of 12.3% or $36.74. 4.3 Comparison of Costs of Service with Revenue Under Proposed Rates A comparison of allocated cost of service with revenues under proposed and existing rates is shown in Tables W -19, S -19A, S -19B, and S -19C. The degree of cost recovery under proposed rates is shown in the next to last column with a 100% ratio representing ideal recovery. The percentage increase or decrease over existing rates shown in the last column indicates the magnitude of revenue adjustment that has been made in the schedule of rates for each customer class. 5.0 Reuse Water Rates 5.1 Reuse Rate Methodology 14 This section details an approach for the City to consider once it has reclaimed or reuse water available to sell. The procedure for establishing rates for reclaimed or reuse water can be similar to the procedure for establishing potable water or wastewater rates, but often must take into account other factors such as marketability conditions and customer's willingness to pay. If the non - potable or reclaimed water is metered, it is appropriate to establish a fixed meter charge that may or may not vary by meter size, and a volume charge based upon the quantity of reclaimed water used. Oftentimes the reclaimed water volume rate is established at a percentage of the utility's potable water rate to create an incentive for using the reclaimed water set at 50 to 100 percent of the cost of potable water. This percentage approach is commonly used and can vary depending upon supply -demand conditions, whether the reuse supply is provided on a "firm" or interruptible basis, whether effluent quality considerations need to be recognized, and other factors. In establishing reuse rates and/or categories of customers for rate- making purposes, other pricing considerations could be recognized to differentiate between charges based on a number of cost related factors. Some of these cost/rate differentiation factors include those for: 1) customers that do or do not provide for on -site storage; 2) customers that require different effluent quality for their application or use; 3) customers that have different delivery or pumping requirements due to ,location; and 4) customers that place different seasonal or peak demands on the reuse system. Based on previous limited reviews of reuse rates established in Florida, Arizona, and California, it was found that these factors were seldom recognized in establishing reuse rates so as to encourage as many customers as possible to use the reclaimed water service and to keep rates as simple as possible. 15 WATER UTILITY I• NO I• • - iii 1 - MI MO MB NM • MI I• - MI i• I• Line No. Customer Class Table W -1 City of Round Rock, Texas Water Utility Historical & Projected Average Number of Customers Fiscal Year Ending September 30 Historical Projected 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Inside City 1 Residential 16,886 18,570 19,336 19,833 20,425 21,042 21,675 22,325 22,992 23,683 24,392 25,125 25,875 26,650 2 Commercial 1,268 1,036 1,062 1,092 1,125 1,158 1,192 1,225 1,258 1,300 1,342 1,383 1,425 1,467 3 Industnal 7 7 7 7 7 8 8 8 8 9 9 9 9 10 4 Apartments 193 199 288 292 300 308 317 325 333 342 350 358 367 375 5 Government 2 2 35 35 35 35 35 35 35 35 35 35 35 35 City 6 - Billed Service 1 1 1 1 1 1 1 1 1 1 1 1 1 1 7 -Free Service 81 89 92 92 92 92 92 92 92 92 92 92 92 92 Bulk Water 8 - Billed Service 65 83 64 64 64 64 64 64 64 64 64 64 64 64 9 -Free Service ' 9 10 14 14 14 14 14 14 14 14 14 14 14 14 10 Total Inside City 18,512 19,997 20,899 21,430 22,063 22,722 23,398 24,089 24,797 25,540 26,299 27,081 27,882 28,708 Outside City 11 Chandler Creek Residential 534 738 1,097 1,108 1,125 1,142 1,158 1,175 1,192 1,192 1,192 1,192 1,192 1,192 12 Chandler Creek Commercial 6 7 6 6 6 6 6 6 6 6 6 6 6 6 13 Outside City No Classification 13 13 16 15 15 15 15 15 15 15 15 15 15 15 14 Total Outside City 553 758 1,119 1,129 1,146 1,163 1,179 1,196 1,213 1,213 1,213 1,213 1,213 1,213 Wholesale 15 Fem Bluff 1 1 1 1 1 1 1 1 1 1 1 1 1 1 16 Brushy Creek 1 1 1 l 1 1 1 1 1 1 1 1 1 1 17 Vista Oaks I 1 1 1 I 1 1 1 1 1 1 I 1 1 18 Williamson Cty MUD 10 0 0 1 I 1 1 1 1 1 1 1 1 1 I 19 Williamson Cty MUD 11 0 0 0 I 1 1 1 1 1 1 1 1 1 1 20 Aqua Source 1 1 1 1 1 1 1 1 1 1 l 1 1 1 21 RR Joint Venture 0 1 1 1 1 1 1 1 1 1 1 1 1 1 22 Manville Water Supply 1 1 1 1 1 1 1 1 1 1 I I 1 1 23 Williamson Cty Park 0 0 0 1 1 1 1 1 1 1 1 1 1 1 .24- Total Wholesale 5 6 7 9 9 9 9 9 9 9 9 9 9 9 25 Total Customers 19,070 20,761 22,025 22,568 23,218 23,894 24,586 25,294 26,019 26,762 27,521 28,303 29,104 29,930 I• • Es - - - - I• so I• me I• we = I= I• I• ow I• me Line No. Customer Class Table W -2 City of Round Rock, Texas Water Utility Historical & Projected Water Sales Volume Fiscal Year Ending September 30 Historical Projected 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal Inside City 1 Residential 2,497,900 2,181,400 2,427,200 2,380,000 2,451,000 2,525,000 2,601,000 2,679,000 2,759,000 2,842,000 2,927,000 3,015,000 3,105,000 3,198,000 2 Commercial 1,047,900 1,034,600 1,127,200 1,113,500 1,147,500 1,181,500 1,215,500 1,249,500 1,283,500 1,326,000 1,368,500 1,411,000 1,453,500 1,496,000 3 Industrial 19,200 16,100 14,800 15,700 16,300 16,800 17,400 17,900 18,500 19,000 19,600 20,100 20,700 21,200 4 Apartments 235,700 220,600 329,300 329,000 338,400 347,800 357,200 366,600 376,000 385,400 394,800 404,200 413,600 423,000 5 Government 2,000 1,000 57,700 57,400 57,400 57,400 57,400 57,400 57,400 57,400 57,400 57,400 57,400 57,400 City 6 - Billed Service 5,000 3,400 4,200 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 3,800 7 -Free Service 133,400 93,400 110,400 102,300 102,300 102,300 102,300 102,300 102,300 102,300 102,300 102,300 102,300 102,300 Bulk Water 8 - Billed Service 82,000 64,700 42,300 45,300 45,300 45,300 45,300 45,300 45,300 45,300 45,300 45,300 45,300 45,300 9 -Free Service 1,000 3,100 3,700 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 10 Total Inside City 4,024,100 3,618,300 4,116,800 4,051,000 4,166,000 4,283,900 4,403,900 4,525,800 4,649,800 4,785,200 4,922,700 5,063,100 5,205,600 5,351,000 Outside City 11 Chandler Creek Residential 56,900 62,900 110,200 103,100 104,600 106,200 107,700 109,300 110,800 110,800 110,800 110,800 110,800 110,800 12 Chandler Creek Commercial 4,600 7,500 12,100 9,100 9,200 9,400 9,500 9,600 9,800 9,800 9,800 9,800 9,800 9,800 13 Outside City No Classification 17,500 15,200 17,900 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 18,000 14 Total Outside City 79,000 85,600 140,200 130,200 131,800 133,600 135,200 136,900 138,600 138,600 138,600 138,600 138,600 138,600 Wholesale 15 Fem Bluff 241,500 262,000 281,400 289,500 298,500 307,400 316,400 325,400 335,600 345,900 356,100 366,400 377,900 389,400 16 Brushy Creek 635,400 667,100 651,600 671,200 691,300 712,100 183,400 0 0 0 ' 0 0 0 0 17 Vista Oaks 120,000 105,900 138,700 143,400 147,500 151,500 155,600 159,700 165,100 170,500 175,900 181,300 186,700 192,100 18 Williamson Cty MUD 10 0 0 29,900 30,800 31,700 32,700 33,600 34,700 35,700 36,800 37,900 39,000 40,200 41,400 19 Williamson Cty MUD 1I 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20 Aqua Source 62,900 45,500 49,500 51,000 52,600 54,100 55,800 57,400 59,200 60,900 62,800 64,600 66,600 68,600 21 RR Joint Venture 0 3,700 10,300 10,600 10,900 11,200 11,600 11,900 12,300 12,600 13,000 13,400 13,800 14,200 22 Manville Water Supply 16,300 10,000 18,500 19,100 19,600 20,200 20,800 21,500 22,100 22,800 23,500 24,200 24,900 25,600 .23 Williamson Cty Park 0 0 0 46,000 47,400 48,800 50,300 51,800 53,300 54,900 56,600 58,300 60,000 61,800 ''24 Total Wholesale 1,076,100 1,094,200 1,179,900 1,261,600 1,299,500 1,338,000 827,500 662,400 683,300 704,400 725,800 747,200 770,100 793,100 25 Total Water Volume 5,179,200 4,798,100 5,436,900 5,442,800 5,597,300 5,755,500 5,366,600 5,325,100 5,471,700 5,628,200 5,787,100 5,948,900 6,114,300 6,282,700 NM 'N - - • MO • NM NM MI MI I - - - MI MN N MI Line No. Customer Class Inside City 1 Residential 2 Commercial 3 Industrial 4 Apartments 5 Government City 6 - Billed Service - SA 7 - Free Service Bulk Water 8 - Billed Service 9 - Free Service 10 Total Inside City Outside City 11 Chandler Crcek Residential 12 Chandler Creek Commercial 13 Outside City No Classification 14 Total Outside City Wholesale 15 Fem Bluff 16 Brushy Creek 17 Vista Oaks 18 Williamson CV MUD 10 19 Williamson Cty MUD 11 20 Aqua Source 21 RR Joint Venture 22 Manville Water Supply 23 Williamson Cry Park 24 Total Wholesale 25 Subtotal Total Water Revenue 26 Less. Free City Service Historical 2002 2003 7,368,900 2,740,100 35,900 892,500 157,900 363,200 30,100 93,500 114,600 23,200 35,000 0 0 116,500 23,600 36,100 0 90,800 Table W-3 City of Round Rock, Texas Water Utility Historical & Projected Water Revenue by Class 7,349,100 2,730,400 37,900 895,700 157,100 351,200 24,500 93,700 2004 7,568,300 2,813,700 39,200 921,200 157,100 9,000 8,200 8,200 8,200 8,200 223,700 208,200 208,200 208,200 208,200 356,400 24,800 93,700 0 118,500 24,000 37,200 93,400 2005 7,796,800 2,897,200 40,600 946,900 157,100 361,800 25,200 93,700 0 120,600 24,400 38,300 96,100 2006 8,031,500 2,980,500 41,900 972,500 157,100 367,100 25,500 93,700 122,700 24,900 39,500 98,900 Fiscal Year Ending September 30 2007 8,272,300 3,063,800 43,100 998,000 157,100 8,200 8,200 8,200 8,200 8,200 8,200 8 ,200 208,200 208,200 208,200 208,200 208,200 208,200 208,200 85,100 90,800 90,800 90,800 90,800 90,800 90,800 90,800 90,800 90,800 90,800 90,800 8,100 8,700 8,700 8,700 8,700 8,700 8,700 8,700 8,700 8,700 8,700 8,700 11,521,200 11,486,100 11,815,400 12,154,500 12,499,400 12,850,200 13,207,900 13,595,100 13,988,700 14,391,600 14,800,700 15,218,900 372,300 26,000 93,700 725,500 746,300 769,500 792,600 815,800 838,900 865,300 891,700 918,100 944,500 974,300 1,004,000 1,021,400 1,039,600 1,058,300 1,077,600 274,400 0 0 0 0• 0 0 0 352,100 363,900 374,300 384,500 394,800 405,100 418,800 432,600 446,400 460,100 473,800 487,500 70,600 72,700 74,800 77,100 79,400 81,800 84,200 86,800 89,300 92,000 94,800 97,700 Projected 486,800 469,400 474,900 480,700 486,300 492,000 497,600 497,600 497,600 497,600 497,600 497,600 124,900 25,300 40,700 101,800 2008 5 8,519,400 3,147,300 44,500 1,023,700 157,100 377,600 26,300 93,700 0 0 127,100 25,800 41,900 104,700 2009 8,775,600 3,251,500 45,800 1,049,200 157,100 377,600 26,300 93,700 0 129,400 26,200 43,200 107,800 2010 2011 9,038,100 3,355,600 47,200 1,074,800 157,100 377,600 26,300 93,700 0 131,800 26,700 44,500 110,900 9,309,900 3,459,900 48,400 1,100,400 157,100 377,600 26,300 93,700 0 134,200 27,200 45,800 114,200 2012 $ 9,587,800 3,564,100 49,800 1,126,000 157,100 377,600 26,300 93,700 0 136,700 27,700 47,200 117,500 2013 $ 9,874,900 3,668,400 51,100 1,151,500 157,100 377,600 26,300 93,700 0 139,300 28,200 48,600 121,000 2,342,400 2,489,500 2,550,000 2,611,200 1,850,400 1,618,500 1,667,800 1,717,700 1,767,700 1,818,000 1,872,000 1,926,300 14,350,400 14,445,000 14,840,300 15,246,400 14,836,100 14,960,700 15,373,300 15,810,400 16,254,000 16,707,200 17,170,300 17,642,800 231,800 216,900 216,900 216,900 216,900 216,900 216,900 216,900 216,900 216,900 216,900 216,900 27 Total Water Revenue 14,118,600 14,228,100 14,623,400 15,029,500 14,619,200 14,743,800 15,156,400 15,593,500 16,037,100 16,490,300 16,953,400 17,425,900 NEI '- ill■ - Nim - - - - - - - - - - Line No. Account Description Water Treatment Plant I Reserve Water 1,680,900 1,610,000 1,762,500 1,933,500 2,125,600 2,233,600 2,347,200 2,466,100 2,592,600 2,725,000 2,864,400 3,011,200 2 Raw Water 231,800 263,000 302,500 347,900 400,100 420,100 441,100 463,200 486,400 510,700 536,200 563,000 3 O&M Lake Stillhouse 300,000 125,000 128,800 132,700 136,700 140,800 145,000 149,400 153,900 158,500 163,300 168,200 4 Power &Light 1,675,000 1,450,000 1,535,900 1,626,900 1,723,300 1,825,400 1,933,500 2,048,000 2,169,300 2,297,800 2,433,900 2,578,100 5 Chemicals 180,000 210,000 222,500 235,600 249,600 264,400 280,000 296,600 314,200 332,900 352,600 373,500 6 All Other 1,396,400 1,195,800 1,231,800 1,268,700 .1,306,700 1,345,900 1,386,300 1,427,900 1,470,700 1,514,800 1,560,200 1,607,000 7 Total Water Treatment Plant 5,464,100 4,853,800 5,184,000 5,545,3,00 5,942,000 6,230,200 6,533,100 6,851,800 7,187,100 7,539,700 7,910,600 8,301,000 Water Systems Support 8 Power & Light' 256,000 200,000 211,800 224,300 237,630 251,700 266,600 282,400 299,100 316,800 335,600 355,500 9 R&M Meters 140,000 63,700 65,600 67,600 69,600 71,700 73,900 76,100 78,400 80,700 83,100 85,600 10 1R&M Wells & Boosters 205,000 210,000 216,300 222,800 229,500 236,400 243,500 250,800 258,300 266,000 274,000 ' 282,200 11 All Other 1,140,100 861,500 887,300 913,900 941,300 969,500 998,700 1,028,700 1,059,600 1,091,400 1,124,100 1,157,700 12 Total Water Systems Support 1,741,100 1,335,200 1,381,000 1,428,600 1,478,000 1,529 ,300 1,582,700 1,638,000 1,695,400 1,754,900 1,816,800 1,881,000 Water Lines Maintenance 13 R&M Lines 248,900 242,700 250,000 257,500 265,200 273,200 281,400 289,800 298,500 307,500 316,700 326,200 14 All Other 1,913,800 1,784,100 1,837,700 1,892,800 1,949,700 2,008,200 2,068,400 2,130,400 2,194,400 2,260,200 2,328,000 2,397,800 15 Total Water Lines Maintenance 2,162,700 2,026,800 2,087,700 2,150,300 2,214,900 2,281,400 2,349,800 2,420,200 2,492,900 2,567,700 2,644,700 2,724,000 16 Environmental Services 17 Utility Billings & Collections Table W-4 City of Round Rock, Texas Water Utility Budgeted and.Projected Operating & Maintenance Expenses Budget Budget Protected 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 $ s s $ $ $ $ $ s $ $ $ 197,200 179,800 185,200 190,700 196,400 202,400 208,500 214,700 221,190 227,700 234,500 241,500 456,100 426,600 439,400 452,600 466,200 480,200 494,700 509,500 524,800 540,600 556,700 573,400 Transfers Department 18 Contractual Obligations -BRA 671,400 728,300 750,200 772,700 795,900 819,800 844,400 869,700 895,800 922,700 950,400 978,900 19 All Other 0 82,500 85,000 87,600 90,200 92,900 95,700 98,600 101,500 104,600 107,700 111,000 20 Total Transfers Department 671,400 810,800 835,200 860,300 886,100 912,700 940,100 968,300 997,300 1,027,300 1,058,100 1,089900 - 21 Utilities Administration 0 888,600 915,200 942,600 970,800 999,900 1,029,800 1,060,700 1,092,500 1,125,200 1,158,900 1,193,600 22 Total O &M Expense 10,692,600 10,521,600 11,027,700 11,570,400 12,154,400 12,636,100 13,138,700 13,663,200 14,211,100 14,783,100 15,380,300 16,004,400 me •N - - - -- l EN am me No NE = um NE a Table W -5 City of Round Rock, Texas Water Utility Proposed Major Capital Improvements Program Line Fiscal Year Endmg September 30 No. Project 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Total Water Capital Projects 1 48" East Water Transmission Line (Phase I) 2 2003 2 7 MG Barton Hall Elevated Tank 3 36' East Water Transmission Lme (Phase II) 4 Tank Rehabs 5 30' Raw Water Lmes Modification 6 Establish Primary Meter & Purchase Extstmg Electric Fac 7 Acquire Electric Service for the WTP from Georgetown 9 Deerfootllrtve 8" Waterline 10' 2003 Water Distribution System Master Plan Update 11 Ground Water (Phase 1) Treatment at Lake Creek 12 PRY Installation Program 13 GPSIGIS Monumentation Survey (Phase Ill ) 14 16' Forest Creek Water Line 15 16" A.W. Grimes Water Line (03 -04) 18 Raw Water Pump Station Upgrade 21 12' Creek Bend Water Line 24 2003 Water Distribution System Master Plan Update 25 Water Dntdbueon System Model Upgrade 26 36' East Water Transmission line (Phase III) 27 Ground Water (Phase H) Treatment at Lake Creek 28 20152 MG Barton Hill El rated Tank 29 1 25 MG Sam Bass Elevated Tank & Water Line 31 20 MGD WTP Engineering & Expansion Phase V 32 Water System Improvements 1999 33 Maio Well Site Improvements - Contract 05 34 Phase [V & Engineering 35 Upgrade Water System Model 36 Green larva Bore/ Waterline 37 South Creek Pressure Relieve Valve Project 38 High Country PRV 42 12' Waterline Hotel Center to La Quiota 45 Utility Bdling Computer System Upgrade 47 Develop Stormwater Management Plan 48 Utility Billing Once Remodel 49 Fern Bluff Tank CORR portion for Rehab 50 Hams, Brwn, Main & San Saba Waterline (City Hall) 51 WTP Land Purchase (18 +/ -acres) 52 West Round Rock Line, Tank & Standpipe 53 Xfr Ops - Software Update 54 Xfr from Ops Ol-02 ,, 55 Areas D-K Projects 56 H W Y 29 Water Line Relocation 63 Total Water Projects S S 2,681,800 0 1 ,349,30 1,655,00 0 1,728,80 2,407,20 0 1,070,60 599,70 450,000 250,000 204,00 0 54,00 54,00 0 233,70 233,70 0 65,70 0 100,00 80,00 0 500,00 5,500,00 2,000,000 500,00 500,00 250,000 500, 115,00 0 80,00 0 150,00 150,00 0 10000 2,400,000 210,000 210,00 8,848,10 259,20 241,60 13,700 26,600 2,900 53,500 9,200 149,000 80,00 32,70 4,60 50,00 70,00 6,10 362,50 260,00 4,805,500 2,495,84 1,700,00 1,000,00 678,00 3,600,00 500,00 250,0 25,000 25,000 25,000 500,00 1,333,30 3,000,00 1,333,30 600,00 1,000,0 1,500,000 1,500,00 100,000 3,000,000 2,500,000 1,333,30 2,681,800 3,004 ,300 4,136,000 2,470,300 204,000 108,000 467,400 65,700 180,000 8,000,000 2,500,000 115,000 80,000 300,000 2,500,000 420,000 25,000 50,000 9,000,000 3,999,900 1,000,000 3,600,000 13,653,600 259,200 241,600 13,700 26,600 2,900 53,500 9,200 149,000 80,000 32,700 4,600 50,000 70,000 1,000,000 3,600,000 6,100 362,500 2,495,800 2,638,000 19,302,640 20,280,900 6,988,000 4,560,000 500,000 300,000 25,000 1,833,300 4,933,300 5,833,300 5,100,000 69,656,400 Reclaimed Water Projects 64 Reclaimed Water- Old Settlers - Outside Lines -LCRA 1,297,200 0 0 0 0 0 0 0 1,297,200 65 Total Projects 20,599,800 20,280,900 6,988,000 4,560,000 500,000 300,000 25,000 1,833,300 4,933,300 5,833,300 5,100,000 70,953,600 N. • I= NE Gm a Ea me No EN - i• - EN ow um N. mu N. Table W -6 City of Round Rock, Texas Water Utility Capital Improvement Program Financing Plan Line Fiscal Year Ending September 30 No. Description 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Source of Funds: 1 Beginning of Year Balance 20,533,300 2,867,500 16,600 41,300' 10,400 2,939,900 6,130,600 9,613,000 11,339,200 9,868,000 7,407,500 2 Revenue Bond Proceeds 0 13,900,000 3,500,000 850,000 0 0 0 0 0 0 0 3 Transfer from Operating Fund 0 1,150,000 900,000 1,000,000 700,000 700,000 650,000 650,000 550,000 500,000 350,000 4 Impact Fees 2,700,000 2,700,000 2,700,000 2,700,000 2,, 0,O00 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 5 Interest Income 234,000 166,500 35,200 8,900 29,500 90,700 157,400 209,500 212,100 172,800 128,900 6 Total Funds Available 23,467,300 20,784,000 7,151,800 4,600,200 3,439,900 6,430,600 9,638,000 13,172,500 14,801,300 13,240,800 10,586,400 Application of Funds: 7 Major Capital Improvements 20,599,800 20,280,900 6,988,000 4,560,000 500,000 300,000 25,000 1,833,300 4,933,300 5,833,300 5,100,000 8 Surety Bonds 0 139,000 35,000 8,500 0 0 0 0. 0 0 0 9 Bond Issuance Costs 0 347,500 87,500 21,300 0 0 0 0 0 0 0 10 Total Funds Applied 20,599,800 20,767,400 7,110,500 4,589,800 500,000 300,000 25,000 1,833,300 4,933,300 5,833,300 5,100,000 11 End of Year Fund Balance 2,867,500 16,600 41,300 10,400 2,939,900 6,130,600 9,613,000 11,339,200 9,868,000 7,407,500 5,486,400 EN — ow Ili lilies illy Illy — we lam Illy am 111th — Table W -7 City of Round Rock, Texas Water Utility Existing and Proposed Debt Service Line Fiscal Year Ending September 30 No. Description 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 $ $ $ 5 Revenue Bonds: 1 Existing Revenue Bonds 1,085,000 1,027,600 825,600 174,600 0 0 0 0 0 0 0 2 Series 2003 0 0 0 0 0 0 0 0 0 0 0 3 Series2004 1,130,900 1,130,900 1,130,900 1,130,900 1,130,900 1,130,900 1,130,900 1,130,900 1,130,900 1,130,900 4 Series 2005 284,800 284,800 284,800 284,800 284,800 284,800 284,800 284,800 284,800 5 Series 2006 69,200 69,200 69,200 69,200 69,200 69,200 69,200 69,200 6 Series 2007 0 0 0 0 0 0 0 7 Series 2008 0 0 0 0 0 0 8 Series 2009 0 0 0 0 0 9 Series 2010 0 0 0 0 10 Series 2011 0 0 0 11 Series 2012 0 0 12 Series 2013 0 13 Subtotal Proposed Revenue Bonds 0 1,130,900 1,415,700 1,484,900 1,484,900 1,484,900 1,484,900 1,484,900 1,484,900 1,484,900 1,484,900 14 Existing General Obligation Bonds 114,200 188,000 201,300 64,100 66,900 64,000 46,400 25,600 0 0 0 15 Total Water Utility Debt Service 1,199,200 , 2,346,500 2,442,600 1,723,600 1,551,800 1,548,900 1,531,300 1,510,500 1,484,900 1,484,900 1,484,900 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Line No. Desmpnon 1 Existing Water Sales Revenue Additional Water Ravenna Required Revenue Months Year Litman Effective 2 2003 0 0%. 9 3 2004 00% 9 4 2005 2.5%v 9 5 2006 2.503 9 6 2007 0003 9 7 2008 0 003 9 8 2009 00% 9 9 2010 0003 9 10 2011 0.0% 9 11 2012 0003 9 12 2013 0 003 9 13 Tad Additional Water Sales Revenue 14 Tad Weser Sales Revenue 15 Other Operating Revenue 16 Iperest Income 17 Tad Revenue 18 Operation end Mainteanca Expense Table W -8 City of Round Rock, Texas Water Utility Comparison of Projected Revenue and Revenue Requirements Under Increased Revenue 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 8 S S 8 3 S 8 5 S 3 S 14,228,100 14,623,400 15,029,500 14,619,200 14,743,800 15,156,400 15,593,380 16,037,100 16,490,300 16,953,400 17,425,900 0 ]81,800 Food Year Ending September 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 365,500 368,600 378,900 389,800 400,900 412,300 423,800 435,600 281,000 377,800 388,400 399,600 411,000 422,600 434,400 446,500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 281,800 646,500 746,400 767,300 789,400 811,900 834,900 858 ,200 882,100 14,228,100 14,623,400 15,311,300 13,263,700 15,490 ,200 15,923,700 16,382,900 16,849,000 17,325,200 17,811,600 18,308,000 267,400 301,900 301,900 301,900 301,900 301,900 301,900 301,900 301,900 301,900 301,900 44 ,200 56,100 53,700 54,800 57,200 60,300 63,000 65,600 68,300 71,100 73,900 14,539,700 14 ,981,400 15,666,900 15,622,400 15,849,300 16,285,900 16,747,800 17 ,216,500 17,695,400 18,184,600 18,683,800 10,692,600 10,521,600 11,027,700 11,570,400 12,154,400 12,636,100 13,138,700 13,663,200 14.211,100 14,783,100 15,380,303 Debt Serum, Revenue Bands 19 Existing Revenue Bends 1,085,000 1,027,600 825,600 174,600 0 0 0 0 0 0 20 Proposed Revenue Bottle 0 1,130,900 .1,415,600 1,484,800 1,484,800 1,484,800 1,484,800 1,484,800 1,484,800 1,484,800 1,484,800 21 Taw Revenue Bonds 1,085,000 2,158,500 2,241 ,200 1,659,400 1,484,800 1,484,800 1,484,800 1,484,800 1,484,800 1,484,800 1,484,800 General Obligation 22 Existing General Obl,gwon Bands 114,200 188,000 201,300 64,100 66,900 64,000 46,400 25,600 0 0 0 23 Routine Capital Outlay 212,700 162,400 167,300 172,300 177,600 183,000 188,500 194,200 200,100 206,100 212,300 Transfers 24 Transfer to Construction Fund 0 1,150,000 900,000 1,000,000 700,000 700,000 650,000 650,000 550,000 500,000 350,030 25 Transfer to General Fund 928,500 1,087,600 1,087,600 1,087,600 1,087,600 1,087,600 1,087,600 1,087,600 1,087,600 1,087,600 1,087,600 26 Total Tmmfen 928,500 2,237,600 1,087,600 2,087,600 1,787,600 1,787,600 1,737,600 1,737,600 1,637,600 1,587,600 1,437,600 27 Total Revenue Bequuemens 13,033,000 15,268,100 15,625,100 15,553,800 15,671200 16,155,500 16,596,000 17,105,400 17,533,600 18,061,600 18.515,000 28 Net Annual Balance • 1,506,700 (286,700) 41,800 68,600 178,000 130,400 151,800 111,100 161,800 123,000 168,800 29 Beginning of Year Balance 1,500,000 3,006,700 2,720,000 2,761,800 2,830,400 3,008,400 3,138,800 3,290,600 3,401,700 3,563,500 3,686,500 30 End of Year Balance 3,006,700 2,720,000 2,761,800 2,830,400 3,000,400 3,138,800 3 ,290,600 3,401,700 3,563,500 3,686,500 3,853,300 31 , Tugeted End of Year Balance 2,673,200 2,630,400 2,756,900 2,892,600 3,038,600 3,159,000 3 ,284,700 3,415,800 3,552,800 3,695,800 3,845,100 Coverage' 32 Net Revenue (a) 3,847,100 4,459,800 4,639,200 4,052,000 3,694,900 3,649,800 3,609,100 3,553,300 3,484,300 3,401,500 3,303,500 33 Revenue Bond Debt Service Coverage (b) 3546% 2066% 207.0'6 244254 2488% 2458% 2431% 239354 234.7% 229 I% 222.3%+ 34 Tow Bond Debt Service Covenge(e) 3208% 1901%, 1899% 2351% 2381% 2357% 2357% 2353% 2347% 2291% 222.5 %. 35 Days of°pwuns Reserve 103 94 91 89 90 91 91 91 92 91 91 (a) Total Revenue (Line 17) Leas Operation and Maintenance Expense (Lino 18) (b) RepreSenb coverage of total 'annual' revenue debt wince (Line 32/ Lute 21) (e) Represents coverage of tow •annual' debt service (Line 321/(Line 21aLine 22)) Table W -9 City of Round Rock, Texas Water Utility Cost of Service 2004 Test Year ( ( ( Line Operating ' Capital No. Description Expense Costs Total $ $ $ Revenue Requirements 1 Operating Expense 10,521,600 10,521,600 2 Revenue Bond Debt Service 1,085,000 1,085,000 3 General Bond Debt Service 188,000 188,000 4 Routine Capital Outlay 162,400 162,400 5 Transfer to General Fund 1,087,600 1,087,600 6 Transfer to Capital Fund 1,150,000 1,150,000 7 Total 11,609,200 2,585,400 14,194,600 Revenue Requirements Met from Other Sources 8 Other Operating Revenue 9 Interest Income 10 Use of Available Funds (a) 11 Partial Year Increase Adjustment (b) 12 Total 13 Net Costs to be met from Water Charges 301,900 0 301,900 45,900 10,200 56,100 234,500 52,200 286,700 (878,000) (195,500) (1,073,500) (295,700) (133,100) (428,800) 11,904,900 2,718,500 14,623,400 (a) A positive value reflects drawdown of funds available at beginning of year; a negative value reflects addition to end of year fund balance. (b) Adjustment for less than full year revenue increase. MI 'MN r - r - NM MI = N r MS r N NM OM r = r Line No. Description Table W -10 City of Round Rock, Texas Water Utility Allocation of Net Plant Investment rnd Capital Costs To Functional Cost Components 2004 Test Year ( ( ( ( ( ( (7) ( ( (10) Common to All Retail Only Extra Capacity Extra Capacity Net Plant Maximum Maximum Customer Maximum Maximum Fire Investment Base Day Hour Billing Base Day Hour Meters Protecuen $ $ $ $ $ $ $ 5 $ $ I Source of Supply 4,733,400 4,733,400 2 Productimareatment 26,415,200 12,811,400 13,603,800 3 Other General Treatment 3,623,600 1,757,400 1,866,200 4 Pump Stations 3,763,900 1,219,500 1,291,000 1,253,400 5 Transmission Mains 14,175,100 6,874,900 7,300,200 6 Distribution Mains 16,369,700 5,303,800 5,614,800 5,451,100 7 Other General Mains 873,000 163,300 173,300 173,800 184,000 178,600 8 Storage 1,304,600 422,700 447,500 434,400 9 Subtotal 71,258,500 27,982,600 24,682,000 1,687,800 5,477,600 5,798,800 5,629,700 10 Meters 87,000 87,000 11 Fire Hydrant/Meter 96,600 96,600 12 Subtotal 183,600 87,000 96,600 13 Other General Plant 319,900 125,300 110,500 7,600 0 24,500 26,000 25,200 400 400 14 Environmental Services 35,200 13,800 12,200 800 0 2,700 2,900 2,800 0 0 15 Water Billing Bldg./Equip. 70,300 70,300 16 Water Reuse 353,900 353,900 17 Total Plant 72,221,400 28,121,700 24,804,700 1,696,200 70,300 5,858,700 5,827,700 5,657,700 87,400 97,000 18 Less: Contributed Plant 15,078,300 3,008,300 3,194,300 2,875,700 3,044,400 2,955,600 19 Net Plant Investment 57,143,100 25,113,400 21,610,400 1,696,200 70,300 2,983,000 2383,300 2,702,100 87,400 97,000 • 20 Percent of Total 100 00% 43 95% 37.82°% 2.97% 0 12% 5.22% 4 87% 4.73% 0.15% 0.17% 21 2004 Test Year Capital Costs 2,718,500 1,194,800 1,028,100 80,700 3,300 141,900 132,400 128,500 4,200 4,600 MO •• - I - - - • - - • MI • OM MN MO MO = • No. Desmptmn Water Treatment Plant 1 Reserve Water 1,610,000 1,610,000 2 Saw Water 263,000 263,000 3 0001 Lake S6 2 ouse 125,000 125.000 4 Power &Lght 1,450,000 1305,000 145,000 3 (Samurais 210,000 210,000 6 MMee 1,195,800 580,000 615,800 7 Subtotal Water Trestmn Mee 4,553,800 4,093,000 760,800 Weter Systems Support 8 Power &Lght 200,000 97,000 103,000 9 R&M Meters 63,700 20 Buboes Admeus0a0on 21 Total O &M Expense (a) Poston value reflects dmwdowt0lOdr sNnble at begmng of 0a0 a negoom value reflects dthtm m and ay= fiend 6.18580. (b) Adjustment far less Nan full year seven rcreue. Table W -11 City of Round Rock, Texas Water Utility Allocation of Operation and Maintenance Expense to Functional Cost Components 2004 Test Year (1) (2) (2) ( (3) (6) (7) (8) (9) (10) Common to AB RBA 0 Exn C494ti15 Extra Capso,N Maximum Maxima= Customer Mourn= Movmum Fun Total Base Day Hour Balms Base Day Hour Men Protection S 5 63,760 10 R&M Wefls &Boosters 210,000 96,800 102,700 10,300 11 AB Other 861,500 352,503 374,100 0 0 0 0 0 115,800 19,100 12 Subtotal W..Synems Sgpon 1335.200 546,303 579,800 0 0 0 0 179,500 29,600 Water hoes Mtuna0enee 11 681.1 Line 242,700 43,100 45,800 0 45,900 48,600 47,300 14 All Other 1,784,100 316,800 316,700 Subtotal Water Lies MabMwee 2,026,800 359,900 382,500 0 383,300 405,900 394,200 0 101,000 15 Enykortraental Serum 179,800 109,400 37,700 0 8,400 8,500 8,600 3,900 2,900 16 Ut ty&limgs&Collec6ms 426,600 426,600 0 12,100 0 337,400 357,300 347,000 0 88,900 Tr4Bas 0 17 110 er lOhbgataos -BRA 728,300 728300 18 All Other 82,500 50,200 17,300 0 0 3,900 4,100 3,900 1,800 1,300 19 Subtotal Tr841( Dept 810,800 778,500 17,300 0 0 3,900 4,100 3.900 1,800 1,3 888,600 540,700 186,100 o 41,500 44,000 42,500 19,100 14,300 10,521,600 6,437,800 1,964,400 0 426,600 437,100 462,900 449,200 204,500 149,100 22 Add Transfer to General Fund 1,087,600 664,500 203,100 0 44,100 45,200 47,800 46,400 21,100 15,400 Less Other Opasmg Revenue 23 Waal bonne 45,900 27,500 8,600 0 1,900 1,900 2,000 2,000 900 700 24 All Other Income 301,900 77,500 82,100 79,600 36,300 26,400 25 (barmy) Decrease m Fiala Avdd le at Year Fad 234,500 143,300 43,800 0 9,500 9,700 10.303 10,000 4,600 3,300 26 PuhaPfeet (nueue) Deer.... 0 0..• Revenue (a) (878,000) (536,400) (163,900) 0 (35,600) (363 08,600) (37,500) (17,100) (12,400) 27 Subtotal Other Operates Revenue (295,700) (365,200) (111,500) 0 (24390) 52,600 55,800 54,100 34,700 18,000 28 Net 0pnhn4 Expense 11,904,900 7,437,500 2,279,000 0 494,900 429,700 454,900 441,500 200,900 146,500 Customer Class Fire Protection Total Units Mgal -1,000 gallons Mgd -1,000 gallons per day (a) Extra capacity in excess of average day usage. (b) Extra capacity in excess of maximum day demand. (c) Includes Inside City, Chandler Creek, and Fire Protection Units Table W -12 City of Round Rock, Texas Water Utility Units of Service 2004 Test Year ( ( ( ( ( ( ( ( ( ( Water Usage , Maximum Day Maximum Hour Equivalent Average Capacity Total Extra Capacity Total Extra Meters & Annual Day Factor Capacity Capacity(a) Factor Capacity Copacuty(b) Services Bills Mgal Mgd % Mgd Mgd % Mgd Mgd Inaldc City Residential 2,451,000 6,715 250 16,788 10,073 375 25,181 8,393 246,310 245,100 Commercial 1,147,500 3,144 200 6,288 3,144 300 9,432 3,144 . 30,851 13,500 Industrial 16,290 45 190 86 41 285 128 42 460 89 Apartments 338,400 927 200 1,854 927 300 2,781 927 10,632 3,600 Government 57,410 157 200 314 157 300 471 157 2,832 416 City 106,120 291 200 582 291 300 873 291 1,135 1,112 Bulk Water 49,280 135 200 270 135 300 405 135 935 935 Total 4,166,000 11,414 26,182 - r 14,768 39,271 13,089 - 293,155 - 264,752 Outside City Chondkr Creek Residential 104,630 287 250 718 431 375 1,076 358 13,505 13,500 Chandler Creek Commercial 9,230 25 200 50 25 300 75 25 378 71 Outside City No Classilicatioa 17,950 49 225 110 61 340 167 57 466 185 Total 131,810 361 878 517 1,318 440 - 14,349 - 13,756 Wholesale Fern Bluff 298,470 818 225 1,841 1,023 340 2,781 940 Brushy Creek 691,310 1,894 275 5,209 3,315 415 7,860 2,651 Vista Oaks 147,480 404 300 1,212 808 450 1,818 606 Williamson Cty MUD 10 31,710 87 250 218 131 375 326 108 Williamson Cry MUD 11 0 0 250 0 0 375 0 0 Aqua Source 52,560 144 315 454 310 475 684 230 RR Joint Venture 10,880 30 200 60 30 300 90 30 Manville Water Supply 19,640 54 310 167 113 465 251 84 Williamson Cty Park 47,380 130 250 325 195 375 488 163 Total 1,299,430 3,561 9,486 5,925 14,298 4,812 1,700 1,700 5,000 3,300 12 103 12 44 0 12 12 12 12 219 5,597,240 15,336 36,546 21,210 54,887 18,341 307,504 278,727 Total Retail Only Units(c) 4,279,860 11,726 28,650 16,924 45,422 16,772 307,038 278,323 Total Outside City Retail Units 17,950 49 110 61 167 57 466 185 Total Wholesale Units 1,299,430 3,561 9,486 5,925 14,298 4,812 0 219 - '- NE we - we um we N- m m Description Number of Units Retail Only Units Outside City Retail Units (a) Wholesale Only Units Unit Description Total System Cost of Service O & M Expense Total Cost - $ Unit Cost - $ /unit Capital Costs Revenue Bond Debt Service Other Capital Costs Total Cost - $ Unit Cost - $ /unit Total Total Cost - $ Unit Cost - $ /unit Mgal - 1,000 gallons Mgd - 1,000 gallons per day Total Table W -13 City of Round Rock, Texas Water Utility Unit Costs of Service 2004 Test Year (a) Units of Service have been increased to reflect Round Rock's policy of maintaining a 2 times differential between Inside City and Outside City retail rates. ( ( ( ( ( ( ( ( ( Common to All Retail Only Extra Capacity Extra Capacity Maximum Maximum Customer Maximum Maximum Meters & Fire Base Day Hour Billing Base Day Hour Services Protection 4,279,860 16,924 16,772 278,323 4,279,860 16,924 16,772 307,038 2,251 35,900 122 114' 370 35,900 122 114 932 1,299,430 5,925 4,812 219 Mgal Mgd Mgd Bills Mgal Mgd Mgd Equiv. Hydrants Meters 11,904,900 7,457,500 2,279,000 11,904,900 7,457,500 2,279,000 1.3281 99.2120 1,084,800 476,800 410,300 32,200 1,300 56,600 52,800 51,300 1,700 1,800 1,633,700 718,000 617,800 48,500 2,000 85,300 79,600 77,200 2,500 2,800 2,718,500 1,194,800 1,028,100 02128 44.7564 14,623,400 8,652,300 3,307,100 1.5409 143.9685 0 494,900 429,700 454,900 441,500 200,900 146,500 0 494,900 429,700 454,900 441,500 200,900 146,500 0.0000 1.7744 0.0996 26.6866 26.1459 0.6523 65.0822 80,700 3,300 141,900 132,400 128,500 4,200 4,600 3.7192 0.0118 0.0329 7.7672 7.6099 0.0136 2.0435 80,700 498,200 571,600 587,300 570,000 205,100 151,100 3.7192 1.7862 0.1324 34.4538 33.7558 0.6660 67.1257 Table W -14 1 1 Extra Capacity Extra Capacity Maximum Maximum Customer Maximum Maximum Meters & Fire Description Total Base Day Hour BiRing Base Day Hour Services Protection 1 Unit Cost of Service - $ /tmtt 1.5409 143.9685 3.7192 1.7862 0.1324 34.4538 33.7558 0.6660 67.1257 1 1 1 1 1 1 1 1 1 1 1 1 1 City of Round Rock, Texas Water Utility Allocation of Cost of Service to Customer Classes 2004 Test Year ( ( ( (4) ( ( ( ( ( Common to All Retail Only Inside City Residential Units of Service 2,451,000 10,073 8,393 245,100 2,451,000 10,073 8,393 246,310 Allocated Cost - $ 6,814,800 3,776,600 1,450,200 31,200 437,800 324,600 347,100 283,300 164,000 Commercial Units of Service 1,147,500 3,144 3,144 13,500 1,147,500 3,144 3,144 30,851 Allocated'Cost -$ 2,643,500 1,768,200 452,600 11,700 24,100 152,000 108,300 106,100 20,500 Industrial Units of Service 16,290 41 42 89 16,290 41 42 460 Allocated Cost - $ 36,700 25,100 5,900 200 200 2,200 1,400 1,400 300 Apartments Units of Service 338,400 927 927 3,600 . 338,400 927 927 10,632 Allocated Cost - 5 779,800 521,400 133,500 3,400 6,400 44,800 31,900 31,300 7,100 Governmental Units of Service 57,410 157 157 416 57,410 157 157 2,832 Allocated Cost- $ 132,600 88,500 22,600 600 700 7,600 5,400 5,300 1,900 City Units of Service 106,120 291 291 1,112 106,120 291 291 1,135 Allocated Cost - $ 243,200 163,500 41,900 1,100 2,000 14,100 10,000 9,800 800 Bulk Water Units of Service 49,280 135 135 935 49,280 135 135 935 Allocated Cost - $ 113,900 75,900 19,400 500 1,700 6,500 4,700 4,600 600 Fire Protection Units of Service 0 1,700 3,300 0 0 1,700 3,300 0 2,251 Allocated Cost - $ 578,100 0 244,700 12,300 0 0 58,600 111,400 0 151,100 Total Inside City 11,342,600 6,419,200 2,370,800 61,000 472,900 551,800 567,400 553,200 195,200 151,100 Description Unit Cost of Service - Slant Table W -15 City of Round Rock, Texas Water Utility Allocation of Cost of Service to Customer Classes 2004 Test Year ( ( ( ( ( ( ( ( ( Common to All Roil Only Extra Capacity Extra Capacity Maximum Maximum Customer Maximum Maximum Meters & Fire Total Base Day Hour Billing Base Day ' Hour Services Protection 1.5409 143.9685 3.7192 1.7862 0.1324 34.4538 33.7558 0.6660 67.1257 Outside City Chandler Creek Residential Units of Service 104,630 431 358 13,500 104,630 431 358 13,505 Allocated Cost -S 298,500 161,200 62,100 1,300 24,100 13,900 14,800 12,100 '9,000 Chandler Creek Commercial Units of Service 9,230 25 25 71 9,230 25 25 378 Allocated Cost - $ 21,200 14,200 3,600 100 100 1,200 900 800 300 Outside City No Classification Units of Service 35,900 122 114 370 35,900 122 114 932 Allocated Cost - $ 87,400 55,300 17,600 400 700 4,800 4 ,200 3,800 600 Total Outside City 407,100 230,700 83,300 1,800 24,900 19,900 19,900 16,700 9,900 0 Wholesale Fem Bluff Units of Service 298,470 1,023 940 12 Allocated Cost- $ 610,700 459,900 147,300 3,500 0 Brushy Creek Units of Service 691 ,310 3,315 2,651 103 Allocated Cost - $ 1,552,600 1,065,200 477,300 9,900 200 Vista Oaks Units of Service 147,480 808 606 12 Allocated Cost - 0 345,800 227 ,200 116,300 2,300 0 Williamson Cty MUD 10 Units of Service 31,710 131 108 44 Allocated Cost - $ 68,300 48,900 18,900 400 100 Williamson Cry MUD 11 Units of Service 0 0 0 0 Allocated Cost - $ 0 0 0 0 0 Aqua Source Units of Service 52,560 • 310 230 12 Allocated Cost -$ 126,500 81,000 44,600 900 0 . RRJomt Venture Umts of Service 10,880 30 30 12 Allocated Cost - S 21 ,200 16,800 4,300 100 0 Manville Water Supply Umts of Service 19,640 113 84 12 Allocated Cost - $ 46,900 30,300 16,300 300 0 • Williamson Cry Park Umts of Service 47,380 195 163 12 Allocated Cost - $ 101,700 73,000 28,100 600 0 Total Wholesale • 2,873,700 2,002,300 853,100 18,000 300 0 0 0 0 0 Total Inside City 11,342,600 6,419 ,200 2,370,800 61,000 472,900 551,800 567,400 553 ,200 195 ,200 151,100 Total Outside City 407,100 230,700 83,300 1,800 24,900 19,900 19,900 16,700 9,900 0 Total Allocated Costs 14,623,400 8,652 ,200 3,307 ,200 80,800 498,100 571,700 587,300 569,900 205,100 151,100 Line No. Description Table W -16 City of Round Rock, Texas Water Utility Comparison of Adjusted Cost of Service with Revenue Under Existing Rates 2004 Test Year (1) (2) (3) (4) (5) (6) Revenue Indicated Total Redistributed Adjusted Under Increase Cost of Public Fire City Water Cost of Existing (Decrease) Service Costs (a) Costs (b) Service Rates Required Inside City 1 Residential 6,814,800 360,600 154,600 7,330,000 7,568,300 (3.1) 2 Commercial 2,643,500 139,800 59,900 2,843,200 2,813,700 1.0 3 Industrial 36,700 1,900 800 39,400 39,200 0.5 4 Apartments 779,800 41,300 17,700 838,800 921,200 (8.9) 5 Government 132,600 7,000 3,000 142,600 157,100 (9.2) 6 City 243,200 0 (234,400) 8,800 8,200 7.3 7 Bulk Water 113,900 6,000 (10,800) 109,100 90,800 20.2 8 Total Inside City 10,764,500 556,600 (9,200) 11,311,900 11,598,500 (2.5) Outside City 9 Chandler Creek Residential 298,500 15,800 6,700 321,000 356,400 (9.9) 10 Chandler Creek Commercial 21,200 1,100 500 22,800 24,800 (8.1) 11 Outside City No Classification 87,400 4,600 2,000 94,000 93,700 0.3 12 Total Outside City 407,100 21,500 9,200 437,800 474,900 (7.8) 13 Wholesale 2,873,700 0 0 2,873,700 2,550,000 12.7 14 Fire Protection 578,100 (578,100) 0 0 0.0 15 Total System 14,623,400 0 0 14,623,400 14,623,400 0.0 (a) Cost of public fire protection is redistributed to other customer classes and will be recovered through Inside City & Outside City water rates. (b) Cost of free City water service is redistributed to other customer classes and will be recovered through Inside City & Outside City water rates. Description Table W -17 City of Round Rock, Texas Water Utility Existing and Proposed Rates ( ( Existing Proposed Rates Rates Minimum Charge - $/Month Meter Size 5/8" 11.60 11.60 3/4" 16.33 16.33 1" 25.78 25.78 1 1/2" 49.40 49.40 2" 77.75 77.75 3" 143.90 143.90 4" 238.40 238.40 6" 758.15 758.15 8" 1,325.15 1,325.15 10" 2,081.15 2,081.15 12" 2,553.65 2,553.65 Volume Charge - $ /1,000 gallons Inside City Residential 1.91 1.91 Commercial 1.91 1.91 Industrial 1.91 1.91 Apartments 1.91 1.91 Government 1.91 1.91 Table w-18 City of Round Rock, Texas Water Utility Comparison of Typical Bills Under Existing and Proposed Rates 2004 Test Year (1) (2) (3) (4) (5) Proposed Rates Indicated Proposed Meter Monthly Existing Increase Percentage Size Water Use Rates Total (Decrease) Change Inches Mgal $ $ $ Residential 5/8 0 11.60 11.60 0.00 0.00 5/8 5 21.15 21.15 0.00 0.00 5/8* 10 30.70 30.70 0.00 0.00 5/8 15 40.25 4025 0.00 0.00 5/8 20 49.80 49.80 0.00 0.00 5/8 25 59.35 59.35 0.00 0.00 Commercial 5/8 10 30.70 30.70 0.00 0.00 5/8 20 49.80 49.80 0.00 0.00 5/8 30 68.90 68.90 0.00 0.00 1 50 121.28 121.28 0.00 0.00 1 * 85 188.13 188.13 0.00 0.00 1 100 216.78 216.78 0.00 0.00 2 200 459.75 459.75 0.00 0.00 Industrial 5/8 40 88.00 88.00 0.00 0.00 5/8 80 164.40 164.40 0.00 0.00 2 100 268.75 268.75 0.00 0.00 2 150 364.25 364.25 0.00 0.00 2 * 200 459.75 459.75 0.00 0.00 Apartments 5/8 60 126.20 126.20 0.00 0.00 ' 5/8* 100 202.60 202.60 0.00 0.00 5/8 150 298.10 298.10 0.00 0.00 1 200 407.78 407.78 0.00 0.00 1 250 503.28 503.28 0.00 0.00 2 300 650.75 650.75 0.00 0.00 Mgal - 1,000 gallons * Represents average user Description Table W -19 City of Round Rock, Texas Water Utility Comparison of Adjusted Cost of Service Revenue Under Proposed and Existing Rates 2004 Test Year (1) (2) (3) - (4) (5) Indicated Revenue As Increase Revenue Revenue A Percent of (Decrease) Under Adjusted Under Adjusted Over Proposed Cost of Existing Cost of Existing Rates Service Rates Service Rates $ $ $ % % ( (1)/(3) Inside City Residential 7,568,300 7,330,000 7,568,300 103.3 0.0 Commercial 2,813,700 2,843,200 2,813,700 99.0 0.0 Industrial 39,200 39,400 39,200 99.5 0.0 Apartments 921,200 838,800 921,200 109.8 0.0 Government 157,100 142,600 157,100 110.2 0.0 City 8,200 8,800 8,200 93.2 0.0 Bulk Water 90,800 109,100 90,800 83.2 0.0 Total Inside City 11,598,500 11,311,900 11,598,500 102.5 0.0 Outside City Chandler Creek Residential 356,400 321,000 356,400 111.0 0.0 Chandler Creek Commercial 24,800 22,800 24,800 108.8 0.0 Outside City No Classification ' 93,700 94,000 93,700 99.7 0.0 Total Outside City 474,900 437,800 474,900 108.5 0.0 Wholesale 2,550,000 2,873,700 2,550,000 88.7 0.0 Total System 14,623,400 14,623,400 14,623,400 100.0 0.0 WASTEWATER UTILITY as • we am am am i• me i• me um i Ns i• no I• i• Ns ow N Line No. Customer Class Table S -1 City of Round Rock, Texas Wastewater Utility Historical & Projected Average Number of Customers Fiscal Year Ending September 30 Historical Projected 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Inside City 1 Residential 16,721 18,426 19,203 19,800 20,392 21,000 21,633 22,283 22,950 23,642 24,350 25,083 25 833 26,608 2 Commercial 1,181 887 897 925 950 975 1,008 1,042 1,075 1,108 1,142 1,175 1,208 1,242 3 Industrial 7 7 7 7 8 8 8 8 9 9 9 9 10 10 4 Apartments 188 191 266 275 283 292 300 308 317 325 333 342 350 358 5 Government 1 1 22 22 22 22 22 22 22 22 22 22 22 22 City 6 - Frac Service 71 - 70 69 69 69 69 69 69 69 69 69 69 69 69 7 Total Inside City 18,169 19,582 20,464 21,098 21,724 22,366 23,040 23,732 24,442 25,175 25,925 26,700 27,492 28,309 Outside City 8 Chandler Creek Residential 534 736 1,092 1,108 1,125 1,142 1,158 1,175 1,192 1,192 1,192 1,192 1,192 1,192 9 Chandler Creek Commercial 2 3 3 3 3 3 3 4 4 4 4 4 4 4 10 Outside City No Classification 4 4 4 4 4 4 4 4 4 4 4 4 4 4 11 Total Outside City 540 743 1,099 1,115 1,132 1,149 1,165 1,183 1 ,200 1,200 1,200 1,200 1,200 1,200 Wholesale Customers 12 Vista Oaks 1 1 1 1 1 1 1 1 1 1 1 1 1 1 13 Williamson Cty MUD 10 0 0 1 1 . 1 1 1 1 I 1 I 1 1 1 14 RR Joint Venture 0 0 1 1 1 1 I 1 1 1 1 1 1 1 15 Total Wholesale 1 1 3 3 3 3 3 3 3 3 3 3 3 3 16 Total Customers 18,710 20,326 21,566 22,216 22,859 23,518 24,208 24,918 25,645 26,378 27,128 27,903 28,695 29,512 MN 'IMO • I• MN EN - - - • - - • I• MN MI • M MN Line No. Customer Class Table S -2 City of Round Rock, Texas Wastewater Utility Historical & Projected Wastewater Sales Volume Fiscal Year Ending September 30 Historical Projected 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal 1,000 gal inside City 1 Residential 1,264,400 1,257,900 1,300,700 1,346,400 1,386,700 1,428,000 1,471,100 1,515,300 1,560,600 1,607,700 1,655,800 1,705,700 1,756,700 1,809,400 2 Commercial 562,900 , 567,900 585,800 598,100 614,300 630,500 652,000 673,600 695,100 716,700 738,200 759,800 781,300 802,900 3 Industrial 15,900 13,200 11,200 12,600 13,100 13,500 13,900 14,400 14,800 15,200 15,700 16,100 16,600 17,000 4 Apartments 157,200 151,300 191,000 207,700 214,000 220,200 226,500 232,800 239,100 245,400 251,700 258,000 264,300 270,600 5 Government 100 100 13,200 13,200 13,200 13,200 13,200 13,200 13,200 13,200 13,200 13,200 13,200 13,200 City 6 - Free Service 22,400 16,100 14,100 14,900 14,900 14,900 14,900 14,900 14,900 14,900 14,900 14,900 14,900 14,900 7 Total Inside City 2,022,900 2,006,500 2,116,000 2,192,900 2,256,200 2,320,300 2,391,600 2,464,200 2,537,700 2,613,100 2,689,500 2,767,700 2,847,000 2,928,000 Outside City 8 Chandler Creek Residential 34,200 41,500 61,500 62,500 63,400 64,400 65,300 66,200 67,200 67,200 67,200 67,200 67,200 67,200 9 Chandler Creek Commercial 1,100 1,600 2,700 2,300 2,400 2,400 2,500 2,600 2,600 2,600 2,600 2,600 2,600 2,600 10 Outside City No Classification 1,200 1,500 1,800 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 11 Total Outside City 36,500 44,600 66,000 66,400 67,400 68,400 69,400 70,400 71,400 71,400 71,400 71,400 71,400 71,400 Wholesale Customers 12 Vista Oaks 45,700 65,400 64,500 66,400 68,400 70,500 72,600 74,800 77,000 79,300 81,700 84,200 86,700 89,300 13 Williamson Cty MUD 10 0 0 23,800 24,500 25,200 26,000 26,700 27,500 28,400 29,200 30,100 31,000 31,900 32,900 14 RR Joint Venture 0 ,0 4,700 4,800 5,000 5,100 5,300 5,400 5,600 5,800 5,900 6,100 6,300 6,500 15 Total Wholesale 45,700 65,400 93,000 95,700 98,600 101,600 104,600 107,700 111,000 114,300 117,700 121,300 124,900 128,700 16 Total Consumption 2,105,100 2,116,500 2,275,000 2,355,000 2,422,200 2,490,300 2,565,600 2,642,300 2,720,100 2,798,800 2,878,600 2,960,400 3,043,300 3,128,100 Table S -3 City of Round Rock, Texas Wastewater Utility Historical & Projected Wastewater Revenue by Class Fiscal Year Ending September 30 Line Historical Projected No. Customer Class 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 0 $ S $ $ $ $ $ $ $ $ $ Inside City 1 Residential 4,443,800 4,591,900 4,729,200 4,870,300 5,017,100 5,167,900 5,322,500 5,482,900 5,647,100 5,817,300 5,991,100 6,170,800 2 Commercial 1,419,000 1,451,900 1,491 ,200 1,530,500 1,582,700 1,635,000 1,687,400 1,739,700 1,792,000 1,844,400 1,896,700 1,948,900 3 Industrial 25,800 28,800 29,700 30,700 31,700 32,700 33,700 34,700 35,600 36,600 37,700 38,600 4 Apartments 513,90G 550,900 567,600 584,300 601,000 617,600 634,300 651,000 667,700 684,400 701,100 717,800 5 Government 44,700 44,700 . 44,700 44,700 44,700 44,700 44,700 44,700 44,700 44,700 44,700 44,700 City 6 - Free Service 33,700 35,300 35,300 35,300 35,300 35,300 35,300 35,300 35,300 35,300 35,300 35,300 7 Total Inside City 6,480,900 6,703,500 6,897,700 7,095,800 7,312,500 7,533,200 7,757,900 7,988,300 8,222,400 8,462,700 8,706,600 8,956,100 Outside City 8 Chandler Creek Residential 228,900 232,400 235,900 239,300 242,800 246,300 249,900 249,900 249,900 249,900 249,900 249,900 9 Chandler Creek Commercial 7,900 7,200 7,300 7,500 7,700 7,900 8,000 8,000 8,000 8,000 8,000 8,000 10 Outside City No Classification 7,700 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 11 Total Outside City 244,500 246,800 250,400 254,000 257,700 261,400 265,100 265,100 265,100 265,100 265,100 265,100 Wholesale 12 Vista Oaks 182,600 188,000 193,700 199,500 205,400 211,600 217,900 224,500 231 ,200 238,100 245,300 252,600 13 Williamson Cty MUD 10 72,000 74,100 76,400 78,700 81,000 83,400 86,000 88,500 91,200 93,900 96,700 99,700 14 Williamson Cty MUD 11 0 0 0 0 0 0 0 0 0, 0 0 0 15 RR Joint Venture 14,200 14,600 15,100 15,500 16,000 16,500 16,900 17,500 18,000 18,500 19,100 19,600 16 Williamson Cty Park 0 0 0 0 0 0 0 0 0 0 0 0 17 Total Wholesale Customers 268,800 276,700 285,200 293,700 302,400 311,500 320,800 330,500 340,400 350,500 361,100 371,900 18 Subtotal Total Revenue 6,994,200 7,227,000 7,433,300 7,643,500 7,872,600 8,106,100 8,343,800 8,583,900 8,827,900 9,078,300 9,332,800 9,593,100 19 Less: Free City Service 33,700 35,300 35,300 35,300 35,300 35,300 35,300 35,300 35,300 35,300 35,300 35,300 20 Subtotal Wastewater Revenue 6,960,500 7,191,700 7,398,000 7,608,200 7,837,300 8,070,800 8,308,500 8,548,600 8,792,600 9,043,000 9,297,500 9,557,800 21 Revenue From Extra Strength 203,100 203,100 203,100 203,100 203,100 203,100 203,100 203,100 203,100 203,100 203,100 203,100 22 Total Wastewater Revenue 7,163,600 7,394,800 7,601,100 7,811,300 8,040,400 8,273,900 8,511,600 8,751,700 - 8,995,700 9,246,100 9,500,600 9,760,900 MI •M MI = WWI WI MS OM In I I - - -- l= NM Table S-4 City of Round Rock, Texas Wastewater Utility Budgeted and Projected Operating & Maintenance Expenses Line Budget Budget Protected No Account Description 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 $ $ $ $ $ $ $ $ $ $ $ $ Wastewater Treatment Plant 1 S.W. Interceptor - Capital Chgs. 136,000 136,000 140,100 144,300 148,600 153,100 157,700 162,400 167,300 172,300 177,500 182,800 2 Sewage Services - Operations 2,040,000 2,167,000 2,015,600 2,082,900 ,2,150,800 2,221,100 2,060,000 2,106,800 2,154,400 2,202,400 2,253,300 2,253,300 3 Sewage Serviccs - Capital 2,433,000 2,567,000 4,234,900 5,000,600 5,803,600 6,542,800 6,797,000 7,046,000 7,429,200 8,018,000 8,469,700 8,469,700 4 All Other 10,000 0 0 0 0 0 0 0 0 0 0 0 5 Total Wastewater Treatment Plant 4,619,000 4,870,000 6,390,600 7,227,800 8,103,000 8,917,000 9,014,700 9,315,200 9,750,900 10,392,700 10,900,500 10,905,800 Wastewater Systems Support 6 Power &Light 50,000 40,000 42,700 45,500 48,500 51,700 55,100 58,800 62,700 66,900 71,300 76,000 7 O&M Vista Oaks 20,000 0 0 0 0 0 0 0 0 0 0 0 8 R&M Lift Stations 35,000 55,000 56,700 58,400 60,200 62,000 63,900 65,800 67,800 69,800 71,900 74,100 9 All Other 329,300 385,500 397,000 408,900 421,200 433,900 446,900 460,200 474,000 488,300 502,900 518,000 10 Total Wastewater Systems Support 434,300 480,500 496,400 512,800 529,900 547,600 565,900 584,800 604,500 625,000 646,100 668,100 Wastewater Lines Maintenance 11 R &M Lines 85,000 177,500 182,800 188,300 193,900 199,700 205,700 211,900 218,300 224,800 231,500 238,400 12 All Other 1,325,600 1,393,600 1,435,300 1,478,300 1,522,600 1,568,300 1,615,400 1,663,800 1,713,600 1,765,100 1,818,100 1,872,600 13 Total Wastewater Lines Maintenance 1,410,600 1,571,100 1,618,100 1,666,600 1,716,500 1,768,000 1,821,100 1,875,700 1,931,900 1,989,900 2,049,600 2,111,000 14 Environmental Services 197,200 179,800 185,200 190,700 196,400 202,400 208,500 214,700 221,100 227,700 234,500 241,500 15 Utility Billings & Collections 456,100 426,600 439,400 452,600 466,200 480,200 494,700 509,500 524,800 540,600 556,700 573,400 16 Transfers Department 0 82,500 85,000 87,600 90,230 92,900 95,700 98,600 101,500 104,600 107,700 111,000 17 Total O &M Expense 7,117,200 7,610,500 9,214,700 10,138,100 11,102,200 12,008,100 12,200,600 12,598,500 13,134,700 13,880,500 14,495,100 14,610,800 • ' - - ! all • . - • M - - - MB i • MN MI RR MI Table S -5 City of Round Rock, Texas Wastewater Utility Proposed Major Capital Improvements Program Lute Ftsral Year Ending September 30 No. Project 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Total $ S S S S S S S S Wastewater Cap0al Projecta 1 Westinghouse Wastewater Interceptor 1,174,600 2 WTPO11'site WW Line 402,300 3 WW Collection System lospectio /Conti Rehab Non Ed 286,300 4 WW Collection System Iospectioo /Caost/Rebab 1,006,000 5 Wastewater Collation System Master Plan 125,000 6 Avery Faros Wastewater Interceptor 80,000 7 Ranch Road 620 @ Bnarwood Construct 10' Wastewater Line 50,000 8 Sanitary Sewer Engineering Study /Repairs 470,100 9 WW Inspection FY 0102 Basics OC3l, CC36 133,900 10 Reple WW Line-Downtown 39,800 11 WW Impact Fee Study for TCBA 1,500 12 Eggers Acres 124,000 13 Circle Drive 97,800 14 Relief Sewer Line lake Cr. & Dove Spgs. LCRA 300,000 15 Chandler Crk Interceptor 4,550,000 16 Total Wastewater Pmjects 8,841,300 17 Detention Projects 18 Channel Improvements GSR 1,100 18 Rubio Drainage 13,000 19 Chisholm Valley Drainage Channel Improvements 40,300 19 Mesa Ridge/ NEB Drainage Improvements 244,900 20 Box Qdverts•620 & Wyoming Springs 200 20 Onion Branch Stormwater Drainage Study 439,700 21 Southereek Subdwiwo Flood Study 5,300 22 Total Detentioo Projects 744,500 O 0 O 0 2,175,700 2,654,000 1,512,10 3,766,800 583,400 2,587,20 125,000 970,000 1,000,000 50,000 7,087,500 4,237,400 4,099,300 4,057,300 3,686,800 2,366,700 2,040,800 2,040,900 1,864,700 903,600 41,226,300 0 0 0 0 0 0 0 1,291,600 1,231,700 1,075,1 2,765,700 2,455,10 1 ,291,6 0 0 0 • 0 0 0 811,800 690,000 715,200 371,50 1,229,000 1 ,350,900 1,149,500 532,10 1,174,600 402,300 12,815,000 18,717 ,300 250,000 2,050,000 100,000 470,100 133,900 39,800 1,500 124,000 97,800 300,000 4,550,000 1,100 13,000 40,300 244,900 200 439,700 5,300 0 0 0 744,500 23 Total Projects 9,585,800 7,087,500 4,237,400 4,099,300 4,057,300 3,686,800 2,366,700 2,040,800 2,040,900 1,864,700 903,600 41,970,800 A 'am EN am N o - - - - - - ow am - - - ow No Table S -6 City of Round Rock, Texas Wastewater Utility Capital Improvement Program Financing Plan Line Fis• al Year Ending September 30 No. Description 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Source of Funds: 1 Beginning of Year Balance 17,334,400 8,810,100 2,637,100 13,600, 39,500 100,800 42,600 49,100 89,600 24,700 38,000 2 Revenue Bond Proceeds 0 0 500,000 3,000,000 3,300,000 2,900,000 1,100,000 800,000 1,000,000 900,000 0 3 Transfer from Operating Fund 0 0 300,000 400,000 100,000 0 500,000 500,000 200,000 200,000 100,000 4 Impact Fees 800,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000 5 Interest Income 261,400 114,500 31,500 30,200 34,100 30,100 11,800 9,300 11,000 9,500 700 6 Total Funds Available 18,395,800 9,724,600 4,268,600 4,243,800 4,273,600 3,830,900 2,454,400 2,158,400 2,100,600 1,934,200 938,700 Application of Funds: 7 Major Capital Improvements 9,585,700 7,087,500 4,237,500 4,099,300 4,057,300 3,686,800 2,366,800 2,040,800 2,040,900 1,864,700 903,600 8 Surety Bonds 0 0 5,000 30,000 33,000 29,000 11,000 8,000 , 10,000 9,000 0 9 Bond Issuance Costs 0 0 12,500 75,000 82,500 72,500 27,500 20,000 25,000 22,500 0 10 Total Funds Applied 9,585,700 7,087,500 4,255,000 4,204,300 4,172,800 3,788,300 2,405,300 2,068,800 2,075,900 1,896,200 903,600 11 End of Year Fund Balance 8,810,100 2,637,100 13,600 39,500 100,800 42,600 49,100 89,600 24,700 38,000 35,100 • i• i• - - - - - r - - - - - - - - Table S -7 City of Round Rock, Texas Wastewater Utility Existing and Proposed Debt Service Line Fiscal Year Ending September 30 No. Description 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 $ $ $ 's $ $ $ $ $ $ $ Revenue Bonds: 1 Existing Revenue Bonds 307,400 252,300 190,400 109,700 0 0 0 0 0 0 0 2 Series 2003 0 0 0 0 0 0 0 0 0 0 0 3 Series2004 0 0 0 0 0 0 0 0 0 0 4 Series 2005 40,700 40,700 40,700 40,700 40,700 40,700 40,700 40,700 40,700 5 Series2006 244,100 244,100 244,100 244,100 244,100 244,100 244,100 244,100 6 Series 2007 268,500 268,500 268,500 268,500 268,500 268,500 268,500 7 Series 2008 235,900 235,900 235,900 235,900 235,900 235,900 8 Series 2009 89,500 89,500 89,500 89,500 89,500 9 Series2010 65,100 65,100 65,100 65,100 10 Series 2011 81,400 81,400 81,400 11 Series 2012 73,200 73,200 , 12 Series 2013 0 13 Subtotal Proposed Revenue Bonds 0 0 40,700 284,800 553,300 789,200 878,700 943,800 1,025,200 1,098,400 1,098,400 14 Existing General Obligation Bonds 283,900 467,500 500,600 159,500 166,400 159,100 115,500 63,700 0 0 0 15 Total Wastewater Utility Debt Service 307,400 252,300 231,100 394,500 553,300 789,200 878,700 943,800 1,025,200 1,098,400 1,098,400 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Une No. Description 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 1 Ensues Wastewater Sal. Revenue Additional Wastewater Revenue Required. Revenue Months Increase Effective Year 2 2003 0 0% 3 2004 90% 4 2005 90% 5 2006 9 0% 6 2007 8 5% 7 2008 85% 8 2009 00% 9 2010 0 0% 10 2011 00% 11 2012 40% 12 2013 00% 13 Total Additional Wastewater Revenue 14 Total Wastewater Revenue 15 Other Operating Revenue 16 Inperestlncome 17 Total Revenue 18 Operation and Maintenance Expense Debt Service: Revenue Bonds 19 Ensuog Revenue Bonds 20 Proposed Revenue Bends 21 Total Revenue Bonds Transfers. 24 Transfer to Construction Fund 25 Tra sf to General Fund 26 Transfer from Impact Fees 27 Total Transfers 28 Total Revenue Requirements 29 Net Annual Balance 30 Bogmting of Year Balance 31 End ofYear Balance 32 Targeted End of Year Balance (a) Total Revenue (Line 17) Lea Operation and Maintenance Expense (Lute 18) (b) Represents coverage of total 'annual' revenue debt service (Line 33/ Line 21) (c) Represents coverage o010122 annual - debt service (Lrne33/(I.ine 21 +L Inc 22)) Table S -8 City of Round Rock, Texas Wastewater Utility Comparison of Projected Revenue and Revenue Requirements Under Increased Revenue Fiscal Year Endm6 September 30 I I 5 I 5 I I I I I 7394,800 7,601,100 7,811300 8,040,400 8,273,900 8,511,600 8,751,700 8,995,700 9,246.100 9,500,000 9,760,900 0 0 0 0 0 0 0 0 0 0 513,100 703,000 723,600 744,700 766,000 787,700 809,600 832,100 855,100 878,500 574,700 788,800 811,700 835,000 858,500 882,500 907,000 932,000 957,500 644,800 884,700 910,100 935,800 961,900 988,700 1,015,900 1,043,700 683,100 936,900 963,400 990,200 1,017,800 1,041,800 1,074,500 762,400 1,045,300 1,074,400 1,104300 1,134,700 1,165,800 0 0 0 0 0 0 0 0 0 0 0 0 434,500 595,200 O 513,100 1 .277,700 2,157,200 3,124,200 4,210,400 4,590,700 4,718,600 4,849,900 5,418,000 5,715,200 7,394,800 8,114,200 9,089,000 10,197,600 11,398,100 12,722,000 13342,400 13,714300 14,096,000 14,918,600 15,476,100 370,000 377,500 377,500 377,500 377,500 377,500 377,500 377,500 377,500 377,500 377,500 70,700 75,500 71,400 60,300 55,200 56,400 59,100 60.200 62,100 65,100 68,500 7,835,500 8,567 ,200 9,537,900 10,635,400 11,830,800 13,155,900 13,779,000 14,152,000 14,535,600 15,361,200 15,922,100 7,117,200 7,610,500 9,214,700 10,138,100 11,102,200 12,008,100 12,200,600 12,598,500 13,134,700 13,880,500 14,495,100 307,400 252,300 190,400 109,700 0 0 0 0 0 0 O 0 . 40,700 284,800 553,300 789,200 878,700 943,800 1,025,200 1,098,400 1,098,400 307,400 252,300 2.31,100 394,500 553,300 789,200 878,700 943,800 1,025,200 1,098,400 1,098,400 General Obligation 22 Existing General Obligation Bonds 283,900 467,500 500,600 159,500 166,400 159,100 115,500 63,700 0 0 0 23 Routine Coprtal Outlay 239,100 217 ,900 224,500 231,200 238,200 245,400 252,800 260,400 268,200 276,300 284,600 O 0 300,000 400,000 100,000 0 500,000 500,000 200,000 200,000 100,000 471,500 532,400 552,400 552,400 552,400 552,400 552,400 552,400 352,400 532,400 552,400 (800,000) (800,000) (800,000) (800,000) (800,000) (800000) (800,000) (800,000) (800,000) (800,000) (800,000) (328,500) (247,600) 52,400 152,400 (147,600) (247,600) 252,400 252,400 (47000) (47,600) (147,600) 7,619,100 8,300,600 10,223,300 11,075,700 11,912,500 12,954,200 13,700,000 14,118,800 14,380,500 15,207,600 15,730,500 216,400 266,600 (685,400) (440,300) (81,700) 201,700 79,000 33,200 155,100 153,600 191,600 3,500,000 3,716,400 3,983,000 3 ,297 ,600 2,857,300 2,773,600 2,977,300 3,056,300 3,089,500 1,244,600 3,398,200 3,716,400 3,983,000 3,297,600 2,857,300 2,775,600 2,977,300 3,056,300 3,089,500 3,244,600 3398,200 3,589,800 1,779,300 1, 902,600 2303,700 2,534,300 2,775,600 3,002,000 3,050,200 3,149,600 3,283,700 3,470,100 3,623,800 Coverage: 33 Net Revenue (a) 718,300 956,700 323,200 497,300 728,600 1,147,800 1,578,400 1,553,500 1,400,900 1,480,700 1,427,000 34 Revenue Bond Debt Semce Covenge(b) 233 3792% 1399% 126.1%. 131.7% 1454% 1796%. 1646% 1366 %a 1348 %. 1299%, 35 Total Bond Debt Servsce Coverage (4) 1215% 1329%. 44.2% 898% 1012% 1210%, 1588% 1542%. 1366% 1348 %. 1299%, 36 Days of Operating Reserve 191 191 131 103 91 90 91 90 90 89 90 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Line No. Description Revenue Requirements 1 Operating Expense 2 Revenue Debt Service 3 General Bond Debt Service 4 Routine Capital Outlay 5 Transfer to General Fund Table S -9 City of Round Rock, Texas Wastewater Utility Cost of Service 2004 Test Year 7,610,500 552,400 6 Transfer to Capital Fund 0 0 7 Total 8,162,900 937,700 9,100,600 Revenue Requirements Met from Other Sources 8 Other Operating Revenue 377,500 0 377,500 9 Interest Income 67,700 7,800 75,500 10 Use of Available Funds (a) (239,100) (27,500) (266,600) 11 Partial Year Increase Adjustment (b) 564,200 64,800 629,000 12 Total 770,300 45,100 815,400 13 Net Costs to be met from Wastewater Charges 7,392,600 892,600 8,285,200 (a) A positive value reflects drawdown of funds available at beginning of year; a negative value reflects addition to end of year fund balance. (b) Adjustment for less than full year revenue increase. ( ( (3) Operating Capital Expense Costs Total $ $ $ 7,610,500 252,300 252,300 467,500 467,500 217,900 217,900 552,400 I= •N — — • — IM — — — — — — I OM MO = NM Line No. Description Table S -10 City of Round Rock, Texas Wastewater Utility Allocation of Net Plant Investment and Capital Costs To Functional Cost Components 2004 Test Year ( ( ( ( ( ( ( ( Capacity Related Strength Related Plant Common Retail ' Suspended Customer Investment Volume to All Only BOD Solids Billing Meters $ $ • $ $ $ $ $ $ 1 Lift Stations 1,179,300 1,179,300 Collection Mains 2 Mains Greater than 12" 10,030,300 10,030,300 3 Mains <=12" 9,501,900 9,501,900 4 Other General 876,000 474,100 401,900 5 Meters 87,000 87,000 6 Environmental Services 35,200 19,000 16,100 0 0 0 100 7 Water Billing Bldg./Equip 70,300 70,300 8 Drainage 157,600 157,600 9 Total Plant 21,937,600 0 11,702,700 10,077,500 0 0 70,300 87,100 10 Less: Contributed Plant 14,450,600 7,296,700 7,153,900 11 Net Plant Investment 7,487,000 0 4,406,000 2,923,600 0 0 70,300 87,100 12 Percent of Total 100.0% 0.0% 58.8% 39.0% 0.0% 0.0% 0.9% 1.2% 13 2004 Test Year Capital Costs 892,600 0 525,200 348,600 0 0 8,400 10,400 me •m . ow ow No am um me um m - - - - . - um NE ow Line 140. Descnptiao Table S -11 City of Round Rock, Texas Wastewater Utility Allocation of Operation and Maintenance Expense to Functional Cost Components 2004 Test Year ( ( ( ( ( ( ( ( Capacity Related Strength Related Common Retail Suspended Customer Total Volume to All Only BOD Solids Billing Metres S S S Wastewater Treatment Platt 1 S W Interceptor - Capital Chgs 136,000 136,000 2 Sewage Services - Opersuoos 2,167,000 1,126,800 520,100 520,100 3 Sewage Services - Capital 2,567,000 1,334,800 616,100 616,100 4 All Other 0 0 0 0 0 5 Total Wastewater Treatment Plant 4,870,000 2,461,600 136,000 0 1,136,200 1,136,200 S S S S Wastewater Systems Support 6 Power & light 40,000 40,000 7 O&M Vista Oaks 0 0 8 R&M Lift Stations 55,000 55,000 9 All Other 321,700 151,800 169,900 10 Meters 63,800 63,800 11 Total Wastewater Systems Support 480,500 40,000 206,800 169,900 0 0 63,800 Wastewater Lmes Maintemmee 12 R&M Lines 177,500 83,800 93,700 13 All Oder 1,393,600 657,700 735,900 14 Total Wvtewater Lines Mairteoaoce 1,571,100 741,500 829,600 15 Eovuomoeotal Services 179,800 64,900 28,200 26,000 29,500 29,500 0 1,700 16 Utility Billings & Collections 426,600 426,600 17 Transfers Depmhaeot 82,500 29,900 12,900 11,900 13,500 13,500 0 800 18 Total O&M Expense 7,610,500 2,596,400 1,125,400 1,037,400 1,179,200 1,179,200 426,600 66,300' 19 Ad& Transfer to General Fwd 552,400 188,400 81,700 75,300 85,600 85,600 31,000 4,800 Less Other Operating Revenue 20 Interest Income 67,700 23,100 10,000 9,200 10,500 10,500 3,800 600 21 All Odra Income 377,500 377,500 22 (Increase) Decrease m Funds Available at Year End (a) (239,100) (81,600) (35,400) (32,600) (37,000) (37,000) (13,400) (2,100) 23 Partial Year (Increase) Decrease m Rate Revenue (b) 564,200 192,600 83,400 76,900 87,400 87,400 31,600 4,900 24 Subtotal Oder Operating Revenue 770,300 134,100 58,000 431,000 60,900 60,900 22,000 3,400 25 Net Opembag Expense 7 ,392,600 2,650,700 1,149,100 681,700 1,203,900 1,203,900 435,600 67,700 (a) Poative value reflects drswdowo of foods available at begoomg of year, a negative value reflects adddon to cod of year fund balance. (b) Adjustment for less than fu0 year revenue increase. •I= m Ns um um N - - No o - - - - No = I Ns Line No. Customer Class Table S -12 - City of Round Rock, Texas Wastewater Utility Estimated Units of Service 2004 Test Year (I) ( ( ( ( ( Wastewater Strength Suspended Volume Capacity BOD Solids Customer Meters Mgal Mgd pounds pounds Bills Eq. Meters Inside City 1 Residential 2,025,600 5,550 2,370,800 3,008,500 244,700 244,932 2 Commercial 705,600 1,933 1,050,300 1,297,600 11,400 25,813 3 Industrial 14,800 41 22,400 27,600 90 463 4 Apartments 244,700 '670 365,900 451,800 3,400 10,244 5 Govemmental 15,200 42 22,600 27,900 259 2,000 6 City 18,200 50 25,500 31,700 826 826 7 Surcharge 637,200 315,300 8 Total Inside City 3,024,100 8,285 4,494,700 5,160,400 260,700 284,300 Outside City 9 Chandler Creek Residential 97,100 266 108,400 138,400 13,500 13,500 10 Chandler Creek Commercial 2,800 8 4,100 5,100 39 286 11 Outside City No Classification 1,900 5 2,700 3,400 49 50 12 Total Outside City 101,800 279 115,200 146,900 13,600 13,800 Wholesale 13 Vista Oaks 76,000 208 116,900 144,000 12 0 14 Williamson Cty MUD 10 28,700 79 43,100 53,200 42 0 15 Williamson Cty MUD 11 0 0 0 0 0 0 16 RR Joint Venture 5,700 16 8,500 10,600 12 0 17 Williamson Cty Park 0 0 0 0 0 0 18 Total Wholesale 110,400 302 168,500 207,800 66 0 19 Total 3,201,900 8,800 4,726,800 5,451,300 274,312 298,100 20 Total Retail Only Units (a) 3,124,000 8,559 4,607,200 5,303,900 274,239 298,086 21 Total Outside City Retail Units 1,900 5 2,700 3,400 49 50 22 Total Wholesale Units 110,400 302 168,500 207,800 66 0 (a) Includes Inside City and Chandler Creek. EIN • E — — m ow ow ma me N No NE = — — ow mu NE me Line No. Description Capital Costs 4 Total Cost - $ 5 Unit Cost - $ /unit Mgal - 1,000 gallons Mgd - 1,000 gallons per day Table S -13 City of Round Rock, Texas Wastewater Utility Unit Costs of Service 2004 Test Year (1) ( ( ' ( ( ( (7) (8) Capacity Related Strength Related Common Retail Suspended Customer Total Volume to All Only BOD Solids Billing Meters Number of Units 1 Retail Only Units 3,124,000 8,559 8,559 4,607,200 5,303,900 274,239 298,086 2 Outside City Retail Units (a) 3,800 ' 10 10 5,400 6,800 98 100 3 Wholesale Only Units 110,400 302 168,500 207,800 66 0 Unit Description Mgal Mgd Mgd pounds pounds Bills Eq. Meters O &M Expense 2 Total Cost - $ 7,392,600 2,650,700 1,149,100 681,700 1,203,900 1,203,900 435,600 67,700 3 Unit Cost - $ /unit 0.8186 129.5260 79.5532 0.2518 0.2182 1.5874 0.2270 Total 6 Total Cost - $ 8,285,200 2,650,700 1,674,300 1,030,300 1,203,900 1,203,900 444,000 78,100 7 Unit Cost - $ /unit 0.8186 188.7263 120.2342 0.2518 0.2182 1.6181 0.2619 (a) Units of Service have been increased to reflect Round Rock's policy of maintaining a 2 times differential between Inside City and Outside City retail rates. $ $ $ $ $ $ $ $ 892,600 0 525,200 348,600 0 0 8,400 10,400 0.0000 59.2003 40.6810 0.0000 0.0000 0.0306 0.0349 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Lme No Description 1 Unit Cost of Service - $/unit Table S -14 City of Round Rock, Texas Wastewater Utility Allocation of Cost of Service to Customer Classes 2004 Test Year ( ( ( ( ( ( ( (8) Capacity Related Strength Related Common Retail Suspended Customer Total Volume to All Only BOD Solids Billing Meters 0.81857 188.72635 120.23420 0.25180 0.21816 1.61806 0.26192 Inside Citv Residential 2 Units of Service 2,025,600 5,550 5,550 2,370,800 3,008,500 244,700 244,932 3 Allocated Cost - $ 5,086,300 1,658,100 1,047,500 667,300 597,000 656,300 395,900 64,200 Commercial 4 Units of Service 705,600 1,933 1,933 1,050,300 1,297,600 11,400 25,813 5 Allocated Cost - $ 1,747,700 577,700 364,800 232,400 264,500 283,100 18,400 6,800 Industrial 6 Units of Service 14,800 41 41 22,400 27,600 90 463 7 Allocated Cost - $ 36,500 12,100 7,700 4,900 5,600 6,000 100 100 Apartments 8 Units of Service 244,700 670 670 365,900 451,800 3,400 10,244 9 Allocated Cost - $ 606,300 200,300 126,500 80,600 92,100 98,600 5,500 2,700 Governmental 10 Units of Service 15,200 42 42 22,600 27,900 259 2,000 11 Allocated Cost - S 38,000 12,400 7,900 5,000 5,700 6,100 400 500 City 12 Units of Service 18,200 50 50 25,500 31,700 826 826 13 Allocated Cost - $ 45,100 14,900 9,400 6,000 6,400 6,900 1,300 200 Surcharge 14 Units of Service 637,200 315,300 15 Allocated Cost - S 229,200 0 0 160,400 68,800 0 0 16 Total Inside City 7,789,100 2,475,500 1,563,800 996,200 1,131,700 1,125,800 421,600 74,500 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Line No. Description Unit Cost of Service - S/unit Table S -15 City of Round Rock, Texas Wastewater Utility Allocation of Cost of Service to Customer Classes 2004 Test Year ( ( ( ( ( ( ( ( Capacity Related Strength Related Common Retail Suspended Customer Total Volume to All Only BOD Solids Billing Meters 0.81857 188.72635 120.23420 0.25180 0.21816 1.61806 0.26192 Outside City Chandler Creek Residential 2 Units of Service 97,100 266 266 108,400 138,400 13,500 13,500 3 Allocated Cost - S 244,500 79,500 50,200 32,000 27,300 30,200 21,800 3,500 s Chandler Creek Commercial 4 Units of Service 2,800 8 8 4,100 5,100 39 286 5 Allocated Cost - S 6,900 2,300 1,400 900 1,000 1,100 100 100 Outside City No Classification 6 Units of Service 3,800 10 10 5,400 6,800 98 100 7 Allocated Cost - S 9,500 3,100 2,000 1,300 1,400 1,500 200 0 8 Total Outside City 260,900 84,900 53,600 34,200 29,700 32,800 22,100 3,600 Wholesale Vista Oaks 9 Units of Service 76,000 208 0 116,900 144,000 12 10 Allocated Cost - $ 162,300 62,200 39,300 29,400 31,400 0 Williamson Cty MUD 10 11 Units of Service 28,700 79 0 43,100 53,200 42 0 12 Allocated Cost - $ 60,900 23,500 14,800 0 10,900 11,600 100 0 Williamson Cty MUD 11 13 Units of Service 0 0 0 0 0 0 0 14 Allocated Cost - S 0 0 0 0 0 0 0 0 RR Joint Venture 15 Umts of Service 5,700 16 0 8,500 10,600 12 0 16 . Allocated Cost - $ 12,000 ' 4,700 2,900 0 2,100 2,300 0 0 Williamson Cty Park 17 Units of Service 0 0 0 0 0 0 0 18 Allocated Cost - S 0 0 0 0 0 0 0 0 19 Total Wholesale 235,200 90,400 57,000 0 42,400 45,300 100 0 '20 Total Allocated Costs 8,285,200 2,650,800 1,674,400 1,030,400 1,203,800 1,203,900 443,800 78,100 Line No. Customer Class 13 Wholesale 14 Total Table 5-16 City of Round Rock, Texas Wastewater Utility Comparison of Allocated Costs with Revenue Under Existing Rates 2004 Test Year ( ( ( Revenue Allocated Redistributed Adjusted Under Indicated Cost of City Wastewater Cost of Existing Revenue Service Costs Service Rates Adjustment Inside City 1 Residential 5,086,300 28,800 5,115,100 4,729,200 7.6 2 Commercial 1,747,700 9,800 1,757,500 1,491,200 17.2 3 Industrial 36,500 200 36,700 29,700 22.9 4 Apartments 606,300 3,400 609,700 567,600 6.8 5 Governmental 38,000 200 38,200 44,700 (15.0) 6 City 45,100 (45,100) 0 0 0.0 7 Surcharge 229,200 1,300 230,500 203,100 12.9 8 Total Inside City 7 (1,400) 7,787,700 7,065,500 10.2 Outside City 9 Chandler Creek Residential 244,500 1,400 245,900 235,900 3.6 10 Chandler Creek Commercial 6,900 0 6,900 7,300 (5.5) 11 Outside City No Classification 9,500 0 9,500 7,200 31.9 12 Total Outside City 260,900 1,400 262,300 250,400 4.2 235,200 0 235,200 285,200 (17.5) 8,285,200 0 8,285,200 7,601,100 9.0 Table S -17 City of Round Rock, Texas Wastewater Utility Existing and Proposed Rates (1) (2) (3) (4) Option A Option B Option C Existing Proposed Proposed Proposed Rates Rates Rates Rates $ $ $ $ Minimum Charge - $/Month Meter Size 5/8" 8.60 8.60 8.60 9.41 3/4" 11.40 11.40 11.40 11.85 1" 17.00 17.00 17.00 17.00 1 1/2" 31.00 31.00 31.00 31.00 2" 47.80 47.80 47.80 45.00 3" 87.00 87.00 87.00 85.00 4" 143.00 143.00 143.00 140.00 6" 451.00 451.00 451.00 435.00 8" 787.00 787.00 787.00 765.00 10" 1,235.00 1,235.00 1,235.00 1,235.00 12" 1,515.00 1,515.00 1,515.00 1,515.00 Volume Charge - $ /1,000 gallons Residential 1.89 2.18 2.12 1.93 Commercial 1.89 2.18 2.12 1.93 Industrial 1.89 2.18 2.12 1.93 Apartments 1.89 2.18 2.12 1.93 Government 1.89 2.18 2.12 1.93 Surcharge - $/pound BOD in excess of 250 m/gl 0.27000 029835 0.29835 0.29835 TSS in excess of 250 m/g1 0.27000 0.29835 0.29835 0.29835 Option A - Winter average billing basis for all customer classes. Option B - Winter average billing basis for residential customers & 70% of actual water use for all other customer classes. Option C - Winter average billing basis for residential customers & 80% of actual water use for all other customer classes. Proposed Rates Current Indicated Proposed Meter Billable Existing Increase Percentage Size Volume (a) Rates Total (Decrease) Change Inches Mgal Residential 5/8 0 8.60 8.60 0.00 0.0% 5/8* 5 18.05 19.50 1.45 8.0% 5/8 10 27.50 30.40 2.90 10.5% 5/8 15 3t..95 41.30 4.35 11.8% 5/8 20 46.40 52.20 5.80 12.5% 5/8 25 -55.85 63.10 7.25 13.0% Commercial 5/8 10 27.50 30.40 2.90 10.5% 5/8 20 46.40 52.20 5.80 12.5% 5/8 30 65.30 74.00 8.70 13.3% 1 * 50 111.50 126.00 14.50 13.0% 1 85 177.65 202.30 24.65 13.9% 1 100 206.00 235.00 29.00 14.1% 2 200 425.80 483.80 58.00 13.6% Industrial 5/8 40 84.20 95.80 11.60 13.8% 5/8 80 159.80 183.00 23.20 14.5% 2 100 236.80 265.80 29.00 12.2% 2 * 150 331.30 374.80 43.50 13.1% 2 200 425.80 483.80 58.00 13.6% Apartments 5/8* 60 122.00 139.40 17.40 14.3% 5/8 100 197.60 226.60 29.00 14.7% 5/8 150 292.10 335.60 43.50 14.9% 1 200 395.00 453.00 58.00 14.7% 1 250 489.50 562.00 72.50 14.8% 2 300 614.80 701.80 87.00 14.2% Mgal - 1,000 gallons * Represents average user Table S -18A City of Round Rock, Texas Wastewater Utility Comparison of Typical Bills Under Existing and Proposed Rates 2004 Test Year Option A (1) (2) (3) (4) (5) (a) Winter average billing basis for all customer classes. Current Proposed Indicated Proposed Meter Billable Billable Existing Increase Percentage Size Volume (a) Volume (b) Rates Total (Decrease) Change Inches Mgal Mgal $ $ $ Residential 5/8 0 0 8.60 8.60 0.00 0.0% 5/8* 5 5 18.05 19.20 1.15 6.4% 5/8 10 10 27.50 29.80 2.30 8.4% 5/8 15 15 36.95 40.40 3.45 9.3% 5/8 20 20 46.40 51.00 4.60 9.9% 5/8 25 25 55.85 61.60 5.75 10.3% Commercial 5/8 10 11 27.50 31.92 4.42 16.1% 5/8 20 22 46.40 55.24 8.84 19.1% 5/8 30 32 65.30 76.44 11.14 17.1% 1 * 50 54 111.50 131.48 19.98 17.9% 1 85 92 177.65 212.04 34.39 19.4% 1 100 108 206.00 245.96 39.96 19.4% 2 200 216 425.80 505.72 79.92 18.8% Industrial 5/8 40 35 84.20 82.80 (1.40) -1.7% 5/8 80 71 159.80 159.12 (0.68) -0.4% 2 100 89 236.80 236.48 (0.32) -0.1% 2* 150 133 331.30 329.76 (1.54) -0.5% 2 200 177 425.80 423.04 (2.76) -0.6% Apartments 5/8* 60 63 122.00 142.16 20.16 16.5% 5/8 100 105 197.60 231.20 33.60 17.0% 5/8 150 158 292.10 343.56 51.46 17.6% 1 200 210 395.00 462.20 67.20 17.0% 1 250 263 489.50 574.56 85.06 17.4% 2 300 315 614.80 715.60 100.80 16.4% Mgal - 1,000 gallons * Represents average user Table S -18B City of Round Rock, Texas Wastewater Utility Comparison of Typical Bills Under Existing and Proposed Rates 2004 Test Year Option B ( ( (3) ( ( ( (a) Winter average billing basis. (b) Winter average billing basis for residential & 70% of actual water use for all other customer classes. Proposed Rates Proposed Rates Current Proposed Indicated Proposed Meter Billable Billable Existing Increase Percentage Size Volume (a) Volume (b) Rates Total (Decrease) Change Inches Mgal Mgal $ $ $ Residential 5/8 0 0 8.60 9.41 0.81 9.4% 5/8* 5 5 18.05 19.06 1.01 5.6% 5/8 10 10 27.50 28.71 1.21 4.4% 5/8 15 15 36.95 38.36 1.41 3.8% 5/8 20 20 46.40 48.01 1.61 35% 5/8 25 25 55.85 57.66 1.81 3.2% Commercial 5/8 10 12 27.50 32.57 5.07 18.4% 5/8 20 25 46.40 57.66 11.26 24.3% 5/8 30 37 65.30 80.82 15.52 23.8% 1 * 50 62 111.50 136.66 25.16 22.6% 1 85 105 177.65 219.65 42.00 23.6% 1 100 124 206.00 256.32 50.32 24.4% 2 200 248 425.80 523.64 97.84 23.0% Industrial 5/8 40 41 84.20 88.54 4.34 5.2% 5/8 80 82 159.80 167.67 7.87 4.9% 2 100 102 236.80 241.86 5.06 2.1% 2 * 150 153 331.30 340.29 8.99 2.71/4 2 200 204 425.80 438.72 12.92 3.0% Apartments . 5/8* 60 72 122.00 148.37 26.37 21.6% 5/8 100 120 197.60 241.01 43.41 22.0% 5/8 150 180 292.10 356.81 64.71 22.2% 1 200 240 395.00 480.20 85.20 21.6% 1 250 300 489.50 596.00 106.50 21.8% 2 300 360 614.80 739.80 125.00 20.3% Mgal - 1,000 gallons * Represents average user Table S -18C City of Round Rock, Texas Wastewater Utility Comparison of Typical Bills Under Existing and Proposed Rates 2004 Test Year Option C ( ( ( ( ( ( (a) Winter average billing basis. (b) Winter average billing basis for residential & 80% of actual water use for all other customer classes. Customer Class Table S -19A City of Round Rock, Texas Wastewater Utility Comparison of Adjusted Cost of Service with Revenue Under Proposed and Existing Rates 2004 Test Year Option A Inside City s 1 Residential 5,131,400 5,115,100 4,729,200 100.3 8.5 2 Commercial 1,669,400 1,757,500 1,491,200 95.0 12.0 3 Industrial 33,700 36,700 29,700 91.8 13.5 4 Apartments 629,700 609,700 567,600 1033 10.9 5 Governmental 48,600 38,200 44,700 127.2 8.7 6 City 0 0 0 0.0 0.0 7 Surcharge 224,400 230,500 203,100 97.4 10.5 8 Total Inside City 7,737,200 7,787,700 7,065,500 99.4 9.5 Outside City 9 Chandler Creek Residential 254,200 245,900 235,900 103.4 7.8 10 Chandler Creek Commercial 8,100 6,900 7,300 117.4 11.0 11 Outside City No Classification 7,500 9,500 7,200 78.9 4.2 12 Total Outside City 269,800 262,300 250,400 102.9 7.7 13 Wholesale 285,200 235,200 285,200 121.3 0.0 14 Total 8,292,200 8,285,200 7,601,100 100.1 9.1 Option A assumes winter average billing basis for all customer classes. (1) (2) (3) (4) (5) Indicated Increase Revenue Revenue Revenue As (Decrease) Under Under A Percent Over Proposed Cost of Existing of Cost of Existing Rates Service Rates Service Rates ( (1)1(3) Customer Class . Table S -19B City of Round Rock, Texas Wastewater Utility Comparison of Adjusted Cost of Service with Revenue Under Proposed and Existing Rates 2004 Test Year Option B ( ( ( ( ( Indicated Increase Revenue Revenue Revenue As (Decrease) Under Under A Percent Over Proposed Cost of Existing of Cost of Existing Rates Service Rates Service Rates $ $ $ % % ( ( Inside City 1 Residential 5,048,200 5,115,100 4,729,200 98.7 6.7 2 Commercial 1,737,700 1,757,500 1,491,200 98.9 16.5 3 Industrial 29,700 36,700 29,700 80.9 0.0 4 Apartments 637,700 609,700 567,600 104.6 12.4 5 Governmental 54,400 38,200 44,700 142.4 21.7 6 City _ 0 0 0 0.0 0.0 7 Surcharge 224,400 230,500 203,100 97.4 10.5 8 Total Inside City 7,732,100 7,787,700 7,065,500 99.3 9.4 Outside City 9 Chandler Creek Residenti 250,400 245,900 235,900 101.8 6.1 10 Chandler Creek Commerc 8,400 6,900 7,300 121.7 15.1 11 Outside City No Classific 7,300 9,500 7,200 76.8 1.4 12 • Total Outside City 266,100 262,300 250,400 101.4 63 13 Wholesale 285,200 235,200 285,200 121.3 0.0 14 Total 8,283,400 8,285,200 7,601,100 100.0 9.0 Option B assumes winter average billing basis for the residential customer class and 70% of actual water use for all other customer classes. Customer Class Table S-19C City of Round Rock, Texas Wastewater Utility Comparison of Adjusted Cost of Service with Revenue Under Proposed and Existing Rates 2004 Test Year Option C (1) (2) ( (4) ( Indicated Increase Revenue Revenue Revenue As (Decrease) Under Under A Percent Over Proposed Cost of Existing of Cost of Existing Rates Service Rates Service Rates (1) / (2) (1) / (3) Inside City 1 Residential 4,982,600 5,115,100 4,729,200 97.4 5.4 2 Commercial 1,790,900 1,757,500 1,491,200 101.9 20.1 3 Industrial 30,400 36,700 29,700 82.8 2.4 4 Apartments 653,300 609,700 567,600 107.2 15.1 5 Governmental 55,200 38,200 44,700 144.5 23.5 6 City . 0 0 0 0.0 0.0 7 Surcharge 224,400 230,500 203,100 97.4 10.5 8 Total Inside City 7,736,800 7,787,700 7,065,500 99.3 9.5 Outside City 9 Chandler Creek Residenti 249,300 245,900 235,900 101.4 5.7 10 Chandler Creek Commerc 8,700 6,900 7,300 126.1 19.2 11 Outside City No Classifica 6,700 9,500 7,200 70.5 (6.9) 12 • Total Outside City 264,700 262,300 250,400 100.9 5.7 13 Wholesale 285,200 235,200 285,200 121.3 0.0 14 Total 8,286,700 8,285,200 7,601,100 100.0 9.0 Option C assumes winter average billing basis for the residential customer class and 80% of actual water use for all other customer classes. COMBINED UTILITIES NM - - - • MI OM MI I• I MI • MI == Line No, Asmara Description 29 Eovimommtal Services 30 UOhty Bangs & Callecbom Table C -1 City of Round Rock, Texas Combined Utility Budgeted and Projected Operating & Maintenance Expenses Budget Budget Ptolated 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 S S S S S S S S Water Treatment Plant 1 Reserve Water 1,680,900 1,610,000 1,762,500 1,933,500 2,125,600 2,233,600 2,347,200 2,466,700 2,592,600 2,725,000 2,864,400 3,011,200 2 Raw Water 231,800 263,000 302,500 347,900 400,100 420,100 441,100 463,200 486,400 510,700 536,200 563,000 3 O&M Lake Snllhouse 300,000 125,000 128,800 132,700 136,700 140,800 145,000 149,400 153,900 158,500 163,300 168,200 4 Power &Light 1,675,000 1,450,000 1,535,900 1,626,900 1,723,300 1,825,400 1,933,500 2,048,000 2,169,300 2,297,800 2,433,900 2,578,100 Chemicals 180,000 210,000 222,500 235,600 249,600 264,400 280,000 296,600 314,200 332,900 352,600 373,500 All Other 1,396,400 1,195,800 1,231,800 1,268,700 1,306,700 1,345,900 1,386,300 1,427,900 1,470,700 1,514,800 1,560,200 1,607,000 7 Taal Water Treatment Plant 5,464,100 4,853,800 5,184,000 5,545,300 5,942,000 6,230,200 6,533,100 6,851,800 7,187,100 7,539,700 7,910,600 8,301,000 Water Systems Support 8 Power &Light 256,000 200,000 211,800 224,300 237,600 251,700 266,600 282,400 299,10D 316,800 335,600 355,500 9 R&M Meters 140,000 63,700 65,600 67,600 69,600 71,700 73,900 76,100 78,400 80,700 83,100 85,600 10 R&M Wells &Boost.. 205,000 210,000 216,300 222,800 229,500 236,400 243,500 250,800 258,300 266,000 274,000 282,200 11 All Other 1,140,100 861,500 887,300 913,900 941,300 969,500 998,700 1,028,700 1,059,600 1,091,400 1,124,100 1,157,700 12 Total Water Systems Support 1,741,100 1,335,200 1,381,000 1,428,600 1,478,000 1,529,300 1,582,700 1,638,000 1,695,400 1,754,900 1,816,800 1,881,000 Water Lin. Maintenance 13 R &M Lutes 248,900 242,700 250,000 257,500 265,200 273,200 281,400 289,800 298,500 307,500 316,700 326,200 14 ABOWer 1,913,800 1,784,100 1,837,700 1,892,800 1,949,700 2,008,200 2,068,400 2,130,400 2,194,400 2,260,200 2,328,000 2,397,800 15 Total Water Lines Maoteoanoe 2,162,700 2,026,800 2,087,700 2,150,300 2,214,900 2,281,400 2,349,800 2,420,200 2,492,900 2,567,700 2,644,700 2,724,000 Wastewater Treatment Plant 16 S W. Interceptor - Capital Chgs. 136,000 136,000 140,100 144,300 148,600 153,100 157,700 162,400 167,300 172,300 177,500 182,800 17 Sewage Semmes - Opereboos 2,040,000 2,167,000 2,015,600 2,082,900 2,150,800 2,221,100 2,060,000 2,106,800 2,154,400 2,202,400 2,253,300 2,253,300 18 Sewage Samna- Capital 2,433,000 2,567,000 4,234,900 5,000,600 5,803,600 6,542,800 6,797,000 7,046,000 7,429,200 8,018,000 8,469,700 8,469,700 19 All Other 10,000 0 0 0 0 0 0 0 0 0 0 0 20 Total Wastewater Treatment Plant 4,619,000 4,870,000 6,390,600 7,227,800 8,103,000 8,917,000 9,014,700 9,315,200 9,750,900 10,392,700 10,900,500 10,905,800 Wastewater Systems Support 21 Power &Light 50,000 40,000 42,700 45,500 48,500 51,700 55,100 58,800 62,700 66,900 71,300 76,000 22 O &M Yana Oaks 20,000 0 0 0 0 0 0 0 0 0 0 0 23 R &MLtft Stations 35,000 55,000 56,700 58,400 60,200 62,000 63,900 65,800 67,800 69,800 71,900 74,100 24 All Other 329,300 385,500 397,000 408,900 421,200 433,900 446,900 460,200 474,000 488,300 502,900 518,000 25 Taal Wastewater Systems Support. 434,300 480,500 496,400 512,800 529,900 547,600 565,900 584,800 604,500 625,000 646,100 668,100 Wastewater Lutes Maintenance 26 R &M Lines 85,000 177,500 182,800 188,300 193,900 199,700 205,700 211,900 218,300 224,800 231,500 238,400 27 All Other 1,325,600 1,393,600 1,433,300 1,478,300 1,522,600 1,568,300 1,615,400 1,663,800 1,713,600 1,765,100 1,818,100 1,872,600 28 Total Wastewater Lima Maiote0850e 1,410,600 1,571,100 1,618,100 1,666,600 1,716,500 1,768,000 1,821,100 1,875,700 1,931,900 1,989,900 2,049,600 2,111,000 394,400 359,600 370,300 381,400 392,800 404,700 416,900 429,300 442,200 455,400 469,000 483,000 912,200 853,200 878,800 905,200 932,400 960,400 989,300 1,018,900 1,049,500 1,081,100 1,113,400 1,146,700 Transfers Department 31 Contractual Obligatons - BRA 671,400 728,300 750,200 772,700 795,900 819,800 844,400 869,700 895,80D 922,700 950,400 978,900 32 All Otter 0 165,000 170,000 175,200 880,400 185,800 191,400 197,200 203,000 209,200 215,400 222,000 33 Taal Transfers Department 671,400 893,300 920,200 947,900 976,300 1,005,600 1,035,800 5,066,900 1,098,800 1,131,900 1,165,800 1,200,900 34 Mimes Administration 0 888,600 915,200 942,600 970,800 999,900 1,029,800 1,060,700 1,092,500 1,125,200 1,158,900 1,193,600 35 Total O &M Expense 17,809,800 18,172,100 20,242,300 21,708,500 23,256,600 24,644,100 25,339,100 26,261,500 27,345,700 28,663,500 29,875,400 30,615,100 •- - - N . ow No No ow o - - - - - - - - Il= Line FisLal Year Ending September 30 No. Description 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Table C -2 City of Round Rock, Texas Combined Utilities Capital Improvement Program Financing Plan Source of Funds: 1 Beginning of Year Balance 37,867,700 11,677,600 2,653,700 54,900 49,900 3,040,700 6,173,200 9,662,100 11,428,800 9,892,700 7,445,500 2 Revenue Bond Proceeds 0 13,900,000 4,000,000 3,850,000 3,300,000 2,900,000 1,100,000 800,000 1,000,000 900,000 0 3 Transfer from Operating Fund 0 1,150,000 1,200,000 1,400,000 800,000 700,000 1,150,000 1,150,000 750,000 700,000 450,000 4 Impact Fees 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000 3,500,000. 3,500,000 5 Interest Income 495,400 281,000 66,700 39,100 63,600 120,800 169,200 218,800 223,100 182,300 129,600 6 Total Funds Available 41,863,100 30,508,600 11,420,400 8,844,000 7,713,500 10,261,500 12,092,400 15,330,900 16,901,900 15,175,000 11,525,100 Application of Funds: 7 Major Capital Improvements 30,185,500 27,368,400 11,225,500 8,659,300 4,557,300 3,986,800 2,391,800 3,874,100 6,974,200 7,698,000 6,003,600 8 Surety Bonds 0 139,000 40,000 38,500 33,000 29,000 11,000 8,000 10,000 9,000 0 9 BondlssuanceCosts 0 347,500 100,000 96,300 82,500 72,500 27,500 20,000 25,000 22,500 0 10 Total Funds Applied 30,185,500 27,854,900 11,365,500 8,794,100 4,672,800 4,088,300 2,430,300 3,902,100 7,009,200 7,729,500 6,003,600 11 End of Year Fund Balance 11,677,600 2,653,700 54,900 49,900 3,040,700 6,173,200 9,662,100 11,428,800 9,892,700 7,445,500 5,521,500 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Table C-3 City of Round Rock, Texas Combined Water and Wastewater Utilities Comparison of Projected Revenue and Revenue Requirements Under Increased Revenue Lime Fiscal Year Endmq September 30 No Desenptson 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 I 5 5 S S 5 5 5 5 5 Eusung Sala Revenue 21,622,900 22, 224, 500 22, 840, 800 22 ,659,600 23,017,700 23,668,000 24345,200 25,032,800 25,736,400 26,454,000 27,186,800 Addmooel Revenue Reamed Revenue Months Year Inmeam ERearve 2 2003 00% 9 0 0 0 0 0 0 0 0 0 0 0 3 2004 31% 9 513,100 703,000 723,600 744,700 766,000 787,700 809,600 832,100 855,100 878,500 4 2005 49% 9 856,500 1,154,300 1,180,300 1,213,900 1,248300 1,283,400 1,319,300 1355,800 1,393,100 5 2006 50% 9 925,800 1,262,500 1,298,500 1335,400 1372.900 1,411,300 1,450300 1,490,200 6 2007 35% 9 683,100 936,900 963,400 990,200 1,017,800 1,045,800 1,074,500 7 2008 3694 9 762,400 1,045,300 1,074,400 1,104,300 1,134,700 1,165,800 8 2009 00% 9 0 0 0 0 0 9 2010 00% 9 0 0 0 0 10 2011 00% 9 0 0 0 11 2012 18% 9 434,500 595,200 12 2013 00% 9 0 13 Total Addmonal Revenue 0 513,100 1 ,559,500 2,803,700 3,870,600 4,977,700 5380,100 5,530,500 5,684, 6,276,200 6,597,300 14 Total Revenue 21,622,900 22,737,600 24,400,300 23,463,300 26,888,300 28,645,700 29,725300 30,563,300 31,421,200 32,730,200 33,784,100 15 Other Opemtmg Revenue 637,400 679,400 679,400 679,400 679,400 679,400 679,400 679,400 679,400 679,400 679,400 16 154ere010000,e 114,900 131,600 125,100 115,100 112,400 116,700 122,100 125,800 130,400 136,200 142,400 17 I Total Revenue 22375 ,200 23,548,600 25304,800 26,257,800 27,680,100 29,441,800 30,526,800 31368,500 32,231,000 33,545,800 34,605,900 18 Operettas and Mamtenanoe Expense 17,809,800 18,132,100 20,242,400 21,708500 23256,600 24,644,200 25,339,363 26,261,700 27,345,800 28,663,600 29,875,400 Deli Semis 19 Existing Revenue Bonds 1,392,400 1,279,900 1,016,000 284,300 0 0 0 0 0 20 Proposed Revenue Bonds 0 1,130,900 1,456300 1, 769,600 2, 038,100 2,274, 000 2, 363, 500 2, 428 ,600 2,510,000 2,583 ,200 2,583,200 21 Total Revenue Bonds 1,392,400 2, 410, 800 2,472300 2, 053, 900 2, 038,100 2, 274, 000 2,363,500 2,428,600 2,510,000 2,583,200 2583,200 General Obbgation 22 Exrsung General Oblgation Bonds 398,100 655,500 701,900 223,600 233,300 223,100 161,900 89,300 0 23 Routine Capital Outlay 451,800 380,300 391,800 403,500 415,800 428,400 441,300 454,600 468,300 482,400 496,900 Transfers: 24 Transfer to C99909eb99 Fund 0 1,150,000 1 ,200,000 1,400,000 800,000 700,000 1,150,000 1,150,000 750,000 700,000 450,000 25 Transfer to General Fund 1,400,000 1,640,000 1,640,000 1,640,000 1,640,000 1,640,000 1,640,000 1,640,000 1,640,000 1,640,000 1,640.000 26 Transfer Rom Impact Fees (800,000) (800,000) (800,000) (800,000) (800,000) (800,000) (800,000) (800,000) (800,000) (800,000) (800,000) 27 Total Transfers 600,000 1,990,000 2,040,000 2,240,000 1,640,000 1,540,000 1,990,000 1,990,000 1,590,000 1,540,000 5,290,000 28 Total Revenue Requuements 20,652,100 23,568,700 25,848,400 26,629,500 27,583,800 29,109,700 30 ,296,000 31224 ,200 31,914,100 33269,200 34,245,500 29 Net Annual Balance 30 Begiwmg of Year Balance 31 End of Year Balance 32 Targeted End of Year Balance Coverage 33 Net Revalue (a) 4565,400 5,416,500 4,962,400 4,549,300 4,423500 4,797,600 5,187,500 5,106,800 4,885200 4,882 ,200 4,730,500 34 Revenue Bond Debt Serene Coverage (b) 32788% 224 68% 20032% 221.50% 21704% 21098% 219.48% 21028% 19463% 18900% 18313% 35 Total Bond Debt Semee Coverage (c) 2550% 1766% 1563% 199,7 %. 1947% 1921% 2054% 2028% 1946% 1890% 1831% 35 Days of Operating Reserve 138 135 109 96 91 91 91 50 91 90 91 (a) Total Revenue (Line 17) Leas Operation end Mmetenance Expand (Lute 18) (b) Represents c0vemge of total 'annual' debt mono, (Lute 331 Lme 21) (c) Represents coverage of total 'annual debt senses (line 33 /(Lure 21 *Line 22)) 1,723,100 (20,100) (643,600) (371,700) 96,300 332,100 230,800 144300 316,900 276,600 360,400 5,000,000 6,723,100 6,703,000 6,059,400 5,687,700 5,784,000 6,116,100 6,346,900 6,491,200 6,808,100 7,084,700 6,723,100 6,703,000 6,059,400 5,687,700 5,784,000 6,116,100 6,346,900 6,491,200 6,808,100 7,084,700 7,445,100 4,452,500 4,533,000 5,060,600 5,427,100 5,814,200 6,161,100 6,334,800 6,565,400 6,836,500 7,165,900 7,468,900 Table C-4A City of Round Rock, Texas Combined Utilities Comparison of Typical Bills Under Existing and Proposed Rates Test Year Ending September 30, 2004 Option A Proposed Rates Indicated Proposed Current Proposed Increase Percentage Quantity Bill Bill (Decrease) Change Mgal Mgal $ $ Residential Water Use 10 30.70 30.70 0.00 0.0% Wastewater Volume Current Winter Average 5 18.05 19.50 1.45 8.0% Total 48.75 5020 1.45 3.0% Commercial Water Use 85 188.13 188.13 0.00 0.0% Wastewater Volume Current Winter Average 50 111.50 126.00 14.50 13.0% Total 299.63 314.13 14.50 4.8% Industrial Water Use • 200 459.75 459.75 0.00 0.0% Wastewater Volume Current Winter Average 150 331.30 374.80 43.50 13.1% Total 791.05 834.55 43.50 5.5% Apartments Water Use 100 202.60 202.60 0.00 0.0% Wastewater Volume Current Winter Average 60 122.00 139.40 17.40 14.3% Total 324.60 342.00 17.40 5.4% Mgal -1,000 gallons Option A - Winter average billing basis for all customer classes. Table C-4B City of Round Rock, Texas Combined Utilities Comparison of Typical Bills Under Existing and Proposed Rates Test Year Ending September 30, 2004 Option B Proposed Rates Indicated Proposed Current Proposed Increase Percentage Quantity Bill Bill (Decrease) Change Mgal Mgal $ $ % Residential Water Use 10 30.70 30.70 0.00 0.0% Wastewater Volume Current Winter Average 5 18.05 19.20 1.15 6.4% Total 48.75 49.90 1.15 2.4% Commercial Water Use 85 188.13 188.13 Wastewater Volume Current Winter Average 50 111.50 70% of Actual Water Use 60 144.20 Total 299.63 332.33 32.70 10.9% Industrial Water Use 200 459.75 459.75 Wastewater Volume Current Winter Average 150 331.30 70% of Actual Water Use 140 344.60 Total 791.05 804.35 1330 1.7% Apartments. Water Use 100 202.60 202.60 Wastewater Volume Current Winter Average 60 122.00 70% of Actual Water Use 70 157.00 Total 324.60 359.60 35.00 10.8% Mgal - 1,000 gallons Option B - Winter average billing basis for residential customers & 70% of actual water use for all other customer classes. Table C-4C City of Round Rock, Texas Combined Utilities Comparison of Typical Bills Under Existing and Proposed Rates Test Year Ending September 30, 2004 Option C Proposed Rates Indicated Proposed Current Proposed Increase Percentage Quantity Bill Bill (Decrease) Change Mgal Mgal $ $ % Residential Water Use 10 30.70 30.70 0.00 0.0% Wastewater Volume Current Winter Average 5 18.05 19.06 1.01 5.6% Total 48.75 49.76 1.01 2.1% Commercial Water Use 85 188.13 188.13 Wastewater Volume Current Winter Average 50 111.50 80% of Actual Water Use 68 148.24 Total 299.63 336.37 36.74 12.3% Industrial Water Use 200 459.75 459.75 Wastewater Volume Current Winter Average 150 331.30 80% of Actual Water Use 160 353.80 Total • 791.05 813.55 22.50 2.8% Apartments Water Use 100 202.60 202.60 Wastewater Volume Current Winter Average 60 122.00 80% of Actual Water Use 80 163.81 Total 324.60 366.41 41.81 12.9% Mgal - 1,000 gallons Option C - Winter average billing basis for residential customers & 80% of actual water use for all other customer classes. APPENDIX City of Round Rock Wholesale Water Contracts Aqua Source Contract Start: September 28, 2000 Contract End: September 28, 2040 Article II, Sec. 2.02 Water Rates: The rate to be charged and paid by Aqua Source for water actually delivered pursuant to this Agreement shall be set by ordinance as amended from time to time by the Round Rock City Council. Said rates shall be reasonable and non- discriminatory. The rate in effect on the effective date of this Agreement is composed of a volume charge of $1.30/1,000 gallons and a monthly demand charge of $4,185. Article II, Sec. 2.03 Metering Equipment: Aqua Source, at its sole expense, shall install and maintain at the Point(s) of Delivery when necessary metering equipment and required devices of standard type to measure properly the quantity of water delivered to Aqua Source. Thereafter, Aqua Source as its cost shall calibrate the metering equipment at the Point(s) of Delivery once every 12 months; provided, however, the cost of calibrating the metering equipment shall be borne by the City if such calibration is requested more frequently than once every 12 months. Aqua Source shall notify the City at least 3 days prior to any such calibrations and the City shall have the right to have a representative present during such calibrations. A meter registering not more than 3% above or below the test result shall be deemed to be accurate. The previous readings of any meter disclosed by test to inaccurate and the statement of charges for water delivered to Aqua Source shall be corrected for the 3 months previous to such test in accordance with the percentage of inaccuracy found by such test. If the meter fails to register for any period, the amount of water furnished during such period shall be deemed to be the amount of water delivered in the corresponding period immediately prior to the failure adjusting for seasonal differences, unless the City and Aqua Source shall agree upon a different amount. The metering equipment register shall be read on or about the first day of each month during normal business hours. Article IV, Sec. 5.01 Impact Fees for New Connections: For each new connection to its water system, Aqua Source agrees to pay to City any and all water impact fees adopted by the City Council which are applicable to all new connections to the City's water system. Aqua Source agrees to notify the City on a monthly basis of the date and address of all new connections to Aqua Source's water system. New connection impact fees established by the City amount to $2,345 per residential living unit equivalent. Chandler Creek Contract Start: May 10, 1984 Article II, Paragraph 1 The City agrees to sell and to deliver water within the boundaries of the District for domestic and commercial uses, such water to be supplied from the City's water distribution system as extended by the District pursuant to the Construction Contract. The City presently has an adequate water supply to supply service to the District. Subject to the City's right to reasonably limit the supply of water to the District residents on the same basis and to the same extent as the supply of water to any other customers within the City, the City agrees that it will provide the District an adequate water supply to serve the District as it develops with a total of 2506 living unit equivalents of water connection rights to ultimately be provided to the District when it is fully developed. Article H, Paragraph 2 On behalf of the District, the City agrees to sell and deliver water service to the Users within the District. Said sales will be directly to the residents of the District, and no master meter will be installed for billing purposes. The rates charged by the City to the District for Users of the District for water actually delivered pursuant to this agreement shall be the same as the water rates which the City charges its retail residential and commercial customers (with equivalent sized meters) inside its city limits. The City shall not charge the District or the Users within the District any water actually delivered that it does not charge its residential or commercial customers inside its city limits and shall not charge the District or the Users within the District any fee, assessment, or other charge for water actually delivered as a functional equivalent of ad valorem property taxes which customer inside the city limits are required to pay. Article II, Paragraph 6 (a) The City shall bear all responsibility to operate, manage, maintain and repair at its expense for the District all of the District facilities. Article II, Paragraph 6(b) Facilities shall include: (1) all water facilities and related appurtenances located within public rights of way or dedicated easements within the District. (2) All water facilities within the District which the District may construct, purchase, own or operate in the future and for which plans and specifications have been approved by the City. Article H, Paragraph 6 (c) The responsibility of the City for the operation, management, maintenance and repair of the District Facilities includes the responsibility for all costs of operation, management and maintenance of the District Facilities, including, but not limited to, repairs, upkeep and replacements, cost of utilities, supervision, engineering, accounting, legal work, auditing, insurance and any other supplies, services, administrative costs and equipment necessary for the operation, management and maintenance of the District Facilities. Article H, Paragraph 6 (d) Ownership of the District Facilities described in Subparagraph 6 (b) shall remain in the District, which shall have the right to inspect them at all times. The City owns or has reserved the oversize capacity in specified portion of the District Facilities as set forth in the June 26, 1986 "Utility Construction Contract Between the City of Round Rock, Texas, The Meadows at Chandler Creek Municipal Utility District." Fern Bluff Contract Start: March 28, 1985 Contract End: March 27, 2025 Article 11, Sec.2.01 Water Service: The City shall deliver and sell water to the District, for commercial and domestic uses, to be supplied from the City's water treatment and distribution system. The City presently has and will maintain and adequate water supply with which to meet the District's current needs. Article II, Sec. 2.02 Water Rates: The rate to be charged to and paid by the District for water actually delivered pursuant to this Agreement shall be set by ordinance as amended from time to time by the Round Rock City Council _ Said rates shall be reasonable as that terms is used in $12.013 of the Texas Water Code and shall be based upon the same general methodology used to determine the rates set forth in this paragraph. The base water rates for the 1991 -1992 fiscal year beginning October 1, 1991, shall be $10.485 per active connection per month within the District. The gallonage rate, shall be $1.76 per 1,000 gallons beginning October 1, 1991, may be adjusted from time to time in the same manner and amounts as it is adjusted for in -city customers of the City. Article II, Sec. 2.03 • Metering Equipment: The District, at its sole expense, shall install and maintain at the Point(s) of Delivery the necessary metering equipment and required devices of standard type to measure properly the quantity of water delivered to the District. The City, at its sole expense, shall install and maintain at any point where water passes from facilities, to be delivered to other customers of the City, the necessary metering equipment and required devices of standard type to measure properly the quantity of water delivered from the District's facilities to such other customers. Article V, Sec. 5.01 Water Impact Fee: For each new connection to this water system, the District agrees to pay any and all water impact fees adopted by the City Council which are applicable to all new connection to the City's water system. The water impact fees shall be adopted in accordance with Chapter 395 of the Texas Local Government Code. The District agrees to notify City on a monthly basis of all new connections to the District's water system. The payment of all impact fees shall be due and payable within 30 days of the date of the connection to the system. Manville Water Suppiv Contract Start: January, 14, 1988 Contract End: Until terminated my mutual agreement Recitals It would be beneficial to the City and Manville to construct an interconnect between the two systems to allow for the temporary transfer of water from one system to the other in the event of an emergency. Article II, Sec. 2.02 Provisions for Connection and Water Service: In the event an emergency occurs affecting Manville's water system, the city agrees to sell water to Manville for a period of thirty days or until the emergency is over, whichever first occurs. In the event Manville wishes to purchase water for more than 30 days, it shall submit a request in writing to the Round Rock Council, who shall determine whether or not to honor the request. Article III, Sec. 3.01 Rates: The party withdrawing water agrees to pay to the party providing water at the higher wholesale or bulk rate charged by either party to its own customers. Article IV, Sec. 4.02 Miscellaneous: Contract is effective from the date of its execution by both parties and continues in effect until terminated by mutual agreement or at the option of either party by giving 180 days written notice to other party. R &R Mobile Contract Start: January 27th, 2000 Contract End: January 27th, 2030 Article II, Sec. 2.01 Delivery of Supply of Waier: Beginning on the Start Date, the City shall deliver and sell water to R &R, for residential and commercial uses only, from the City's water treatment and distribution system. The City presently has and will maintain an adequate water supply with which to meet R &R's current and future needs, but is not obligated to provide service for more than 230 LUEs. Quantity of Water Service: The quantity of water service delivered by the City shall be measured by master meters at all Point(s) of Delivery. Regardless of anything contained herein to the contrary, the number of LUE's of water service provided herein is limited to no more than 230 LUE's, unless this Agreement is amended in writing by the parties. Article II, Sec. 2.02 Water Service Rates and Procedures: The City shall charge and R&R shall pay the City, for water service received at the applicable wholesale water rate and under the billing, payment, collection and disconnect procedures as established by the City Council and as amended from time to time. The initial rate for water will be $1.27/1,000 gallons of water metered at the point of entry plus a monthly demand charge $850.00. The City will notify R &R at least 60 days before any rate increase for R&R becomes effective. Any increase in rate for R&R must be based upon an increase in the actual cost of service as determined by a rate study using standard methodologies. The rate study must be provided to R&R 30 days before the rate increase is adopted. Article II, Sec. 2.03 Metering Equipment: R &R, at its sole expense, shall install and maintain at the Point(s) of Delivery the necessary metering equipment and required devices of standard type to measure properly the quantity of water delivered to R &R. Once installed, the meters shall be owned by the City. From time to time the City shall have the option of calibrating the meters at its cost. Article VI, Sec. 6.01 Impact Fees for New Connection: For each new connection to its water system, R &R agrees to pay any and all water impact fees adopted by the City Council which are applicable to all new connections to the City's utility system. The impact fees shall be adopted in accordance with Chapter 395 of the Texas Local Government Code. R &R agrees to notify City on a monthly basis of all new connections R &R's water system. The payment of all impact fees shall be due and payable within 30days of the date of the connection. Failure to notify City of new connections or to pay the impact fees when due shall be considered as a default of this Agreement. Article VI, Sec. 6.02 Impact Fees for Existing Connections: The City and R&R agree that there are 141 existing connections to R &R's system. R &R agrees to provide the city with names and address of the 141 existing connections. R &R agrees that upon execution of this agreement it is obligated to pay City impact fees of $1,946.25 for each existing connection for a total of $274,421.25. Vista Oaks Contract Start Date: January 22, 1987 Amendment Date: April 22, 1993 Contract End Date: January 22, 2027 Chapter 10, Sec. 10.201 (7.1) Rates for Utility Service to Williamson County Municipal Utility District No. 9: (a) The rates shall consist of a volumetric rate and a monthly base charge per connection to the water system. (b) The volumetric rate for water is $1.76/1,000 gallons of water delivered. (c) The District shall pay a monthly base charge for each separate connection according to the size of the meter as follows: 5/8" - $10.52; 1" - $21.70; 3/4" - $14.25; 1 1/2" - $40.32. Williamson County MUD #10 & #11 Contract Start: March 22, 2001 Contract End: March 22, 2041 Article 11, Sec. 2.01 Water Supply Services: The City agrees to sell and deliver to the District, at the Point or Points of Delivery, all Water that may reasonably be required by users within the District for domestic and commercial uses. The District will construct, finance, and own its District Water System, and will be responsible for operating and maintaining the facilities that compromise its District Water System, as well as meter reading and billing its customers. Article II, Sec. 2.03 Metering of All Water Delivered: All Water delivered to the District will be measured by a master meter installed at each Point of Delivery. The District will calibrate its master meters once every 12 months or more frequently upon the City's request; however, the cost of calibration will be borne by the City if the City requests calibration more frequently than once every 12 months. Article II, Sec. 2.04 Reading of Metering Equipment: All master meters will be read by the City at least once during each monthly billing cycle. The District will read all District master meters daily during the period between June 15 and September 15, and, during the remainder of the year, will read all master meters daily except on weekends and State and Federal Holidays. Article V, Sec. 5.01 The District agrees to collect City Impact Fees established under applicable City ordinances for the purchase of permanent wastewater capacity to serve the land within the District. Applicable fees will be collected by the District at the time of issuance of each tap, and the collected fees paid to the City on a monthly basis. As of the date of this Agreement, the City's Impact Fees are $2,345 per living unit equivalent for water. The District will also collect and nanit an additional Impact Fee of $150 per living unit equivalent for water or so long as the City continues to collect service -area -wide LUE oversize fees under existing Sec. 8.610(h) and 8.161(h) of the City's Subdivision Ordinance. Article V, Sec. 5.02 Wholesale Water Rates: The City will provide wholesale water service to the District for cost -of- service water rates. The initial rate to be charged by the City to the District for water supplied under this Contract will be $2.36/ 1,000 gallons. These rates will be subject to adjustment, on an annual basis, beginning one year from the date of this Contract, by ordinance adopted by the City of Round Rock Council. Any rate adjustments proposed will be reasonable and non - discriminatory. In the future, the wholesales to the District may consist of two rate components, a demand charge and a volumetric charge. Article V, Sec. 5.03 Rate Increases: The City agrees to give the District at least 30 days written notice prior to the effective date of any change in its Impact Fees, LUE Fees, or Water Rates, in order to enable the District to timely adjust the rates and fees charged to the District's customers. Article V, Sec. 5.04 Billings: the City will bill the District for Water Supply Services in accordance with the City's normal utility service regulations applicable to other City utility customers, and will provide the District with a monthly, itemized statement of the amount of Water fumished at each Point of Delivery during the billing period. Williamson County Park Contract Start: April 25, 2002 Contract End: April 25, 2006 Article I, Sec. 1.02 Provision of Water Service: City's obligation to provide water services under this Contract is subject to the capacity of City's facilities to provide water services to Purchaser after meeting the municipal, domestic, commercial, and industrial needs within City's corporate limits, and after meeting any contractual obligations existing as of the date of execution of this Contract, but in no event shall the city be obligated to provide more than 250,000 gallons per day, averaged over any consecutive 30 day period. Article II, Sec. 1.03 Provision of Water Service: Purchaser agrees to abide by all voluntary and mandatory conservation and use restrictions imposed by City units own citizens. Purchaser is solely responsible for the construction of any and all lines servicing the Property, including the negotiations of any and all easements or pass through agreements with other entities. It is acknowledged by Purchaser that water service will pass through Williamson County M.U.D. No. 9, and that it is Purchaser's obligation to obtain approval of said pass through. This Contract is subject to Purchaser entering into a pass through agreement with M.U.D. No. 9 which is acceptable to City. Article II, Sec. 2.01 Rates: Purchaser agrees to pay City for all water delivered to Purchaser at the rate authorized by Chapter 10, Sec. 10.201(5), Code of Ordinances (1995), as amended from time to time applicable to sale of water to customers located inside the corporate limits of City. Brushy Creek Contract Start Date: October 14, 1986 Contract End Date: October 14, 2006 Ordinance No. G 93 09 - 23 - 9E Amendment Article I, Sec. 7 Rates for Water Service To Brushy Creek Municipal Utility District (a) The rate for water service to Brushy Creek Municipal Utility District ( "BCMUD ") shall consist of a Volumetric Rate and a Monthly Excess Capacity Charge, both of which are due and payable on a monthly basis. (b) The Volumetric Rate for water is $0.93 per 1,000 gallons of water delivered. (c) The Monthly Excess Capacity Charge shall be determined by multiplying the Monthly Excess Capacity Rate by BCMUD's Excess Capacity. The Monthly Excess Capacity Rate is $15,117 per million gallons per day (NGD) of Excess Capacity. The Excess Capacity shall be equal to BCMUD's peak day usage expressed in MGD less BCMUD's annual average day usage. City Of Round Rock Wholesale Wastewater Contracts Chandler Creek Contract Start: May 10, 1984 Article II, Paragraph 4 The City agrees to receive, treat, collect and dispose of sewage generated within the boundaries of the District, such sewage to be collected into the City's sanitary sewer trunk line as extended by the District pursuant to the Utility Construction Contract. Subject to the City's right to reasonably limit the amount of sewage received from the District on the same basis and to the same extent as sewage received from any other customer within the City, the City agrees to receive, treat, collect and dispose of sewage generated within the District and in amounts sufficient to serve the District as it develops with a total of 2506 living unit equivalents of wastewater service rights to ultimately be provided to the District when it is fully developed. Article II, Paragraph 5 The City agrees to sell wastewater collection and treatment services to the Users within the boundaries of the District. The rates charged by the City to the District for such Users within the District for wastewater services pursuant to this agreement shall be the same as the wastewater rates which it charges its retail and residential and commercial customers (with an equivalent sized meter) inside its city limits. The City shall not charge the District or the Users within the District any wastewater actually delivered that it does not charge its residential or commercial customers inside its city limits and shall not charge the District or the Users within the District any fee, assessment, or other charge for wastewater actually delivered as a functional equivalent of ad valorem property taxes which customer inside the city limits are required to pay. Article II, Paragraph 6 (a) The City shall bear all responsibility to operate, manage, maintain and repair at its expense for the District all of the District facilities. Article II, Paragraph 6 (b) Facilities shall include: (1) all wastewater facilities and related appurtenances located within public rights of way or dedicated easements within the District. (2) All wastewater facilities within the District which the District may construct, purchase, own or operate in the future and for which plans and specifications have been approved by the City. Article II, Paragraph 6 (c) The responsibility of the City for the operation, management, maintenance and repair of the District Facilities includes the responsibility for all costs of operation, management and maintenance of the District Facilities, including, but not limited to, repairs, upkeep and replacements, cost of utilities, supervision, engineering, accounting, legal work, auditing, insurance and any other supplies, services, administrative costs and equipment necessary for the operation, management and maintenance of the District Facilities. Article II, Paragraph 6 (d) Ownership of the District Facilities described in Subparagraph 6 (b) shall remain in the District, which shall have the right to inspect them at all times. The City owns or has reserved the oversize capacity in specified portion of the District Facilities as set forth in the June 26, 1986 "Utility Construction Contract Between the City of Round Rock, Texas, The Meadows at Chandler Creek Municipal Utility District." R &R Mobile Contract Start: January 27th, 2000 Contract End: January 27th, 2030 Article III, Sec. 3.01 (a) Collection and Treatment Services: Beginning on the Start Date, the City agrees to provide wastewater collection and treatment service for domestic and commercial purposes to R &R on a wholesale basis. The City presently has and will maintain an adequate wastewater treatment capacity with which to meet R &R's current and future needs, but is not obligated to provide service for more than 230 LUE's. Article III, Sec. 3.01 (d) Quantity of Wastewater Service: The quantity of wastewater service provided by the City shall be based upon the actual monthly water consumption, or the average monthly consumption for December, January, and February of each fiscal year, whichever is less. Regardless of anything contained herein to the contrary, the number of LUE's of wastewater service provided herein is limited t no more than 230 LUE's. Article VI, Sec. 6.01 Impact Fees for New Connection: For each new connection to its water system, R &R agrees to pay any and all wastewater impact fees adopted by the City Council which are applicable to all new connections to the City's utility system. The impact fees shall be adopted in accordance with Chapter 395 of the Texas Local Government Code. R &R agrees to notify City on a monthly basis of all new connections R &R's water system. The payment of all impact fees shall be due and payable within 30days of the date of the connection. Failure to notify City of new connections or to pay the impact fees when due shall be considered as a default of this Agreement. Article VI, Sec. 6.02 Impact Fees for Existing Connections: The City and R &R agree that there are 141 existing connections to R &R's system. R &R agrees to provide the city with names and 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 . 1 1 • 1 address of the 141 existing connections. R&R agrees that upon execution of this agreement it is obligated to pay City impact fees of $1,946.25 for each existing connection for a total of $274,421.25. Vista Oaks Contract Start: January 22, 1987 Amendment Date: April 22, 1993 Section 10 10.202 (2) Sewer Rates for Wholesale Sewer Service to Governmental Agencies: (a) The monthly rate is $2.60/1,000 gallons of sewage discharged. (b) If the sewage discharge is not metered, the monthly sewage discharge shall be equal to: (i) Actual amount of water delivered, or (ii) Average amount of water delivered December, January, and February, whichever is Less, and (iii) an additional 12% as an inflow and infiltration factor. Section 10 10.202 (2.1) Sewer Rates for Williamson County Municipal Utility District No. 9: The monthly rate is $2.83/1,000 gallons of sewage metered Williamson County MUD #10 & #11 Contract Start: March 22, 2001 Contract End: March 22, 2041 Article III, Sec. 3.01 Agreement to Provide Wastewater Service: The City agrees to accept, treat and dispose of all wastewater that is generated by users within the District, collected by the District, and delivered to the Point of Delivery into the City Wastewater System. Article V, Sec. 5.01 Impact Fees: The District agrees to collect City Impact Fees established under applicable City ordinances for the purchase of permanent wastewater capacity to serve the land within the District. Applicable fees will be collected by the District at the time, . of issuance of each tap, and the collected fees paid to the City on a monthly basis. As of the date of this Agreement, the City's Impact Fees are $1,500 per living unit equivalent for wastewater. The District will also collect and remit an additional Impact Fee of $150 per living unit equivalent for wastewater or so long as the City continues to collect service -area -wide LUE oversize fees under existing Sec. 8.610(h) and 8.161(h) of the City's Subdivision Ordinance. Article V, Sec. 5.02 Wholesale Wastewater Rates: The City will provide wholesale wastewater service to the District for cost -of- service wastewater rates. The initial rate to be charged by the City to the District for wastewater supplied under this Contract will be $3.03/ 1,000 gallons. These rates will be subject to adjustment, on an annual basis, beginning one year from the date of this Contract, by ordinance adopted by the City of Round Rock Council. Any rate adjustments proposed will be reasonable and non - discriminatory. In the future, the wholesale rates to the District may consist of two rate components, a demand charge and a volumetric charge. Article V, Sec. 5.03 Rate Increases: The City agrees to give the District at least 30 days written notice prior to the effective date of any change in its Impact Fees, LUE Fees, or Wastewater Rates, in order to enable the District to timely adjust the rates and fees charged to the District's customers. Article V, Sec. 5.04 Billings: The City will bill the District for Wastewater Supply Services in accordance with the City's normal utility service regulations applicable to other City utility customers, and will provide the District with a monthly, itemized statement of the amount of Water furnished at each Point of Delivery during the billing period. Unless the District and the City agree on an alternate methodology, (i) until such time as the District is built -out 50 %, the City will bill the District for Wastewater on the basis of the District's average monthly Water usage during the prior December, January, and February, exclusive of Water used for irrigation purposes that is measured by the District though dedicated irrigation meters, or on the basis of 70% of the District's current monthly Water bill, exclusive of Water used for irrigation purposes that is measured by the District though dedicated irrigation meters, whichever is more; (ii) at such time as the District is 50% built -out, the City will bill the District for wastewater on the basis of the District's average monthly water usage during the prior December, January, and February, exclusive of water used for irrigation purposes that is measured by the District through dedicated irrigation meters or on the basis of the District's current water bill, whichever is less. Until the District has established a history of water usage for the months of December, January, and February, the City will bill the District for wastewater based upon 70% of the District's current monthly water usage, exclusive of water used for irrigation purposed that is measured by the District through dedicated irrigation meters. Williamson County Park Contract Start: April 25, 2002 Contract End: April 25, 2006 Article I, Sec. 1.02 Provision of Wastewater Service: City's obligation to provide wastewater services under this Contract is subject to the capacity of City's facilities to provide wastewater services to Purchaser after meeting the municipal, domestic, commercial, and industrial needs within City's corporate limits, and after meeting any contractual obligations existing as of the date of execution of this Contract, but in no event shall the city be obligated to provide no more than 52 Living Unit Equivalents of wastewater service 1 1 1 1 1 1 1 1 1 1 1 1 1 Article II, Sec. 1.03 Provision of Wastewater Service: Purchaser agrees to abide by all voluntary and mandatory conservation and use restrictions imposed by City on its own citizens. Purchaser is solely responsible for the construction of any and all lines servicing the Property, including the negotiations of any and all easements or pass through agreements with other entities. It is acknowledged by Purchaser that water service will pass through Williamson County M.U.D. No. 9, and that it is Purchaser's obligation to obtain approval of said pass through. This Contract is subject to Purchaser entering into a pass through agreement with M.U.D. No. 9 which is acceptable to City. Article 11, Sec. 2.01 Rates: Purchaser agrees to pay City for all wastewater delivered to Purchaser at the rate authorized by Chapter 10, Sec. 10.202(1), Code of Ordinances (1995), as amended from time to time applicable to sale of wastewater to customers located inside the corporate limits of City.