Loading...
HomeMy WebLinkAbout2004-08-24 Workshop Meeting City Commission Meeting Agenda Packet AGENDA DANIA BEACH CITY COMMISSION WORKSHOP MEETING TUESDAY, AUGUST 24, 2004 - 6:00 P.M. ANY PERSON WHO DECIDES TO APPEAL ANY DECISION MADE BY THE CITY COMMISSION WITH REGARD TO ANY MATTER CONSIDERED AT THIS MEETING OR HEARING WILL NEED A RECORD OF THE PROCEEDINGS, AND FOR SUCH PURPOSE MAY NEED TO ENSURE THAT A VERBATIM RECORD OF THE PROCEEDINGS IS MADE WHICH RECORD INCLUDES THE TESTIMONY AND EVIDENCE UPON WHICH THE APPEAL IS TO BE BASED. LOBBYIST REGISTRATION REQUIRED - REGISTRATION AS A LOBBYIST IN THE CITY OF DANIA BEACH IS REQUIRED IF ANY PERSON, FIRM OR CORPORATION IS BEING PAID TO LOBBY THE COMMISSION ON ANY PETITION OR ISSUE PURSUANT TO ORDINANCE NO. 01-93.REGISTRATION FORMS ARE AVAILABLE IN THE CITY CLERK'S OFFICE IN THE ADMINISTRATION CENTER. IN ACCORDANCE WITH THE AMERICANS WITH DISABILITIES ACT, PERSONS NEEDING ASSISTANCE TO PARTICIPATE IN ANY OF THESE PROCEEDINGS SHOULD CONTACT LOUISE STILSON,CITY CLERK, 100 W.DANIA BEACH BLVD,DANIA BEACH,FL 33004,(954)924-3622,AT LEAST 48 HOURS PRIOR TO THE MEETING. 1. Call to order 2. Roll Call: 3. Discussion on Water and Sewer Rate Study. (Patricia Varney, Finance Director) 4. Adjournment. WORKSHOP MEETING TUESDAY, AUGUST 24, 2004 AGENDA 1 i } CITY OF DANIA BEACH, FLORIDA ^3 L" ky% � WATER AND WASTEWATER RATE STUDY DRAFT August 19, 200 Public Resources Management Group, Inc. Utility, Rate, Financial and Management Consultants , 3 Public Resources Management Group, Inc. Utility, Rate, Financial and Management Consultants DRAFT August 19, 2004 Ms. Patricia Varney Director of Finance City of Dania Beach 100 West Dania Beach Boulevard Dania Beach, FL 33004 Subject: Water and Wastewater Rate Study Dear Ms. Varney: We have completed our study of the water and wastewater rates for the City of Dania Beach (the "City"), and have summarized the results in this letter report for your consideration. This report summarizes our review of the City's existing rates for water and wastewater service necessary to meet the projected revenue requirements for fiscal year ending September 30, 2005 ("Fiscal Year 2005") through the fiscal year ending September 30, 2009 (the "study period"). This analysis also includes proposed modifications to the City's water and wastewater impact fee levels based on the City's capital investment required to meet future expansion needs. In our review of the existing water and wastewater rates, we have relied upon certain information and data collected from the City including the City's Comprehensive Annual Financial Reports; the proposed Fiscal Year 2004 and 2005 budgets; the Master Water and Wastewater Plan; customer statistics; periodic reports; records of operation; and other information and data provided by the utility. To the extent we have performed our analyses using the data and information obtained from the City and others, we have relied upon such information to be accurate and no assurances are intended and no representation or warranties are made with respect thereto or the use made herein. During the course of the study, it was determined that the proposed rates and charges should meet a number of goals and objectives. The single most important objective of the study is to develop proposed utility rates that meet the projected expenditure requirements of the water and wastewater utility systems in order to maintain sound financial operations and fund the anticipated capital needs of the utility systems. The other goals and objectives considered in the study include the following: • Proposed rates should be based on cost of service principles • Proposed rates should minimize "rate shock" to customers if possible • Proposed rates should promote the conservation of water resources • Proposed rates should comply with rate covenants as required by outstanding indebtedness • Proposed rates should maintain adequate reserves for emergencies and unforeseen capital needs K:V 173-01\1-tr Report.doc .'3_iI °�. �'I. , .c�.' ... eti, �' Ott i{. e'` i 4ti ' . ()t Ms. Patricia Varney DRAFT City of Dania Beach August 19, 2004 Page 2 The proposed rates and charges are based on the recovery of the total costs anticipated for the City and cost of service principles applied to such costs. As such, the report following this letter summarizing our study and outlining our proposed rates is considered by PRMG to be reasonable and reflects the cost of service for each utility system. We appreciate the opportunity to be of service to the City. Respectively submitted, Public Resources Management Group, Inc. Henry L. Thomas Vice President and Principal Stephanie Willet Rate Analyst Attachments K:U 173-01\Ltr Repoitdoc DRAFT CITY OF DANIA BEACH WATER AND WASTEWATER RATE STUDY TABLE OF CONTENTS Page Description Number Letter of Transmittal Tableof Contents................................................................................................................i Listof Tables.......................................................................................................................ii INTRODUCTION............................................................................................................... I CUSTOMER AND SALES FORECAST........................................................................... 3 REVENUEREQUIREMENTS .......................................................................................... 5 Principal Assumptions and Considerations..................................................................... 5 Water and Wastewater System Revenue Requirements Summary................................. 8 Adequacy of Existing Utility Rate Revenues................................................................ 10 DebtService Compliance.............................................................................................. 11 RATEDESIGN................................................................................................................. 12 Classification of Water and Wastewater Costs............................................................. 13 WaterRate Design ........................................................................................................ 15 Wastewater System Rate Design .................................................................................. 16 IMPACTFEES ................................................................................................................. 17 MISCELLANEOUS SERVICE CHARGES.................................................................... 18 CONCLUSIONS AND RECOMMENDATIONS ........................................................... 18 APPENDIX A—Existing and Proposed Water and Wastewater Rates APPENDIX B— Inter-Utility Rate Comparisons APPENDIX C—Water and Wastewater Impact Fee Analysis K:A1 173-01\L[r Report.doc i DRAFT CITY OF DANIA BEACH WATER AND WASTEWATER RATE STUDY LIST OF TABLES Table No. Description Table 1 Historical and Projected Customer Statistics —Water System Table 2 Historical and Projected Customer Statistics —Wastewater System Table 3 Projected Net Revenue Requirements—Water System Table 4 Projected Net Revenue Requirements—Wastewater System Table 5 Allocation of Operating Expenses to Individual Systems Table 6 Projected Operating Expenses—Water System Table 7 Projected Operating Expenses— Wastewater System Table 8 Operating Expense Escalation Factors Table 9 Capital Improvement Program Table 10 Projected Debt Service Coverage Analysis—Water and Wastewater System Table 11 Classification of FY 2005 Net Revenue Requirements—Water System Table 12 Classification of FY 2005 Net Revenue Requirements—Wastewater System Table 13 Existing and Proposed Water and Wastewater Rates Table 14 Bill Comparison for Proposed Residential Water Rates Table 15 Bill Comparison for Proposed Residential Wastewater Rates Table 16 Bill Comparison for Proposed Residential Water and Wastewater Rates Table 17 Bill Comparison for Proposed Commercial Water Rates Table 18 Bill Comparison for Proposed Commercial Wastewater Rates Table 19 Bill Comparison for Proposed Commercial Water and Wastewater Rates K:A1173-01\Ltr Repoitdoc 11 DRAFT CITY OF DANIA BEACH WATER AND WASTEWATER RATE STUDY LIST OF TABLES Appendix A—Existing and Proposed Water and Wastewater Rates Table A-I Summary of Existing and Proposed Water and Wastewater Rates Appendix B—Inter-Utility Rate Comparisons Table B-1 Comparison of Typical Monthly Residential Bills for Water Service Table B-2 Comparison of Typical Monthly Residential Bills for Wastewater Service Table B-3 Comparison of Typical Monthly Residential Bills for Water and Wastewater Service Appendix C—Water and Wastewater Impact Fee Analysis Table C-1 Fixed Assets Allocation Table C-2 Allocation of Planned Capital Projects Table C-3 Water System Impact Fee Analysis Table C-4 Wastewater System Impact Fee Analysis Table C-5 Comparison of Impact Fees for Water and Wastewater Service Appendix D—Miscellaneous Service Charges Table D-1 Comparison of Existing and Proposed Miscellaneous Services Charges K:AI 173-01 s\Ltr Repoit.doc lll DRAFT CITY OF DANIA BEACH WATER AND WASTEWATER RATE STUDY INTRODUCTION The City of Dania Beach (the "City") is located on the coast of southeastern Broward County (the "County"). The City has recently annexed several large areas and doubled its area to over 6 square miles, and increased its population to nearly 30,000 people, from 13,700 persons in 1995. The community is primarily residential, with small concentrations of light industry, shopping, offices and some beachfront property within the corporate limits. A small industrial sector was added in the most recent annexation, but none of the industries would be considered "intensive." Most of the annexed area is served with water and sewer by Broward County.I The City of Dania Beach was incorporated under the laws of the State of Florida in 1904. It is the oldest incorporated City in Broward County. The Chief Administrative Officer of the City Government is the City Manager who is appointed by the City Commission. The Utilities and Public Works Department is one of six major departments within the City. The Utilities and Public Works Department operates the water and wastewater utility systems within the City. The initial water system has grown to where over 4,600 connections exist within the City limits. The wastewater system has been served with central sewer since the 1940s with treatment by the City of Hollywood at their current 42 MGD facility.I The goal of this study is to assist the City in establishing water and wastewater rates sufficient to recover the cost of operating, maintaining, repairing and financing the water and wastewater systems. As outlined in this report, water and wastewater rate adjustments are proposed in order to support the revenue requirements of the individual water and wastewater systems on a stand- alone basis. The City's current capital improvement program reflects significant capital investments to improve and expand the City's water treatment plant and transmission system. For the wastewater system significant expenditures are planned to rehabilitate the City's sewer collection system. The current funding plan calls for the water system improvements to be funded by a loan from the State of Florida Department of Environmental Protection's State Revolving Loan Fund (the "SRF loan"). The proposed water rate increases are phased in over the next several fiscal years to ensure that the water rates are adequate to fund the annual debt service associated with the SRF loan. The sewer collection system rehabilitation is funded primarily through increased rate revenues. The proposed wastewater rates are increased over the next several fiscal years to establish an annual renewal and replacement funding level to properly maintain the sewer collection system. Based on the projected operating results, the City can satisfy the projected water and wastewater system revenue requirements (i.e., expenditures) with a series of rate increases over the next five years. Facilities Plan prepared by Public Utility Management and Planning Services, Inc. K:\1173-01\Ltr Rcport.doc -1- DRAFT Estimated System-Wide Rate Revenue Increase Effective 2005 2006 2007 2008 2009 Water System [1] 10% 12% 12% 12% 12% Wastewater System[2] 8% 8% 8% 7% 6% [I] Proposed system-wide average water rate increases obtained from Table 3 at the end of this report. [2] Proposed system-wide average wastewater rate increases obtained from Table 4 at the end of this report. This study provides a schedule of proposed rates to be effective with bills rendered on or after October 1 of each fiscal year. Such rates serve to meet the projected net revenue requirements of the water and wastewater system beginning in Fiscal Year 2005. It is recommended that overall rate levels should be reviewed in approximately two years to determine the actual level of future revenue requirements. The City last adjusted monthly water and wastewater rates by 5.0% and 5.5%, respectively, which became effective on October 1, 2003. Based on the proposed rate adjustments through Fiscal Year 2009 estimated herein, the average user with 6,000 gallons of metered water use will see the combined monthly water and sewer bill increase from $39.00 to $60.49 over the five-year period beginning in 2005. This equates to an average annual increase of approximately $4.30 for the typical residential water and wastewater bill. The primary reasons for the proposed rate increases shown above include i) increasing operating expenses including employee benefits such as health insurance; ii) funding ongoing system renewals, replacements, and upgrades; iii) additional debt service associated with estimated debt funding of capital; and iv) lower interest income due to lower rates and lower fund balances. The existing and proposed water and wastewater rates are summarized in Appendix A at the end of this report. Detailed residential bill comparisons of existing rates to the proposed water and wastewater rates are shown on Tables 14 through 16. A summary of the total water and wastewater bill impact on residential customers beginning October 1, 2004 using 1,000, 6,000 and 20,000 gallons of water per month,respectively, is shown below: Comparison of Combined Residential Water and Wastewater Bills Under Existing and Proposed Rates [Il 1,000 6,000 20,000 Gallons Gallons [2] Gallons Existing Rates $17.78 $39.00 $109.60 Proposed Oct. 2004 Rates $20.33 $42.11 $117.24 [I] Amounts obtained from Table 16 and reflect customers located inside the City limits. [2] Reflects the average monthly billing per residential account. In addition to the residential bill comparisons shown above, Tables 17 through 19 at the end of this report provide comparisons of existing water and wastewater bills for certain commercial customers at various usage levels. The recommendations of this study are based on a financial forecast developed for the water and wastewater systems. The financial forecast starts with the identification of utility operating and capital needs, next considers the capital financing plan and, finally, establishes the timing of rate K:AI 173-01\Ltr Report.doc -2- DRAFT adjustments and borrowing, if necessary. The basis for the rate study's recommendations is a financial forecast developed for Fiscal Years 2005 through 2009. While further rate adjustments beyond Fiscal Year 2005 are indicated in the financial forecast, an updated financial forecast should be completed in approximately two years in order to refine the level of future increases in revenue requirements. CUSTOMER AND SALES FORECAST During Fiscal Year 2003, it is estimated that the City provided service to an average of 4,627 water customers and 3,858 wastewater customers as shown on Tables 1 and 2. The City's current rates are distinguished among various customer classes including residential, commercial, sprinklers, laundry mats, and condominiums. The City has provided the following historical data by these customer classes: Average Units Served During Fiscal Year 2003 Water System [1] Average Percent of Total Amounts Accounts Residential 3,680 79.5% Commercial 557 12.0% Sprinklers 323 7.0% Laundry Mats 7 0.2% Condominiums - 61 1.3% Total 46,28 1 o0.0°o [1] Based on information provided by the City and illustrated in Table 1. Average Units Served During Fiscal Year 2003 Wastewater System [I] Average Percent of Total Amounts Accounts Residential 3,282 85.1% Commercial 506 13.1% Sprinklers N/A N/A Laundry Mats 7 0.2% Condominiums 63 1.6% Total 3,858 100.0% [I] Based on infonnation provided by the City and illustrated in Table 2. As shown above 79.5% of water units are classified as residential, while 85.1% of the wastewater accounts are residential. K:A1 173-01\Lu-Report.doc -3- DRAFT This study includes a forecast of customers and usage to evaluate the adequacy of rate levels and design of rate structures. This customer and sales forecast includes the period from Fiscal Year 2004 through 2009. Based on a review of potential growth and new development for the City, growth assumptions used in the Facilities Plan, and discussions with City staff, it has been assumed that the City's water customer base would increase by a compounded average of 0.6% annually for the six-year period ending Fiscal Year 2009, while the wastewater system would increase by a compounded average of 0.7% annually. The actual growth forecasted herein is based on assumptions regarding account growth by customer class. This detailed method of forecasting is used as a basis to forecast metered consumption, rate revenue under existing rates, and to provide comprehensive data for rate design purposes. Water sales are projected based on usage trends experienced by each customer class during the recent past. The total water sales forecast is based on the sum of individual forecasts prepared for each of the customer classifications (i.e., residential, commercial, etc.). This is appropriate since the customer growth rates by class are projected to be different, and therefore, the water sales forecast should be consistent with the type of customer growth anticipated. The customer growth forecast also assumes that prevailing local economic conditions and development will be similar to the conditions experienced over the past several years. To the extent actual conditions deviate from recent historical experience, the results as projected herein could be substantially different from those projections, The forecast of wastewater customers and wastewater sales or "revenue gallons" (i.e., metered water consumption that receives a wastewater flow charge) was developed in the same manner as the water system sales. It should be noted that total wastewater revenue gallons differ from water sales since not all water customers receive City wastewater service. Tables 1 and 2 provide a summary of the forecast in the number of accounts served and the associated sales and flow requirements for the water and wastewater systems, respectively. This forecast is summarized in the following tabulation by utility: Water System [1] Wastewater System [21 Annual Revenue Gallons Fiscal Year Units (1,000 gallons) Units (1,000 gallons) 2003 [3] 4,627 818,387 3,858 660,384 2004 4,657 821,349 3,888 663,369 2005 4,724 830,404 3,955 672,459 2006 4,739 831,885 3,970 673,952 2007 4,754 833,366 3,985 675,445 2008 4,769 834,847 4,000 676,937 2009 4,784 836,328 4,015 678,430 Average Annual Growth Rate(FY03—FY09) 0.6% 0.4% 0 7% 0.5° [1] Amounts obtained ti-om Table I. [21 Amounts obtained from Table 2. [3] Based on infonnation provided by the City. K:A1 173-01\Ltr Report.doc -4- DRAFT REVENUE REQUIREMENTS The various components of cost associated with operating and maintaining a municipally-owned utility system, as well as the cost of financing the renewal and replacement of facilities and capital improvements for upgrades and expansion, are generally referred to as the utility cash revenue requirements. The sum of these cost components, after adjusting for other income and miscellaneous utility revenues, represents the net revenue requirements. The revenue requirements for this rate study are predicated on an analysis of water and wastewater costs for the six (6) fiscal year period ending September 30, 2009 (i.e. Fiscal Years 2004 through 2009). The projected revenue requirements included the various generalized cost components described below: • Operating Expenses: These expenses include the cost of utilities, chemicals, labor, materials, supplies, and other items necessary for the operation and maintenance of the water and wastewater systems. • Debt Service: Debt service includes the principal and interest on the City's current and future loan obligations payable from the net operating revenues of the water and wastewater systems. • Other Revenue Requirements: This component of cost includes, in general, any ongoing capital improvements (capital outlay) to be financed from revenues and annual transfers, if any, to the Renewal and Replacements (R&R) Fund needed for ongoing system renewals and replacements over the six-year forecast period. Principal Assumptions and Considerations The projected cash revenue requirements as shown on Tables 3 and 4 for the water and wastewater systems, respectively, reflect certain assumptions, considerations and analyses. The major assumptions, considerations and analyses that are included in the projected revenue requirements for the study period are as follows: 1. The adopted Fiscal Year 2004 Annual Budget and the proposed Fiscal Year 2005 Annual Budget associated with the operations of the utility systems serve as the basis for the water and wastewater systems' expenditure projections. Unless otherwise noted, the underlying assumptions and expenditure amounts included therein are assumed to be reasonable and reflect anticipated operations. Such budgetary amounts are incorporated into the revenue requirement component of the study, except for adjustments and assumptions as noted hereunder. 2. Projected revenues from current rates and charges for the City's water and wastewater systems are based on the schedule of rates and charges effective as of October 1, 2003. Such rates are applied to the customer and sales or usage forecast previously discussed in this report. Tables 3 and 4 summarize the projected rate revenues under existing rates for the forecast period for both the water and wastewater systems, respectively. K:A1 173-01\LU-Report.doc -5- DRAFT 3. The operations and maintenance expenses of the water and wastewater systems proposed for Fiscal Year 2005 are projected for the remaining four (4) years of the forecast period (i.e., through Fiscal Year 2009). These operating cost projections are illustrated on Tables 6 and 7 for the water and wastewater systems, respectively. A summary of the operating expense escalation factors is shown on Table 8. The projected operating expenses were developed for the study period as follows: (a) Proposed Fiscal Year 2005 operating expenses such as professional services, other contractual services, and certain other indirect expenses are projected to increase from current proposed levels at an annual rate of inflation equal to approximately 2.2%. The forecast of inflation is based upon the Consumer Price Index (CPI) forecast prepared by the Congressional Budget Office as contained in "The Budget and Economic Outlook" report dated January 2004. (b) Proposed Fiscal Year 2005 operating expenses which have a direct correlation to customer growth, usage, and demand such as customer service and billing charges, maintenance of vehicles and equipment, utility and chemical charges, and other direct expenses are projected to increase over the forecast period as such demand increases and as illustrated in Table 8. (c) Utility system salaries and wages and other personnel benefits are increased above Fiscal Year 2005 amounts by 7.0% annually to reflect increases due to cost of living adjustments and allowances for salary adjustments such as promotions and merit increases. No additional personnel needs have been identified by the City at this time; therefore, no additional staff is reflected in the analysis. (d) General liability and employee health insurance costs are assumed to increase 15.0% annually. These relatively high escalation factors reflect recent trends in overall insurance costs. (e) The City maintains a bulk wastewater service agreement with the City of Hollywood. These costs reflected in the forecast period are increased based on customer growth and an anticipated adjustment in wholesale costs of approximately 3% annually. (f) The adopted Fiscal Year 2004 and proposed Fiscal Year 2005 Budgets have been adjusted for possible contingency costs equal to 1.5% of anticipated operation and maintenance expenses. The remaining forecast periods also reflect this contingency to account for unforeseen expenses. 4. The capital expenditures for the water and wastewater systems are based on estimated project costs derived from the City's Master Waster and Wastewater Plans, and the City's Five-Year Capital Budget through Fiscal Year 2009. Table 9 provides a detail listing of the planned water and wastewater capital projects during the study period. In general, the major expenditures in the CIP include the following type of projects: K:A1173-01\Ltr Repoit.doc -6- DRAFT Water Plant Upgrade • Water Main Replacement • Water Main Looping Upgrades • Sanitary Sewer Infiltration/Inflow Program ® Lift Station Rehabilitation This analysis assumes that additional debt will be issued to fund a major portion of certain projects during Fiscal Years 2004 through 2009. A summary of the capital improvement program and the anticipated funding sources is shown on the following table: Total Capital Funding Program 2004-2009 111 Capital Improvement Projects Water System Water Storage Tank Removal&Replacement $2,213,000 Water Plant Upgrade 5,136,000 Chlorine System Upgrades 350,000 Water Main Replacement 323,180 Refurbish Existing Water Treatment Plant 732,000 Abandon Existing Plant Site Wells 25,000 Construction of Well "I" 650,000 Water Main Looping Upgrades 5,185,000 High Service Pumps 575,000 Total Water System $15,189,180 Wastewater System Sanitary Sewer Infiltration/Inflow Program $1,918,700 Lift Station Rehabilitation 1,154,500 Installation of Security Systems 25,000 Total Wastewater $3,098,200 Total Capital Improvement Projects $18,287,380 Total Departmental Capital $927,174 Total Capital Funding Program 19 214 554 Fund Sources State Revolving Fund Loan(SRF) $15,190,500 Water Utility Fees [2] 557,274 Sewer Utility Fees [2] 1,569,900 Operating Reserves 408,180 Water Impact Fees 720,000 Sewer Impact Fees 768,700 Total Fund Sources 19 214,554 [1] Amounts derived from Table 9. [2] Includes funding of the renewal and replacements anticipated in the C1P. K:A1173-01\Ltr Rcport.doc -7- DRAFT 5. The water and wastewater systems should have adequate cash reserves in order to meet day-to-day funding needs as well as to be able to meet any unexpected emergencies requiring immediate financial resources. It is recommended that the City maintain the equivalent of at least 90 days of O&M expenses in operating reserves so as to provide sufficient liquidity. A comparison of the City's estimated available fund balances projected by the City as of September 30, 2003 with projected fund balances as of September 30, 2009 are shown on the following table: Additions to Uses of Fund Funds Fund Balance Balance Projected Available [1] through through Balance [2] Fund Description 9/30/03 FY2009 FY2009 9/30/09 Unrestricted Revenue Fund $1,883,655 $2,398,175 $885,311 $3,396,519 R&RFund [3] 0 1,250,000 1,175,000 75,000 Water Impact Fees [4] 709,779 359,095 720,000 348,874 Wastewater Impact Fees [4] 711,105 335,150 768,700 277,555 Total $3 3 44 539 . 4 342 420 $3,549,011 4,097,948 [1] Amounts represent estimated funds available as of September 30,2003 as provided by the City- [2] Projected balances assume proposed rate adjustments are implemented. [3] Additions to fund balances through Fiscal Year 2009 funded from water and wastewater utility rates. [4] Additions and uses of funds assume adoption of proposed impact fees effective October I,2004. 6. In order to meet the funding needs of the CIP as discussed above, deposits to the Renewals and Replacements (R&R) Fund are required.during the forecast period. As a minimum ongoing funding mechanism beyond the forecast period, at least 3.0% to 5.0% of the previous fiscal year gross revenues should be deposited into the R&R Fund annually. For the forecast period of this report, the minimum deposit is $250,000 per year on average. 7. The City also earns other operating revenue from miscellaneous charges for specific customer service requests or needs. These other revenue sources reduce the revenue requirements needed from monthly rates. Examples of miscellaneous revenue include turn-on charges, meter installation and tap charges, and delinquent payment charges. The projection of these revenues is based on historical activity levels and expected future customer growth. Water and Wastewater System Revenue Requirements Summary The projected net revenue requirements through Fiscal Year 2009 for the City's water system that are estimated to be needed to be recovered from user rates or charges are summarized below: K:A1 173-01\Ltr Report.doc -c�- DRAFT Fiscal Year Revenue Requirements-Water System [1] Water System 2004 2005 2006 2007 2008 2009 Total Operating Expenses $2,139,662 $2,448,297 $2,552,285 $2,723,179 $2,872,338 $3,033,192 Existing Debt Service 66,064 10,931 0 7,431 0 0 Additional Debt Service 0 0 0 0 1,043,231 1,043,189 Capital Funded from Rates/R&R and Other Deposits 32,000 120,900 97,818 99,970 102,169 104,417 Total Water Expenditures/Transfers 2,237,726 2,580,128 2,650,103 2,830,580 4,017,738 4,180,798 Less Income and Funds from Other Sources 151,176 156,872 163,670 170,561 175,714 178,952 Net Revenue Required from Rates &2 42 $114 s2 bo 9�12 842 025 4 0 1 4 [1] Derived from Table 3. As can be seen in the above summary, the estimated net revenue requirements for the water system for the six (6) years beginning with the Fiscal Year 2004 are anticipated to increase by approximately 14% or approximately $380,000 per year on average. The primary reasons for these increases are: i) continued inflationary increases in operating expenses; ii)the additional debt service associated with the water plant upgrade and expansion and water transmission main improvements; iii) incremental operating expenses incurred with the expansion and upgrade of the water plant; and iii) funding requirements for continued departmental capital needs for vehicles and equipment and water system asset renewal and replacements. The corresponding net revenue requirements through Fiscal Year 2009 for the wastewater system are summarized as follows: Fiscal Year Revenue Requirements-Wastewater System 11] Wastewater System 2004 2005 2006 2007 2008 2009 Total Operating Expenses $2,544,969 $2,690,453 $2,832,703 $2,962,526 $3,099,212 $3,243,530 Existing Debt Service 44,299 7,330 0 4,982 0 0 Additional Debt Service 0 0 0 0 193,769 193,761 Capital Funded from Rates/ R&R and Other Deposits 130,409 270,976 347,496 408,568 271,997 325,016 Total Wastewater Expenditures/Transfers 2,719,677 2,968,759 3,180,199 3,376,076 3,564,978 3,762,307 Less Income and Funds from Other Sources 92,517 96,185 100,302 105,057 107,836 108,743 Net Revenue Required from Rates S2 Cz27�160 2 72 $3,079.896 2 1 Q2 .457.142 $3,C53 5�4 [1] Derived from Table 4. As can be seen in the above summary, the estimated net revenue requirements for the wastewater system for the six (6) years beginning with the Fiscal Year 2009 are anticipated to increase by approximately 7% or approximately $205,000 per year on average. The primary reasons for these increases are: i) continued inflationary increases in operating expenses; ii) the additional debt service associated with lift station rehabilitation program; and iii)pay-as-you-go funding requirements for continued water collection system renewal and replacements. K:\1173-01\Ltr Reporl.doc -9- DRAFT Adequacy of Existing Utility Rate Revenues As shown on Table 3, based on the forecast of sales and revenues for the water system and the assumptions and considerations set forth herein with respect to the estimation of water system revenue requirements, the existing water rate revenue deficiency for the study period is anticipated to be as follows: Fiscal Year Ending September 30, 2004 2005 2006 2007 2008 2009 Water System[1] Net Revenue Requirements from Retail Rates $2,086,550 $2,423,256 $2,486,433 $2,660,019 $3,842,025 $4,001,846 Water Rate Revenue From Existing Rates (Projected) 2,243,055 2,269,662 2,273,483 2,277,304 2,281,124 2,284945 Estimated Surplus/(Deficiency)Under Existing Rates ]56.5 5152M 212 5 3-82 3 15 (l 56Q 221 1 71 f 201 System-Wide Rate Adjustments Proposed[2] 0% 10% 12% 12% 12% 120/6 Proposed Implementation Date Oct. 04 Oct. 05 Oct.06 Oct. 07 Oct.08 Additional Revenue From Prior-Year Rate Increases $0 $0 $227,300 $528,300 $866,500 $1,246,300 Additional Revenue From Current Year Rate Adjustments 0 227,000 300,100 336,700 377,700 423,700 Total Water Rate Revenue 2,243,055 2,496,662 2,800,883 3,142,304 3,525,324 3,954,945 Estimated Revenue Surplus/(Deficiency)Under Proposed Rate Implementation[3] $156,505 $73,406 $314,450 $482,284 ($316,701) ($46,901) [1] Derived from Table 3. [2] Effective October I stof each fiscal year. [3] Estimated Surplus/Deficiencies assume rate adjustments are implemented. As shown above for the water system, a 10% system-wide water rate increase is proposed for bills rendered on or after October 1, 2004. Subsequent rate adjustments that are needed to meet future revenue requirements are recommended for implementation at October I of each fiscal year. The City should review rates in approximately two (2) years in order to assess the actual level of future rate adjustments necessary. As shown on Table 4, based on the forecasted growth of the wastewater system and the assumptions and considerations set forth herein with respect to the estimation of wastewater system expenditures, the existing wastewater rate revenue deficiency in the study period is anticipated to be as follows: K:A1 173-01\Ltr Report.doc -10- DRAFT Fiscal Year Ending September 30, 2004 2005 2006 2007 2008 2009 Wastewater System[I] Net Revenue Requirements from Retail Rates $2,627,160 $2,872,574 $3,079,896 $3,271,019 $3,457,142 $3,653,564 Wastewater Rate Revenue From Existing Rates (Projected) 2,627,160 2,659,774 2,665,297 2,670,819 2,676,342 2,681,864 Estimated Surplus/(Deficiency)Under Existing Rates 0 212 80 414 5 C 1Q_2Q0 (7g0•g001 (971,700) System-Wide Rate Adjustments Proposed[2] 0% 8% 8% 8% 7% 6% Proposed Implementation Date Oct.04 Oct.05 Oct.06 Oct.07 Oct.08 Additional Revenue From Prior-Year Rate Increases $0 $0 $213,200 $444,400 $695,100 $933,000 Additional Revenue From Current Year Rate Adjustments 0 212,800 230,300 249,200 236,000 216,900 Total Wastewater Rate Revenue 2,627,160 2,872,574 3,108,797 3,364,419 3,607,442 3,831,764 Estimated Revenue Surplus/(Deficiency)Under Proposed Rate Implementation[3] $0 $0 $28,900 $93,400 $150,300 $178,200 [1] Derived from Table 4. [2] Effective October I S1 of each fiscal year. [3] Estimated Surplus/Deficiencies assume rate adjustments are implemented. As shown above, the rate adjustments needed to meet the future revenue requirements for the wastewater system reflect an 8% system-wide wastewater rate increase that is proposed for bills rendered on or after October 1, 2004. Subsequent rate adjustments are recommended at October 1 of each fiscal year. The City should review rates in approximately two (2) years in order to assess the actual level of future rate adjustments necessary. Debt Service Compliance In addition to meeting the net revenue requirements (i.e., expenditure requirements), the proposed water and wastewater rates must be sufficient to meet the debt service coverage requirements of the City's proposed future SRF debt allocated to the water and wastewater system. This City's covenant related to the proposed SRF debt requires the City to: "...fix, establish and maintain such rates and will collect such fees, rentals or other charges whenever necessary, as will always provide Gross Revenues in each Fiscal Year sufficient to pay (a) one hundred per centum (100%) of all Costs of Operation and Maintenance of the System for such Fiscal Year and (b) one hundred and fifteen per centum (115%) of all SRF principal and interest payable for such fiscal year." K:AI 173-01\Ltr Repoi7.doc -1 1- DRAFT As summarized on Table 10, the anticipated revenue for the water and wastewater systems, assuming that the City adopts the proposed rates in this report, should be adequate for the forecast period to meet the rate covenant requirements of the anticipated future SRF debt. The projected debt service coverage for the City's anticipated borrowings is summarized on the following table: Debt Service Coverage [1] Fiscal Year SRF Coverage [2] 2004 N/A 2005 N/A 2006 N/A 2007 N/A 2008 117% 2009 145% [I] Amounts obtained from Table 10. [2] Required coverage of 1 15%. RATE DESIGN Rate design involves the calculation of monthly rates and charges for each customer classification (i.e., residential, commercial, etc.). The goal of this task is to establish a pricing structure or formula to recover the total revenue requirements of the utility system in an equitable manner, consistent with the cost of providing service, regulatory guidelines, overall revenue stability, and the City's fiscal and pricing policies. The proposed utility rates, to the extent practical, should meet the following criteria for service provided by publicly owned utilities: • Utility rates should be based on a policy that calls for the lowest possible prices consistent with the requirements of providing quality service on an ongoing basis. • Utility rates should be simple and understandable. • Utility rates should be equitable among customers, taking into consideration the cost of providing service to the various users of the system. • Utility rate and cost recovery strategies should recognize the system's current financial needs, and where possible, help develop approaches to avoid "rate shock" in the future. • Utility rates should be designed to encourage the most efficient use of the City's utility plant investment and discourage unnecessary or wasteful use of resources. • Utility rates should comply with applicable orders and requirements of state and federal regulatory authorities, if any, that may have jurisdiction. Other considerations that have an effect on the design of the user fees include revenue stability, historical rate form, and competitiveness with neighboring utility systems. K:A1 I73-01\Ltr Report.doc -12- DRAFT In order to make a reasonable determination of the projected revenues from each customer classification, it is beneficial to have a customer bill frequency analysis. The bill frequency analysis summarizes the number of bills rendered at various consumption levels for each customer classification, and provides a way to analyze the effect of any change in rates. The City provided PRMG with customer and sales information by customer classification and service type on an annual basis for Fiscal Year 2003. The billing information is used to develop a bill frequency analysis for the water and wastewater system. This bill frequency analysis is used to develop a projection of detailed billing determinants for each customer class (i.e., water usage by rate block) which along with the customer and sales forecast provides the basis for estimating utility rate revenues and interpreting the effects of proposed rate changes. Classification of Water and Wastewater Costs In order to properly design water and wastewater rates it is necessary to allocate costs to the various rate structure components (e.g., monthly base service charge versus the usage charge). The water and wastewater system costs are classified into three groups for ratemaking purposes: i) fixed costs including certain production, transmission and distribution operating, maintenance and capital-related costs; ii) variable or flow-related costs such as chemicals for treatment, disposal, and pumping costs; and iii) billing and customer service related costs. The water and wastewater system revenue requirements are assigned to these three cost classifications on the following basis: 1. Fixed Costs - Those costs that are incurred to maintain a system of readiness capable of meeting the total combined demands of all customers are classified as fixed or capacity- related costs. Capacity costs include that portion of operating and maintenance expenses, capital expenditures, and other costs that are generally fixed and do not vary materially with the quantity of flow or that cannot be designated specifically as a customer or variable cost. Fixed costs are further classified into base capacity costs and extra capacity costs based on system peak to average demand relationships. Except as noted otherwise, for rate design purposes the base capacity costs are generally included in volume charges while the extra capacity costs are included in the monthly customer charge. 2. Variable Costs - Those costs that vary substantially or directly with flow, including such items as chemicals, utilities, and sludge disposal are classified as variable or flow-related costs. 3. Customer or Service Costs - Those costs directly related to the number and type of customers, such as customer accounting, billing, meter, and services-related expenses are classified as customer-related costs. K:A1173-01\Ltr Repoitdoc -1 3- DRAFT Tables 11 and 12 set forth the classification of the projected net revenue requirements for Fiscal Year 2005 of the water and wastewater systems, respectively. The fiscal year ending September 30, 2005 is the basis (test year) for the classification of water and wastewater costs for rate design purposes. As shown on Table 11, the classified water system costs are summarized as follows: Fiscal Year 2005 Water[1] Fixed Costs: Base Capacity $1,099,187 Extra/Peak Capacity 384,196 Total Fixed Costs $1,483,383 Variable Costs 486,510 Customer Costs 526,769 Total Net Revenue Requirements J2,496.662 [1] Derived from Table IL Table 12 sets forth the classification of the projected net revenue requirements for Fiscal Year 2005 of the wastewater system. As shown on Table 12, the classified wastewater system costs are summarized as follows: Fiscal Year 2004 Wastewater[I] Fixed Costs: Base Capacity $1,862,410 Extra/Peak Capacity 836,735 Total Fixed Costs $2,699,145 Variable Costs 0 Customer Costs 173,429 Total Net Revenue Requirements $�872,574 [1] Derived from Table 12. A detailed summary of the classified revenue requirements for Fiscal Year 2005 of the water and wastewater systems is shown on Tables 11 and 12, respectively. The following is a synopsis of the classification of the major cost categories. Water Treatment: All expenses in the water treatment function, with the exception of contractual services, utilities, and chemical supplies are classified according to the plant in service allocation which is currently 83% fixed and 17% customer. Contractual services, utilities, and chemical supplies, which include electric pumping costs and chemical costs, respectively, are classified as variable since they typically vary according to the level of water treated and pumped to customers. K:AI 173-01\1-tr Report.doc -14- DRAFT Wastewater Treatment: All expenses in the wastewater treatment function, contractual services payable to the City of Hollywood, are classified according to base/extra capacity. The wastewater base/extra capacity allocator is 74% base and 26% extra based on the peak day design criteria used in the City's Master Wastewater Plan. Water Transmission and Wastewater Collection: These costs are classified between base, extra, and customer-related according to the estimated expenditures on customer service needs versus overall system transmission needs. Administrative Costs (Water and Wastewater): These costs are classified according the salary classification of all other departments with the exception of other contractual services. Other contractual services are classified as direct customer related since this expense is a City allocated expense for customer service. Other Revenue Requirements: Annual debt service, capital funded from rates, and transfers to the Revenue Fund are classified based on the respective water and wastewater base/extra capacity allocators. The R&R Fund is classified based on the respective allocations between base, extra, and customer-related. Interest income and miscellaneous other revenue that reduces revenue requirements are classified as revenue-related. Water Rate Design Based on the customer forecast, the projected net revenue requirements of the water system and the cost of service analysis discussed earlier in this section, the proposed rates for the water system beginning October 1, 2004 are as follows: Proposed Water Rate Schedule Effective October I,2004 AVAILABILITY CHARGE (Per ERU) Residential $6.50 Commercial 6.50 Sprinklers 6.50 Laundry Mats 6.50 Condominiums 6.50 VOLUMETRIC CHARGE(Per 1,000 Gallons) Equivalent Residential Unit(ERU) Monthly Usage Range(Gallons) 0-5,000 $1.47 5,001-14,000 2.23 Above 14,000 2.27 Table 14 at the end of this report contains a bill comparison of existing to proposed residential water rates. As Table 14 shows, the monthly water bill for a residential water customer using 6,000 gallons of water per month (i.e., the average monthly residential consumption) will increase $1.57 from $14.51 to $16.08, or about 11%, under the proposed Fiscal Year 2005 rate increase. K:AI 173-01\Ltr Repon.doc -15- DRAFT Wastewater System Rate Design Based on the customer forecast, the projected net revenue requirements of the wastewater system and the cost of service analysis discussed earlier in this section, the proposed rates for the wastewater system beginning October 1, 2004 is as follows: Proposed Wastewater Rate Schedule Effective October 1,2004 [1] AVAILABILITY CHARGE(Per ERU) Residential $9.50 Commercial 9.50 Laundry Mat 9.50 Condominium 9.50 VOLUMETRIC CHARGE(Per 1,000 Gallons) Equivalent Residential Unit(ERU) Monthly Usage Range(Gallons) All Usage $2.86 Table 15 at the end of this report contains a bill comparison of existing to proposed residential wastewater rates. As Table 15 shows, the monthly wastewater bill for a residential wastewater customer using 6,000 gallons of water per month (i.e., the average monthly residential consumption) will increase $2.17 from $24.49 to $26.66, or about 9%, under the proposed Fiscal Year 2005 rate increase. Table 16 at the end of this report contains a bill comparison of total monthly water and wastewater bills for existing and proposed residential water and wastewater rates. Under the proposed Fiscal Year 2005 rates, a typical 6,000-gallon water and wastewater bill would increase by $3.74 from S39.00 to $42.74. This represents an approximate 10% increase over current water and wastewater rates at this usage level. Tables 17 to 19 reflect similar comparisons for the typical commercial bill based on the Fiscal Year 2005 proposed increase. The typical commercial bill reflects average monthly usage of approximately 4,000 gallons. Appendix A, at the end of this report, presents proposed rates through Fiscal Year 2009. In addition, comparisons of existing to proposed water and wastewater rates is illustrated with neighboring utilities in Appendix B. Appendix B at the end of this report shows single-family residential water and wastewater rate comparisons that include a number of municipal-owned utilities in Florida. When making comparisons of rates for water and wastewater service, several factors may have an effect on the rate levels being charged. These factors may include: 1. Level of treatment required before the distribution of water to the ultimate customer; 2. Level of treatment and effluent disposal methods of wastewater service; 3. Plant capacity utilization, age, and assistance in construction by federal grants, system development charges, etc.; K:\I I73-01\Ltr Report.doc -16- DRAFT 4. General fund and administrative fee transfers made by municipal and County systems which may account for differences in the level of rates charged; and 5. Bond Covenants and funding requirements of the rates. For the utilities included in the rate comparisons, no analysis has been made of the above- mentioned factors, as they related to the reported water and wastewater rates currently being charged. IMPACT FEES Similar to most water and wastewater utilities throughout Florida, the City charges impact fees to those customers requesting a new connection to the City's water and wastewater system. An impact fee is a charge imposed on new users of real property to help finance the capital cost of constructing public facilities necessary to serve new connections. The purpose of an impact fee is to assign, to the extent practical, growth-related capital costs to those new residents or users responsible for such additional costs. The impact fee can be considered to be a new user's contribution to those facilities or capital costs required to provide a comparable level of service to that which is being provided to existing customers. Appendix C at the end of this report provides the detailed calculations that support the methodology used in developing the proposed impact fees provided herein. The City's existing impact fees per equivalent Residential User (ERU) are $990 and $352 for water and wastewater, respectively. Based on a review of the City's detailed fixed assets and future planned capital improvements that can be allocated to new customers, the following impact fees are proposed to be adopted effective October 1, 2004: Proposed Water Impact Fee per ERU $1,185 Proposed Wastewater Impact Fee per ERU 685 Combined Water and Wastewater Impact Fee per ERU $LM As shown above the proposed water impact fee increases by $195 from $990 to $1,185, and the proposed wastewater impact fee increases by $333 from $352, to $685. The combined water and wastewater impact fee increases by $528 from $1,342 to $1,870. While the overall impact fee level increases, the proposed impact fee levels are comparable to impact fees of other nearby utilities as shown on Table C-5 in Appendix C and summarized below: Comparison of Existing and Proposed Impact Fees with Other Utilities 111 Impact Fee per ERU Water Wastewater Total Dania Beach Existing $990 $352 $1,342 Proposed 1,185 685 1,870 Other Utilities Surveyed $1,658 $1,671 $3,329 [1] Amounts obtained from Table C-5 and reflect customers located inside the City limits. K:A1173-01\Ltr Report.doc -17- DRAFT Appendix C at the end of this report provides further detail and discussion relative to the results of this impact fee analysis. MISCELLANEOUS SERVICE CHARGES The City has provided information regarding the cost of providing a variety of miscellaneous services. These services are typically customer-specific costs that are recovered through a specific group of fees. Examples of miscellaneous service fees include meter installation charges, late payment fees and tap charges. Based on the information provided by the City the proposed miscellaneous service fees are shown in Table D-1 in Appendix D of this report. CONCLUSIONS AND RECOMMENDATIONS Based on our studies, assumptions, considerations, and analyses as summarized herein, we are of the opinion that: 1. The City's existing rates for water and wastewater service systems will not recover the water and wastewater systems projected revenue requirements for the fiscal years ending September 30, 2004 through 2009 based on the funding requirements of the City's Capital Improvement Program. 2. The City should consider adopting the water and wastewater rates proposed effective October 1, 2005 and October 1 each fiscal year thereafter. The proposed rates are anticipated to meet the projected revenue requirements through Fiscal Year 2009. The revenue requirements include operation and maintenance expenses, the funding of capital improvements, and the payment of debt service on the City's existing and anticipated debt service. 3. The City should reevaluate its rates in two years to redefine any future rate needs. 4. The City should consider adopting the proposed impact fees as summarized in this report. 5. The City should consider adopting the proposed miscellaneous service charges reflected in this report. 6. If adopted, the proposed rates as reflected in the study should be adequate to meet the rate covenant requirements (e.g., debt service coverage) of the City's proposed SRF debt. 7. The proposed rates produce monthly water and wastewater bills that are comparable with those of neighboring utilities. K:\1 173-01\Ltr Rcpori.doc -1 g- "ABLES O/ 00 Q 0.. v� o�n o�n o0000o momo 0 000 0o QQooQQ oo�o 0 000 00 �e e O m rni M N N O N h O O O O O Q Q O O Q p m N N O 0 0 0 0 0 0 r b O N I�L-c ID N O O N N N N O fmV O O N W Q O vbi v�Oi v`Oi O 00 O h N 1O �O Q O N O � � v a o 0 0. o 0 0 0 0 o 0 0 0 o n o Q o o r o r o r Q o o Q mom o v a o 0 0 0 0 o a ry L 3 O m N N N m orvo — �n v� v��n N O O O O M n W Op o Q m m m m b O O 0 0 O O F R cNC U O m M m N N N O Ga 3 a ry aW U y < 3 � k• Z r�Z '"'Z �° b Z Z b b N N Z N Z z z Z Z ^Z vi v�i Z Z h N N O Z O z Z z z z ^Z rrvn n Wn.z z y �N E E a E E c E f a6 7 U¢ �o c � � ° o�o c � v `v �o ❑ i zEN E¢ 'a ° aa' �� ya ;vr � € 5 as - 5 a z 0 o cL o 'o o w' o 0 0 0 0 0 0 E z° o aa o 0 o a: o 0 0 0 0 0 K aSH W F FF¢WFF zF3FFF oSF WF FF¢W HH zF-F3HF FF °zS[- W F FF+ ZF F.F. v 3 =z O-� m �n I n m 1- O -Q N Q a m m m m m m Q Q'V Q V NF owl a 00 O O P 0 0 0 r1 N 'Q[-:16 0 0 0 O Q1 w N -- 00 O O O U N O -- 00 0 0 O t�N N C 9 W N � O h - N e e b o 0 0 '� " ' E o00 oo nr moo 00o rho �M eoa o nN�a o o 0. Q Q Q O Q n n r0 Q Q _Q Q Q n_Q N N Q Q P n Q Q Q N mzZ 2'zz y tD N � O Si T O 'O j O n O u`JN c c o Fo W F F.F. la o vi v W 0 N �-» o 0o Q P. vl O �n O vl N O O N N M P C T e e O O O O OM M O O O g e e 0 0 0 O O r r W o o M h� M O O O O vri O O M O O M -� _ O O ID Q Q Q Q N O O Q Q vl�n vl vl vi N vi O O vi 0 0 O n M M N N — N O Q P Q N vi Q �n vi vl vl O O N O O M N C C W —M O O M O Q a e O O O O O h h W o o P Q Q Q Q M O 0 0 0 r 0 0 N O O Q Q vi vl vl v� n O O N vt O O U by M M M M h O O o0 00 O O vi O O u � rjj O T 0. O p O O O ^N O O r r O o0 o a r O r O r M O O S2O Q o a O O O h h m e e IT O M M N N -- L R N a G 3 O � v E U. u' zzz z NNrZ zC1N z'Z, zzz z zz �� z zz z z z z NvriZZ .L N M M M M o0 l W CO O M M M N N -- O T C T C T-E c Ea C W o N oC7 QQ EQ6 �'.�3c7 r oU u 4Q.�E<6 9 qq cG qGG S r O � 3 E d a a m a E a-,am © a a o]m y € y ro o o rX o 0 o w' o 0 0 0 0 0 o c4 o 0 0 0 0 0 9 z., F W F FFQ W FF 2F3FFF Ez...F W F FF2 W FF zF3FFF ;z F W F FF zFFF `o 4 a U & 3 8 zN M Q v b h o0 0 O N M Q v b r oo P O N Q h N ^ M n pQ a \( .! 7 !; 3 22z a2 rk22 el222 ® 2 / , g . / ; $ � ( � } : \\ }} \\}\ }})/$ \ §/\\ // \\ /: •! /\\/}}) z ® ®2/\20 (` #) Table 3 City of Dania Beach,Florida Page 1 of 1 2004 Water and Wastewater Rate and Fee Study DRAFT Projected Water Net Revenue Requirements Line Projected Fiscal Year Ending September 30, No. Description 2004 2005 2006 2007 2008 2009 I Operating Expenses[1] $ 2,139,662 $ 2,448,297 $ 2,552,285 $ 2,723,179 $ 2,872,338 $ 3,033,192 Other Revenue Requirements: Debt Service 2 Short-Term Notes(Water Meters and Vehicles) 66,064 10,931 0 7,431 0 0 3 Additional SRF Loan#1 0 0 0 0 1,043,231 1,043,189 4 Total Debt Service 66,064 10,931 0 7,431 1,043,231 1,043,189 Other Miscellaneous Revenue Requirements: 5 Transfers to(from)Operating Reserves Fund[2] 0 0 0 0 0 0 Departmental Capital and Capital Improvements: 6 Departmental Capital[3] 32,000 95,900 97,818 99,970 102,169 104,417 7 Funded From Utility Fees[4] 0 25,000 0 0 0 0 8 Transfers to R&R Reserves[5] 0 0 0 0 0 0 9 Total Other Miscellaneous Revenue Requirements 32,000 120,900 97,818 99,970 102,169 104,417 10 Gross Revenue Requirements 2,237,726 2,580,128 2,650,103 2,830,580 4,017,738 4,180,798 Less Other Income and Funds from Other Sources: I 1 Interest[6] 15,200 17,800 20,900 24,600 26,200 25,800 12 Other Revenue[7] 135,976 139,072 142,770 145,961 149,514 153,152 13 Total Other Income 151,176 156,872 163,670 170,561 175,714 178,952 14 Total Net Revenue Requirements[8] 2,086,550 2,423,256 2,486,433 2,660,019 3,842,025 4,001,846 Revenue from Rates: 15 Revenue from Existing Retail Rates[9] 2,243,055 2,269,662 2,273,483 2,277,304 2,281,124 2,284,945 16 Prior Year Rate Adjustment 0 0 227,300 528,300 866,500 1,246,300 17 Total Applicable Rate Revenue 2,243,055 2,269,662 2,500,783 2,805,604 3,147,624 3,531,245 Current Year Rate Adjustments 18 Current Year Rate Adjustments(Effective Oct. 1) 0.0% 10.0% 12.0% 12.0% 12.0% 12.0% 19 Revenue From Current Year Rate Adjustments - 227,000 300,100 336,700 377,700 423,700 20 Total Revenue From Rates $ 2,243,055 $ 2,496,662 $ 2,800,883 $ 3,142,304 $ 3,525,324 $ 3,954,945 21 Revenue Surplus/(Deficiency) 156,505 73,406 314,450 482,284 (316,701) (46,901) 22 Revenue Surplus/(Deficiency)% 6.98% 2.94% 11.23% 15.35% -8.98% -1.19% Footnotes: [1] Derived from Table 6. .[2] Required transfers to meet the working capital requirements of the City. [3] Based on planned capital purchases as provided by the City. [4] Derived from Table 9. [5] Required transfers based on renewal and replacements as identified in Table 9. [6] Estimated based upon flow of funds balance. [7] Miscellaneous charges and revenues based upon historical trends as provided by the City. [8] Total net revenue requirements to be recovered from rates. [9] Projected rate revenues based on customer forecast identified in Table 1 and existing City rates. Table 4 Page I of I City of Dania Beach,Florida DRAFT 2004 Water and Wastewater Rate and Fee Study Projected Wastewater Net Revenue Requirements Line Projected Fiscal Year Ending September 30, No. Description 2004 2005 2006 2007 2008 2009 1 Operating Expenses[1] $ 2,544,969 $ 2,690,453 $ 2,832,703 $ 2,962,526 $ 3,099,212 $ 3,243,530 Other Revenue Requirements: Debt Service 2 Short-Term Notes(Water Meters and Vehicles) 44,299 7,330 0 4,982 0 0 3 Additional SRF Loan#1 0 0 0 0 193,769 193,761 4 Total Debt Service 44,299 7,330 0 4,982 193,769 193,761 Other Miscellaneous Revenue Requirements: 5 Transfers to(from)Operating Reserves Fund[21 118,409 (52,424) 22,628 82,053 (56,202) (4,903) Departmental Capital and Capital Improvements: 6 Departmental Capital[3] 12,000 73,400 74,868 76,515 78,199 79,919 7 Funded From Utility Fees 141 0 0 0 0 0 0 8 Transfers to R&R Reserves[5] 0 250,000 250,000 250,000 250,000 250,000 9 Total Other Miscellaneous Revenue Requirements 130,409 270,976 347,496 408,568 271,997 325,016 10 Gross Revenue Requirements 2,719,677 2,968,759 3,180,199 3,376,076 3,564,978 3,762,307 Less Other Income and Funds from Other Sources: 11 Interest 161 15,100 17,800 20,900 24,600 26,200 25,900 12 Other Revenue[7] 77,417 78,385 79,402 80,457 8L636 82,843 13 Total Other Income 92,517 96,185 100,302 105,057 107,836 108,743 14 Total Net Revenue Requirements[8) 2,627,160 2,872,574 3,079,896 3,271,019 3,457,142 3,653,564 15 Revenue from Existing Retail Rates[9] 2,627,160 2,659,774 2,665,297 2,670,819 2,676,342 2,681,864 16 Prior Year Rate Adjustment 0 0 213,200 444,400 695,100 933,000 17 Total Applicable Rate Revenue 2,627,160 2,659,774 2,878,497 3,115,219 3,371,442 3,614,864 Current Year Rate Adjustments 18 Current Year Rate Adjustments(Effective Oct. 1) 0.0% 8.0% 8.0% 8.0% 7.0% 6.0% 19 Revenue From Current Year Rate Adjustments - 212,800 230,300 249,200 236,000 216,900 20 Total Revenue From Rates $ 2,627,160 $ 2,8 22,574 $ 3,108,797 $ 3,364,419 $ 3,607,442 $ 3,831,764 21 Revenue Surplus/(Deficiency) 0 0 28,900 93,400 150,300 178,200 22 Revenue Surplus/(Deficiency)% 0.00% 0.00% 0.93% 2.78% 4.17% 4.65% Footnotes: [11 Derived from Table 7. [2] Required transfers to meet the working capital requirements of the City. [3] Based on planned capital purchases as provided by the City. [4] Derived from Table 9. [5] Required transfers based on renewal and replacements as identified in Table 9. [6] Estimated based upon flow of funds balance. [7] Miscellaneous charges and revenues based upon historical trends as provided by the City. [81 Total net revenue requirements to be recovered from rates. 191 Projected rate revenues based on customer forecast identified in Table 2 and existing City rates. Table 5 Page 1 of 3 DRAFT City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Allocation of Utility Ouerafne Expenses to Individual System Approved Percent Allocation Allocation Line Budget As Adjusted No. Description 2004 f11 Adjustments 2004 Basis Water Wastewater Water Wastewater OPERATING EXPENSES: WATER SYSTEM(Water Fund) Water Administration l Regular Salaries $92,660 $0 $92,660 Direct-W 100.00% 0.00% $92,660 $0 2 Overtime 1,000 0 1,000 Direct-W 100.00% 0.00% 1000 0 3 Longevity Pay 2,531 0 2,531 Direct-W 100.00% 0,00% 2,531 0 4 HCA Taxes 6,588 0 6,588 Direct-W 100.00% 0.00% 6,588 0 5 Medicare Taxes 1,541 0 1,541 Direct-W 100.00% 0.00% 1,541 0 6 Retirement Contributions 16,945 0 16,945 Direct-W 100,00% 0.00% 16,945 0 7 Life&Health Insurance 16,965 0 16,965 Direct-W 100.00% U0% 16,965 0 8 Workers Compensation 248 0 248 Direct-W 100.00% &00% 248 0 9 Accounting and.Auditing 4,376 0 4,376 Direct-W 100,00% 0.00% 4,376 0 10 Contractual Services 1,014 0 1,014 Direct-W 100.00% 0.00% 1,014 0 11 Training&Per Diem 1,000 0 1,000 Direct-W 100.00% 0.00% 1,000 0 12 Expense Account 1,800 0 1,800 Direct-W 100.00% 0,00% 1,800 0 13 Telephone 2,412 0 2,412 Direct-W 100.00% 0.00% 2,412 0 14 Electricity 360 0 360 Direct-W 100.00% 0.00% 360 0 15 Equipment Rentals 756 0 756 Direct-W 100.00% 0.00% 756 0 16 Trailer Rentals 2,700 0 2,700 Direct-W 100,00% 0.00% 2,700 0 17 Insurance Coverage 37,956 0 37,956 Direct-W 100.00% 0.00% 37,956 0 18 Office Supplies 1,050 0 1,050 Direct-W 100.00% 0,00% 1,050 0 19 Miscellaneous Supplies 1,500 0 1,500 Direct-W 100.00% 0.00% 1,500 0 20 Building Supplies 900 0 900 Direct-W 100.00% 0.00% 900 0 lnterfund Transfer 224373 0 224,373 Direct-W 100.001/6 0.00% 224,373 0 21 Total Administration $418,675 $0 $418,675 $418,675 $0 Water Accounting&Billing 22 Regular Salaries $69,698 $0 $69,698 Direct-W 100.00% 0.00% $69,698 $0 23 Part-time Salaries 10,350 0 10,350 Direct-W 100,00% 0.00% 10,350 0 24 Overtime 500 0 500 Direct-W 100.00% 0.00% 500 0 25 Longevity Pay 2,058 0 - 2,058 Direct-W 100.00% 0.00% 2,058 0 26 Accrued Leave Buyback - 2,000 0 2,000 Direct-W 100.00% 0.00% 2,000 0 27 FICA Taxes 5,587 0 5,587 Direct-W 100.00% 0.00% 5,587 0 28 Medicare Taxes 1307 0 1307 Direct-W 100,00% 0.00% 1,307 0 29 -Retirement Contributions 9,261 0 9,261 Direct-W 100.00% 0.00% 9,261 0 30 Life&Health Insurance 20,047 0 20,047 Direct-W 100.00% 0.00% 20,047 0 31 Workers Compensation 325 0 325 Direct-W 100.000/o 0.00% 325 0 32 Professional Service 15,000 0 15,000 Direct-W 100.00% 0.00% I5,000 0 33 Training&Per Diem 0 0 0 'Direct-W 100,00% 0.00% 0 0 34 Education Reim/Re-certification 2,500 0 2,500 Direct-W 100,00% 0.00% 2,500 0 35 Telephone 3,336 0 3,336 Direct-W 100.00% 0.00°/ 3,336 0 36 Postage 7,575 0 7,575 Direct-W 100.001/6 0.00% 7,575 0 37 Mtn.of Equipment 500 0 500 Direct-W 100.00% 0.00% 500 0 38 Printing&Binding 1,800 0 1,800 Direct-W 100.00% 0.00% 1,800 0 39 Office Supplies 910 0 810 Direct-W 100.00% 0,000/1 910 0 40 Miscellaneous Supplies 0 0 0 Direct-W 100.00% 0.001/6 0 0 41 Computer Software 0 0 0 Direct-W 100.00% 0.00% 0 0 42 Total Accounting&Billing $152,654 $0 $152,654 $152,654 $0 Water Distribution 43 Regular Salaries $161,625 $0 $161,625 Direct-W 100.00% 0.00% $161,625 $0 44 Overtime 25,000 0 25,000 Direct-W 100.00% 0.00% 25,000 0 45 Longevity Pay 6,007 0 6,007 Direct-W 100.001/6 0.00% 6,007 0 46 Accrued Leave Buyback 8,000 0 8,000 Direct-W 100.00% 0.00% 8,000 0 47 FICA Taxes 14,686 0 14,686 Direct-W 100.00% 0.00% 14,686 0 48 Medicare Taxes 3,435 0 3,435 Direct-W I00.00% 0.00% 3,435 0 49 Retirement Contributions 47,561 0 47,561 Direct-W 100.00% 0.00% 47,561 0 50 Life&Health Insurance 76,595 0 76,595 Direct-W 100.00% 0.00% 76,595 0 51 Workers Compensation 12,595 0 12,595 Direct-W 100.00% 0,00% 12,595 0 52 Professional Service 15,000 0 15,000 Direct-W 100.00% 0.00% 15,000 0 53 Contractual Services 1,800 0 1,800 Direct-W 100.00% 0.00% 1,800 0 54 Training&Per Diem 1,200 0 1,200 Direct-W 100.00% 0.00% L200 0 55 Telephone 1,620 0 1,620 Direct-W 100.00% 0,00% 1,620 0 56 Equipment Rentals 0 0 0 Direct-W 100.00% 0.00% 0 0 57 Trailer Rentals 0 0 6 Direct-W 100.00% 0.00% 0 0 58 Miscellaneous Rentals 3,000 0 3,000 Direct-W 100.00% 0.00% 3,000 0 59 Mm.of Equipment 35,000 0 35,000 Direct-W 100.00% 0.00% 35,000 0 60 Mtn.of Communication Equip. 0 0 0 Direct-W 100.00% 0.00% 0 0 61 Mm.of Vehicles 5,000 0 5,000 Direct-W 100.00% 0.00% 5,000 0 62 Mtn.of Buildings 0 0 0 Direct-W 100.00% 0.00% 0 0 63 Mtn.of Grounds 5,000 0 5,000 Direct-W 100.00% 0.00% 5,000 0 64 Mtn.of Utilities 30,000 0 30,000 Direct-W 100.00°/ 0.00% 30,000 0 65 Gasoline 14,000 0 14,000 Direct-W 100.00"/6 0.00% 14,000 0 66 Miscellaneous Supplies 82,000 0 82,000 Direct-W 100.00% 0.00% 82,000 0 67 Uniforms 600 0 600 Direct-W 100.00% 0.00% 600 0 68 Building Supplies 0 0 0 Direct-W 100.00% 0.0 V/6 0 0 69 Books,Subscriptions,Publications 100 0 100 Direct-W 100.00% 0.00% 100 0 70 Memberships 75 0 75 Direct-W 100.00% 0.00% 75 0 71 Total Water Distribution $549,899 $0 $549,899 $549,899 $0 Foomoles continued on Page 3 of 3. Table 5 Page 2 of 3 DRAFT City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Allocation of Utility Ooeratine Expenses to Individual Systems Approved Percent Allocation Allocation Line Budget As Adjusted No. Description 2004111 Adjustments 2004 Basis Water Wastewater Water Wastewater Water Plant 72 Regular Salaries $232,017 $0 $232,017 Direct-W 100.00% 0.00% $232,017 $0 73 Overtime 30,000 0 30,000 Direct-W 100.00% 0.00% 30,000 0 74 Longevity Pay 11,036 0 11,036 Direct-W 100.00% 0.00% 11,036 0 75 Accrued Leave Buyback 13,000 0 13,000 Direct-W 100.00% 0.00% 13000 0 76 FICA Taxes 21,094 0 21,094 Direct-W 100.00% 0.00% 21,094 0 77 Medicare Taxes 4,659 0 4,658 Direct-W 100.00% 0.00% 4,659 0 78 Retirement Contributions 69,339 0 69,339 Direct-W 100.00% 0.001/6 69,339 0 79 Life&Health Insurance 68,369 0 68,368 Direct-W 100.001/ 0,00% 68,368 0 80 Workers Compensation 10,356 0 10,356 Direct-W 100.00% 0.00% 10,356 0 81 Professional Service 1,500 0 1,500 Direct-W 100.00% 0.00% 1,500 0 82 Consultant Engineers 6,000 0 6,000 Direct-W 100.00% 0,00% 6,000 0 83 Contractual Services 174,320 0 174,320 Direct-W 100.00% 0.00% 174,320 0 84 Training&Per Diem 7,800 0 7,800 Direct-W 100.00% 0.00% 7,800 0 85 Education Reim/Re-certification 1,000 0 1,000 Direct-W 100.001/ 0.00% 1000 0 86 Expense Account 0 0 0 Direct-W 100.00% 0.00% 0 0 87 Telephone 660 0 660 Direct-W 100,00% 0.00% 660 0 88 .Postage 1,500 0 1,500 Direct-W 100.00% 0.00% 1,500 0 89 Electricity 91,200 0 91,200 Direct-W 100.00% 0.00% 91,200 0 90 Equipment Rentals 0 0 0 Direct-W 100.00% 0.00% 0 0 91 Miscellaneous Rentals 850 0 850 Direct-W 100.00% 0.00% 850 0 92 Mtn.Equipment 35,100 0 35,100 Direct-W 100.00% 0.00% 35,100 0 93 Mtn.of Communication Equip. 225 0 225 Direct-W I00.00% 0.00% 225 0 94 Mtn.of Vehicles 1,000 0 1,000 Direct-W 100.00% 0.00% 1,000 0 95 him.of Buildings 7,500 0 7,500 Direct-W 100.00% 0.00% 7,500 0 96 Mtn.of Grounds 13,560 0 13,560 Direct-W 100.00% 0.00% 13,560 0 97 Printing&Binding 3,000 0 3,000 Direct-W 100.00% 0.00% 3,000 0 98 Permit/License Fees 1,130 0 1,130 Direct-W 100.00% 0.00% 1,130 0 99 Office Supplies 0 0 0 Direct-W 100.00% 0.00% 0 0 t00 Gasoline 2,000 0 2,000 Direct-W 100.00% 0.00% 2,000 0 101 Miscellaneous Supplies 25,000 0 25,000 Direct-W 100.00% 0.00% 25,000 0 102 Chemicals Supplies 147,600 0 147,600 Direct-W 100.00% 0.001/ 147,600 0 103 Building Supplies 4,000 0 4,000 Direct-W 100,00% 0.00% 4,000 0 104 Books,Subscriptions,Publications 200 0 200 Direct-W 100.001/ 0,00% 200 0 105 Memberships 1,800 0 1,800 Direct-W 100.00% 0.00% 1,800 0 106 Depreciation f2j 195000 (195,000) 0 'Direct-W 100.00% 0.00% 0 0 107 Total Water Plant $1,181,813 ($195,000) $986,813 $986,813 $0 108 TOTAL WATER OPERATING EXPENSES $2,303,041 ($195000) $2,108,041 $2,108041 $0 WASTEWATER SYSTEM(Sewer Fund) Sewer Administration 109 Regular Salaries $32,117 $0 $32,117 Direct-S 0.001/ 100.00% $0 $32,117 110 Overtime 1,000 0 1,000 Direct-S 0.00% 100.00% 0 1,000 III Longevity Pay 1,266 0 1266 Direct-S 0.00% 100.00% 0 1,266 112 Accrued Leave Buyback 1000 0 1,000 Direct-S 0.00% 100.00% 0 1,000 113 FICA Taxes 2,444 0 2,444 Direct-S 0.00% 100.00% 0 2,444 114 Medicare Taxes 654 0 654 Direct-S 0.001/ 100.00% 0 654 115 Retirement Contributions 8,472 0 8,472 Direct-S 0.001/6 100.001/ 0 8,472 116 Life&Health Insurance 8,482 0 8,482 Direct-S 0.001/ 100.001/6 0 8,482 117 Worker's Compensation 124 0 124 Direct-S 0.00% 100.00% 0 124 ll8 Accounting and Auditing 5,119 0 5,119 Direct-S 0.00% 100.00% 0 5,119 119 Contractual Services 507 0 - 507 Direct-S 0.001/6 100.00% 0 507 120 Training&Per Diem 0 0 0 Direct-S 0.00% 100.00% 0 0 121 Expense Account 900 0 900 Direct-S 0.001/6 100.00% 0 900 122 Telephone 1,026 0 1,026 Direct-S 0.00% 100.00% 0 1,026 123 Electricity 180 0 180 Direct-S 0.00% 100.00% 0 180 124 Equipment Rentals 378 0 378 Direct-S 0.00% 100.00% 0 378 125 Trailer Rentals 1,350 0 1,350 Direct-S 0.00% 100.00% 0 1,350 126 Insurance Coverage 46,187 0 46,187 Direct-S 0.00'/6 100.00% 0 46,187 127 Office Supplies 525 0 525 Direct-S 0.00% 100.00% 0 525 128 Building Supplies 450 0 450 Direct-S 0.00% 100.001/6 0 450 Interfund Transfer 185,413 0 185,413 Direct-S 0.00% 100.00% 0 185,413 129 Total Administration $297.594 $0 $112,181 $0 $112,181 Sewer Accounting&Billing 130 Regular Salaries $55,990 $0 $55,990 Direct-S 0.00% 100.00% $0 $55,990 131 Part-time Salaries 10,945 0 10945 Direct-S 0.00% 100.00% 0 10,945 132 Overtime 500 0 500 Direct-S - 0.00% 100.001/1 0 500 133 Longevity Pay 1,149 0 1149 Direct-S 0.00% 100.00% 0 1,149 134 Accrued Leave Buyback 1,000 0 1000 Direct-S 0.00% 100.00% 0 1,000 135 FICA Taxes 4,905 0 4905 Direct-S 0,00% 100.00% 0 4,905 136 Medicare Taxes 1,145 0 1145 Direct-S 0.00% 100.00% 0 1,145 137 Retirement Contributions IS 695 0 15695 Direct-S 0.001/6 100.00% 0 15,695 138 Life&Health Insurance 20,047 0 20047 Direct-S 0.00% 100.00% 0 20,047 139 Worker's Compensation 269 0 269 Direct-S 0.00% 100.00% 0 269 140 Professional Service 15,000 0 15000 Direct-S 0.00% 100.00% 0 15,000 141 Training&Per Diem 900 0 800 Direct-S 0.00% 100.00% 0 800 142 Telephone 2,856 0 2856 Direct-S 0.00% 100.001% 0 2,856 143 Postage 7,575 0 7575 Direct-S 0.00% 100.001/ 0 7,575 144 Printing&Binding 1,800 0 1800 Direct-S 0.00% 100,00% 0 1,800 145 Office Supplies 800 0 800 Direct-S 0.00% 100,00% 0 800 146 Computer Software 0 0 0 Direct-S 0.00% 100.00% 0 0 147 Total Accounting&Billing $140,476 $0 $140,476 $0 $140,476 Footnotes continued on Page 3 of 3. Table 5 Page 3 of 3 DRAFT City of Dania Beach,Florida 2Do4 Water and Wastewater Rate and Fee Study Allocation of Utility Operating Expenses to Individual Systems Approved Percent Allocation Allocation Line Budget As Adjusted No. Description 2004[11 Adjustments 2004 Basis Water Wastewater Water Wastewater Sewer Collection 148 Regular Salaries $162,483 $0 $162,483 Direct-S 0.00% 100.00% $0 $162,483 149 Overtime 15,000 0 15,000 Direct-S 0.00% 100.00% 0 15,000 150 Longevity Pay 9,667 0 9,667 Direct-S 0.00% 100.00% 0 9,667 151 Accrued Leave Buyback 3,500 0 3,500 Direct-S 0.00% 100.00% 0 3,500 152 FICA Taxes 13,789 0 13,789 Direct-S 0.00% 100,00% 0 13,789 153 Medicare Taxes 3,225 0 3,225 Direct-S 0.00% 100.00% 0 3,225 154 Retirement Contributions 47,566 0 47,566 Direct-S 0.00% 100.00% 0 47,566 155 Life&Health Insurance 70,686 0 70,686 Direct-S 0.00% 100.00% 0 70,686 156 Worker's Compensation 8,030 0 8,030 Direct-S 0.00% 100.00% 0 8,030 157 Consultant Engineers 30,000 0 30,000 Direct-S 0.00% 100.00% 0 30,000 158 Contractual Services 1,577,694 0 1,577,694 Direct-S 0.00% 100.00% 0 1,577,694 159 Training&Per Diem 2,000 0 2,000 Direct-S 0,00% 100.00% 0 2,000 160 Telephone 1,644 0 1,644 Direct-S 0.00% 100,00% 0 1644 161 Electricity 42,000 0 42,000 Direct-S 0.00% ID0.00% 0 42,000 162 Equipment Rentals 1,000 0 1,000 Direct-S 0.00% 100.00% 0 1,000 163 Trailer Rentals 1,775 0 1,775 Direct-S 0.00% 100,00% 0 1,775 164 Miscellaneous Rentals 0 0 0 Direct-S 0.00% 100.00% 0 0 165 Mtn.Equipment 12,000 0 12,000 Direct-S 0.00% 100.00% 0 12,000 166 Mtn.of Communication Equip. 0 0 0 Direct-S 0.00% 100.00% 0 0 167 Mtn.of Vehicles 2,850 0 2,850 Direct-S 0.00% 100.00% 0 2,850 168 Mt.of Grounds 5,820 0 5,920 Direct-S 0.001/6 100,00% 0 5,820 169 Mtn.of Utilities 25,000 0 25,000 Direct-S 0.00% 100.00% 0 25,000 170 Gasoline 3,500 0 3,500 Direct-S 0.00% 100,00% 0 3,500 171 Miscellaneous Supplies 30,000 0 30,000 Direct-S 0.001/. 100,00% 0 30,000 172 Building Supplies 0 0 0 Direct-S 0.00% 100.00% 0 0 173 Memberships 60 0 60 Direct-S 0.001/6 100.001/6 0 60 174 Depreciation[21 147000 (147,000) 0 Direct-S 0.00% 100.00°/ 0 0 175 Total Sewer Collection $2,216,289 ($147,000) $2,069,289 $0 $2,069,289 176 TOTAL WASTEWATER OPERATING EXPENSES $2,654,359 ($147,000) $2,321,946 $0 $2,321,946 177 TOTAL WATER AND WASTEWATER OPERATING EXPENSES $4,957,400 ($342,000) $4,429,987 $2,108,041 $2,321,946 Footnotes: [1] -Based on the Citys adopted budget for the Fiscal Year ending September 30,2004 as provided by the City. [21 Adjustment to operating and maintenance expenses for non-cash allocations. Table6 Pagel of2 DRAFT City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Projected Water Operative Expenses Adopted Line Escalation Budget Projected Fiscal Year Ending September 30, No. Description Reference[11 2004[21 2005[31 2006 2007 2008 2009 OPERATING EXPENSES-WATER SYSTEM WATER SYSTEM(Water Fund) Water Administration 1 Regular Salaries Labor $92,660 $105,317 $112,689 $120,577 $129,018 $138,049 2 Overtime Labor 1,000 1,000 1,070 1,145 1,225 1,311 3 Longevity Pay Labor 2,531 2,678 2,865 3,066 3,281 3,510 4 FICA Taxes Labor 6,588 7,940 8,496 9,091 9,727 10,408 5 Medicare Taxes Labor 1,541 1,857 1,987 2,126 2,275 2,434 6 Retirement Contributions Labor 16,945 31,950 34,187 36,580 39,140 41,880 7 Life&Health Insurance Ins 16,965 30,331 34,881 40,113 46,130 53,049 8 Workers Compensation Labor 248 1,609 1,722 1,842 1,971 2,109 9 Accounting and Auditing Inflation 4,376 4,376 4,464 4,562 4,662 4,765 10 Contractual Services Inflation 1,014 0 0 0 0 0 11 Training&Per Diem Labor 1,000 1,000 1,070 1,145 1,225 1,311 12 Expense Account Inflation 1,800 1,800 1,836 1,876 1,918 1,960 13 Telephone Inflation 2,412 3,000 3,060 3,127 3,196 3,266 14 Electricity Inflation 360 390 398 407 415 425 15 Equipment Rentals Inflation 756 1,244 1,269 1,297 1,325 1,354 16 Trailer Rentals Inflation 2,700 2,700 2,754 2,815 2,877 2,940 17 Insurance Coverage Ins 37,956 38,730 44,540 51,220 58,903 67,739 18 Office Supplies Inflation 1,050 1,500 1,530 1,564 1,598 1,633 19 Miscellaneous Supplies Inflation 1,500 1,000 1,020 1,042 1,065 1,089 20 Building Supplies Inflation 900 1,350 1,377 1,407 1,438 1,470 Interfund Transfer GF 224,373 235,038 242,089 249,352 256,832 264,537 21 Total Administration $418,675 $474,810 $503,302 $534,353 $568,222 $605,239 Water Accounting&Billing 22 Regular Salaries Labor $69,698 $59,847 $64,036 $68,519 $73,315 $78,447 23 Part-time Salaries Labor 10,350 11,248 12,035 12,878 13,779 14,744 24 Overtime Labor 500 500 535 572 613 655 25 Longevity Pay Labor 2,058 0 0 0 0 0 26 Accrued Leave Buyback Labor 2,000 2,000 2,140 2,290 2,450 2,622. 27 FICA Taxes Labor 5,587 5,158 5,519 5,905 6,319 6,761 28 Medicare Taxes Labor 1,307 1,207 1,291 1,382 1,479 1,582 29 Retirement Contributions Labor 9,261 18,535 19,832 21,221 22,706 24,296 30 Life&Health Insurance Ins 20,047 22,038 25,344 29,145 33,517 38,545 31 Worker's Compensation Labor 325 273 292 313 334 358 32 Professional Service Inflation 15,000 4,500 4,590 4,691 4,794 4,900 33 Training&Per Diem Labor 0 0 0 0 0 0 34 Education Relrn/Re-certification Inflation 2,500 0 0 0 0 0 35 Telephone Inflation 3,336 3,396 3,464 3,540 3,618 3,698 36 Postage Cust-Water 7,575 10,966 11,220 11,502 11,792 12,088 37 Mtn.of Equipment Cust-Water 500 500 512 524 538 551 38 Printing&Binding Inflation 1,800 200 204 208 213 218 39 Office Supplies Inflation 810 620 632 646 661 675 40 Miscellaneous Supplies Inflation 0 0 0 0 0 0 41 Computer Software Inflation 0 0 0 0 0 0 42 Total Accounting&Billing $152,654 $140,988 $151,648 $163,338 $]76,127 $190,139 Water Distribution 43 Regular Salaries Labor $161,625 $206,410 $220,859 $236,319 $252,861 $270,561 44 Overtime Labor 25,000 15,000 16,050 17,174 18,376 19,662 45 Longevity Pay Labor 6,007 8,573 9,173 9,815 10,502 11,237 46 Accrued Leave Buyback Labor 8,000 8,000 8560 9,159 9,800 10,486 41 FICA Taxes Labor 14,686 16,898 18,081 19,347 20,701 22,150 48 Medicare Taxes Labor 3,435 3,953 4,230 4,526 4,843 5,182 49 Retirement Contributions Labor 47,561 65,304 69,875 74,767 80,000 85,600 50 Life&Health Insurance Ins 76,595 75,182 86,459 99,428 114,342 131,494 51 Worker's Compensation Labor 12,595 10,520 11,256 12,044 12,887 13,790 52 Professional Service Inflation 15,000 5,000 5,100 5,212 5,327 5,444 53 Contractual Services Inflation 1,800 86,850 88,587 90,536 92,528 94,563 54 Training&Per Diem Labor 1,200 1,200 1,284 1,374 1,470 1,573 55 Telephone Inflation 1,620 2,000 2,040 2,085 2,131 2,178 56 Equipment Rentals Inflation 0 0 0 0 0 0 57 Trailer Rentals Inflation 0 0 0 0 0 0 58 Miscellaneous Rentals Inflation 3,000 3,000 3,060 3,127 3,196 3,266 59 Mm.of Equipment Cust-Water 35,000 20,000 20,463 20,978 21,506 22,047 60 Mtn.of Commurrication Equip. Cust-Water 0 0 0 0 0 0 61 Mtn.of Vehicles Cust-Water 5,000 5,000 5,116 5,245 5,377 5,512 Footnotes continued on Page 2 of 2. Page 2 of 2 Table 6 DRAFI. City of Dania Beach,Florida - 2004 Water and Wastewater Rate and Fee Study Projected Water Operating Expenses Adopted Line Escalation Budget Projected Fiscal Year Ending September 30, No. Description Reference[11 2004[21 2005[31 2006 2007 2008 2009 62 Mtn.of Buildings Inflation 0 0 0 0 0 0 63 Mtn.of Grounds Inflation 5,000 5,000 5,100 5,212 5,327 5,444 64 Mtn.of Utilities Cust-Water 30,000 25,000 25,579 26,223 26,883 27,559 65 Gasoline Inflation 14,000 11,834 12,071 12,336 12,608 12,885 66 Miscellaneous Supplies Inflation 82,000 75,000 76,500 78,183 79,903 81,661 67 Uniforms Inflation 600 1,500 1,530 1,564 1,598 1,633 68 Building Supplies Inflation 0 0 0 0 0 0 69 Books,Subscriptions,Publications Inflation 100 100 102 104 107 109 70 Memberships Inflation 75 75 77 78 80 82 71 Total Water Distribution $549,899 $651,399 $691,152 $734,836 $782,352 $834,118 Water Plant 72 Regular Salaries Labor $232,017 $269,199 $288,043 $308,206 $329,780 $352,865 73 Overtime Labor 30,000 25,000 26,750 28,623 30,626 32,770 74 Longevity Pay Labor 11,036 13,734 14,695 15,724 16,825 18,002 75 Accrued Leave Buyback Labor 13,000 8,000 8,560 9,159 9,800 10,486 76 FICA Taxes Labor 21,094 22,407 23,975 25,654 27,450 29,371 77 Medicare Taxes Labor 4,658 5,241 5,608 6,000 6,420 6,870 78 Retirement Contributions Labor 69,339 85,579 91,570 97,979 104,838 112,177 79 Life&Health Insurance Inflation 68,368 84,249 85,934 87,825 89,757 91,731 80 Worker's Compensation Labor 10,356 11,096 11,873 12,704 13,593 14,545 81 Professional Service Inflation 1,500 1,500 1,530 1,564 1,598 1,633 82 Consultant Engineers Inflation 6,000 28,000 6,242 6,380 6,520 6,664 83 Contractual Services Inflation 174,320 168,974 172,353 176,145 180,020 183,981 84 Training&Per Diem Labor 7,800 7,800 8,346 8,930 9,555 10,224 85 Education Reim/Re-certification Labor 1,000 1,000 1,070 1,145 1,225 1,311 86 .Expense Account - Inflation 0 0 0 0 0 0 87 Telephone Inflation 660 1,000 1,020 1,042 1,065 1,089 88 Postage Inflation 1,500 1,500 1,530 1,564 1,598 1,633 89 Electricity TotWatProd 91,200 118,000 120,570 245,500 251,337 257,312 90 Equipment Rentals Inflation 0 300 306 313 320 327 91 Miscellaneous Rentals Inflation 850 1,625 1,658 1,694 1,731 1,769 92 Mtn.Equipment Inflation 35,100 60,000 61,200 62,546 63,922 65,329 93 Mtn.of Communication Equip. Inflation 225 225 230 235 240 245 94 Mtn.of Vehicles Inflation 1,000 600 612 625 639 653 95 Mtn.of Buildings Inflation 7,500 24,000 24,480 25,019 25,569 26,131 96 Mtn.of Grounds Inflation 13,560 10,036 10,237 10,462 10,692 10,927 97 Printing&Binding Inflation 3,000 1,500 1,530 1,564 1,598 1,633 98 Peunit/LicenseFees Inflation 1,130 1,180 1,204 1,230 1,257 1,285 99 Office Supplies Inflation 0 0 0 0 0 0 100 Gasoline Inflation 2,000 1,198 1,222 1,249 1,276 1,304 101 Miscellaneous Supplies Inflation 25,000 20,650 21,063 21,526 22,000 22,484 102 Chemicals Supplies TotWatProd 147,600 170,000 173,703 88,421 90,523 92,675 103 Building Supplies Inflation 4,000 0 0 0 0 0 104 Books,Subscriptions,Publications Inflation 200 200 204 208 213 218 105 Memberships Inflation 1,800 1,125 1,148 1,173 1,199 1,225 106 Contingency[4J 1.50% 31,621 36,182 37,719 40,244 42,448 44,825 107 Total Water Plant $1,018,434 $1,181,100 $1,206,184 $1,290,652 $1,345,637 $1,403,696 108 TOTAL WATER OPERATING EXPENSES $2,139,662 $2,448,297 $2,552,285 $2,723,179 $2,872,338 $3,033,192 109 Annual%Increase 14.4% 4.2% 6.7% 5.5% 5.6% Footnotes: [11 Derived from Table 8. 12] Derived from Table 5 as adjusted. (31 Based on the City's proposed budget for the Fiscal Year ending September 30,2005 as provided by the City. [41 Adjustment to recognize unforeseen charges equal to 1.5%of total operating and maintenance expenses. Table 7 Page 1 of 2 DRAFT City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Proiected Wastewater Operatine Expenses Adopted Line Escalation Budget Projected Fiscal Year Ending September 30, No. Description Reference[1] 2004[2] 2005[3] 2006 2007 2008 2009 OPERATING EXPENSES-WASTEWATER SYSTEM WASTEWATER SYSTEM(Sewer Fund) Sewer Administration 1 Regular Salaries Labor $32,117 $29,672 $31,749 $33,971 $36,349 $38,894 2 Overtime Labor 1,000 800 856 916 980 1,049 3 Longevity Pay Labor 1,266 1,339 1,433 1,533 1,640 1,755 4 Accrued Leave Buyback Labor 1,000 500 535 572 613 655 5 FICA Taxes Labor 2,444 2,368 2,534 2,711 2,901 3,104 6 Medicare Taxes Labor 654 552 591 632 676 724 7 Retirement Contributions Labor 8,472 9,211 9,856 10,546 11,284 12,074 8 Life&Health Insurance Ins 8,482 4,705 5,411 6,222 7,156 8,229 9 Worker's Compensation Labor 124 717 767 821 878 940 10 Accounting and Auditing Inflation 5,119 5,119 5,221 5,336 5,454 5,574 11 Contractual Services Inflation 507 500 510 521 533 544 12 Training&Per Diem Labor 0 0 0 0 0 0 13 Expense Account Inflation 900 900 918 938 959 980 14 Telephone Inflation 1,026 3,000 3,060 3,127 3,196 3,266 15 Electricity Inflation 180 195 199 203 208 212 16 Equipment Rentals Inflation 378 400 408 417 426 436 17 Trailer Rentals Inflation 1,350 1,350 1,377 1,407 1,438 1,470 18 Insurance Coverage Ins 46,187 46,580 53,567 61,602 70,842 91,469 19 Office Supplies Inflation 525 600 612 625 639 653 20 Building Supplies Inflation 450 825 842 860 879 898 Interfund Transfer GF 185,413 207,264 213,482 219,886 226,483 233,277 21 Total Administration $297,594 $316,597 $333,927 $352,849 $373,534 $396,203 Sewer Accounting&Billing 22 Regular Salaries Labor $55,990 $65,451 $70,033 $74,935 $80,180 $85,793 23 Part-time Salaries Labor 10,945 11,248 12,035 12,878 13,779 14,744 24 Overtime Labor 500 500 535 572 613 655 25 Longevity Pay Labor 1,149 1,840 1,969 2,107 2,254 2,412 26 Accrued Leave Buyback Labor 1,000 1,000 1,070 1,145 1,225 1,311 27 FICA Taxes Labor 4,905 5,298 5,669 6,066 6,490 6,945. 28 Medicare Taxes Labor 1,145 1,239 1,326 1,419 1,518 1,624 29 Retirement Contributions Labor 15,695 10,444 11,175 11,957 12.794 13,690 30 life&Health Insurance Ins 20,047 22,038 25,344 29,145 33.517 38,545 31 Worker's Compensation Labor 269 301 322 345 369 395 32 Professional Service Inflation 15,000 4,500 4,590 4,691 4,794 4,900 33 Training&Per Diem Labor 800 - 0 0 0 0 0 34 Telephone Inflation 2,856 2,136 2,179 2,227 2,276 2,326 35 Postage Cust-Sewer 7,575 10,966 11,227 11,516 11,913 12,117 36 -Printing&Binding Inflation 1,800 200 204 208 213 218 37 Office Supplies Inflation 800 400 408 417 426 436 38 Computer Software Inflation 0 0 0 0 0 0 39 Total Accounting&Billing $140,476 $137,561 $148,085 $159,627 $172,262 $186,108 Sewer Collection 40 Regular Salaries Labor $162,483 $193,106 $206,623 $221,087 $236,563 $253,123 41 Overtime Labor 15,000 10,000 10,700 11,449 12,250 13,108 42 Longevity Pay Labor 9,667 9,397 10,044 10,747 11,499 12,304 43 Accrued Leave Buyback Labor 3,500 3,500 3,745 4,007 4,288 4,588 44 FICA Taxes Labor 13,789 15,410 16,489 17,643 18,878 20,199 45 Medicare Taxes Labor 3,225 3,604 3,856 4,126 4,415 4,724 46 Retirement Contributions Labor 47,566 61,314 65,606 70,198 75,112 80,370 47 Life&Health Insurance Ins 70,686 77,763 89,427 102,842 118,268 136,008 48 Worker's Compensation Inflation 8,030 7,808 7,964 8,139 8,318 8,501 49 Consultant Engineers Inflation 30,000 30,000 30,600 31,273 31,961 32,664 50 Contractual Services 14] Input 1,577,694 1,637,654 1,713,646 1,771,120 1,828,832 1,886,782 51 Training&Per Diem Labor 2,000 2,000 2,140 2,290 2,450 2,622 52 Telephone Inflation 1,644 1,700 1,734 1,772 1,811 1,851 53 Electricity Inflation 42,000 55,000 56,100 57,334 58,596 59,885 54 Equipment Rentals Inflation 1,000 822 838 857 876 895 55 Trailer Rentals Inflation 1,775 0 0 0 0 0 56 Miscellaneous Rentals Inflation 0 1,500 1,530 1,564 1,598 1,633 57 Mtn.Equipment Cust-Sewer 12,000 20,000 20,476 21,004 21,545 22,100 58 Mtn.of Communication Equip. Cust-Sewer 0 0 0 0 0 0 59 Mtn.of Vehicles Cust-Sewer 2,850 3,000 3,071 3,151 3,232 3,315 60 Mtn.of Grounds Cust-Sewer 5,820 3,300 3,379 3,466 3,555 3,646 Footnotes continued of Page 2 of2. Table 7 Page 2 of 2 DRAFT City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Projected Wastewater Operating Expenses Adopted Line - Escalation Budget Projected Fiscal Year Ending September 30, No. Description Reference[1] 2004[2] 2005[31 2006 2007 2008 2009 61 Mtn.of Utilities Inflation 25,000 25,000 25,500 26,061 26,634 27,220 62 Gasoline Inflation 3,500 4,007 4,087 4,177 4,269 4,363 63 Miscellaneous Supplies Inflation 30,000 30,600 31,212 31,899 32,600 33,318 64 Building Supplies Inflation 0 0 0 0 0 0 65 Memberships Inflation 60 60 61 63 64 65 66 Contingency[5] 1.50% 37,610 39,760 41,863 43,781 45,801 47,934 67 Total Sewer Collection $2,106,899 $2,236,295 $2,350,692 $2,450,049 $2,553,416 $2,661,218 68 TOTAL WASTEWATER SYSTEM $2,544,969 $2,690,453 $2,832,703 $2,962,526 $3,099,212 $3,243,530 69 Annual%Increase 5.7% 5.3% 4.6% 4.6% 4.7% Footnotes: [11 Derived from Table 8. 121 Derived from Table 5 as adjusted. [3] Based on the City's proposed budget for the Fiscal Year ending September 30,2005 as provided by the City. [4] Represents bulk wastewater payments to the City of Hollywood and based on the Large User Agreement between the parties. [5) Adjustment to recognize unforeseen charges equal to 1.5%of total operating and maintenance expenses. Table 8 City of Dania Beach,Florida Page 1 of 1 2004 Water and Wastewater Rate and Fee Study DRAFT Operating Expense Escalation Factors Line Escalation/De-escalation Factors No. Description Reference 2005 2006 2007 2008 2009 1 Constant Factor Constant 1.0000 1.0000 1.0000 1.0000 1.0000 2 Inflation(CPI Price Index) Inflation 1.0160 L0200 1.0220 1.0220 1.0220 3 General Fund Transfers GF 1.0300 1.0300 1.0300 1.0300 1.0300 4 Labor Labor 1.0700 1.0700 1.0700 1.0700 1.0700 5 Water:Customer Growth+Inflation Cust-Water 1.0304 1.0232 1.0252 1.0252 1.0251 6 Sewer:Customer Growth+Inflation Cust-Sewer 1.0332 1.0238 1.0258 1.0258 1.0258 7 Total Customers+Inflation Customers 1.0317 1.0235 1.0254 1.0254 1.0254 8 Rate Revenue-Water WaterRev 1.1131 1.1219 1.1219 1.1219 1.1219 9 Rate Revenue-Sewer SewerRev 1.0934 1.0822 1.0822 1.0722 1.0622 10 Rate Revenue-Total Revenue 1.1025 1.1007 1.1010 1.0962 1.0917 It Total Water Production+Inflation TotWatProd 1.0270 1.0218 1.0238 1.0238 1.0238 12 Sewer Flow+Inflation SewerFlow 1.0297 1.0222 1.0242 1.0242 1.0242 13 Insurance Ins 1.1500 1.1500 1.1500 1.1500 1.1500 14 Other Other 1.0500 1.0500 1.0500 1.0500 1.0500 15 Zero Zero 0.0000 0.0000 0.0000 0.0000 0.0000 0 0 o O CDOOOOOOOOOO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 • 0 0 0 O 00 0 0 0 0 0 0 0 0 00 0 0 0 0 0 00 O 0 0 00 0 0 00 O O O O •-- 0 0 0 0 0 0 0 0 ^ O [� �n O N M �n 0 0 •-- O [� M y _M 'O O O M N v O O O O'n v O\ O 00 cr v) 00 h O �n 1) oo O o0 t- oo 11 M h oo h o0 vi 10 0> oo O N 'O a0 N N •� 7 h t— N oo .�-,^.-. o0 O 69 69 69 69 69 69 65 69 A Q p' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O O 0 0 Cl 0 0 0 0 0 O O O O O O O 01 O O O Cl Cl 0 0 Cl wn O vl n n o kn O N 69 69 69 6A 64 69 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O Cl 0 0 0 0 0 0 0 0 O 0 0 Cl O O O O O O O O O O O 0 0 0 0 O U O O\ O\ O O 00 O O O O O O t- N O� Crl N O O O O O. O O kn �n 00 00 00 00 vn kn o0 N N 'n ^ 'n M N N N h o kl N N O N cV E,9 69 6A 69 69 69 65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O O O O O O O O O O O O 0 O O O O O O v1 In vn v) O O vi O O O O (= O N N 7 N O N 7 h O O �) O�o 00 O '7 h N N 7 00 h N O N N M N ^ M 69 69 69 6R 69 69 6H 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cl O O Cl Cl O O O O O O O O O O O O M O O O M O O w) vn oo O M O o0 O O kn O O O vl O �D N 0o M N O n �D M �O O O 7 �o O 11 kn O et vj t— O O, �t^ CD InV1 O M DD N In 00 V1 0o In 00 N M O 7 M oo a\ 00 O1 T � 69 69 69 69 69 69 6A 7 a> 0 0 0 0 0 Cl 0 0 0 Cl 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 ti O v� O O vi O O O O vn O O O In O 1n O O O O �O O O O �O O \O ,D ^p In O oo vj O M O O'n'n oo O Vn kn oo O o0 O 'n ^' N fh �o vi vl N N OO o0 �OL R L O N l� •--� N U ^ h 01 0 al 69 69 6A 69 69 69 69 q 3 a o O o O o 0 o 0 0 0 O o 0 0 0 o O o 0 0 0 0 o O O o 0 0 el •� c o0 0 o O O o 00 N a o 0 0; a o o; A a o0 o v O o v O C N N N N N ^ N 69 69 6) 69 69 69 69 o w ° 'A Do U, c/) En7 Kv5 tn � 3 � o3 � N coo 4w--i F � U y' U � T > 3 _ _ o ro � y •cbb � s; y a W b e atii n _ tb b) b o > O u w W -- 12 . �+ U n O N u O 0. Q .5 .$0 0 .cc C y � FQ W � aai U. w � Gi W � a �•-� u O �0 Cn cC ,rl cd m m L 6 V] cn Oca O z o d m sll� m .n o o m ro R u d A ro > 3 Q Q � 333 nv3x ¢ c� c� 333x c nrnaa� c FO � � x3c/) V) b Q � 0 a) -� N M -Zr v'i 10 h oo 01 O ^ NM 7 cn c �o h o0 O N N N N :a Z w 0 N O 1.0 O O 01 O O\ M N DD N .00 1n k Op Q (T O o0 U t� C� P. O 00 t` oo <t n M t` M 7 r a a M N N 1D �O N O O N N .-. N 00 M M 16 69 V O N 0 0 0 00 N ON M 0 W, .ti O\ N 00 O O1 �t N N N t� N m kn 6R ~ O M N 'cY O OH O O 00 ID In �O O �O O O O O O 7 t` N O m �D M m O 00 �c N 'ct m — In t— �o \p y t— O rl 116 N M N kr 1p \p d o O [� O t— a� 't N 00 N \10 00 O C ':n N N 00 �c �o N t— t— 0� to N �D N C W y M O tN O O M N� 00 M 00 00 O O O lc�O 00 O QO �o — I- N 7 .v1 00 lO �O y O M t� kn M N m N N 7 00 00 c> O t` N �o 7 It N t— vn M 00 00 00 O N In vl 00 M LL N N N kn 69 7 � o0 tDi U In d> t- C, .N-i V1 t- N 00 O 00 M M R CC CD �D N �n M N -t U m 00 00 L. cl > N N kn N n w � V 69 R � � U V L O .� .L W O O O O M N Q� m 00 0 00 O C) D O vl �D O � �fJ M t� oo h N -N 000 [� A Cl - cq O N C N N C -i kn � � Y Y L 7 O O y N N N QbjO :3 N 4 Q' N Cli O bD U 'O N 3 y � v � 3 C a 53 =33 a) 4 > N w > b > c of moon GL bobn P c °o° > U °v\ > > y.. an o o ro a E W � Y _ a R a CI. n F" Lcl O o0 W 3 ro °' E° w a>i Q o oa Ni aoi aoi a`i bn Cd iZ o Gy �c cd w � C7u; c7r� 5O L33 ° A Cwv4� 2 �v4 Cj v" o C13 F 0 :a Z w° h O 00 O h O ^ a, 10 0 0 0 O O 't 0 0 0 0 0 00 O h 00 O O Cl 00 b y 00 M O O •--� O h M O h O O O 01 V O M O O <t V 0 O O M M [- O M O llO cl o0 C� ll lD M O W O M N �n kn .-.N h .-. ..-. O ^. �• .-. .-. M .-.. N W .-. ^. .--� h V cl •-. N v� •--• 00 N 7 v) ^ N O t (� 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 oO o0 0 Cl 0 0 0 0 0 0 o 0 0 0 L1 O O N IA N N ^ N h 00 �D �D 00 �O V O N a, �D oO N C\ O M N kn O N_ h oo O O O oo h �n oo M O O N u W N M U N W � F m N N M 7 �n M o0 N �D h 't N O CD V� O N �n •--� ^ N U U a� V a, M M 7 7 0 N 0 0 0 't h �o O h 7 ON o0 c) O O O O O O O O O O O O 'T O M h 7 �O O O 'D •--� N �? a0 •--� 7 M M •--� N r- ^� M �n N 't W C� 7 ¢ 3 � O O OI's O O O O O O O O O O O O O O O O O O O O O O O O O O O O CD O O cls N a\ U D1 b O N N O O, 'D r- 'D N �t v� M a, r- O o" 0 0 0 0 0 00 0 0 0 0 0 �D O O\ N �•+ �n O O O r- N r— oo .-� -. ID O iD h o0 lD M lD vl ^ f- (V ^ N o0 a, N O h O, h N N ^ N ~ M ^ n H cQ h 7 N o0 'D Cl vi M 0 u o r- 7 W O h 0 Cl 0 0 0 0 0 0 0 0 0 0.O y M 7 7 M oO v-� N oo cMf1 'n h N 7 It r- N N cj U ^ .--� N �It ^ DO 'O C C fs. W cd b9 i m u U w � v M Ol O kn ID �o V1 M oo 0, O ^ O O O O O O O O O O O O O h r- oo M 7 a\ N "r h O �n --� h oo N O oo [r4 O1 N �D "tw h 4� Oa O 6q -N N R d C U A C C v ti ti y ti ti y - W z o v `cnv rnvlciv) ciii� vvvvnvvcn vvv > UUUUUUUUUUUU 3 � ¢ r� 3333333333333333 � 333 � c � o w N h O oo O h O O1 �o 0 0 0 0 0 'ct 0 0 0 0 0 o0 O h o0 0 0 0 00 h M O O y ^ O h 7 k l 1n M O r- O O O U 7 0 M 0 0 V� M -+ 'IT O O O M r- O O\ 00 D\ M lO M O o0 O M N h h VI O M O 00 o0 N �n O N �n O N �n N h .-• .-• O .-:V •-, ,-• M .-, N oo.-. ,-. .-. vi 7 O� ,=; N vi oo N V O M M M M h vl c� 64 N Gqq cr U N 7 z � w F x w F d � 3 � 3 w � Vl re7 O O O y c) O U Cp ti Q .V YC N y C 'ti C o S a C Q ❑ y a c y e Ca U � o � � a � a d o ' o n. R � � � > U o v a z O aCi x ,� 00 aQi C cOi O cCa oA'a 'C u a�i a> "� v aci " ti o_ QQ GL' d o bb cn Q p oon°A >>uo w o K a w o Qco a- Cl o .[ 5 M � h �D h 00 O1 O ^ N M V v1 �O h 00 D\ O •-� N M �7 '!l ID r- Do o\ O •--• N M V C ^ •--� ^ ^ --+ �+ N N N N r4 N N N N N M M M M M az O �o �c O O O O O a0 O O M O 00 M 7 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 v O` O1 �o O O N 00 1- O O\ M O 00 N O O O O O O O O M O O O r O1 M 01 Vl N �O 01 7 0 Vl O oc O n M 00 00 M O 69 N to Q N 0 0 0 0 Cl 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .o 69 69 y � U N id > ^y O 10 �o O O O O O 00 O O O O O O o 0 0 0 0 0 0 0 0 0 Cl 0 0 0 0 Cl 0 0 0 0 0 0 0 y Qj O\ �O O O N 00 69 6j p M O O � a Loq U U O O O O O O Cl O O U �o C. .-. M O O, N W Vl 00 O Cl O O N O Vl O N y 6A v� [l M O CD 0, O, c4 'O N 7 r- t` O N N N lo oo M CD C 7 M U 00 00 00 ll� N C p 7 M �--� .-+M 7 �O N •--�D\ 7 •-� .--�V'1 N �D �O 7 N 69 64 ¢ 3 � 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a� 69 6v 6v a O O O O Cl O O O O M Cl M M O N M N 0 0 0 0 o0 O O v1 M O N O t- M N b4 O r O M r [- r h 00 oc M O1 00 00 E ate+ Q1 lO M M O o0 00 M M O1 O\ 00 -- cr H 6's N O 69 >, Uj � L i y Uj cc Cl O O O O O O O b9 N N O N r4-� cO N M r 7 -� --� O O N 7 Cl-d' Cl '7 O oo U O 00 --� O M 7 O O --� O O 7 �O O O O O ° Y E w 'a te 0 Cl 0 0 0 0 0 0 0 V M M 7 M O O\ — .--, — — M 7 O n I�c O r- M 'r .r U L V3 N N o\ O r Qi r lo ca i U U !-' O1 V1 r N mot' .-. O o0 00 lo .--� r 7 00 00 M r_ O o0 O 00 00 7 7 O\ N r M ''O N O, cC cC � o � z � i z � _ - � �- � Qeeeeeeeeeeeeeeeeeeeeeeeeeee U3 0 � � � � � � � � � 33333 �3333333333 �3333333333333 ¢ x o � o w O M O 00 M 7 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 U co , O o0 N O O O O O O O O M O r-O O f� 01 Cl V� O o0 Q\ M �-+ N Cloo W N O O O Cl O Cl o0 O N _ 7 w °J � za = bA Gag a E o ° ° a o I c a w aroi ai F� U U ° a a°i a o p .G W c4 cn .° v ai wHa a o Uf° Rrxo ° ¢ w c a3avEt �= w[= � aaaw U V'� r Do C1 O' t- oo U C) N M r o0 0) O N M �o f^ 00 c1 O .-. N C M M M M M O1 0 7 Cl r � C, C, b 0 0 70 0 0 0 00 0 h Cl Vl O CD ,O O O O 00 O O O CDV1 N O r O\ CD CD CD7 r 7 O, CD r O CD O O O N O N 0, 0 M O oo Q\ v'> CDO N 00 O O, --� O r O �t N O M ,O O N 10 C C ro Cl M 00 N V"N 7 ^' .ti 00 00 r O � F O N N ^-� N a0 00 •-- N ,O .--� M DD � O . cry M 6A 6) N Q m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 41r •p 69 69 In � � o y C In U N (1� � 69 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O N 69 69 O U U ss ` �n '•O O 10 0, N ,O N r- N O O N 00 O 00 N O O M M oo .-. r 00 N 00 O N 7 0 0 70� b M --� 'II 00 O ^+ 7 'O 00 O, r l0 CY, M O M o0 V1 O\ O r M n 00 ;j N N M M r oo M Oo N N CDO ,O N --� N 7 O C p vi 7 N •--� M 7 7 .. 7 O V OM 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'O 0 0 0 0 0 0 7 V U 69 [� O O !� r O o o a 00 CD kn GS 7 7 7 7 Oo O, M r Q, 00 Cl O o0 N O N o0 O O O, M 00 0o N O ,O 10 0 0 �O �O N v', M v, 0o r N 7 O\ 00 M M 'IT v'> �n O o0 01 lD 7 7 00 O\ lO M O N N N V 00 00 N N M t C, M N � O\ --� -- T C M o0 E M O 10 00 7 O� M ,O Q\ D\00 r O N ,0+ N N -� r r N 7 ^-' M N n 69 70 69 _ � L y y Uj O, M ra\ �c O O M N O O V'i O V1 M Cl ,O oo cr, O N M V O oD O, O O M N In a, M M M m Q` M Nr4 O ,O N N � �--� .-. N V N r O, D1 'O � LL W ro 69 69 6M9 L C3 y U O i •,� O D\ vl -. .-+ O r [- d, v, W O O CN O N �O Vl r O W o0 O O M m ,r U L N O M -•� M 7 00 O o0 M r O, oo N N M N N 01 0 --� M m y U .0 Cl 7 7 a\ oo N r O\ 00 O, N oo �O ,O O, O U M [� [� r r ,D M M o0 3 ro vi 00 7 M M iN N r 7 .-• M 7 ,O N N ,O O, N 7 R R U O U N CC CC U y Cz C C C — C C C G G C C G U d �, � � ro ro _ ro ro ro ro _ ro ro ro ro _ ro ro ro ro ro ro ro ro ro ro ro ro ro ro ro ro � ro cC _ o � `" 33 � 33333333 � 333 � 3j333333333333j � 333 ;R N •� y O\ O 7 O r •--� D1 O, ,O O O V 0 0 0 0 0 0 0 V, O vl O O m O O O W O O O O Vl N Cl r N U O r- C 0 7 r 7 CIO O [— O O O O O O N O N O O M O DD Vi O O -r 0 O O M ,O O N �O O O O VC U O, Vl M 00 N Vl Vl r ,-• ••00 00 [�•-• •--� •-• 00 O 7 O •--r .--� .•.O O .--�,O.•-. 00 N CA N o0 00 -. N ,O .-, N N r M ao V O U 7 69 ^. N vUi N 69 69 cls w z � w z w c o o Q w � V U C C C L ro c =Co rig °' � o c a ro U o Wc's a a, w o Q E o CQ .E w w DO w en W o 0 0 o c ;, on �' N o 0 o E ? x .a � rz0 .aQuxa3a uuF- ww [ a 'wwa` w0c7c� ww � E Q 3 H ,y M M V ,D r 00 O, O N M V r o0 C, O N M r W O, o r- rrrr- r- r000000 00 00 00 00 00 00000, rnrnrnrnrnrno, rno, 00000000O o a z O O O O O 00 O N N M M O O O .N.. O r r O to a\ a1 O1 O D1 0o O o0 et �p �p O O C, �o M O O, N N 0o f- O1 a\ p N N N 69 6A 69 t Q 0 0 0 O O O O O oo O N N M M O p" b C oho 0 oNo v v ° co vi cl �o ri > , (� 69 69 6v O O O O O Cl O O O O O O O O [- r y O O p C C 69 69 � 64 U U ti 0 0 0 O O o0 a% O O O O Ol M N dj M O M o0 oo o0 1- '� M N N N �n O Ol O\ O N rq M ") 609 M Q3 U 69 60q 69 O O O O o Cl 0 o v O o 0 o v _o y r- ( M cl 0 V V ^ v�i kn N oho N 7 V 69 7 69 69 69 O oo V O N l- O O O O r- b M M M to D1 N N oo .�. O t- N o0 69 7 � L 3 N O 'lO O l N O O O O N �, M M �o oo 7 l� r- N 01 Y� _ 00 00 `O M O 00 o0 M w r p N N O vi ID O O M d" N to AO N oo R CL W U 6M9 6M9 o .� LT. , F ,�Ri •,= O O O O o0 c1 O O O O O O oe oo (:P\ CO C O O 6G9 O o o a N N It 0 � a o N •n O O 0 0 0 0 0o O N N R CO N O O O N O l= n O 17 �D �O _ C C O� D\ D1 O 0, -. oo O o0 7 V = N O O .^-. � lo M I oc M �n r- 7 7 011 N N N - 69 6A 69 U 4�j N V1 w > O O uo C C #zw y ^ w w !7 [' C4 c W zW o z o > cu) o 'o Ll _N N n C/ > o A ` � p -aQ o O = o f� F- F- C] NSO > F p Q H u z ¢ z :� z N O O, O 00 N -- V) 0 0 �n v r 00 O O O oo Q, 7 00 — 0 0 �o r o M 0 �o V) ^ CD — O O O 0 'n 00 CDN �o 01 v1 V O V O o\ M V M O O M �0 00 1 v1 M In N r r --• Vn Oi c ^ 7 1 v1 10 0o N v1 V N Wn o0 O N N 7 O M n M c^yC N ^ N U V Vj M — 7 O In M^ .... O N V N O F 69 N 6q — W Q R a on o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 � 10 obq o 00 0 0 0 0 00 0 0 0 W TS N N � ro o 0 0 R U N 69 CY. N o rn o0 "t O N O Vl r O M — oo O O O o0 rn �t O O �o r N o M 'n n M 01 M '7 N �n ^ r O N o0 V 7 0 V O 01 M 7 M 0 0 M a1 ^ N M �o ^ �n N -- 7 ^ N-oo M ^ N N 7 N � oo O N N V O M n ^ E o 00 N^ r- '. vi O N V N O ti 69 69 O O U U N r ^ V O In o0 0 �o M V O oo v1 N M �o 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 N r v V N 't O 69 y N 609 _ �bA O Gq ¢ U 0 O o o 0 0 0 0 0 o O 0 0 0 O O O O 0 O O CD 0 0 0 O O O 0 0 O O CD 0 R IR 0o M rn oo �p 'n g 01 M �o 0o O V o0 0 �o tr v o ^ 0 N o 0 0 0 0 0 0 0 0 0 0 0 0 E yr n no rno o n vvvoo oMMrn r bq � Id bN^9 M N V 69 O B u r o0 r ^ " M g V n M ^ 0 0 io M 01 O M M O 0 0 0 0 0 0 0 0 0 0 0 0 0 a1 R 00 r 01 N N V V N M O 10 V o0 O r M o0 O 69 M 0 0 --• N 10 M N ^ -^� N Gs W R u n d v1 N r O M " 7 " r 0 �n N ON 00 r 7 0o C) O — O O O O O O O 0 0 0 0 0 0 �0 cl�m to V r r V'1 N �n N 7 7 00 a\ U O r 69 � U .� � M �o N � N �n M M v1 N V V •^ �o E N V r -R R R. U 7 7 N N N 0 •° 3 U y V C N Z o U R a a N N _N N � N N_ � ° O w is ie ie m ca ro m —H � R m as 9 is is G. R ci > 0 0 ^ v coo V) U) V) Ln cn V) V) V) � V) rA � DO Cl) DO cn cn cn U U U U U U U U U U U U U U1-v) v) V) U1 fn CIO v) U1 v) U1 Cl) v) v)_v) V) cn fn vn u: N C u y N O D\ 0 0 0 0 o V1 0 0 0 0 'n t r m O O O o0 01 7 00 O O �o _ r ,O M O �o of ^ O O 0 0 O v� 00 o N \o U v1 V O V 0 M V M O O �00 M v1 M W, N r r v1 a1 O ^ 7 M v� �o oo N �n �' N 11 00 O N cl V y1 N .E O1 .-. N o�V i/i M 10 O N ` N5q M 6q vRUi N CL' "o, 5 w F x w Q o 3 ° w w d 3 UCa o �_ U O co) ' y W y aoiQ 'JLl 9 � w F �bny a1 Cl y a.O d U❑ cG ai U G' Foy I., .d m a°T R vO W `� UO oR a a o . U aoEi aLN a U a cU 0.v m CIO m c °a U ca. a ca y o c o F. 3 o ro > 3 F Ua .� .QU Wo W Q. a C ou ciQN y w O o O yk an1 N av'c � CU ' CRNn d �2ai Qco30 0U !% u �opwa ¢Uw on, co a a ati cHc sa Ft- v1 �o r 00 r oo O, O ^ N M V v1 C O ^ ^ ^ ^ (V N N N N N ri N N N M M M M M M az �o O O O \0 O i— O O V 7 M oo O V O O O N O 0 0 O O O O r- 0 0 0 0 M �o O O O CDoo O -^ C) �o CD CDV) CD CD N O CD CD O CD-O CD �o �o -- O O �o h N ON M V1 M r- r- CD r- N kn O M M In 7 0 cl 10 ON w w C, r- M M N N M M N O t4 Q cd Q. U O O CD O 0 O� 0 0 0 0 0 0 0 0 Cl 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 � 'r 7 � r �y O y 6N9 �i 10 O O O �D C,i's 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O61) y V C' N V V) o0 O [- 7 7 p 69 6S U U O o0 V O 'n C\ M r- 00 O -- 'D -p 59 N - o0 7 rn M N N N M M N V M V O O v y � bq O 6N9 69 U ¢ 3v O O O O C) 0 0 (D O CD CD CD CD O CD C) C) C, O O O O O O O CD CD CD C, O O O O C:)01.04 119of Id It 0 0 0 0 0 7 M r- C., C7, N 'o N h 0� V r- O 'D O r- O N O C, V) M M b9 V 00 r- M N �o D1 V kn r� oo V) oo �o �o �o C) �O 7 'n � �O oo N oo o0 N -4 N M M oo l� � �O M o0 V l� a1 N h D, N N N N ,-. Ei O U 0, m n M 'D �o r- O\ r- V N M V M CD � CD O Q` --� 10 r N m V1 N M M N M F 69 N N 69 69 y 3 a� _ oo U C) CD O O C:) N V �D N V M V N M M -- O N O O [- O O, -- a, oo M O o0 ti 59 [- N 'n 'n O N O a; N Q; C ' X ctl v1 N O .-. 6lq 6EH w E U .N. u V L L y O O O O O N r o0 00 0o V oo V U V) O M oo O "D O o0 N r O M O r y K y 6A o0 O o0 O 'n N N 'n '0'D Vl O V V V M 'D 7 N Q\ u o0 7 M V1 7 0o O M V M Vl V) O �D O N O 1� o0 ID �o N O M'n O O\ r O [� (D 7'V1 N N M ^-� N N h (D E.9 v� w Y obi U i u C U o w U U U U o 0 0 0 0 0 0 0 0 o CQ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c o U U U U U U U U U U cn U U U U U U U U U U U U U U U U c ¢ cnUDLnV) ullcnV) V) cnV) V) cnVDQnV) v) cncnV� V) CIO cl� cl� cn �ocn N W u H b O O O O O r- O O_ 7 V M G7 C) V CD CD O N O 0 0 0 00 0 r- 0 0 0 0 � 01 N 7 N '-' O M V M 000 O�o O O oN0 O O O O r- N V U U C U O ri _ � O 0 C� 1� O of M Vj M r- r- O r-N '/� O M M In 7 O 0 M U O > ,� M M In N N M M N —It 6s N h ON Ei EA b9 69 cr w z CIO F F wc Ln Ln .k c D o c C4 O U Obo ti O a> W ti W a0i . q ro 0 c y CR: 7 0 0 > .> O y c U m ti E E c - ti a c re p ro a F U M p W _ P C o c o = 0 aci °' U c y' aoi U > C7 � °q o .E > F- 'ta H x i u o o '` o w w w w c c ou o w c a u U 0 C o°Jo 2 Q '`- "' .o a a a` W o 0 0 0 0 a a y C E Q y 00 U C U U N ,w p C C '` U 7 '� vi C C C C C v� vi :� O � Fa" Qa° aoUF � rx0 .5 xa3uuP - wwF- c7 w UH o y �D r- oo a, O N M Vn �o r- oo c, O N M 7 Vn �o r- o0 U O N M V Vl �D r- 00 a, C M M'M M-7 7 7 7 7 V V V V kn N V) V1 V) V) In In V) Vn �o �o �o \O 10 110 �o �o �o ol az CD 0 �CD v o 0 o 0) o v Lo or r- M M 7 7 O LO pp0 M r N M O 00 r oo 0) r r w0 w O `�-' N 6Nq ^' r JO 00 F N N M Ntfl 69 69 b0 A cC a O Cl 50q O 0 0 0 6 CDkn O 01 (O p p0 [O p r o r r- rn cG 0 0 O 0 0 0 C) 0 0 o 0 V 00 N 69 a) o0 -C N V � O 69 V3 U U oo � O o00, 0 000 0 °r 00 h iA a N 0000 U 00 00 r M . N Mffj _ V£fi N y �n ffl a3 � 0 0 � O 0 0 0 0 0 O 60�9 O kl� 11 It CD 0 o N 0 O r o0 N O O O O r M � Ft3 '— '� 0O r' V N CT) in V] F N 69 LO N i v N s9 69 i V] y u N O r, r CD N — O O p CD �D M G. N N N 00 00 011 Cl)73 M ,D •p U N �p N �D ONO V CD N M (A O 00 M o7 o R h w W � ds R � �••^ d .u•, L r 0 M M O rn � CM o 0 0 CD r O R y O p r U 7 M M M V A R a+ cL1aG CA In U 69 69 �° 3 a v 0 u u o •L ¢ � v7 � � cGcC r� N t3 u t« O O O N 00 0 00 r 00 O It 61) 5rq N M O 00 m 00 r oo fD r r p > ` o0 oc N ,69 VA N N w z z > w > co Q u ¢ & E� W y u z �s a 43 5 z 'L v $ " W F o a°i v O >W > E z 0 z ct LG y y �3 > c A ~ � .¢L1wF0 p v � 0 c .W� sQ F �-Ll O O F C7 a F cG z ClN �l r In 10 r oo C, O -- N M o r � r i� r- r- r ro0oo 00 00 az Table 13 City of Dania Beach,Florida Page 1 of 2 2004 Water and Wastewater Rate and Fee Study DRAFT Existing and Proposed Water and Wastewater Rates Line Existing Rates Rates Effective Fiscal Year Ending September 30 No. Description 2004 2005 2006 2007 2008 2009 Effective Date 2004 (Oct. ) (oct.2oos) (oct.2oo6) (oct.2oo7) (Oct.2008) WATER RATES Residential/Condominiums: Water Base Rate per ERU 1 All Meters $5.39 $6.50 $7.50 $8.00 $8.50 $9.00 Water Consumption Rate per 1,000 gallons(per ERU) All Meters 2 0 to 5,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 3 5,001 to 14,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 4 over 14,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 Commercial/Sprinklers/Laundry Mats: Water Base Rate per ERU Water Meter Size(inches) 5 5/8" $5.39 $6.50 $7.50 $8.00 $8.50 $9.00 6 1, 13.47 16.24 18.74 19.99 21.24 22.49 7 11/2" 26.94 32.49 37.49 39.99 42.48 44.98 8 2" 43.11 51.99 59.99 63.99 67.98 71.98 9 Y 86.23 103.99 119.99 127.99 135.98 143.98 10 4" 134.73 162.48 187.47 199.97 212.47 224.97 11 6" 269.45 324.94 374.93 399.93 424.92 449.92 Water Consumption Rate per 1,000 gallons(per ERU) Water Meter Size(inches) 5/8"Meter 12 0 to 5,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 13 5,001 to 14,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 14 over 14,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 1"Meter 15 0 to 12,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 16 12,001 to 35,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 17 over 35,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 L5"Meter 18 0 to 25,000 Gallons $1.40 $1.47 SL63 $1.87 $2.14 $2.46 19 25,001 to 70,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 20 over 70,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 2"Meter 21 0 to 40,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 22 40,001 to 112,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 23 over 112,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 3"Meter 24 0 to 80,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 25 80,001 to 224,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 26 over 224,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 4"Meter 27 0 to 125,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 28 125,001 to 350,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 29 over 350,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 6"Meter 30 0 to 250,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 31 250,001 to 700,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 32 over 700,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 Table 13 City of Dania Beach,Florida Page 2 of 2 2004 Water and Wastewater Rate and Fee Study DRAFT. Existing and Proposed Water and Wastewater Rates Line Existing Rates Rates Effective Fiscal Year Ending September 30 No. Description 2004 2005 2006 2007 2008 2009 Effective Date (Oct.2004) (Oct.2005) (Oct.2006) (Oct.2007) (Oct.2008) Retail Effluent Irrigation Rates Water Base Rate per ERU Water Meter Size(inches) 5/8" $4.35 $5.25 $6.05 $6.46 $6.86 $7.26 1" 10.90 $13.14 $15.17 $16.18 $17.19 $18.20 11/2" 21.75 $26.23 $30.26 $32.28 $34.30 $36.32 2" 43.50 $52.46 $60.53 $64.56 $68.60 $72.63 3" 87.00 $104.92 $121.06 $129.13 $137.20 $145.27 4" 174.00 $209.83 $242.12 $258.26 $274.40 $290.54 Water Consumption Rate per 1,000 gallons(per ERU) All Meters $0.13 $0.14 $0.15 $0.17 $0.20 $0.23 WASTEWATER RATES Residential/Condominiums: 33 Wastewater Base Rate per ERU $8.29 $9.50 $10.50 $I 1.00 $11.50 $12.00 Water Consumption Rate per 1,000 gallons(per ERU) 34 All Usage $2.70 $2.86 $3.07 $337 $3.65 $3.91 Commercial/Sprinklers/Laundry Mats: Wastewater Base Rate per ERU Water Meter Size(inches) 35 5/8" $8.29 $9.50 $10.50 $11.00 $11.50 $12.00 36 1" 20.74 23.77 26.27 27.52 28.77 30.02 37 11/2" 41.47 47.52 52.53 55.03 57.53 60.03 38 2" 66.36 76.05 84.05 88.05 92.06 96.06 39 3" 132.72 152.09 168.10 176.11 184.11 192.12 40 4" 20737 237.64 262.65 275.16 287.67 300.17 41 6" 414.74 475.28 525.30 550.32 575.33 600.35 Water Consumption Rate per 1,000 gallons(per ERU) 42 All Usage $2.70 $2.86 $3.07 $3.37 $3.65 $3.91 Page t of f DRAFT Table 14 City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Bill Comparison for Proposed Residential Water Rates Existing Rates Proposed Rates-FY 2005 $5.39 Base Rate $6.50 Base Rate Rate per kgal per ERU: Rate per kgal per ERU: $1.40 0-5 $1.47 0-5 $2.12 6-14 $2.23 6-14 $2.64 above 14 kgal $2.77 above 14 kgal Existing Proposed Oct.2004 Increase Increase Monthly Use Total Avg Rate Total Avg Rate Marginal Total (gal) Bill per Kgal Bill per Kgal Rate Bill % 0 $5.39 n/a $6.50 n/a $1.11 $1.11 21 e/o 1,000 6.79 6.79 7.97 7.97 0.07 1.18 17% 2,000 8.19 4.10 9.44 4.72 0.07 1.25 15% 3,000 9.59 3.20 10.91 3.64 0.07 1.32 141/6 4,000 10.99 2.75 12.38 3.10 0-07 1.39 13% 5,000 12.39 2.48 13.85 2.77 0.07 1.46 12% 6,000 14.51 2.42 16.08 2.68 0.11 1.57 11% 7,000 16.63 2.38 18.31 2.62 0.11 1.68 10% 8,000 18.75 2.34 20.54 2.57 0.11 1.79 10% 9,000 20.87 2.32 22.77 2.53 0.11 1.90 9% 10,000 22.99 2.30 25.00 2.50 0.11 2.01 9% 11,000 25.11 2.28 27.23 2.48 0.11 2.12 8% 12,000 27.23 2.27 29.46 2.46 0.11 2.23 8% 13,000 29.35 2.26 31.69 2.44 0.11 2.34 8% 14,000 31.47 2.25 33.92 2.42 0.11 2.45 8% 15,000 34.11 2.27 36.69 2.45 0.13 2.58 8% 16,000 36.75 2.30 39.46 2.47 0.13 2.71 7% 17,000 39.39 2.32 42.23 2.48 0.13 2.84 7% 18,000 42.03 2.34 45.00 2.50 0.13 2.97 7% 19,000 44.67 2.35 47.77 2.51 0.13 3.10 7% 20,000 47.31 2.37 50.54 2.53 0.13 3.23 7% 30,000 73.71 2.46 78.24 2.61 0.13 4.53 6% 40,000 100.11 2.50 105.94 2.65 0.13 5.93 6% 50,000 126.51 2.53 133.64 2,67 0.13 7.13 6% 80,000 205.71 2.57 216.74 2.71 0.13 11.03 5% 100,000 258.51 2.59 272.14 2.72 0.13 13.63 5% 200,000 522.51 2.61 549.14 2.75 0.13 26.63 5% 240,000 628.11 2.62 659.94 2.75 0.13 31.83 5% 400,000 1,050.51 2.63 1,103.14 2.76 0.13 52.63 5% 500,000 1,314.51 2.63 1,380.14 2.76 0.13 65.63 5% 1,000,000 2,634.51 2.63 2,765.14 2.77 0.13 130.63 5% The typical residential bill averages approximately 6,000 gallons monthly per account. Page 1 of 1 DRAFT Table 15 City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Bill Comparison for Proposed Residential Wastewater Rates Existing Rates Proposed Rates-FY 2005 $8.29 Base Rate $9.50 Base Rate Rate per kgal per ERU: Rate per kgal per ERU: $2.70 0-5 $2.86 0-5 $2.70 6-14 $2.86 6-14 $2.70 above 14 kgal $2.86 above 14 kgal Existing Proposed Oct.2004 Increase Increase Monthly Use Total: Avg Rate Total Avg Rate Marginal Total (gal) Bill per Kgal Bill per Kgal Rate Bill % 0 $8.29 n/a $9.50 n/a $1.21 $1.21 15% 1,000 10.99 10.99 12.36 12.36 0.16 1.37 12% 2,000 13.69 6.85 1522 7.61 0.16 1.53 11% 3,000 16.39 5.46 18.08 6.03 0.16 1.69 101/0 4,000 19.09 4.77 20.94 5.24 0.16 1.85 10% 5,000 21.79 4.36 23.80 4.76 0.16 2.01 9% 6,000 24.49 4.08 26.66 4.44 0.16 2.17 9% 7,000 27.19 3.88 29.52 4.22 0.16 2.33 9% 8,000 29.89 3.74 32.38 4.05 0.16 2.49 8% 9,000 32.59 3.62 35.24 3.92 0.16 2.65 8% 10,000 35.29 3.53 38.10 3.81 0.16 2.81 8% 11,000 3T99 3.45 40.96 3.72 0.16 2.97 8% 12,000 40.69 3.39 43.82 3.65 0.16 3.13 8% 13,000 43.39 3.34 46.68 3.59 0.16 3.29 8% 14,000 46.09 3.29 49.54 3.54 0.16 3.45 7% 15,000 48.79 3.25 52.40 3.49 0.16 3.61 7% 16,000 51.49 3.22 55.26 3.45 0.16 3.77 7% 17,000 54.19 3.19 58.12 3.42 0.16 3.93 7% 18,000 56.89 3.16 60.98 3.39 0.16 4.09 7% 19,000 59.59 3.14 63.84 3.36 0.16 4.25 7% 20,000 62.29 3.11 66.70 3.34 0.16 4.41 7% 30,000 89.29 2.98 95.30 3.18 0.16 6.01 7% 40,000 116.29 2.91 123.90 3.10 0.16 7.61 7% 50,000 143.29 2.87 152.50 3.05 0.16 9.21 6% 80,000 224.29 2.80 238.30 2.98 0.16 14.01 6% 100,000 278.29 2.78 295.50 2.96 0.16 17.21 6% 200,000 548.29 2.74 581.50 2.91 0.16 33.21 6% 240,000 656.29 2.73 695.90 2.90 0.16 39.61 6% 400,000 1,088.29 2.72 1,153.50 2.88 0.16 65.21 6% 500,000 1,358.29 2.72 1,439.50 2.88 0.16 81.21 6% 1,000,000 2,708.29 2.71 2,869.50 2.87 0.16 161.21 6% The typical residential bill averages approximately 6,000 gallons monthly per account. Page 1 of 7 DRAFT Table 16 City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Bill Comparison for Proposed Residential Water and Wastewater Rates-Combined Existing Proposed Oct.2004 Increase Monthly Use Total Avg Rate Total Avg Rate Total (gal) Bill per Kgal Bill per Kgal Bill % 0 $13.68 n/a $16.00 n/a $2.32 17% 1,000 17.78 17.78 20.33 20.33 2.55 14% 2,000 21.88 10.94 24.66 1233 2.78 13% 3,000 25.98 8.66 28.99 9.66 3.01 12% 4,000 30.09 7.52 33.32 8.33 3.24 11% 5,000 34.18 6.84 37.65 7.53 3.47 10% 6,000 39.00 6.50 42.74 7.12 3.74 10% 7,000 43.82 6.26 47.83 6.83 4.01 9% 8,000 48.64 6.08 52.92 6.62 4.28 9% 9,000 53.46 5.94 58.01 6.45 4.55 9% 10,000 58.28 5.83 63.10 6.31 4.82 8% 11,000 63.10 5.74 68.19 6.20 5.09 8% 12,000 67.92 5.66 73.28 6.11 5.36 8% 13,000 72.74 5,60 78.37 6.03 5.63 8% 14,000 77.56 5.54 83.46 5.96 5.90 8% 15,000 82.90 5.53 89.09 5.94 6.19 7% 16,000 88.24 5.52 94.72 5.92 6.48 7% 17,000 93.58 5.50 100.35 5.90 6.77 7% 18,000 98.92 5.50 105.98 5.89 7.06 7% 19,000 104.26 5.49 111_61 5.87 7.35 7% 20,000 109.60 5.48 117.24 5.86 7.64 7% 30,000 163.00 5.43 173.54 5.78 10.54 6% 40,000 216.40 5.41 229.84 5.75 13.44 6% 50,000 269.80 5.40 286.14 5.72 16.34 6% g0,000 430.00 5.38 455.04 5.69 25.04 6% 100,000 536.80 5.37 567.64 5.68 30.84 6% 200,000 1,070.80 5.35 1,130.64 5.65 59.84 6% 240,000 1,284.40 5.35 1,355.84 5.65 71.44 6% 400,000 2,138.80 5.35 2,256.64 5.64 117.84 6% 500,000 2,672.80 5.35 2,819.64 5.64 146.84 5% 1,000,000 5,342.80 5.34 5,634.64 5.63 291.84 5% The typical residential bill averages approximately 6,000 gallons monthly per account. Page 1 of 1 DRAFT Table 17 City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Bill Comparison for Proposed Commercial Water Rates Existing Rates Proposed Rates-FY 2005 $5.39 Base Rate $6.50 Base Rate Rate per kgal per ERU: Rate per kgal per ERU: $1.40 0-5 $1.47 0-5 $2.12 6-14 $2.23 6-14 $2.64 above 14 kgal $2.77 above 14 kgal Existing Proposed Oct.2004 Increase Increase Monthly Use Total Avg Rate Total Avg Rate Marginal Total (gal) Bill per Kgal Bill per Kgal Rate Bill % 0 $5.39 n/a $6.50 n/a $1.11 $1.11 21% 1,000 6.79 6.79 7.97 7.97 0.07 1.18 17% 2,000 8.19 4.10 9.44 4.72 0.07 1.25 15% 3,000 9.59 3.20 10.91 3.64 0.07 1.32 14% 4,000 10.99 2.75 12.38 3.10 0.07 1.39 13% 5,000 12.39 2.48 13.85 2.77 0.07 1.46 12% 61000 14.51 2.42 16.08 2.68 0.11 1.57 11% 7,000 16.63 2.38 18.31 2.62 0.11 1.68 10% 8,000 18.75 2.34 20.54 2.57 0.11 1.79 10% 9,000 20.87 2.32 22.77 2.53 0.11 1.90 9% 10,000 22.99 2.30 25.00 2.50 0.11 2.01 9% 11,000 25.11 2.28 27.23 2.48 0.11 2.12 8% 12,000 27.23 227 29.46 2.46 0.11 2.23 8% 13,000 29.35 2.26 31.69 2.44 0.11 2.34 8% 14,000 31.47 2.25 33.92 2.42 0.11 2.45 8% 15,000 34.11 227 36.69 2.45 0.13 2.58 8% 16,000 36.75 2.30 39.46 2.47 0.13 2.71 7% 17,000 39.39 2.32 42.23 2.48 0.13 2.84 7% 18,000 42.03 2.34 45.00 2.50 0.13 2.97 7% 19,000 44.67 2.35 47.77 2.51 0.13 3.10 7% 20,000 47.31 2.37 50.54 2.53 0.13 3.23 7% 30,000 73.71 2.46 78.24 2.61 0.13 4.53 6% 40,000 100.11 2.50 105.94 2.65 0.13 5.83 6% 50,000 126.51 2.53 133.64 2.67 0.13 7.13 6% 80,000 205.71 2.57 216.74 2.71 0.13 11.03 5% 100,000 258.51 2.59 272.14 2.72 0.13 13.63 5% 200,000 522.51 2.61 549.14 2.75 0.13 26.63 5% 240,000 628.11 2.62 659.94 2.75 0.13 31.83 5% 400,000 1,050.51 2.63 1,103.14 2.76 0.13 52.63 5% 500,000 1,314.51 2.63 1,380.14 2.76 0.13 65.63 5% 1,000,000 2,634.51 2.63 2,765.14 2.77 0.13 130.63 5% 'rhe typical commercial bill averages approximately 4,000 gallons monthly per account. Page t of 1 DRAFT Table 18 City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Bill Comparison for Proposed Commercial Wastewater Rates Existing Rates Proposed Rates-FY 2005 $8.29 Base Rate $9.50 Base Rate Rate per kgal per ERU: Rate er kgal per ERU: $2.70 0-5 $2.86 0-5 $2.70 6-14 $2.86 6-14 $2.70 above 14 kgal $2.86 above 14 kgal Existing Proposed Oct.2004 Increase Increase Monthly Use Total Avg Rate Total Avg Rate Marginal Total (gal) Bill per Kgal Bill per Kgal Rate Bill % 0 $8.29 n/a $9.50 n/a $1.21 $1.21 15% 1,000 10.99 10.99 12.36 12.36 0.16 1.37 12% 2,000 13.69 6.85 15.22 7.61 0.16 1.53 11% 3,000 16.39 5.46 18.08 6.03 0.16 1.69 10% 4,000 19.09 4.77 20.94 5.24 0.16 1.85 10% 5,000 21.79 4.36 23.80 4.76 0.16 2.01 9% 6,000 24.49 4.08 26.66 4.44 0.16 2.17 9% 7,000 27.19 3.89 29.52 4.22 0.16 2.33 9% 8,000 29.89 3.74 32.38 4.05 0.16 2.49 8% 9,000 32.59 3.62 35.24 3.92 0.16 2.65 8% 10,000 35.29 3.53 38.10 3.81 0.16 2.81 8% 11,000 37.99 3.45 40.96 3.72 0.16 2.97 8% 12,000 40.69 3.39 43.82 3.65 0.16 3.13 8% 13,000 43.39 3.34 46.68 3.59 0.16 3.29 8% 14,000 46.09 3.29 49.54 3.54 0.16 3.45 7% 15,000 48.79 3.25 52.40 3.49 0.16 3.61 7% 16,000 51.49 3.22 55.26 3.45 0.16 3.77 7% 17,000 54.19 3.19 58.12 3.42 0.16 3.93 7% 18,000 56.89 3.16 60.98 3.39 0.16 4.09 7% 19,000 59.59 3.14 63.84 3.36 0.16 4.25 7% 20,000 62.29 3.11 66.70 3.34 0.16 4.41 7% 30,000 89.29 2.98 95.30 3.18 0.16 6.01 7% 40,000 116.29 2.91 123.90 3.10 0.16 7.61 7% 50,000 143.29 2.87 152.50 3.05 0.16 9.21 6% 80,000 22429 2.80 238.30 2.98 0.16 14.01 6% 100,000 278.29 2.78 295.50 2.96 0.16 17.21 6% 200,000 548.29 2.74 581.50 2.91 0.16 33.21 6% 240,000 656.29 2.73 695.90 2.90 0.16 39.61 6% 400,000 1,088.29 2.72 1,153.50 2.88 0.16 65.21 6% 500,000 1,358.29 2.72 1,439.50 2.88 0.16 81.21 6% 1,000,000 2,708.29 2.71 2,869.50 2.87 0.16 161.21 6% The typical commercial bill averages approximately 4,000 gallons monthly per account. Page 1 of 1 DRAFT Table 19 City of Dania Beach,Florida 2004 Water and Wastewater Rate and Fee Study Bill Comparison for Proposed Residential Water and Wastewater Rates-Combined Existing Proposed Oct.2004 Increase Monthly Use Total Avg Rate Total Avg Rate Total (gal) Bill per Kgal Bill per Kgal Bill % 0 $13.68 n/a $16.00 n/a $2.32 17% 1,000 17.78 17.78 20.33 20.33 2.55 14% 2,000 21.88 10.94 24.66 12.33 2.78 13% 3,000 25.98 8.66 28.99 9.66 3.01 12% 4,000 30.08 7.52 33.32 8.33 3.24 11% 5,000 34.18 6.84 37.65 7.53 3.47 10% 6,000 39.00 6.50 42.74 7.12 3.74 10% 7,000 43.82 6.26 4T83 6.83 4.01 9% 8,000 48.64 6.08 52.92 6.62 4.28 9% 9,000 53.46 5.94 58.01 6.45 4.55 9% 10,000 58.28 5.83 63.10 6.31 4.82 8% 11,000 63.10 5.74 68.19 6.20 5.09 8% 12,000 67.92 5.66 73.28 6.11 5.36 8% 13,000 72.74 5.60 78.37 6.03 5.63 8% 14,000 77.56 5.54 83.46 5.96 5.90 8% 15,000 82.90 5.53 89.09 5.94 6.19 7% 16,000 88.24 5.52 94.72 5.92 6.48 7% 17,000 93.58 5.50 100.35 5.90 6.77 7% 18,000 98.92 5.50 105.98 5.89 7.06 7% 19,000 104.26 5.49 111.61 5.87 7.35 7% 20,000 109.60 5.48 IIT24 5.86 7.64 7% 30,000 163.00 5.43 173.54 5.78 10.54 6% 40,000 216.40 5.41 229.84 5.75 13.44 6% 50,000 269.80 5.40 286.14 5.72 16.34 6% 80,000 430.00 5.38 455.04 5.69 25.04 6% 100,000 536.80 5.37 567.64 5.68 30.84 6% 200,000 1,070.80 5.35 1,130.64 5.65 59.84 6% 240,000 1,284.40 5.35 1,355.84 5.65 71.44 6% 400,000 2,138.80 5.35 2,256.64 5.64 117.84 6% 500,000 2,672.80 5.35 2,819.64 5.64 146.84 5% 1,000,000 5,342.80 5.34 5,634.64 5.63 291.84 5% The typical commercial bill averages approximately 4,000 gallons monthly per account. APPENDIX A Table A-1 City of Dania Beach,Florida Page 1 of 2 2004 Water and Wastewater Rate and Fee Study DRAFT Existine and Proposed Water and Wastewater Rates Line Existing Rates Rates Effective Fiscal Year Ending September 30 No. Description 2004 2005 2006 2007 2008 2009 Effective Date (Oct.2004) (Oct.2005) (Oct.2006) (Oct.2007) (Oct.2008) WATER RATES Residential/Condominiums: Water Base Rate per ERU I All Meters $5.39 $6.50 $7.50 $8.00 $8.50 $9.00 Water Consumption Rate per 1,000 gallons(per ERU) All Meters 2 0 to 5,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 3 5,001 to 14,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 4 over 14,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 Commercial/Sprinklers/Laundry Mats: Water Base Rate per ERU Water Meter Size(inches) 5 5/8" $5.39 $6.50 $7.50 $8.00 $8.50 $9.00 6 1" 13.47 16.24 18.74 19.99 21.24 22.49 7 11/2" 26.94 3249 37.49 39.99 42.48 44.98 8 2" 43.11 51.99 59.99 63.99 67.98 71.98 9 3" 86.23 103.99 119.99 127.99 135.98 143.98 10 4" 134.73 162.48 187.47 199.97 212.47 224.97 11 6" 269.45 324.94 374.93 399.93 424.92 449.92 Water Consumption Rate per 1,000 gallons(per ERU) Water Meter Size(inches) 5/8"Meter 12 0 to 5,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 13 5,001 to 14,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 14 over 14,000 Gallons 2.64 2.77 3.07 3.53 404 4.64 1"Meter 15 0 to 12,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 16 12,001 to 35,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 17 over 35,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 1.5"Meter 18 0 to 25,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 19 25,001 to 70,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 20 over 70,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 2"Meter 21 0 to 40,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 22 40,001 to 112,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 23 over 112,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 3"Meter 24 0 to 80,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 25 80,001 to 224,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 26 over 224,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 4"Meter 27 0 to 125,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 28 125,001 to 350,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 29 over 350,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 6"Meter 30 0 to 250,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 31 250,001 to 700,000 Gallons 2.12 2.23 2.47 2.83 324 3.73 32 over 700,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 Table A-1 City of Dania Beach,Florida Page 2 of 2 2004 Water and Wastewater Rate and Fee Study DRAFT' Existine and Proposed Water and Wastewater Rates Line Existing Rates Rates Effective Fiscal Year Ending September 30 No. Description 2004 2 005 2006 2007 2008 2009 Effective Date (Oct.2004) (Oct.2005) (Oct.2006) (Oct.2007) (Oct.2008) Retail Effluent Irrigation Rates Water Base Rate per ERU Water Meter Size(inches) 5/8" $4.35 $5.25 $6.05 $6.46 $6.86 $7.26 1" 10.90 $13.14 $15.17 $16.18 $17.19 $18.20 11/2" 21.75 $26.23 $30.26 $32.28 $34.30 $36.32 2" 43.50 $52.46 $60.53 $64.56 $68.60 $72.63 3" 87.00 $104.92 $121.06 $129.13 $137.20 $145.27 4" 174.00 $209.83 $242.12 $258.26 $274.40 $290.54 Water Consumption Rate per 1,000 gallons(per ERU) All Meters $0.13 $0.14 $0.15 $0.17 $0.20 $0.23 WASTEWATER RATES Residential/Condominiums: 33 Wastewater Base Rate per ERU $8.29 $9.50 $10.50 $11.00 $11.50 $12.00 Water Consumption Rate per 1,000 gallons(per ERU) 34 All Usage $2.70 $2.86 $3.07 $3.37 $3.65 $3.91 Commercial/Sprinklers/Laundry Mats: Wastewater Base Rate per ERU Water Meter Size(inches) 35 5/8" $8.29 $9.50 $10.50 $11.00 $11.50 $12.00 36 1" 20.74 23.77 26.27 27.52 28.77 30.02 37 11/2" 41.47 47.52 52.53 55.03 57.53 60.03 38 2" 6636 76.05 84.05 88.05 92.06 96.06 39 3" 132.72 152.09 168.10 176.11 184.11 192.12 40 4" 207.37 237.64 262.65 275.16 287.67 300.17 41 6" 414.74 475.28 525.30 550.32 575.33 600.35 Water Consumption Rate per 1,000 gallons(per ERU) 42 All Usage $2.70 $2.86 $3.07 $337 $3.65 $3.91 APPENDIX Page 33 of 1 DRAFT Table B-1 City of Dania Beach Water and Wastewater System 2004 Water and Wastewater Rate and Fee Study Comparison of Typical Monthly Residential Bills for Water Service(1) Residential Service for a 518"or 3/4"Meter Line 0 2,000 4,000 5,000 7,000 12,000 15,000 20,000 No. Description Gallons Gallons Gallons Gallons Gallons Gallons Gallons Gallons City of Dania Beach: 1 Existing Rates $5.39 $8.19 $10.99 $12.39 $16.63 $27.23 $34.11 $47.31 2 Proposed Rates FY 2005 6.50 9.44 12.38 13.85 18.31 29.46 36.69 50.54 3 Proposed Rates FY 2006 7.50 10.76 14.02 15.65 20.59 32.94 40.95 56.30 4 Proposed Rates FY 2007 8.00 11.74 15.48 17.35 23.01 37.16 46.35 64.00 5 Proposed Rates FY 2008 8.50 12.78 17.06 19.20 25.68 41.88 52.40 72.60 6 Proposed Rates FY 2009 9.00 13.92 18.84 21.30 28.76 47.41 59.51 82.71 Other Florida Utilities: 7 Broward County $8.73 $12.11 $15.49 $17.18 $20.56 $33.36 $43.18 $6133 8 City of Boca Raton 8.82 9.86 10.90 11.42 12.46 15.06 18.42 24.62 9 City of Boynton Beach 6.65 6.65 8.23 9.81 13.05 21.62 27.17 36.97 10 City of Coral Springs 13.59 15.45 17.31 18.24 20.10 25.91 29.57 35.67 11 City of Deerfield Beach 12.57 15.97 19.37 21.07 24.70 34.35 40.98 52.03 12 City of Hallandale Beach 11.41 12.87 14.47 15.27 1733 23.92 29.17 37.92 13 City of Lake Worth 8.30 10.68 13.06 1425 17.61 26.01 31.05 44.95 14 City of Miramar-Eastern Service Area 7.62 10.66 13.70 15.22 18.96 28.31 33.92 45.62 15 City of Miramar-Western Service Area 7.62 10.66 13.70 15.22 18.96 28.31 33.92 45.62 16 City of Pompano Beach 8.72 11.30 13.88 15.17 17.75 25.00 30.07 41.02 17 City of Riviera Beach 6.32 7.92 10.15 11.58 14.98 25.55 32.54 45.94 18 City of Stuart 4.89 9.17 13.45 15.59 19.87 30.57 36.99 51.97 19 City of West Palm Beach 8.04 10.53 13.01 14.26 17.06 25.04 30.57 39.80 20 Cooper City 7.94 12.04 16.14 18.19 22.29 32.54 38.69 48.94 21 Martin County 16.95 20.79 24.63 26.55 30.39 41.39 49.25 65.80 22 Palm Beach County 7.65 9.15 10.65 12.25 15.45 27.85 39.25 58.25 23 Town of Jupiter 11.04 13.66 16.28 17.59 20.21 26.76 30.69 37.24 24 Village of Royal Palm Beach 12.87 16.67 20.47 22.37 26.17 35.67 41.37 50.87 25 Village ofTequesta 10.91 14.37 17.83 19.56 23.02 31.67 40.40 54.95 26 Other Florida Utilities'Average $9.51 $12.13 $14.88 $16.36 $19.52 $28.36 $34.59 $46.29 (1) Unless otherwise noted,amounts shown reflect residential rates in effect August 2004 and are exclusive of taxes or franchise fees,if any,and reflect rates charged for inside the city service. All rates are as reported by the respective utility. This comparison is intended to show comparable charges for similar service for comparison purposes only and is not intended to be a complete listing of all rates and charges offered by each listed utility. Page I of I DRAT t' Table B-2 City of Dania Beach Water and Wastewater System 2004 Water and Wastewater Rate and Fee Study Comparison of Typical Monthly Residential Bills for Wastewater Service(l) Residential Service for a 5/8"or 3/4"Meter Line 0 2,000 4,000 5,000 7,000 12,000 15,000 20,000 No. Description Gallons Gallons Gallons Gallons Gallons Gallons Gallons Gallons City of Dania Beach: 1 Existing Rates $8.29 $13.69 $19.09 $21.79 $27.19 $40.69 $48.79 $62.29 2 Proposed Rates FY 2005 9.50 15.22 20.94 23.80 29.52 43.82 52.40 66.70 3 Proposed Rates FY 2006 10.50 16.64 22.78 25.85 31.99 47.34 56.55 71.90 4 Proposed Rates FY 2007 11.00 17.74 24.48 2785 34.59 51.44 61.55 78.40 5 Proposed Rates FY 2008 11.50 18.80 26.10 29.75 37.05 55.30 66.25 84.50 6 Proposed Rates FY 2009 12.00 19.82 27.64 31.55 39.37 58.92 70.65 90.20 Other Florida Utilities: 7 Broward County $12.22 $16.92 $21.62 $23.97 $28.67 $40.42 $47.47 $47.47 8 City of Boca Raton 11.15 11.15 11.15 11.15 11.15 11.15 11.15 11.15 9 City of Boynton Beach 10.13 13.21 16.29 17.83 20.91 20.91 20.91 20.91 10 City of Coral Springs 18.40 21.58 24.76 26.35 29.53 37.48 42.25 50.20 11 City of Deerfield Beach 8.96 12.30 15.64 17.31 20.65 29.00 29.00 29.00 12 City of Hallandale Beach 9.09 13.75 18.41 20.74 25.86 39.38 48.14 62.74 13 City of Lake Worth 6.19 9.37 12.55 14.14 17.32 22.09 22.09 22.09 14 City of Miramar-Eastern Service Area 11.50 16.48 21.46 23.95 28.93 41.38 48.85 61.30 15 City of Miramar-Western Service Area 7.29 11.41 15.53 17.59 21.71 32.01 38.19 48.49 16 City of Pompano Beach 10.56 14.34 18.12 20.01 23.79 29.46 29.46 29.46 17 City of Riviera Beach 6.55 9.99 13.43 15.15 18.59 23.75 23.75 23.75 18 City of Stuart 4.86 12.78 20.70 24.66 32.58 52.38 52.38 52.38 19 City of West Palm Beach 6.22 11.11 16.01 18.45 23.35 33.67 33.67 33.67 20 Cooper City 17.18 21.10 25.02 26.98 30.90 36.78 36.78 36.78 21 Martin County 18.65 26.17 33.69 37.45 44.97 56.25 56.25 56.25 22 Palm Beach County 7.80 9.80 11.80 14.00 18.40 25.00 25.00 25.00 23 Town of Jupiter 13.67 13.67 13.67 13.67 13.67 13.67 13.67 13.67 24 Village of Royal Palm Beach 15.25 18.61 21.97 23.65 27.01 35.41 40.45 48.85 25 Village of Tequesta 13.67 13.67 13.67 13.67 13.67 13.67 13.67 13.67 26 Other Florida Utilities'Average $11.02 $14.60 $18.18 $20.04 $23.77 $31.26 $33.32 $36.15 (1) Unless otherwise noted,amounts shown reflect residential rates in effect August 2004 and are exclusive of taxes or franchise fees,if any,and reflect rates charged for inside the city service. All rates are as reported by the respective utility. This comparison is intended to show comparable charges for similar service for comparison purposes only and is not intended to be a complete listing of all rates and charges offered by each listed utility. Page I of 1 DRAFT Table B-3 City of Dania Beach Water and Wastewater System 2004 Water and Wastewater Rate and Fee Study Comparison of Typical Monthly Residential Bills for Water and Wastewater Service(1) Residential Service for a 5/8"or 3/4"Meter Line 0 2,000 4,000 5,000 7,000 12,000 15,000 20,000 No. Description Gallons Gallons Gallons Gallons Gallons Gallons Gallons Gallons City of Dania Beach: 1 Existing Rates $13.68 $21.88 $30.08 $34.19 $43.82 $67.92 $82.90 $109.60 2 Proposed Rates FY 2005 16.00 24.66 33.32 37.65 47.83 73.28 89.09 117.24 3 Proposed Rates FY 2006 18.00 27.40 36.80 41.50 52.58 80.28 97.50 128.20 4 Proposed Rates FY 2007 19.00 29.48 39.96 45.20 57.60 88.60 107.90 142.40 5 Proposed Rates FY 2008 20.00 31.58 43.16 48.95 62.73 97.18 118.65 157.10 6 Proposed Rates FY 2009 21.00 33.74 46.48 52.85 68.13 106.33 130.16 172.91 Other Florida Utilities: 7 Broward County $20.95 $29.03 $37.11 $41.15 $49.23 $73.78 $90.65 $108.80 8 City of Boca Raton 19.97 21.01 22.05 22.57 23.61 26.21 29.57 35.77 9 City of Boynton Beach 16.78 19.86 24.52 27.64 33.96 42.53 48.08 5788 10 City of Coral Springs 31.99 37.03 42.07 44.59 49.63 63.39 71.82 85.87 11 City of Deerfield Beach 21.53 28.27 35.01 38.38 45.35 63.35 69.98 81.03 12 City of Hallandale Beach 20.50 26.62 32.88 36.01 43.19 63.30 77.31 100.66 13 City of Lake Worth 14.49 20.05 25.61 28.39 34.93 48.10 53.14 67.04 14 City of Miramar-Eastern Service Area 19.12 27.14 35.16 39.17 47.89 69.69 82.77 106.92 15 City of Miramar-Western Service Area 14.91 22.07 29.23 32.81 40.67 60.32 72.11 94.11 16 City of Pompano Beach 1928 25.64 32.00 35.18 41.54 54.46 59.53 70.48 17 City of Riviera Beach 12.87 17.91 23.58 26.73 33.57 49.30 56.29 69.69 18 City of Stuart 9.75 21.95 34.15 40.25 52.45 82.95 89.37 104.35 19 City of West Palm Beach 14.26 21.64 29.02 32.71 40.40 58.71 64.24 73.47 20 Cooper City 25.12 33.14 41.16 45.17 53.19 69.32 75.47 85.72 21 Martin County 35.60 46.96 58.32 64.00 75.36 9T64 105.50 122.05 22 Palm Beach County 15.45 18.95 22.45 26.25 33.85 52.85 64.25 83.25 23 Town of Jupiter 24.71 27.33 29.95 31.26 33.88 40.43 44.36 50.91 24 Village of Royal Palm Beach 26.54 30.34 34.14 36.04 39.84 49.34 55.04 64.54 25 Village ofTequesta 21.93 28.97 36.01 39.60 46.79 62.93 73.72 91.10 26 Other Florida Utilities'Average $20.21 $26.38 $32.69 $36.02 $42.92 $59.20 $67.19 $81.25 (1) Unless otherwise noted,amounts shown reflect residential rates in effect August 2004 and are exclusive of taxes or franchise fees,if any,and reflect rates charged for inside the city service. All rates are as reported by the respective utility. This comparison is intended to show comparable charges for similar service for comparison purposes only and is not intended to be a complete listing of all rates and charges offered by each listed utility. APPENDIX C �Q a 0 0 0 0 0 0 0 o 0 0 0 o c o 0 o e 0 0 0 0 o 0 o p o 0 0 0 0 o v~o ,n 3 h N D\h r�1 Nt w M M M 0 0 0 0 0 0 0 0 0 O 0 0 0 o e 0 0 0 0 0 0 O O O O O O O p C b 0 0 0 0 t 00 N M p �Y1 V P W O P b 0 U y A 'Ir b _- R 00 r? b h � e0 0 a e s e o v o a 0 0 0 0 3 0 0 0 0 o u y o 0 0 0 0 0 0 0 0 o w � A C ti F P. 0 Q o e e e o 0 0 0 0 3 0 000dd � o 00 a o0000 0 o SBSSSo 0 o SSS o U T lo r � m q Z, _1C G N 6 U � a = w U a 3 a moo $ � �2'4 4 0. P.�FO v�A E� G� m� ,�aFw o ae a a w m b W 0 N o0 N w N °� �• �> O �•-• b t� V�O t � �C7�C7 y a "� O W ._ o�o0 0 0 0 0 0 0 0 0 0 0 o a o — o 0 F sv 0 oa m .. o F� c k W 0 0 0 0 0 0 0 0 0 0 0 0 o N a o.o0 0 0 0 0 0 0 0 0 0 0 (= o 0 0 C7 � N N C Vi k W c c c E E E E E E E •E E E E F 0 0 0 0 0 0 0 0 0 0 0 0 N Vi 00 O O O Q O E d o 0 0 0 0 0 0 0 0 0 0 a n o 0 O N N a a w N V t O O O O O O O O O O V 30 3 0 0 0 0 0 0 0 0 0 0 0 � O oc7 vr� vvvvaovcv O 0 0 0 0 0 O O 0 0 - O O O O O O O 0 0 0 0 V a 3 Qo 0 0 0 0 0 0 0 0 0 0 0 ds o 0 0 71 0 0 0 M 0 2' _ U a v > O � 6 O O O O O O O O O O O .-• O O O O O '� O O` E 0 E o e`n n E v 2 W � — 3 o z 33� 3aau3xoo o � a � F 0 az w Table C-3 Page 1 of 2 DRAFT City of Dania Beach,Florida Water System Development of Water System Connection Impact Fee Line No. Description Amount Water Production and Treatment Facilities: 1 Cost of Existing Facilities[1] $1,615,638 2 Existing Pant Capacity(GPD)(ADF)[2] 3,000,000 3 ERU Factor-GPD[3] 300 4 Estimated ERUs to be Served by Existing Facilities[4] 10,000 5 Percent Remaining Capacity of Existing Facilities[5] 0.00% 6 Allocation of Existing Facilities to Incremental Growth[5] 0 7 Rate per ERU Associated with Existing Facilities[5] S0.00 New Water Production and Treatment Facilities: 8 Cost of New Facilities Allocable to Growth[6] $3,852,000 9 Plant Capacity Allocable to Growth(GPD)[6] 2,000,000 10 ERU Factor-GPD[3] 300 11 Estimated ERUs to be Served by Additional Facilities[4] 6,667 12 Cost per ERU Associated with New Facility $577.80 13 Total Cost per ERU of Water Production/Treatment Facilities $577.80 Primary Transmission/Distribution System: 14 Existing Facilities [7] xC $4,944,784 15 Additional Costs Capitalized to Existing Facilities 5,185,000 16 Total Existing Facility Costs 10,129,784 17 Existing Capacity of Transmission and Distribution System(GPD)'[8] 5,000,000 18 Existing Plant Capacity(GPD)(ADF)[2] 3,000,000 19 Percent Remaining Capacity of Existing Facilities 40.00% 20 Subtotal $4,051,914 21 Estimated Capacity(GPD)(ADF)[6] 2,000,000 22 ERU Factor-GPD[3] 300 23 Estimated ERUs served by Transmission/Distribution Facility[4] 61667 24 Total Cost per ERU of Transmission/Distribution Facilities $607.79 25 Total Combined Cost per ERU $1,185.59 26 Proposed Connection Impact Fee per ERU[9] $1,185.00 27 Existing Fee per ERU $990.00 28 Proposed Adjustment $195.00 GPD=Gallons Per Day Footnotes continued on Page 2 of 2. Table C-3 Page 2 of 2 DRAFT City of Dania Beach,Florida Water System Development of Water System Connection Impact Fee Footnotes: [1] As calculated in Table C-1 and based on the fixed asset schedule as provided by the City. [2] Represents the current capacity of the system. [3] Based on information provided by the City,300 gallons per day reflects the equivalent residential unit(ERU)factor. [4] Calculated based on capacity and the City's ERU Factor of 300 GPD. [5] Remaining available capacity to serve new growth. [6] As calculated on Table C-2. [7) As calculated in Table C-1 and based on the fixed asset schedule as provided by the City. [8] Total planned capacity of the system following completion of the water improvements. [9] Per Equivalent Residential Unit(ERU),300 gallons per day,or one single family residence. Page I of 1 DRAFT Table C-4 City of Dania Beach,Florida Wastewater System Development of Wastewater Svstem Connection Impact Fee Line No. Description Amount Wastewater Primary Collection System Costs 1 Existing Facilities [1] xC $7,308,501 2 Additional Costs Capitalized to Existing Facilities 0 3 Subtotal of Existing Facilities 7,308,501 4 Existing Capacity of Transmission and Distribution System(GPD)[2] 3,195,990 5 Existing Wastewater Treatment Flows(GPD)(ADF)[3] 2,938,127 6 Percent Remaining Capacity for Future Growth 8.07% 7 Capacity Costs Allocated to Future Growth $589,674 8 Estimated Capacity for Future Growth(GPD)(ADF) 257,863 9 ERU Factor-GPD[4] 300 10 Estimated ERUs served by Collection Facilities[5] 860 11 Cost per ERU of Collection Facilities $686.03 12 Total Combined Cost per ERU $686.03 13 Proposed Connection Impact Fee per ERU[6] $685.00 14 Existing Fee per ERU $352.00 15 Proposed Adjustment $333.00 GPD=Gallons Per Day Footnotes: [1] As calculated in Table C-1 and based on the fixed asset schedule as provided by the City. [2] Based on a review of the collection system. [3] Represents the current capacity of the system. [4] Based on information provided by the City,300 gallons per day reflects the equivalent residential unit(ERU)factor. [5] Calculated based on capacity and the City's ERU Factor of 300 GPD. [6] Per Equivalent Residential Unit(ERU),300 gallons per day,or one single family residence. Table C_5 Page I of 1 City of Dania Beach DRAFT Water and Wastewater System 2004 Water and Wastewater Rate and Fee Study Comparison of Capital Connection Char1jes for Water and Wastewater Service (1) Line Residential 5/8"x 3/4" Meter No. Description Water Wastewater Combined City of Dania Beach: 1 Existing Impact Fees $990 $352 $1,342 2 Proposed Impact Fees 1,185 685 1,870 Other Florida Utilities: 3 Broward County $1,071 $1,945 $3,016 4 City of Boca Raton 5,195 4,168 9,363 5 City of Boynton Beach 1,679 299 1,978 6 City of Coral Springs 860 610 1,470 7 City of Deerfield Beach 865 405 1,270 8 City of Hallandale Beach 825 0 825 9 City of Lake Worth 400 1,450 1,850 10 City of Miramar-Eastern Service Area 2,914 1,700 4,614 11 City of Miramar-Western Service Area 2,914 5,030 7,944 12 City of Pompano Beach 700 700 1,400 13 City of Riviera Beach 1,571 1,117 2,688 14 City of Stuart 1,120 1,600 2,720 15 City of West Palm Beach 1,270 940 2,210 16 Cooper City 1,316 2,201 3,517 17 Martin County 1,710 2,100 3,810 18 Palm Beach County 1,200 1,800 3,000 19 Town of Jupiter 1,855 1,813 3,668 20 Village of Royal Palm Beach 1,780 2,060 3,840 21 Village of Tequesta 2,252 1,813 4,065 22 Other Florida Utilities'Average $1,658 $1,671 $3,329 (1) Unless otherwise noted, amounts shown reflect residential rates in effect August 2004 and are exclusive of taxes or franchise fees, if any, and reflect rates charged for inside the city service. All rates are as reported by the respective utility. This comparison is intended to show comparable charges for similar service for comparison purposes only and is not intended to be a complete listing of all rates and charges offered by each listed utility. APPENDIX D Table D-1 City of Dania Beach Page l of 2 2004 Water and Wastewater Utility Rate and Fee Study DRAFT Schedule of Miscellaneous Water and Wastewater Service Charges Line No. Description Existing Proposed Minimum Connection Charge: Installation of Water Service(Tap)Line Only: 1 5/8"Line $439.00 $1,450.00 2 1"Line 549.00 1,550.00 3 1.5"Irrigation Line N/A 1,650.00 4 1.5"Line 730.00 1,650.00 5 2"Irrigation Line N/A 1,750.00 6 2"Liine 913.00 1,750.00 Installation of Water Meter Only: 7 5/8"Meter $185.00 $245.00 8 1"Meter 231.00 310.00 9 1.5"Irrigation Meter N/A 605.00 10 1.5"Meter 308.00 810.00 11 2"Irrigation Meter N/A 740.00 12 2"Meter 376.00 1,265.00 13 3"Meter 1,825.00 1,850.00 14 4"Meter 3,647.00 2,700.00 15 6"Meter 6,383.00 3,900.00 Installation of Sewer Service(Tap)Line Only: 16 5/8"Line N/A $1,935.00 17 1"Line N/A 2,135.00 18 1.5"Line NIA 2,335.00 19 2"Line N/A 2,535.00 20 Interest on Delinquent Monthly User Fees 5.00% 5.00% Utility Connection Deposit: Water Single Family Residential Service 21 5/8"x 3/4"Meter $50.00 $50.00 22 Multi-Family 50.00 50.00 23 Construction Service(blanket fee) 50.00 50.00 24 Temporary Meter Deposit 100.00 100.00 25 All Others Not Specified 100.00 100.00 Wastewater Single Family Residential Service 26 5/8"x 3/4"Meter $50.00 $50.00 27 Multi-Family 50.00 50.00 28 Construction Service(blanket fee) 50.00 50.00 29 All Others Not Specified 100.00 100.00 General Service Charges: 30 Meter Re-read[1] $15.00 $25.00 31 Meter Removal&Testing[2] $25.00 $65.00 Table D-1 City of Dania Beach Page 2 of 2 2004 Water and Wastewater Utility Rate and Fee Study DRAFT Schedule of Miscellaneous Water and Wastewater Service Char es Line No. Description Existing Proposed 32 Meter Seal/Coupling is Broken or Removed $20.00 $20.00 33 Meter Removal or Lock $50.00 $50.00 34 Backflow Tests $35.00 $35.00 Fire Hydrant Services: Meter Rental $10.00 per year $10.00 per year Hydrant Water Usage $1.75 per 1,000 gallons $1.75 per 1,000 gallons Temporary Usage not from a Hydrant Meter $1.75 per 1,000 gallons $1.75 per 1,000 gallons Fire Line or Sprinkler Service $10.00 per year $10.00 per year Duty of Consumer as to Leaks or Waste: 35 Meter Turn-on Fee[3] $10.00 $25.00 Bill Delinquency and Service Reinstatement: Reinstatement Fees[41 36 Within 15 days of Discontinuance $20.00 $30.00 37 More than 15 days of Discontinuance 50.00 $75.00 38 New Applicants 25.00 $37.50 Connectine or Disconnecting Service by Consumer 39 Penalty of Prohibited Curb Cock Use $10.00 $10.00 Footnotes: [11 Charge applies only if meter is functioning properly and the reading is correct. [21 Charge applies only if meter is registering 3%or less upon removal and testing. [31 Water supply is turned on after leaks or waste on consumer's premises have been fixed. [4] Reinstatement fees apply only upon full payment of due bills. PROPOSED RTE Table 13 City of Dania Beach,Florida Pagel of 2 2004 Water and Wastewater Rate and Fee Studv DRAFT Existing and Proposed Water and Wastewater Rates Line Existing Rates Rates Effective Fiscal Year Ending September 30, No. Description 2004 2005 2006 2007 2008 2009 Effective Date (Oct.2004) (Oct.2005) (Oct.2006) (Oct.2007) (Oct.2008) WATER RATES Residential/Condominiums: Water Base Rate per ERU 1 All Meters $5.39 $6.50 $7.50 $8.00 $8.50 $9.00 Water Consumption Rate per 1,000 gallons(per ERU) All Meters 2 0 to 5,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 3 5,001 to 14,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 4 over 14,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 Commercial/Sprinklers/Laundry Mats: Water Base Rate per ERU Water Meter Size(inches) 5 5/8" $5.39 $6.50 $7.50 58.00 $8.50 $9.00 6 1" 13.47 16.24 18.74 19.99 21.24 22.49 7 11/2" 26.94 32.49 37.49 39.99 42.48 44.98 8 2" 43.11 51.99 59.99 63.99 67.98 71.98 9 3" 86.23 103.99 119.99 127.99 135.98 143.98 10 4" 134.73 162.48 187.47 199.97 212.47 224.97 11 6" 269.45 324.94 374.93 399.93 424.92 449.92 Water Consumption Rate per 1,000 gallons(per ERU) Water Meter Size(inches) 5/8"Meter 12 0 to 5,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 13 5,001 to 14,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 14 over 14,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 1"Meter 15 0 to 12,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 16 12,001 to 35,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 17 over 35,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 1.5"Meter 18 0to 25,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 19 25,001 to 70,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 20 over 70,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 2"Meter 21 0 to 40,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 22 40,001 to 112,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 23 over 112,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 3"Meter 24 0 to 80,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 25 80,001 to 224,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 26 over 224,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 4"Meter 27 0 to 125,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 28 125,001 to 350,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 29 over 350,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 6"Meter 30 0 to 250,000 Gallons $1.40 $1.47 $1.63 $1.87 $2.14 $2.46 31 250,001 to 700,000 Gallons 2.12 2.23 2.47 2.83 3.24 3.73 32 over 700,000 Gallons 2.64 2.77 3.07 3.53 4.04 4.64 Table 13 City of Dania Beach,Florida Page 2 of 2 2004 Water and Wastewater Rate and Fee Study DRAFT Existing and Proposed Water and Wastewater Rates Line Existing Rates Rates Effective Fiscal Year Ending September 30, No. Description 2004 2005 2006 2007 2008 2009 Effective Date (Oct.2004) (Oct.2005) (Oct.2006) (Oct.2007) (Oct.2008) Retail Effluent Irrigation Rates Water Base Rate per ERU Water Meter Size(inches) 33 5/8" $4.35 $5.25 $6.05 $6.46 $6.86 $7.26 34 1" 10.90 $13.14 $15.17 $16.18 $17.19 $18.20 35 11/2" 21.75 $26.23 $30.26 $32.28 $34.30 $36.32 36 2" 43.50 $52.46 560.53 $64.56 $68.60 $72.63 37 3" 87.00 $104.92 $121.06 $129.13 $137.20 $145.27 38 4" 174.00 $209.83 $242.12 $258.26 $274.40 $290.54 Water Consumption Rate per 1,000 gallons(per ERU) 39 All Meters $0.13 $0.14 $0.15 $0.17 $0.20 $0.23 WASTEWATER RATES Residential/Condominiums: 40 Wastewater Base Rate per ERU $8.29 $9.50 $10.50 $11.00 $11.50 $12.00 Water Consumption Rate per 1,000 gallons(per ERU) 41 All Usage $2.70 $2.86 $3.07 $3.37 $3.65 $3.91 Commercial/Sprinklers/Laundry Mats: Wastewater Base Rate per ERU Water Meter Size(inches) 42 5/8" $8.29 $9.50 $10.50 $11.00 511.50 $12.00 43 1" 20.74 23.77 26.27 27.52 28.77 30.02 44 1 1/2" 41.47 47.52 52.53 55.03 57.53 60.03 45 2" 66.36 76.05 84.05 88.05 92.06 96.06 46 3" 132.72 152.09 168.10 176.11 184.11 192.12 47 4" 207.37 237.64 262.65 275.16 287.67 300.17 48 6" 414.74 475.28 525.30 550.32 575.33 600.35 Water Consumption Rate per 1,000 gallons(per ERU) 49 All Usage $2.70 $2.86 $3.07 53.37 $3.65 $3.91 YEAR-TO-YEAR TE COMPARISONS PARISONS s`. 0 0 0 0 o 0 0 0 0 0 801 O O Cl� C� 00 � `O �c \U � o Y � ` \ O N d1 \O l- 00 Q 00 M M M M M M v1 �O l- a1 O V) (',I v) oo � I'D� l� M O M � I-C� � O r- �t --1 00 v) 00 _. V) 01 '�t C1 M 00 O M v' O \O V) N 01 I'D p yam, 01 O N m �n 00 O N E "d O oo Vn M k O 6g - N N M V) r- O M ram4 01 O O N 00 N Do [- t � M M M M N M -zl- V) V) N N N N N N N N N N N (-I 01 � � 01 � M v� [� 01 � ,--� M l- ,--� V� 01 M l- 00 01 -- M l� a -0 � 00 � O N � � 00 O N mil' l- m O \O O N M V') 00 1 O O O O O O O O O O O O O O O O mow. m!, N O O � 01 41 00 00 00 [l- [-- [l- [— �c C 1 N M W) �10 00 O M 't \O 00 `D Z' O V N 1 C -. cM \O d' N W-� N c-, oo O W) C1 00 It M -- -- O Ln M M M M M M M Cd O W N 00 O W N 00 �t O O O O O O w _ v> M N O O� 00 `O V) M M C1 v> O 01 N V) 00 O M "O O-, N W-i 00 N �,O V) M N Gr O ^" 69 r- '- N N N N M M M \O N 01 V) Vr l� �,D 00 00 T N M V) -- 00 l� - cT 00 Cr � M O 00 l� \o V) N C1 Q1 00 x •yS Q1 01 01 O\ O� cT 01 O� 01 O� 01 � 01 CT 01 cT 00 kf) N r- N N N N � C., N V) 00 N C� �c M N N M M 00 -- 1 � 1 ^ bA V) I'O [— 00 01 OLf) O O C) O �1 I.P, 1.01 0 o 0 0 0 0 o 0 o 0 0 0 0 0 M N '-+ O O 01 01 01 00 l— l— \o `o "o c c� 00 � N a �t 1 It It It 1, M V) � O N O N V) 00 --i \O V) 't M z ~ M M \O M M N M N V) '- -, "0 00 V.) N O M M "o M V1 — 00 \D M 01 00 N O N 01 00 [� r-� �6 1.6 11 �6 V-i V-i Lf� V•i kl� cj O rn �10 01 N e d M N O 0\ d I�t Zi- rn [- o0 C\ O O N V) 00 ct' 00 M l-� N l-: N 00 M 01 r-� M 01 '.6 M M 'It I�t V) V) \o 00 -- N N u 00 d V N �t O 'o 00 -:t M M 00 M -- O bA l� 01 D Ln 00 Ln N O 01 00 V) �t � tt Z O 00 t-- `o � "o V) V) Vi V) NV) N y� 00 00 00 00 00 00 O N I:t `0 00 O O O O O `o l� 00 01 O r-+ O 00 "o d N `o O 00 V) O d' 0\ M 00 M 00 N 01 M `0 01 �' � 6F3 •-� r; N N a; ,. N M It V) r- oo O1 O O O t O I1�I ! \ \ \ \ \ \ 0 0 0 0 0 0 0 0 0 0 0 go 801 001 0 0 0 ` t It C4 c" Cd oo •--� � � to l� O �h Do C — O M d �O 00 O N Vn l� Q1 N l� 00 CO 00 a, (D" H O � O M N O l� M ^- Ln '- O O\ o0 o0 0o [-- 00 51 Q\ 01 N N r� O cM � � N Lf1 N O*) v� N O\ �t oo N _ to — � M O �O O v) a1 O� M O [� Lf) C� O N kl� 06 O M kri r-� O ,6 r--� r-� 00 N N N N �t V) 00 -� M O C1 l� V l� �O v� ct Ln ®' N x Z M M N N N N N N N N N N N Mimi C4 Ln d 01 m 00 O M Ln r- O \O Vn N ol\ \O p 01 O N M "d 00 O N E O 00 V� c*i It I LLJI uj �-. �Jevvo 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NN - O 01 01 0\ Crl 00 00 00 00 00 00 00 00 00 00 LL U O -+ N M cF �o r- 00 01 O O O O O �^ C O N V oo O N E X — N M � W) N N N N N M d Vi [-� 0\ C � N [— O l— N l— 00 � N l— O N M 00 V) M V) [— — 00 Ljr) M N -- [— \o It M N M 00 \o Lf� V) q q M M M M M ^C O l— I:t -- 00 V) N 01 `o M O V) 0 0 0 0 _ Llr) Lr) r- 00 01 Cl) O — N Lr) 01 M O 01 N Lf) 00 Lr) 00 N M N N N M M M V) l� O M �101 O 69 N -\ M V) N 0\ � 00 O V) p Z M N E N O 01 00 zt M .--i O My C.0 Q a. /� ♦ ® O �10 N 00 It O �o N 00 Nt 0 0 0 0 0 0 tf) M N — zl- r- M (01 V) N V) x N "D Ln M N '^ b9 N N N N M M Mr) 't 01 N V) W s, ®,®! Ch � x ro 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 M N 0 0 0 0 0 0 0 D1 01 0\ � o LLO r- tt 00 Lr) O V) 01 �t 0\ O l- O 't 00 M M Lr) if) "o 00 O \O \O O ^" 6i4 N N O O O O O �c r- N O N 00 (f) a• ® M N M 00 Lf) N OC*� Ln M N N N g x N M- O D; 00 E23W bA 3.w O � It 000 OV) O OVO C — I N O 00 � ®® p yam, oo N � N �6 �- N 0o f,i 01 � 00 C; sy p N N M M a1 N oo N M ®I Q M M M M N M NV) -- d I'0 00 if) N . ® M M `o M V) — 00 \O I:t M 0\ 00 [— l� l� Z O N 0\ 00 l.� l-: 6 \o \o .d L'� L v> N N - O M `0 0\ NLn M N O d1 O M I'0 0\ M `o l� 00 01 O O N v) 00 -- co� O C! 00 M l- N l- N 00 cM 01 O v') Ln "0 00 -- [� N 00 V) `o [� 00 C� O Ln O O �O O n 01 l� 00 C*1 O O r o 0 0 0 0 0 0 0 0 ` N N N M M ®' tl tk Vn N N -- ^. v) ,o N l— N L ram, O O O N N N M M Li [� N `o O ^" EA, N [� ol ® t�00 o 0c oo 0 V1 00 N N N M M d' 00 Ln oo oo -- `0 01 \o N o0 ... O o0 o0 M 01 N to l� cl M Lr) l O M i/; 00 l6 M O\ 41 N N N N M (:N M ,o (Z � � ) i 1�j M 0o M M N 't 00 -:t O M N o -t [— p O Cl 00 00 00 l� 00 O, O\ C\ norm, N a1 d M M M N N N N N N N N N O m \o C*� N to N c;,\ v) N c1 :t -- - oo N O Ln d1 01 M O l- Ln O r--� a1 O N L'i oo O M o0 N N N N I n ooMai -- a! I , O -� N M Ln `o [— 00 O\ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 l� 00 00 00 00 00 00 Ol� C1 Q1 01 C1 LL O ti v O O O O O O O O O O O O O O O O v) 00 IZI- r- O M �c a1 N kf) O kf) Lf) W) Lr) -4 N N N N M M L'i Ao a1 N Ln al � r r- a1 r, rn M 00 00 O a1 r- V) -t cd N 01 \O M O `n O O O O -zi- 00 N V) a1 M l� `r? OO `n or-O " l� N r- O l- N [� 00 � N O N M o0 1 O Lr) M V) F- -- 00 V) M N M M M M M cn 00 "o Lf) Vi -ZI: -ZI: d "Zi '4 ®' O I- mot w V) N a1 H M O O O O O ' vn vr) la 00 a\ 01 O N V) Cl 1-0 m O p ice, O cM "d a\ N v-) 00 Lri 00 '.4 �c - O m O ^" -- - - N N N M M M Ali ®, Q� O vn O O O O N M � V) � r-- 00 a1 G �J��� o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 �o l� 00 00 a1 01 01 O O O O N N v O 00 N "o O \o M 01 L N N 01 d "o Ln V) a; `O \p W m It � r- 01 r- M 00 00 N 01 N V) -- 01 im, O N r- Lr) 01 O W N 01 r- N It It -� 0\ 01 00 00 l- r- r- r- C-- � r- \O ^C � O � oo N "o O O O — — — — a1 � N o0 N � � Cl) N It � 00 O N D1 M M M N cz p p N N M M It V) V') `o � r- OIt r-+ 00 It N N M ol tf j O O O O O � — `o l� N O N 00 v) M 00 E N O a\ M N N 16 O O O O O O 00 V) 01 01 — 't 00 N 00 V) O V) — p 00 N l-� N �d + N 00 M 0� (-: 00 01 -- N N N M M �t d Vn (f') �,o 1,0 0\ N 00 Vn i� 64 p 0 -- N M vn �o I- 00 p1 O 0 0 0 0 r� 0 0 0-10 0 o c o NN CJ O I� � - 00 � \O I` 00 C\ C1 't 00 00 (` — W) r- O M V) 00 N � O d 00 O V) � r- 00 \_ O O — -- ^ N N M M M 00 M 00 M coq d' l� N l� d' a1 M � M I� p M G1 N x I` �o �o vn vn � �o � 00 00 bA �" Gw ci 1 "t3 O 0o N �o O � 00 N �o O O 00 M C1 _ L I— a1 O N d I'0 C1 Lr) C� N O 00 O N I� Q1 N Lri 06 NLf� N N N M M MV) Q 01 O\ V) C1 O "o O 00 00 N 00 t M N N M �fi O O,, Ln M K', M M M M M M M M M M N tj O I� d' 00 V) 00 -� tn 00 r-+ � C1 \O N 00 i w ^, O 00 I— \o � M .-� O 00 \o � M C1 N � I` 00 C1 .--� M 'n r O M 00 --� 'o M C1 C1 69 ^-+ -- N N N N M `O C� M �o O N M d' W1 00 O\ O O O O O co 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C4 V) L �o l— [— l— [— l— l— [— 00 00 00 00 00 V!! op y LL 0 �d 0 00 110 E N O 00 � NT N 0 0 0 0 0 0 N N N M M oo H LLI- m Lr) O oo M L!1 [— 01 c-, cM O N M M et o0 N O a1 x N O G1 00 �,p Vi Lr� vi vi q M cY o 0 0 0 _ Lr) 00 M O N v> O Lrl O O L'� oo N �,O a� M [� O q 00 o`to N — a M 00 O -- V) N ON l— V) o -- 00 V1 N 01 M O O O Cl O M � -, 00 N Ln O\ M r— `r? oo � C� 00 N N N M M MI:t P6I 0�®A! M/ GA c o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 V r- 00 00 0o C1 a1 a1 C� Cl\ O O - .-, 0 eC C� O Lr) O V) O v> �t M N - a1 I�t 00 00 r- `J C . O v1 N [- zl- - 00 V,) (n 't M p - N N M cri V i Lri O N O 00 OL � C C�4 .� N M M tv +�- CC cd 01 a1 \O O� O� - \o O O � v) O l� � [� l� [- M C1 I- V) M C1 00 00 l- l� N N k1 (V O C� C.) 00 00 00 00 [- [- [- [- [- Cd - O O\ 00 [� �o V) M N -- O N 00 M a1 �O [- V) M �--� C� 00 [-- �o N t "o O o1 r— � ® O cc O L M 0o v� N C� \o M 00 M Or--� Q" O NC�3 N M M Ln \o \o 00 --i M -- 00 si�i' N M M O. 01 l� M 00 00 N C1 N V� O N C\ [-- �o �-+ .--i O O C d' ^4 O\ C1 00 00 [- [� [- [- [- [- [- \o l O d 00 N o O O O �--+ -� \o N 00 - r— a1 N et � 00 O N o\ M M M N C M � � � r— r— O t N M N ■saw ♦l b�D O O O O O o 0 0 0 1.01 180 0 0 0 0 0 0 0 0 0 CI Ln N N 00 �.1 f O O O\ C1 ^ M M O - �O Lf) cj Q 00 7T O M V) 00 O M r- �c V') � M _.. O a1 M 00 M O l— I�t N C1 I�t �o O It 00 N "d o; 01 A, '-; -- -- .-- N N N M M M 00 N l— N � t Ct '�t 7t M \o M l— p `o M O\ N 00 � \o \o � � �t �o [— 00 00 vLn S, � � O �t oo N �o O �t oo N � O O o0 M � �o l� O\ O N �o a1 N `o ®® O 00 O N -t' l� 01 N Ln 00 N Ln N N N M M 1 � I O Ln O O O O �l \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C ® vUi \ C O W N 00 It O \ N 00 d O O O O O O V) I� O N v) 00 O M Lf) 00 l� M (01\ Lr) \ ��♦ ~ C � � O r- r- � � N N cV N M �t V� 00 O M H 1 N eq � � o O o Cl� � M N 00 � � V N M � V) p N Lri l- ) N oc O [� LnO 00 M Ln [- 01 01 M O N ch M 00 _ O - Lr) a\ Lr) N O C\ 00 " N o 0\ 00 kn .r) Lr) U \ •® O U ..., LnOOk Lr) O o 0 N - 00 M O N O v O p4Z -, 00 N Vr Q1 M l� O 00 0000 N Vi C*) C 64 N N N M M 7t Idt "zi- it LU ■' ' bA N M 7t � � 00 O1 O � O O O O � � � -` Yr is o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 00 W o1 C*� C C1 O O O -� ee O oo N O t � cM 00 N �o 00 N Vn 00 N M M (n �c � -- t M -- \' 00 ?� c� [� [� N [� 00 M t� [- O r- O C1 p M o0 M �o O l� -'I- N "o "o V-� V) d1 N "o C1 M N 1�0 Ln :t M (:j .. O M l� 00 r- M O r-+ 00 M 00 M ®® v� _ N O o0 to M -4 O N 00 M C1 NFf3 N M d Ln \o `o N M Ln M 01 r- �n M O\ 00 00 r- t� N N N O 01 C1 00 00 00 00 r-- r-- r-- r-- � ' CA �d > G� to ,I- M N O v'� 00 M C1 �t 01 00 O Lf� l� M 00 vi N C1 ,6 M 00 [� M O l� ® f� Y •^ N N M M zt "r Ln \o I'D l� 00 -+ �n M 00 N M M ®®; � 1 O O> O I