Loading...
HomeMy WebLinkAboutWater Rates Analysis Report - 10/1/2013Final Draft Report Oro Valley Water Utility Water Rates Analysis Prepared for October 2013 Prepared by 4 CH2MHILL 1840 E. River Road, Suite 200 Tucson, Arizona ExecutiveSummary......................................................................................................................ES-1 1. Intro duction/Background..................................................................................................1-1 Scopeof Work......................................................................................................................1-1 WaterUse Trends................................................................................................................1-2 GrowthTrends.....................................................................................................................1-2 Organizationof this Report................................................................................................1-3 2. Financial Plan......................................................................................................................2-1 Structureof Funds...............................................................................................................2-1 General Assumptions..........................................................................................................2-2 OperatingFund...................................................................................................................2-2 Revenue Forecast....................................................................................................2-2 Operations and Maintenance Expenses .............. ................................................ 2-3 DebtService.............................................................................................................2-4 CapitalOutlay.........................................................................................................2-4 Summary of Revenue Requirements...................................................................2-5 CashFlow Analysis................................................................................................2-5 Development Impact Fee Funds........................................................................................2-6 Alternative Water Resources Development Impact Fee Fund .........................2-6 Potable Water System Development Impact Fee Fund.....................................2-6 3. Cost of Service.....................................................................................................................3-1 Summaryof Results............................................................................................................3-1 4. Rate Design..........................................................................................................................4-1 Introduction..........................................................................................................................4-1 Assumptions........................................................................................................................4-1 ExistingRates.......................................................................................................................4-1 Rate Design and Proposed Rates.......................................................................................4-2 BaseRates................................................................................................................4-2 CommodityRates...................................................................................................4-2 Other Service Fees and Charges........................................................................................4-6 Rate Considerations and Recommendations...................................................................4-7 5. Preferred Financial Scenario............................................................................................5-1 6. Bill Impacts..........................................................................................................................6-1 Preferred Financial Scenario Bill Impact..........................................................................6-1 Comparison to Surrounding Utilities...............................................................................6-3 7. Summary and Conclusions...............................................................................................7-1 Tables ES-1 Current and Proposed Commodity Rates..................................................................... ES-2 ES-2 Residential Class Customer Bill Impacts (5/8- x 3/4-inch meter) ............................. ES-3 ES-3 Commercial Class Customer Bill Impacts (2-inch meter) ........................................... ES-4 2-1 Operating Fund General Assumptions............................................................................2-2 2-2 Projected Annual Growth in Number of EDUs..............................................................2-3 2-3 Remaining Outstanding Principal Balance as of FY 2012/13.......................................2-4 2-4 Projection of Operating Fund Revenue Requirements..................................................2-5 3-1 Revenue and Cost of Service for Proposed Customer Classes.....................................3-1 4-1 Oro Valley Existing Water Rates - Residential, Multifamily Residential, Commercial, and Irrigation................................................................................................4-2 OH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT 11 07_13 4-2 Distribution of Residential and Irrigation Water Consumption - Percentage of Usage by Tier...............................................................................................4-3 4-3 Distribution of Commercial and Master -Metered Multifamily Water Consumption - Percentage of Usage by Tier.......................................................4-3 4-4 Current and Proposed Commodity Rates........................................................................4-5 4-5 Projected Revenue at Proposed Rates..............................................................................4-6 6-1 Residential Class Customer Bill Impacts (5/8- x 3/4-inch meter)...............................6-1 6-2 Commercial Class Customer Bill Impacts (2-inch meter)..............................................6-2 6-3 Comparison of Residential (5/8- x 3/4-inch Meter) Base and CommodityRates................................................................................................................6-3 6-4 Residential (5/8- x 3/4-inch Meter) Monthly Bills at Varying Levels of WaterUse.............................................................................................................................6-4 6-5 Comparison of Commercial (2-inch Meter) Base and Commodity Rates ...................6-4 6-6 Commercial (2-inch Meter) Monthly Bills at Varying Levels of Water Use ...............6-5 Figures 1-1 Water Use History Potable and Reclaimed Water..........................................................1-2 1-2 Historical Growth Rates.....................................................................................................1-3 Appendices Appendix A: Financial Plan Tables A-1 Projected Water Revenue under Existing Rates A-2 Operations and Maintenance Expense Projection A-3 Summary of Existing Debt A-4 Capital Improvement Program - Potable and Reclaimed Water A-5 Projection of Cash Flow A-6 Debt Service Coverage Calculation Appendix B: Service Fees B-1 Current and Proposed Base Rates and Commodity Rates B-2 Proposed Service Fees and Other Charges Appendix C: Preferred Financial Scenario C-1 Operating Fund C-2 Alternative Water Resources Development Impact Fee Fund C-3 Potable Water System Development Impact Fee Fund C-4 Summary of All Funds Appendix D: Bill Impacts D-1 Bill Comparisons by Meter Size CH2M HILL_FINAL CRAFT RATES ANALYSIS REPORT_11 07_13 Executive Summa The Oro Valley Water Utility (Utility) contracted with CH2M HILL to perform a cost of service analysis and rate study for the Utility's potable and reclaimed water systems. The purpose of the cost of service analysis and rate study was to determine the system revenue requirements for a 5-year period (through Fiscal Year [FY] 2017/18), estimate the cost of providing service to the Utility's customers, and develop a schedule of rates and fees that equitably recovers these costs from the Utility's various customer classes. The study also involved updating the Utility's development impact fees, which were provided to the Utility under separate cover. The proposed adjustments to the Utility's water rate structure and commodity rates were designed to move the commercial and master -metered multifamily customers closer to their cost of service based on the cost of service analysis results. Proposed commodity rates maintain the current tiered rate structure for residential and irrigation customer classes, but commercial and master -metered multifamily customer classes move to a uniform commodity rate for all consumption (equal to the proposed residential Tier 1 commodity rate). In keeping with Oro Valley's current practice, the potable water turf rate remains equal to the Tier 1 residential commodity rate. Also as per current practice, the proposed potable water construction rate remains $1.00 more than the Tier 4 commodity rate. There is no increase proposed for reclaimed rates in the next FY (FY 2013/14), however, reclaimed rates gradually increase over the 5-year study period. No increase is proposed to the monthly base rates for potable or reclaimed water use. Current and proposed commodity rates are provided Table ES-1. CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_i i_07_13 ES-1 TABLE ES-1 Current and Proposed Commodity Rates Customer Class Current Rate FY 2012113 ($11,000 gallon) Proposed Rate FY 2013114 ($11,000 gallon) Residential Tier 1 2.20 2.23 Tier 2 2.99 3.01 Tier 3 4.03 4.07 Tier 4 5.38 5.49 Irrigation Tier 1 2.20 2.23 Tier 2 2.99 3.01 Tier 3 4.03 4.07 Tier 4 5.38 5.49 Commercial 2.20' 2.23 Master -Metered Multifamily 2.20' 2.23 Turf 2.20 2.23 Construction 6.38 6.49 All Reclaimed Classes 2.20 2.20 'Commedcial and Master -Metered Multifamily Tier 1 rate. The recommended commodity rate increases in the above table generate the revenue necessary to satisfy the Water Utility's revenue requirements, comply with debt service coverage requirements, and maintain target cash reserve balances as documented in this rates analysis report. The Preferred Financial Scenario cash flow results are provided in Section 4 and Appendix C. Residential rates and bill impacts for customers with a 5/8- x 3/4-inch meter are provided in Table ES-2. The residential tier thresholds (7,000,16,000, and 32,000) are highlighted in yellow and the average consumption level (8,000 gallons) is highlighted in blue. CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_1107_13 ES-2 TABLE ES-2 Residential Class Customer Bill Impacts (5/8- x 3/4-inch meter) Gallons Used Current Water Rate FY 2012/13 Proposed Water Rate FY 2013114 Groundwater Preservation Fee' Current Monthly Bill FY 2012/13 Proposed Monthly Bill FY 2013114 Amount of Increase Percent Increase 0 14.19 14.19 0.00 14.19 14.19 - 0.0% 1,000 16.39 16.42 0.95 17.34 17.37 0.03 0.2% 2,000 18.59 18.65 1.90 20.49 20.55 0.06 0.3% 3,000 20.79 20.88 2.85 23.64 23.73 0.09 0.4% 4,000 22.99 23.11 3.80 26.79 26.91 0.12 0.4% 5,000 25.19 25.34 4.75 29.94 30.09 0.15 0.5% 6,000 27.39 27.57 5.70 33.09 33.27 0.18 0.5% 7,000 29.59 29.80 6.65 36.24 36.45 0.21 0.6% 8,000 32.58 32.81 7.60 40.18 40.41 0.23 0.6% 9,000 35.57 35.82 8.55 44.12 44.37 0.25 0.6% 10,000 38.56 38.83 9.50 48.06 48.33 0.27 0.6% 11,000 41.55 41.84 10.45 52.00 52.29 0.29 0.6% 12,000 44.54 44.85 11.40 55.94 56.25 0.31 0.6% 13,000 47.53 47.86 12.35 59.88 60.21 0.33 0.6% 14,000 50.52 50.87 13.30 63.82 64.17 0.35 0.5% 15,000 53.51 53.88 14.25 67.76 68.13 0.37 0.5% 16,000 56.50 56.89 15.20 71.70 72.09 0.39 0.5% 20,000 72.62 73.17 19.00 91.62 92.17 0.55 0.5% 30,000 112.92 113.87 28.50 141.42 142.37 0.95 0.7% 32,000 120.98 122.01 30.40 151.38 152.41 1.03 0.7% 33,000 126.36 127.50 31.35 157.71 158.85 1.14 0.7% 'No proposed change in the GPF The average residential customer's monthly bill will increase $0.23 - a 0.6 percent increase in their monthly bill under the proposed rates. Bill impacts are slightly larger at higher consumption levels as a result of the increasing proportion of commodity rates to base rates. Commercial rates and bill impacts for customers with a 2-inch meter (the most common commercial meter size) are provided in Table ES-3. The 2-inch meter tier thresholds (56,000, 128,000, and 256,000) are highlighted in yellow and the 2-inch meter average consumption level (60,000 gallons) is highlighted in blue. Negative dollars are shown using parentheses and percentages using a minus sign (-). CH2M HILL_FINAL DRAFT RATES ANALYSIS REPORT-1 107_13 ES-3 TABLE ES-3 Commercial Class Customer Bill Impacts (2-inch meter) Current Proposed Groundwater Current Proposed Amount of Gallons Water Rate Water Rate Preservation Monthly Bill Monthly Bill Increase Percent Used FY 2012/13 FY 2013/14 Fee' FY 2012/13 FY 2013/14 (Decrease) Increase 0 113.53 113.53 0.00 113.53 113.53 - 0.0% 10,000 135.53 135.83 9.50 145.03 145.33 0.30 0.2% 20,000 157.53 158.13 19.00 176.53 177.13 0.60 0.3% 30,000 179.53 180.43 28.50 208.03 208.93 0.90 0.4% 40,000 201.53 202.73 38.00 239.53 240.73 1.20 0.5% 50,000 223.53 225.03 47.50 271.03 272.53 1.50 0.6% 56,000 236.73 238.41 53.20 289.93 291.61 1.68 0.6% 60,000 248.69 247.33 57.00 305.69 304.33 (1.36) -0.4% 70,000 278.59 269.63 66.50 345.09 336.13 (8.96) -2.6% 80,000 308.49 291.93 76.00 384.49 367.93 (16.56) -4.3% 90,000 338.39 314.23 85.50 423.89 399.73 (24.16) -5.7% 100,000 368.29 336.53 95.00 463.29 431.53 (31.76) -6.9% 120,000 428.09 381.13 114.00 542.09 495.13 (46.96) -8.7% 128,000 452.01 398.97 121.60 573.61 520.57 (53.04) -9.2% 140,000 500.37 425.73 133.00 633.37 668.73 (74.64) -11.8% 160,000 580.97 470.33 152.00 732.97 622.33 (110.64) -15.1% 180,000 661.57 514.93 171.00 832.57 685.93 (146.64) -17.6% 200,000 742.17 559.53 190.00 932.17 749.53 (182.64) -19.6% 220,000 822.77 604.13 209.00 1,031.77 813.13 (218.64) -21.2% 240,000 903.37 648.73 228.00 1,131.37 876.73 (254.64) -22.5% 256,000 967.85 684.41 243.20 1,211.05 927.61 (283.44) -23.4% 260,000 989.37 693.33 247.00 1,236.37 940.33 (296.04) -23.9% 'No proposed change in the GPF The average (60,000 gallons) commercial customer's monthly bill will decrease $1.36, representing a 0.4 percent decrease in their monthly bill under the proposed rates. By moving toward cost of service rates, a 2-inch commercial customer using more than 58,000 gallons per month would see a reduction in their bill. This means that the effect of modifying the commercial rate structure is greater than the effect of the Tier 1 commodity rate increase for commercial customers using more than 58,000 gallons of water per month. It also means that commercial users will receive relatively lower bills while residential users receive somewhat higher bills under cost of service rates (as compared to current rates). CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 ES4 1. Introduction/Backaround The Oro Valley Water Utility (Utility) contracted with CH2M HILL to perform a cost of service analysis and rate study for the Utility's potable and reclaimed water systems. The purpose of the cost of service analysis and rate study was to determine the system revenue requirements for a 5-year period (through Fiscal Year [FYI 2017/18), estimate the cost of providing service to the Utility's customers, and develop a schedule of rates and fees that equitably recovers these costs from the Utility's various customer classes. The study also involved updating the Utility's development impact fees, which were provided to the Utility under separate cover. Scope of Work The scope of the analysis consisted of the following major tasks: • Collect information and review goals and assumptions with Utility staff • Prepare rate model • Determine system revenue requirements and user characteristics • Project system revenues • Allocate costs to potable water and reclaimed water systems and to the customer classes of these systems • Update water rates • Present results • Provide the Utility with rate model for Utility staff use References throughout this report made to a year or FY mean the year beginning July 1 and ending June 30. Water rates in effect beginning July 1, 2012 are designated as FY 2012/13 rates. The analysis spans a 7-year period beginning in FY 2011/12 and ending in FY 2017/18 - hereinafter referred to as the study period. Transition to cost -of -service rates is assumed to begin in FY 2013/14 with a rate increase and rate restructuring, followed by additional rate increases and transition towards revenue -neutral cost -of -service rates through FY 2017/18. The 4-year period between FY 2014/15 and FY 2017/18 is called the adjustment period or forecast period. It should be noted that this study considers the financial effects of prospective capital projects that are included in the Utility's capital improvement plan (CIP) for the water system. This study uses current and anticipated new debt service amounts needed to fund the planned improvements at the time this study was prepared. The study also considers anticipated system growth rates, assumptions regarding future cost increases, additional CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 i-1 operating costs that maybe incurred from new capital improvements, and known changes in costs associated with regulatory assessments and water purchases from outside agencies. Water Use Trends As indicated in the 2012 Water Rates Analysis Report, the Utility has experienced a reduction in total water use of 9.2 percent over the last 7 years, and water use decreased by 1.3 percent during FY 2011/12 from the previous year (without a rate increase).1 Figure 1-1 provides the historic potable and reclaimed water use for the past 7 years. FIGURE 1.1 Water use in Oro Valley continues to decline on both a total and average per account basis. As such, the Operating Fund revenue projections (discussed in the Financial Plan section of this report) incorporates a reduction in billed volumes by 1.3 percent annually for all potable water customer classes to account for conservation trends in water use. The decline in water use was incorporated on a per account basis. However, total water consumption increases slightly due to account growth. Growth Trends The historic growth rates for the last 7 years are illustrated in Figure 1-2. 1 Water Rates Analysis Report, Town of Oro Valley, November 7, 2012, page 4. CH2M HILL_FINAL DRAFT RATES ANALYSIS REPORT_l 1_07_13 1-2 Historical Growth Rates 400 7 - - - - -. - . 350 346 y 300 _ _. _ 250 8 200 • 2 100 - _ - _ 97 _ 5D_- _ - _. _._ 68 61 __- 2006107 2007/09 2008/09 2009/10 2020/11 2021/12 2022/13 FIGURE 1.2 The historic growth rate declined significantly through FY 2010/11, however it has trended upwards again in the past 2 years as the number of new connections per year has been increasing from the low point of 61 new connections recorded in FY 2010/11. Organization of this Report This report is organized into the following sections: • Financial Plan - The purpose of this section is to present the basis for projections of operation and maintenance (O&M) expenses, CIP, and debt service planned through FY 2017/18. This section shows the financial results that would occur by implementing the recommended capital projects and levels of operation with annual increases to commodity rates and charges. • Cost of Service - The purpose of this section is to present the results and key findings of the Cost of Service study conducted to evaluate the cost of service for the Utility's existing customer classes. • Rate Design - The purpose of this section is to present the results and key findings for the rate structure option considered. This section provides recommendations and considerations for changes to the existing rate structure to shift each customer class closer to its cost of service. • Preferred Financial Scenario -The purpose of this section is to present the results of the rate study analysis to reflect the Utility's familiarity of tables developed in previous Water Rates Analysis Reports. • Bill Impacts - The purpose of this section is to present the bill impact of the new rates on the Utility's most common users. Monthly residential and commercial bills at the proposed rates are compared to monthly bills of surrounding utilities at various usage levels is also included in this section. CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 1-3 2. Financial Plan The purpose of this section is to summarize the Town of Oro Valley Water Utility's (the Utility) future Operating Fund revenue requirements, provide a 5-year projection of Operating Fund cash flows, and estimate debt service coverage (on a combined -funds basis). Structure of Funds The Utility manages three separate funds; the Operating Fund, the Alternative Water Resources Development Impact Fee (AWRDIF) Fund, and the Potable Water System Development Impact Fee (PWSDIF) Fund. Each fund is briefly discussed below: Operating Fund - The primary fund for the Utility which includes management of O&M and labor expenditures for the potable and reclaimed water systems, and non -growth capital expenditures related to the existing system. Revenue for this fund is generated through potable and reclaimed water sales, service fees and charges, investment income, and other miscellaneous revenue. AWRDIF Fund - This fund includes capital expenditures related to alternative water resource projects such as Central Arizona Project (CAP) and reclaimed water and the related debt service. Revenue generated from groundwater preservation fees (GPF) is transferred to this fund. Impact fees collected at the time new water meters are purchased and interest income on cash reserves is also accrued in this fund. • PWSDIF Fund - This fund includes capital expenditures related to expansion or growth projects for the potable water system and related debt service. Revenue for this fund is generated through impact fees collected when new water meters are purchased and through interest income on cash reserves. Revenue and expenses from each of the three funds are combined to calculate the Utility's debt service requirements according to Town policies and as stated in bond covenants. However, revenues and expenses from these funds are managed separately. Operating Fund revenue generated through water sales is projected based on the assumptions and analysis discussed in the following sections. The projected impact fee revenue generated for the AWRDIF and PWSDIF Funds are based on growth projections discussed herein and proposed impact fees discussed in the Oro Valley Water Utility Development Impact Fees Study report2. 2 CH2M HILL, Oro Valley Water Utility Development Impact Fees Study, October 2013. CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_11_07_13 2-1 General Assumptions The financial plan for the Operating Fund is based on the general assumptions provided in Table 2-1. TABLE 2.1 Operating Fund General Assumptions Description Unit Inflation for O&M Categories and Interest Labor and Benefits 3.5% General Inflation 2.0% Inflation plus Growth (5-year average) 4.0%' Electricity 14%2 Central Arizona Groundwater Replenishment Calculated District Interest Rate on Cash Reserves 0.5% Proposed Bond Terms Bond Period 20 years Issuance Costs 1 % of Principal Interest Rate 2.7% Debt Service Coverage Requirements Senior Lien Revenue Bonds 1.3 Excise Tax Backed Bonds 1.0 Number of Months Rates Effective 6 months Elasticity of Demand -0.20 Target Cash Reserve Balance No less than $3,000,000 'The average growth rate for the planning period is 2 percent. Annual Inflation plus Growth ranges from 3.6% to 4.2% due to the varying growth rate during the 5-year planning period. 2The electricity rate is expected to increase in July of FY 2013/14 and again in FY 2017/18 based upon the tariff currently proposed by TEP to the Arizona Corporation Commission. These assumptions are utilized in the analysis as described in following sections. Operating Fund Revenue Forecast The revenue forecast was based on analysis of the Utility's monthly billing data for FY 2009/10 through FY 2011/12 and a projection of water usage and growth in number of new connections. CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_11_07_13 2-2 The Utility anticipates the growth rate to continue to increase and provided the projected number of equivalent dwelling units (EDU) for the next 6 years. The projected annual growth in the number of EDUS is provided in Table 2-2. TABLE 2.2 Projected Annual Growth in Number of EMS Calendar Year 2013 2014 2015 2016 2017 2018 Projected Additional System EDUS 300 300 400 400 400 450 Allocation of EDUs to Customer Classes Residential 265 265 353 353 353 397 Commercial 26 26 35 35 35 39 Multifamily Residential 3 3 4 4 4 5 Irrigation 6 6 8 8 8 9 All Other Classes 0 0 0 0 0 0 Existing System EDUS 23,208 Total System EDUS 23,508 23,808 24,208 24,608 25,008 25,458 Annual growth is forecasted to increase from the current level of approximately 300 EDUS to 450 EDUS by the end of the forecast period. Projected additional system EDU's were allocated across all classes according to the distribution in the number of accounts by class. The detailed projection of water revenue under existing rates is provided in the attached Appendix A - Financial Plan Tables, Table A-1. Operations and Maintenance Expenses The Utility operations and maintenance (O&M) expenses were analyzed and projected for the financial plan period. O&M expenses include personnel, administration, production, and distribution expenses for both potable water and reclaimed water. Baseline O&M expenses were based on the Town Manager's FY 2013/14 budget and future O&M expenses were forecasted using the assumptions in Table 2-1. The Utility does not anticipate hiring additional personnel during the financial plan period, therefore, only an annual cost -of - living and merit increases (3.5 percent combined) were used to project future labor and benefits expenditures. In addition, annual regulatory assessments and water purchases from outside agencies are included in the annual O&M budget. The Utility purchases CAP water for recharge and for water wheeling through Tucson Water. The planned recharge rate for the forecast period is anticipated to increase from 7,000 AF to 9,000 AF. The Central Arizona Groundwater Replenishment District (CAGRD), Tucson Water Wheeling Costs, and CAP Recharge costs are also included in the O&M budget. These costs may vary from year-to-year and have been incorporated into the analysis based on figures provided by the Utility. CH210 HILL_FINAL DRAFT RATES ANALYSIS REPOR7_11 07_13 2-3 The complete O&M expense analysis is provided in Appendix A, Table A-2. Debt Service Annual debt obligations are met by the revenue generated in the three funds, the Operating Fund, the AWRDIF, and the PWSDIF. A summary of the existing debt allocated to each of these funds is provided in the Appendix A, Table A-3. The remaining outstanding principal balance for each fund as of the beginning of FY 2012/13 is listed in Table 2-3, below. TABLE 2.3 Remaining Outstanding Principal Balance as of FY 2012/13 Fund Outstanding Principal Balance Operating Fund $30,822,990 AWRDIF $12,967,610 PWSDIF $ 3,091.660 Total $46,882,260 Only the Operating Fund debt service was included in the analysis of revenue requirements (for potable and reclaimed rates). However, the combined debt service coverage for all funds was calculated using all sources of revenue; the debt service coverage ratio was calculated by dividing net revenue from all sources by the combined debt service from all three funds. Although the debt service coverage ratio is 1.3 for Senior Lien Loans and 1.0 for Excise Tax Loans (which are considered junior obligations) the Utility manages to a target 1.3 debt service coverage ratio for all loans. The Utility's calculation of debt service coverage is provided in the Preferred Financial Scenario proformas located in Appendix C. Debt service coverage and cash reserves are the two primary metrics that govern the determination of required revenues. Capital Outlay While O&M expenses cover day-to-day operations, the Utility incurs additional capital expenditures to replace existing water facilities. These non -growth -related capital expenditures (i.e., existing system improvements) are provided in Appendix A, Table A-4. Debt is planned to fund these future capital improvements in FY 2013/14 and FY 2015/16. New facilities for planned future growth are identified separately in a long-term CIP associated with the PWSDIF for expansion related water projects and the AWRDIF for alternative water projects. These growth related capital projects are not funded with Operating Fund revenue, and therefore are not considered in this analysis. CH2M HILL -FINAL DRAFT FATES ANALYSIS REPORT _11 07_13 2-4 Summary of Revenue Requirements A summary of the Operating Fund revenue requirements for the 5-year planning period is presented in Table 2-4. TABLE 2.4 Projection of Ooeratino Fund Revenue Reauirements FY 2013114 FY 2014/15 FY 2015/16 FY 2016117 FY 2017/18 Utility Expenditures $ $ $ $ $ Personnel 2,688,464 2,782,560 2,879,950 2,980,748 3,085,074 Operations & Maintenance 3,800,775 3,606,386 3,689,728 3,774,540 4,009,403 Groundwater Extinguishment Credits 405,000 405,000 405,000 - - CAP Wheeling Costs (includes TW + CAP water Costs) 718,065 718,065 918,065 962,512 962,512 CAP Recharge Costs 1,043,250 1,101,500 1,301,000 1,321,000 1,329,000 CAGRD Costs 150,000 285,000 359,000 - - Subtotal Expenditures 8,805,554 8,898,512 9,552,743 9,038,800 9,385,989 Debt Service 3,289,202 3,724,170 3,757,470 3,931,877 3,645,455 Capital Outlay 2,611,200 2,835,090 3,533,823 3,517,905 745,255 Total Expenditures 14,705,956 15,457,772 16,844,036 16,488,582 13,776,699 Cash Flow Analysis The 5-year financial plan was developed to meet the following objectives: • Revenues adjusted to meet annual revenue requirements, cash reserves, and debt service coverage requirements. • Debt issued to fund capital improvement according to the Utility's funding plans. • The ending cash balance in the Operating Fund maintained to meet the Utility's requirements and financial objectives. A summary of the annual revenue increases, debt issuances, and the operating fund balance is provided in the Financial Plan tables in Appendix A. The Financial Plan serves as the basis for the Cost of Service Analysis, Rate Design, and the Preferred Financial Scenario. Following the initial analysis of rate scenarios and discussions of the initial rate study results with its stakeholders, the Utility confirmed the basis of the Preferred Financial Scenario, which forms the foundation for recommended rates and cash flow summary as presented in Section 5: Preferred Financial Scenario. C112M HILL -FINAL DRAFT RATES ANALYSIS REPORT it 07 13 2-5 Development Impact Fee Funds Alternative Water Resources Development Impact Fee Fund The AWRDIF Funds may be used for capital expenditures related to alternative water resources including reclaimed water and CAP water. Revenue is generated for this fund through impact fees collected when a new water meter is purchased and from interest earned on cash balances. Also, the GPF, collected through the Operating Fund, is transferred to AWRDIF Fund for repayment of the outstanding debt for the reclaimed water delivery system and for future debt on the CAP water delivery system. Impact fee revenues projected for the planning period are based on the growth projections discussed in the Operating Fund section and using the proposed impact fee in the recent development impact fee report. The revenue generated by impact fees was added to the projected revenue generated by the GPF with no increase to the current GPF. The revenue requirements for this fund include the existing debt service, proposed CIP for alternative water projects, and repayment of funds to the Operating Fund. The projected revenue and revenue requirements for the 5-year planning period are presented in Appendix C, Table C-2. Potable Water System Development Impact Fee Fund The Potable Water Development Impact Fee (PWSDIF) Fund is used to fund capital water projects related to growth. These improvements include new potable water reservoirs, pump stations, water mains, and wells that are required to meet the demands of new customers. However, there are no capital projects scheduled for the 5-year planning period, so revenue generated in this fund will be used for existing debt service. The revenue sources for the PWSDIF Fund include impact fees collected when a new water meter is purchased and from interest earned on cash balances. An updated impact fee for this fund is discussed in the development impact fee report. Impact fee revenues projected for the planning period are based on the growth projections discussed in the Operating Fund section. The revenue requirements for this fund include existing debt and growth -related CIP projects. Since no additional capital improvements are planned for this fund over the next 5 years, the revenue will be used to pay down existing debt for previously constructed growth related projects. The projected cash flow for this fund is provided in Appendix C, Table C-3. 0112M HILL_FINAL DRAFT RATES ANALYSIS REPORT-1 107 13 2-6 3. Cost of Service The purpose of this section is to summarize the results of the Utility's cost of service analysis. The complete cost of service analysis, discussion, and tables were provided in separate technical memorandum, dated June 11, 2013. The base -extra capacity method described in American Water Works Association (AWWA) Manual M1 - Principles of water Rates, Fees, and Charges was used to allocate Oro Valley's water system costs. The AWWA Manual M1 defines base -extra capacity as the cost allocation method in which "costs of service are classified to the functional cost components of base, extra capacity, and customer costs."3 The fundamental principle used in developing an equitable rate structure is to distribute costs such that each customer class pays its proportionate share of the total system costs. Customers are grouped into reasonably homogeneous classes, and the cost of serving each class is calculated. Rates can then be developed to recover the cost of serving each customer class from the users within that class. Summary of Results The cost of service results supported a reduction in revenues derived from the commercial and master -metered multifamily customers, which would necessitate new customer classes. Using the new customer classifications, revenue under existing rates, calculated cost of service, and difference between the two is provided in Table 3-1. TABLE 3.1 Revenue and Cost of Service for Pr000sed Customer Classes Customer Class Revenue at Existing Rates $ Cost of Service $ Variance % Residential and Irrigation (combined) 8,892,828 9,182,740 3.3 Commercial and Master -Metered Multifamily (combined) 1,383,707 1,125,977 (18.6) Turf 109,251 178,030 63.0 Construction 161,898 60,937 (62.4) Reclaimed 1,451,555 1,451,555 (0.0) Total System 11,999,239 11,999,239 0.00 3 American Water Works Association (AWWA) Manual Ml —Principles of water Rates, Fees, and Charges. Fifth Edition, American Water Works Association, Page 51. CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11_0713 3-1 In order to achieve its cost of service, the new commercial and master -metered multifamily residential customer classes would require an 18.6 percent reduction in revenues generated from water rates while the residential and irrigation customer class would require a 3.3 percent increase. These results were a significant factor in recommending changes to the Utility's rates and rate structure in this study, as described in the following Section 4: Rate Design. While the difference in percentage terms between the turf and construction customer classes is relatively large, these classes are insignificant in terms of cost recovery, representing less than 2 percent of the Utility's revenue under existing rates. In addition, these classes exhibit somewhat offsetting results. Because of their relatively small size, unique customer characteristics4, and offsetting results, no rate structure changes were recommended for these classes. Based on the Utility's internal analysis, the reclaimed customer class is currently meeting its cost of service as reclaimed revenues are adequate to pay for reclaimed operations and maintenance, and renewal and replacement capital costs. 4 The construction class cost of service is likely understated as a result of the temporary demands these accounts place on the system. Additionally, these accounts do not pay impact fees to fund capital improvements needed to meet their demands. CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 32 4. Rate Design Introduction The purpose of this rate design section is to develop a schedule of proposed rates that recover system revenue requirements based on a number of factors, including customer class cost of service, ease of administration and implementation, and conservation orientation. The proposed rate structure includes a new uniform commodity rate for commercial and master -metered multifamily customers. The current rate structure was maintained for residential and irrigation customers (a four -tier commodity rate), turf customers (a uniform commodity rate equal to the Tier 1 residential rate), and potable -water construction customers (a uniform commodity rate equal to $1.00 more than the Tier 4 residential rate). Development of the recommended rate adjustments is described in the following sections. Assumptions The following assumptions were used in the water rates analysis: • The proposed rate restructuring (to uniform commercial and master -metered multifamily commodity rates) and rate increases are revenue neutral over the forecast period. • Proposed rate increases are levelized over the forecast period to avoid sudden shifts in water rates. • Operating Fund ending cash balances do not fall below the minimum cash reserve target of $3.0 million throughout the forecast period. • The rate adjustments consider the price elasticity of demand. An estimated price elasticity for Oro Valley was assumed to be approximately -0.2 (i.e., a 10 percent increase in price, resulted in approximately a 2 percent reduction in demand). • Rates developed for all FYs are assumed to be effective beginning in January of each FY. Existing Rates The existing Utility rate structure includes a base rate dependent on meter size, and a commodity rate for water usage. Residential, multifamily residential, commercial, and irrigation customer classes are charged the same tiered commodity rates for water usage that vary by meter size. Water usage for turf and reclaimed classes is assessed the Tier 1 rate and the potable construction water rate is $1.00 more than the Tier 4 commodity. Table 4-1 provides Oro Valley's current water rates. CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_11 W_13 4-1 TABLE 4.1 Oro Valley Existing Water Rates - Residential, Multifamily Residential, Commercial, and Irrigation Meter Size Base Rate Commodity Tier 1 $2.20 per 1,000 gallons Commodity Tier 2 $2.99 per 1,000 gallons Commodity Tier 3 $4.03 per 1,000 gallons Commodity Tier 4 $5.38 per 1,000 gallons 5/8 x 3/4 $14.19 0 - 7,000 7,001 - 16,000 16,001 - 32,000 Over 32,000 3/4 x 3/4 $21.29 0 - 10,000 10,001 - 24,000 24,001 - 48,000 Over 48,000 1 $35.48 0 - 17,000 17,001 - 40,000 40,001 - 80,000 Over 80,000 1.5 $70.95 0 - 35,000 35,001 -80,000 80,001 - 160,000 Over 160,000 2 $113.53 0 - 56,000 56,001 - 128,000 128,001 - 256,000 Over 256,000 3 $227.05 0 - 112,000 112,001 - 256,000 256,000 - 512,000 Over 512,000 4 $354.77 0-175,000 175,001 - 400,000 400,001 - 800,000 Over 800,000 6 $709.54 0 - 860,000 860,001 - 2,000,000 2,000,001 - 3,500,000 Over 3,500,000 8 $1,135.26 0 - 860,000 860,001 - 2,000,000 2,000,001 - 3,500,000 Over 3,500,000 Usage for the turf and reclaimed water customer classes is currently billed at the Tier 1 rate of $2.20/1,000 gallons. The potable water construction rate is equal to $1.00 greater than the Tier 4 rate, or $6.38/1,000 gallons. Rate Design and Proposed Rates The proposed rate design maintains a tiered structure for the residential and irrigation customer classes, transitions the commercial and master -metered multifamily customers into new customer classes with a uniform commodity rate, and maintains the uniform commodity rate for turf, construction, and reclaimed water customers. Base Rates The cost of service analysis indicated that base rates should remain the same when compared to current base rates. As such, the current base rates assessed to all customer classes remain the same in all years of the forecast period. The current and proposed base rates by meter size are listed in Table 4-1 above. Commodity Rates The block sizes, rate differential between tiers, and rate structure for each customer class were evaluated to develop the proposed commodity rates. Water usage block thresholds are unchanged for the proposed rate structure for the residential and irrigation customer classes. An analysis of the residential and irrigation usage indicated the current block structure for the residential and irrigation classes is currently achieving the Utility's cost recovery objectives. The distribution of the volume of water consumption between tiers for residential, irrigation and the two customer classes combined is provided in Table 4-2. CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_11_07_13 42 TABLE 4.2 Distribution of Residential and Irriqation Water Consumption — Percentage of Usaqe by Tier Meter Distribution of Residential Volume Distribution of Irrigation Volume Distribution of Residential and Irrigation Volume Size Tier 1 Tier 2 Tier 3 Tier 4 Tier 1 Tier 2 Tier 3 Tier 4 Tier 1 Tier 2 Tier 3 Tier 4 518" 66% 24% 8% 2% 27% 20% 19% 34% 65% 24% 8% 2% 3/4" 68% 26% 6% 1% 57% 31% 11% 2% 67% 26% 6% 1% 1" 68% 24% 7% 1% 38% 28% 21% 14% 58% 25% 11% 5% 11/2" 65% 35% 0% 0% 29% 24% 22% 24% 30% 24% 22% 24% 2" 100% 0% 0% 0% 28% 23% 24% 25% 28% 23% 24% 25% 3" 0% 0% 0% 0% 17% 20% 27% 36% 17% 20% 27% 36% 4" 0% 0% 0% 0% 20% 16% 23% 41% 20% 16% 23% 41% As demonstrated in the table above, the majority of residential water use occurred in the Tier 1 block (approximately 65 to 70 percent); approximately 25 percent in the Tier 2 block; and less than 10 percent and 5 percent in the Tier 3 and Tier 4 blocks, respectively. Irrigation water usage was roughly 25 percent per block (across all meter sizes). Therefore, proposed commodity rates maintain the current tier structure for residential and irrigation customer classes with a rate differential between tiers of 35 percent, which is the same as the current tier -differential. An analysis of the commercial and master -metered multifamily water usage indicated an inconstant and more random distribution between tiers and between meter sizes. The distribution of the volume of water consumption between tiers for commercial and master - metered multifamily customers is provided in Table 4-3. TABLE 4.3 Distribution of Commercial and Master -Metered Multifamily Water Consumption — Percentage of Usage by Tier Meter Distribution of Commercial Volume Distribution of Master -Metered Multifamily Volume Distribution of Commercial and Master -Metered Multifamily Volume Size Tier 1 Tier 2 Tier 3 Tier 4 Tier 1 Tier 2 Tier 3 Tier 4 Tier 1 Tier 2 Tier 3 Tier 4 5/8" 19% 12% 15% 54% 0% 0% 0% 0% 19% 12% 15% 54% 3/4" 81% 19% 0% 0% 0% 0% 0% 0% 81% 19% 0% 0% 1" 49% 21% 15% 15% 29% 26% 40% 5% 45% 22% 20% 13% 11/2" 53% 19% 14% 14% 76% 19% 4% 1% 63% 19% 9% 9% 2" 50% 27% 18% 5% 47% 26% 19% 8% 49% 26% 19% 6% 3" 41% 18% 18% 23% 0% 0% 0% 0% 41% 18% 18% 23% 4" 18% 21% 27% 34% 28% 36% 31% 5% 23% 27% 28% 22% 6" 53% 35% 12% 0% 0% 0% 0% 0% 53% 35% 12% 0% CH2M HiLLFINAL DRAFT RATES ANALYSIS REPORT 11 07_13 4-3 As demonstrated in the table above, commercial customers are using significantly more water in the upper tiers than other customer classes. Master -metered multifamily customers are also using more water in the Tier 2 and Tier 3 when compared to residential customers. These consumption patterns are likely contributing to the commercial and master -metered multifamily customers exceeding their cost of service. In addition, the more random distribution of consumption between meter sizes may introduce somewhat arbitrary cost recovery within a given customer class. The cost of service results together with the water consumption distribution analysis supports moving commercial and master -metered multifamily customers to new, uniform commodity rate for all consumption (equal to proposed residential Tier 1 commodity rate). It should be noted that patio homes, which were formerly classified as multifamily customers, are now included as residential customers in the proposed rate structure design. In keeping with Oro Valley's current policy, the potable water turf rate is equal to the Tier 1 residential commodity rate. There is only one customer in the turf classification, which is a golf course that is supplied from the potable water system due to the location and expense of construction to extend the reclaimed water system. Consistent with current policy, the proposed potable water construction rate is $1.00 more than the Tier 4 rate since construction water is provided through a temporary meter and no impact fees are collected. The Utility conducted an analysis of total operating expenses attributable to the reclaimed water system, which demonstrated that all reclaimed O&M expenses are currently met with revenues from reclaimed water rates. As a result, reclaimed rates increase more gradually than potable water rates, consistent with the Town of Oro Valley Water Policies. Proposed rates for the Preferred Financial Scenario 5-year forecast period are listed in Table 4-4. The rate increases in Table 4-4 vary from year to year in order to achieve the revenue requirements defined in Utility's financial plan. Rate increases in percentage terms will normally be slightly higher than the required revenue increases due to the elasticity of water demand (customers will reduce consumption due to an increase in price). The complete schedule of proposed base rates and commodity rates is provided in Appendix B. CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11 W_13 4-4 N roi M m ro ccl cl col N o _ M 0 o M !O M (p M M M (N N M V ul N M V h N N N (6 N M M 0 C0 M 0 0 0 � W N r <o m r m o r r r m M N O h N O N N N N N N N Cl V' h fV (h V N fV N fV fG N N O O Y N O O Y N N N V N N M V N N M V 0 N N N f0 N O m M M O W M M p p O M O N O) O M N 01 O M N N N M N N N V IN N N V � N N N 0 N E N y W y 41 N N N 0 d N 0 F FAg m E v o ° o H W E H C C �E Revenue calculated using the proposed commodity rates in Table 4-4 above, along with revenue generated from base rates satisfies the revenue requirements for the 5-year planning period. The projected revenue from the base rate and proposed commodity rates by customer class is provided in Table 4-5. TABLE 4.5 Projected Revenue at Proposed Rates FY 2012/13' FY 2013114 FY 2014/15 FY 2015/16 FY 2016/17 FY 2017/18 Customer Class (Dollars) (Dollars) (Dollars) (Dollars) (Dollars) (Dollars) Residential 4,566,073 4,590,059 4,668,366 4,753,674 4,816,682 4,853,076 Commercial 669,759 506,807 553,006 599,057 642,183 684,987 Multifamily Residential 237,674 182,390 187,746 193,075 197.528 201,800 Irrigation 916,175 923,202 941,725 960.550 974.712 983,858 Turf 104,639 103,741 103,612 103,475 102,891 101.553 Construction 95,375 94,615 94,573 94,314 93,649 92,435 Turf -Reclaimed 1,395,759 1,396,759 1,402,009 1,418,693 1,429,254 1,429,254 Irrigation -Reclaimed 4,368 4,368 4,388 4,440 4,473 4,473 Construction -Reclaimed 730 730 734 742 748 748 Sub -Total Commodity Revenue 7,990,552 7,801,672 7,956,146 8,128,019 8,262,120 8,352,183 Base Rate Revenue 4,008,686 4,088,101 4,194,247 4,300,393 4,406,538 4,526,117 Total Projected Revenue 11,999,238 11,889,773 12,150,394 12,428,412 12,668,658 12,878,300 Required Revenue' 11,999,238 12,022,642 12,144,394 12,403,832 12,628,369 12,851,268 % Difference Projected and Required Revenue 0.00% 1.12% -0.05% -0.20% -0.32% -0.21% 'Revenue projected at existing rates. 'Required Revenue as presented in the Financial Plan Section Projected revenues meet the revenue requirement over the 5-year forecast period, with the exception of the first year (FY 2013/14), following the rate restructuring. In the early years of the projections, where projected revenues fall short of the indicated revenue requirement, ending cash balances will be utilized to smooth the transition to higher water rates, while maintaining ending cash balances and debt service coverage requirements. Other Service Fees and Charges The new development hydraulic and design review fees and the new development construction inspection fees are proposed to increase to recover costs incurred to provide these services. The Utility is also proposing to increase the late payment fee. The current fee is a flat rate of $5.00. It is proposed to be $5.00 or 1 percent of the outstanding balance whichever is greater. These updated service fees and charges were developed by the Utility and are located in Appendix B. No change is proposed for the remaining service fees and charges. CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_11_OL13 4-6 Rate Considerations and Recommendations The proposed rate design includes a mix of new and existing rates and rate structures that recover system revenue requirements, achieve the Utility's implementation goals, and maintain an ongoing conservation orientation. The overarching rate design consideration was the modification of all rates, as appropriate, to move each customer class closer to its cost of service while avoiding sudden shifts in rates. The proposed residential and irrigation rate structure remains the same, as their combined revenue under the current structure effectively recovers their respective costs of service. Proposed residential and irrigation commodity rates increase approximately 1.5 percent over the next 3 years. Proposed base rates for all customer classes remain unchanged. Commercial and master -metered multifamily customers were moved into new customer classes with a new rate structure that reflects their lower cost of service (the combined revenue generated by these classes was approximately 30 percent greater than their cost of service). Commercial and master -metered customers were transitioned to a new, uniform commodity rate equal to the proposed Tier 1 residential rates, which more closely recovers their cost of service. The Utility's existing policy for turf and customers remains the same (i.e., the commodity rate equals the proposed Tier 1 residential rate). The reclaimed rate structure remains the same and the proposed reclaimed commodity rate remains the same in the first year of the forecast period, followed by gradual increases thereafter. The construction rate is consistent with current rates ($1.00 greater than the proposed Tier 4 residential rate). CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 47 5.Preferred Financial Scenario The Preferred Financial Scenario was developed to reflect the Utility's familiarity with tables from previous Water Rates Analysis Reports. The basis for the Preferred Financial Scenario and the underlying assumptions are described within the following sections. Proformas for the Preferred Financial Scenario can be found in Appendix C. In the development of the Preferred Financial Scenario, the goals were to ensure that all existing rate setting policies were met, to propose rate increases that would not result in rate shock, and to utilize cash reserves to fund capital projects and minimize future debt. WIFA loans to fund capital projects are included in the Preferred Financial Scenario in the amounts of $5.0 million in FY 2013/14 and $3.0 million in FY2015/16. Analysis of the Preferred Financial Scenario indicates cash reserves can be used to fund FY 2014/15 capital projects. Proceeds from the two WIFA loans are received over a 4-year period because loan proceeds are received only after the capital expenditures are made. Capital projects planned in the final 2 years of the planning period can be funded by cash reserves. The projected ending cash balance of the Operating Fund at the end of the 5-year analysis period is $3.4 million. The Preferred Financial Scenario also builds the cash balance of the AWRDIF Fund over the 5-year period. Building this cash balance will be important as the Town moves forward with increased deliveries of CAP water. The Preferred Financial Scenario financial projections for the PWSDIF Fund assume no new growth -related capital projects during the forecast period. Debt service for previously constructed growth -related facilities will continue to be paid from revenues collected from impact fees. Both the AWRDIF and PWSDIF were recently updated and revised and these proposed fees can be found in the Water Utility Development Impact Fees Study, dated October 2013. The projections for the Operating Fund, AWRDIF Fund, and the PWSDIF Fund were combined to evaluate the overall debt service coverage at the end of the FY. Analysis of the proposed rates presented in this report and the proposed impact fees discussed in the development impact fees report indicate the Utility will meet the debt service coverage requirement by the Oro Valley Mayor and Council Water Policies and Bond Covenants for all 5 years. CH2M HILL_FINAL DRAFT RATES ANALYSIS REPORT_11_07_13 51 Based on the analysis discussed in this report, the following changes to the rate structure are recommended: • Maintain the current tiered rate structure for Residential customer class and the Irrigation customer class. • Assess the Commercial customer class and the Master -Metered Multifamily customer class a uniform commodity rate equal to the Tier 1 Residential rate. • Maintain current Utility policies of setting the Turf rate as a uniform commodity rate and equal to the Tier 1 Residential rate. • Comply with current Utility policies of setting Reclaimed rates at a reduced rate. The reclaimed rates have no increase in FY 2013/14 but will have a gradual increase over the 5-year forecast period. • Maintain current Utility policy for Construction water rates of $1.00 greater than the Tier 4 Residential rate. • No increase required to the monthly base rate for potable or reclaimed water use. • No increase to the GPF for potable or reclaimed water use. • No change in the block thresholds for residential and irrigation classes. This Preferred Financial Scenario generates the revenue needed to maintain an adequate cash balance in all funds and meets the Utility's debt service coverage requirements. An analysis of the impact of the proposed water rates on single family residential and commercial customers is provided in the following Bill Impact section of this report. CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 5,2 6. Bill Impacts CH2M HILL analyzed the bill impact of the new rates on the Utility's most common users. All potable water users also pay a groundwater preservation fee (GPF) of $0.95 per 1,000 gallons, which is included in the monthly bill. There is no change proposed to the groundwater preservation fee. Preferred Financial Scenario Bill Impact The following section provides examples of the bill impacts on a residential customer and a commercial customer. Bill impacts for specific customer classes and individual meter sizes are provided in Appendix D. Residential rates and bill impacts for customers with a 5/8- x 3/4-inch meter are shown below in Table 6-1. The residential tier thresholds (7,000,16,000, and 32,000) are highlighted in yellow and the average consumption level (8,000 gallons) is highlighted in blue. TABLE 6.1 Residential Class Customer Bill Impacts (518- x 3/4-inch meter) Gallons Used Current Water Rate FY 2012/13 Proposed Water Rate FY 2013114 Groundwater Preservation Fee' Current Monthly Bill FY 2012113 Proposed Monthly Bill FY 2013/14 Amount of Increase Percent Increase 0 14.19 14.19 0.00 14.19 14.19 - 0.0% 1,000 16.39 16.42 0.95 17.34 17.37 0.03 0.2% 2,000 18.59 18.65 1.90 20.49 20.55 0.06 0.3% 3,000 20.79 20.88 2.85 23.64 23.73 0.09 0.4% 4,000 22.99 23.11 3.80 26.79 26.91 0.12 0.4% 5,000 25.19 25.34 4.75 29.94 30.09 0.15 0.5% 6,000 27.39 27.57 5.70 33.09 33.27 0.18 0.5% 7,000 29.59 29.80 6.65 36.24 36.45 0.21 0.6% 8,000 32.58 32.81 7.60 40.18 40.41 0.23 0.6% 9,000 35.57 35.82 8.55 44.12 44.37 0.25 0.6% 10,000 38.56 38.83 9.50 48.06 48.33 0.27 0.6% 11,000 41.55 41.84 10.45 52.00 52.29 0.29 0.6% 12,000 44.54 44.85 11.40 55.94 56.25 0.31 0.6% 13,000 47.53 47.86 12.35 59.88 60.21 0.33 0.6% 14,000 50.52 50.87 13.30 63.82 64.17 0.35 0.5% 15,000 53.51 53.88 14.25 67.76 68.13 0.37 0.5% 16,000 56.50 56.89 15.20 71.70 72.09 0.39 0.5% 20,000 72.62 73.17 19.00 91.62 92.17 0.55 0.5% 30,000 112.92 113.87 28.50 141.42 142.37 0.95 0.7% 32,000 120.98 122.01 30.40 151.38 152.41 1.03 0.7% 33,000 126.36 127.50 31.35 157.71 158.85 1.14 0.7% 'No proposed change in the GPF CHN HILL_FINAL DRAFT RATES ANALYSIS REPORT _11 07_13 6i1 The average residential customer's monthly bill will increase $0.23 - a 0.6 percent increase in their monthly bill under the proposed rates. Bill impacts are larger at higher consumption levels as a result of the increasing proportion of commodity rates to base rates. Commercial rates and bill impacts for customers with a 2-inch meter (the most common commercial meter size) are provided in Table 6-2. The 2-inch meter tier thresholds (56,000, 128,000, and 256,000) are highlighted in yellow and the 2-inch meter average consumption level (60,000 gallons) is highlighted in blue. Negative dollars are shown using parentheses and percentages using a minus sign (-). TABLE 6.2 Commercial Class Customer Bill Impacts (2-inch meter) Gallons Used Current Water Rate FY 2012/13 Proposed Water Rate FY 2013/14 Groundwater Preservation Fee' Current Monthly Bill FY 2012/13 Proposed Monthly Bill FY 2013/14 Amount of Increase (Decrease) Percent Increase 0 113.53 113.53 0.00 113.53 113.53 - 0.0% 10,000 135.53 135.83 9.50 145.03 145.33 0.30 0.2% 20,000 157.53 158.13 19.00 176.53 177.13 0.60 0.3% 30,000 179.53 180.43 28.50 208.03 208.93 0.90 0.4% 40,000 201.53 202.73 38.00 239.53 240.73 1.20 0.5% 50,000 223.53 225.03 47.50 271.03 272.53 1.50 0.6% 56,000 236.73 238.41 53.20 289.93 291.61 1,68 0.6% 60,000 248.69 247.33 57.00 305.69 304.33 (1.36) -0.4% 70,000 278.59 269.63 66.50 345.09 336.13 (8.96) -2.6% 80,000 308.49 291.93 76.00 384.49 367.93 (16.56) -4.3% 90,000 338.39 314.23 85.50 423.89 399.73 (24.16) -5.7% 100,000 368.29 336.53 95.00 463.29 431.53 (31.76) -6.9% 120,000 428.09 381.13 114.00 542.09 495.13 (46.96) -8.7% 128,000 452.01 398.97 121.60 573.61 520.57 (53.04) -9.2% 140,000 500.37 425.73 133.00 633.37 558.73 (74.64) -11.8% 160,000 580.97 470.33 152.00 732.97 622.33 (110.64) -15.1% 180,000 661.57 514.93 171.00 832.57 685.93 (146.64) -17.6% 200,000 742.17 559.53 190.00 932.17 749.53 (182.64) -19.6% 220,000 822.77 604.13 209.00 1,031.77 813.13 (218.64) -21.2% 240,000 903.37 648.73 228.00 1,131.37 876.73 (254.64) -22.5% 256,000 967.85 684.41 243.20 1,211.05 927.61 (283.44) -23.4% 260,000 989.37 693.33 247.00 1,236.37 940.33 (296,04) -23.9% 'No proposed change in the GPF CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT_11 97_13 62 The average (60,000 gallons) commercial customer's monthly bill will decrease $1.36, representing a 0.4 percent decrease in their monthly bill under the proposed rates. By moving toward cost of service rates, a 2-inch commercial customer using more than 58,000 gallons per month would see a reduction in their bill. This means that the effect of modifying the commercial rate structure is greater than the effect of the Tier 1 commodity rate increase for commercial customers using more than 58,000 gallons of water per month. It also means that commercial users will receive relatively lower bills while residential users receive somewhat higher bills under cost of service rates (as compared to current rates). Comparison to Surrounding Utilities This section compares the proposed rate update to current water rates of utilities in the region. The proposed water rates for a single family residential customer with a 5/8- x 3/4-inch water meter, which is the meter size for the majority of customers, is shown with residential water rates of surrounding utilities in Table 6-3. The table also includes rates for the same meter size. Tucson Water assesses commodity rates based on 100 cubic feet, or 748 gallons. As done in previous Water Rates Analysis Reports prepared by the Utility, the commodity rate for Tucson Water was converted to represent the charge for 1,000 gallons. TABLE 6.3 Comparison of Residential (518- x 3/4-inch Meter) Base and Commoditv Rates Water Provider Monthly Base Rate Tier 1 Cost Per 1,000 gallons Tier 2 Cost Per 1,000 gallons Tier 3 Cost Per 1,000 gallons Tier 4 Cost Per 1,000 gallons Oro Valley - Current 14.19 2.20 2.99 4.03 5.38 Oro Valley - Proposed 14.19 2.23 3.01 4.07 5.49 Tucson Water 9.68 1.73 3.59 9.20 14.79 Marana Water 15.12 2.46 3.43 4.46 5.50 Metro Water 20.00 2.00 2.70 4.21 5.62 As demonstrated from the table above, the proposed water rates are within the range of the utilities within the region. However, the number of tiers and volume of water within each tier varies by utility. So, comparison of raw base rates and commodity rates for the neighboring utilities is not as effective as comparing monthly bills for specific consumption levels. CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 6-3 Table 6-4 provides a better comparison of the proposed rates to the rates of the surrounding utilities with a calculation of the monthly bill at specific consumption levels. As noted in previous Oro Valley Water Rates Analysis Reports, these charges only reflect water use fees and specifically exclude taxes, charges for wastewater service, GPF, and similar renewable water resource fees charged by other water providers. TABLE 6.4 Residential (5/8- x 3/4-inch Meter) Monthly Bills at Varvino Levels of Water Use Water Provider Cost for 8,000 gallons Cost for 15,000 gallons Cost for 25,000 gallons Cost for 40,000 gallons Oro Valley - Current 32.58 53.51 92.77 164.02 Oro Valley - Proposed 32.81 53.88 93.52 165.93 Tucson Water 37.71 66.08 129.26 239.56 Marana Water 34.80 56.87 96.32 173.62 Metro Water 38.80 63.73 115.70 221.00 As demonstrated in the table above, the monthly bill calculated at the proposed rates for Oro Valley water customers with 5/8- x 3/4-inch meters continue to be less than the surrounding water providers for all water use levels. Since this study proposes a uniform commodity rate for commercial customers, a comparison of the proposed commercial customer Oro Valley rates with other regional providers was developed. The average commercial customer has a 2-inch meter; these rates are shown in Table 6-5. TABLE 6.5 Comparison of Commercial (2-inch Meter) Base and Commoditv Rates Tier 1 Cost Tier 2 Cost Tier 3 Cost Tier 4 Cost Monthly Per1,000 Per1,000 Per1,000 Per1,000 Water Provider Base Rate gallons gallons gallons gallons Oro Valley - Current 113.53 2.20 2.99 4.03 5.38 Oro Valley - Proposed 113.53 2.23 N/A N/A N/A Tucson Water 54.03 2.97 N/A N/A N/A Marana Water 46.44 3.03 N/A N/A N/A Metro Water 160.00 2.00 2.70 4.21 5.62 CH2M HILL FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 64 The proposed commercial rate for Oro Valley is less than the surrounding utilities' Tier 1 rate for all utilities except for Metro water. However, as with the residential comparison, an analysis of monthly bills for commercial account customers was performed to provide a better idea of how the proposed rates affect a commercial customer with a 2-inch meter at varying levels of water use. The comparison of monthly bills for commercial customers is shown in Table 6-6. TABLE 6.6 Commercial (2-inch Meter) Monthlv Bills at Varvina Levels of Water Use Water Utility Cost for 50,000 gallons Cost for 100,000 gallons Cost for 150,000 gallons Cost for 200,000 gallons Oro Valley — Current 223.53 368.29 540.67 742.17 Oro Valley— Proposed 225.03 336.53 448.03 559.53 Tucson Water 252.54 451.09 649.60 848.15 Marana Water 197.94 349.44 500.94 652.44 Metro Water 272.60 425.72 644.68 925.68 As demonstrated in the table above, the calculated bills for an Oro Valley 2-inch commercial customer is less than Tucson and Metro water customers, but greater than Marana Water customers for 50,000 gallons. The impact of the proposed rates for all meter sizes is located in Appendix D, along with the monthly bill amounts calculated in 1,000-gallon increments for the 5/8- x 3/4-inch meters and varying increments for larger meter sizes. CH2M HILL -FINAL DRAFT RATES ANALYSIS REPORT _11 07_13 6.5 7.Summary and Conclusions This report presents the analysis conducted by CH2M HILL to develop a new water rate structure and proposed water rates over a 5-year planning period. These proposed changes form the basis for the Preferred Financial Scenario. A financial plan for the Operating Fund was also developed to determine the revenue required over the 5-year planning period based on projected O&M expenses, CIP projects, and debt service. The results of the financial plan were used to analyze the cost of service for each customer class. Changes to the rate structure and the corresponding proposed commodity rate increases are intended to move the major customer classes closer to their cost of service. The rate structure modifications include maintaining the tiered structure for residential class and irrigation class. Modifications also include charging the commercial customer class and master -metered multifamily customer class a new, uniform commodity rate equal to the Tier 1 residential rate. There is no increase proposed in the first year of the study period for reclaimed water rates, but gradual increases to the reclaimed commodity rate are recommended in future years. The rate for Turf customers is equal to the Tier 1 residential rate, and Construction water rates are $1.00 greater than the Tier 4 commodity rate. The proposed rate structure complies with current Town policies. The changes to the rate structure and the proposed rate increases generate the revenue required to meet the required debt service coverage ratios and maintain the required minimum cash balance as set by Town policies for the 5-year planning period. A typical residential customer with a 5/8- x 3/4-inch meter and water usage of 8,000 gallons will experience a 0.6 percent increase in their monthly bill. A commercial customer with a 2-inch meter and water usage of 60,000 gallons will see a 0.4 percent decrease in their monthly bill. The proposed rate increases are within a similar range of the neighboring water utilities, when comparing the monthly bills for residential and commercial customers. New development hydraulic and design review fees and new development construction inspection fees are proposed to increase to recover the costs associated with providing the services. Additionally, late payment fees are proposed to increase from $5.00 to $5.00 or 1 percent of the outstanding balance, whichever is greater. No change is proposed for the remaining service fees and charges. CH2M HILL_FINAL DRAFT RATES ANALYSIS REPORT_11 07_13 7-1 APPENDIX A Financial Plan Tables LL n � N O 6 A C m c •N \ .+ a c LL 7 roi o ¢3 ooa c > O m « u o � N a LL U O a` o m w in v io ry m o� � in n m e in N in m a s v in w o V1 a1 W N Vt W n 4 tD rl • 0 ri ri .ti .-i .4 l0 N N CO N V1 N M O V1 O a M m a W w w in Vf 01 O N Vf V m O .-I n Ut vO1i m nw n 'i N t0 CO V M rl a N M 0 lD ✓1 ei e OJ N 01 m a CO lD VI N •'"! L i w m o ro is m n 1O rvm m te r". o m m w r°fi m o m I .a ri '-I •-I .-1 O .� N •i 'I N VI m in in m in m m v oo m in m .-i W W tp O tD tD N Ol .i W n tD n rl O1 •i rl N VF a76 a a E a a E E a s v v z E ¢ c E a c °+'' E O fO 'E c t c t ti v y a s 0 2 a 0 3 a E N a E « io E m 't c `t m e N u .10. > 5 U = I3 V H : U a C 10- K m V V1 w n w m 0 0 ti Q x O Q O1 N Of N f1 m N O W M O � O] N M b r ip m V1 N 10 N% l0 N b N IA Q Q 1p V1 N N mry bmm Q.i mmry mm egOH ry i�i+m n1pioo�n vel,o �vnio.tOi .h- wrv�v"i,a v� b e n m M m N o Q n m m ut N N� O V1 N ri N e R rl N n m O 01 ei N M 40 m m N S N N N W M eN4 b Q m •'I M O N M m O Q Vf N O Q Q M N N eMi N N H b N fl N .Ni pM Ilim O N b Omt Ol pm Vnl eQ1 IMl1 O M N N .'1 eNi 1 H O m M Q Q 01 m. N N W b N M n ei i I!r N e1 10 m I V W N n'1 N N � O I(1 CO foil N Q 6 N gIq mn vl �voiamo em mm n mom�m m b ti I/m�n vni Noo po vei [O N Q N N O M N N n Vl N OI O N Q W Qoe ti no n O O n n M n 10 p O O Vl Q N N O Ol LQ y VI e1 r p ei e1 (V fVl WIqN m N eti t0 m V W N fVl N fV O N m ,M,�' m 8N p O T N N O O p yp O p 8 yp O Iml1 C Vl M emi Vnl N ei n t0 40 'I ei N ei M � ONl 1bD O N lO M fV W V1 m O O lm0 N OJ N 4b/1 N M N O N N N em1 O N fO fV rl f0 W � V W N M N V O VI W Vl N g88g�888$8��8 8�S$8 88 8ryR mg$Lri LIL riomro � tin m mri .ti fd� v�"v ro rvfri N ri„o vinm in 8888oe88$8888gm8' o rn fnomvl mry N Hvipm.ti .d r`io ni fo e.e-r `� m N U w z 2 2 U z z ~ a O W & o o" G o w u w z uu a 0 o p co -m q6 a o o r J a a i a g w N $ z m ou 3 ou o� Q o f ¢ u o w m w m J g m z O O d z? u r n Q n r f 0 2 U' 2 O O 8 N 'i N N N p ry N O S (QfI pT p M M M yp N yp n Vl N N Ol N N O l0 lOD m � N t0 100 100 b t00 f0 40 400 400 l0 l0 100 100 100 N l00 l00 `o `o «o `0 0 `v 0 0 0 0 0 `o 0 0 0 0 0 0 0 0 0 A N N R N Fr! C C C C C C C C v W v v a v v i i i `v `w 0 `w U'a (O U'a Z eel N M Q 1!1 b N m OI M M eNi ei M 'I eb1 en1 em1 em1 N N N m �Lrm`n�88e e258E$No00 �rv.in �tini of d Wiry ri�o "vein m O m C a d W za U 3 Z f U Z a c W O W N a 6 W z aZ d a F a i w o a i z p}{ O c etJ = l'1 Ow W U Z O w z W a m g o z '^ w w w j z u i m 6 w o f O Yf N a f I- a e�E W O O a z O i�z s wry m tl� � o W a i a o d� r a i r o iI o o°1inn pn mmmo.im Q N e� Q rvmm O N N t00 b b 100 b � S � � S tOO 100 PO t00 tOO l00 0000000000000000 0 .W -Z m N N n O` N N N N N N N M M M M M M toll fnfl fmfl M O 0 0 N x n e N LL N S m-I W n (fN'1 tN0 M N e0i Iml1 8 ei N lO N O] fl l0 40 O N N rl l0 Q N W e W n Of n 'I �-1 m n N N N N Q N VI 'I N W N O m e ti N M M N N ei .i M� M N OI t0 W N W N� N N N O � O O� N Of tp N VI e Q 01 lO � VI � VI ei N N N N Q N O1 N W rl tO M M N � O1 W O p O n M OJ N VI N e1 VI N Q M Q ll N d' W VI p1 10 40 1p N N VI N N •'I N Q N VI rl N V N CO O m � V �'1 N M N O n W V ti O a 4D trvvl 'N1 40 W O W 1!1 M m N W O Ili $ O N O O N O V O O Q l0 o Q Im � N Vf m Q m olpn Ip olp$ � g g$$25o mn �mv mlrmimry omag a s vni vmo a n m ry Inrvrv.Ni n a I11 M N Ill '1 N V� O � W f�'1 '1 N fVl l�'1' N N ei W O W ei QN eQ1 p888 O pNp 8 801 8Q 8 810 Qm yONl pO pON pON O IOIN//�� pO QSa 4N0 Q N Vl fi N o O N O Q W (VI rl N R1 M N N N I E n- N M T t0 O n S O O N O§ y Ol -1 O N O N N O O OQl tOvl IOiI N O M O I m u z z w w '-' z z r z Y r wz_ O w c O N w fm G 0-2�c n f Ins E Oan s n W Z Z a Q 2 N J Q U N Z Q 2 VV1 7 Q 6 Z O Q O F Z O 7 w0 U O O w m f 0 i O J w0 U W 2 0 0 U' w0 u '�""v2i�zzml'^,� =z rc �'wk' a gZZ W Paz �gcz o z z w N a 0 0 m a a a a W d o o o i o ni c= a a' i o Il, u a w Yf x H m J Q i m Wa u w f °a r x F Q u H m a 0602� zj6=^S zNu rc WOQo O C o y 0O�ww�rUr ap i'�l�vnOig p No 550In S�z> R 2z z o ra o3 i� 0O i-" z ",�z ��,�OLL o z Q'r'W' Izo i LL $ 'o a E o z n LL $ 'o u u a g ,��, o i- a r i 0 z �, d o z LL tep o ti ry m m m m g g 0 0 o g o 0 0 o e o 0 0 0 0 o p m pp o pp nl top ry m m m m ep os yp ypQ O . . . m . . m . . . l0 10 O IO 40 tO tO tO O . . . . . b t0 IO 400 40 O l00 l00 lOO tOO N l0 �D l0 b o co_ o co 0 0 o co o ca co 0 o E E E co co co oc co o co 0 0 0 0 o .c... o 0 0 0 0 0 0 E c' E E c' E c c F F F m c c c c c c c c c c c c c c c c c c c c c c c c a a v _ _ N N u 2 K C R R R N A N N N N R N R R N N R N .. c c c c c c cv C c c c C u Y C C G C C C C C C C C C C C C C C i i Q O Q Q e Q Q Q Q IOII INII INII N N N N N Imll Imll N N ING 1p 1p tp V tnp tNp Imp n n n n n n n O O m a n Q a.y mom a on ory m.+mm.+w o.y a 01 � N� m M N n VI tO O pp Vl N O1 40 C„ m Ot V1 n m V1 Q O N m tO la Q m W Q O1 O O � O „ m e1 V M ei ei ei VI fVl m M rl N' Of � V rl tO ' O ei e'I O O M Q N M N m O N m m m tO m l0 C0 l0 N m Vl ti D] 1� m y� O m N 01 l0 Q m Q l0 O 10 10 m Q O D] M Q ei N M VI VI 01 O tC 'I Q IN rl ei ei V1 fv1 %W V1 N 01 O IV1 N m 'I 'I m n M e1 e1 O Of O N 1w0 h e N V On1 e1 v'I M m'1 n N 9 ei W rvm o.-i 'z .ti vi "'n m.Qi nq i of o (ri N IO V1 m e m m ' m l0 n N Ol lO n m m N W b m Vi m Q M m lO m n m N-i Of N N N m IR i e lO O1 4M VI N Q OI O M n O1 N N O N m n ti 0'M e1 O M 'I '1 O M n m eQi N d) Oi M O1 m`d � gis$ ng � $ggmn nSv�orvr���.ni o m e e e mom n.immm.-� �n .mi g ai a; rv,�.-i a ri .+ti drG�mrni n'o6 aim g S m E o a ry o �m g$ W$ w g n m g in � g of m m 'i r7 ri .y v v ni .6 le of ry rci m U U' z w U 6 w Q z J >� zz o z w a z ea eIImz f ¢ u a. >Oz p z p o p m w o G w p 0 0 m cL a z z H H W U W b a m a Q U Z 2 eL w o y 0 Q of z n a j a i U s z W a Ze O eif ¢ r a c c z z m U O z U' g mN < - w Z J z] u z 0 0_ n O�>dtou z r n �f=zz-tld�N O'O'O 4ep o.Ni ... m m m m mo3oo$00�� O N b b b b b N b b N N N. w w.. N {� 22e22222�#�55�5���i O O O O O O O O O O O O O O O 'aa + . . U' . . . U' . d d O O o O o O O O O O O O O O O O O O O O O « .« .2 .� _ _ _ _ m e p n n n W m W (O W w W W w w ael m m Om1 P ON1 P P ami T n e'I N m Q Ol Q Q Ol N 01 m m„ O VI Vl N O n m N O Vp M� O O b M VI t(1 � O m N Q VI w Q l0 O1 rl Q n n Q M (V 1 Q ^ W e1 N O N N rl 'I N .ti N N r VI Q Om n t0 M O N e m N m tO .a N N O Q OI O1 N N O O1 m m N V1 a VI m O M Vf N e N Of ei t0 ri N' O N N I e1 e1 N e4 N I N IA n IV1 N t0 er N n n le/1 m N VO1 N m O en9 d M O I N N N e fmM1 O N m .o v�N n a mm�n mom Qw.+e mmm.y 'I b n N 01 N N ei ei N .ti N fl N O l0 M n m H n e O N O. n m. 2 e N . n I 0 0 M m ti n m M Q 10 N Q IQ t0 O e tO N 01 M N m m N N Q m O1 N m e n tO t0 e fl C h N P N N e4 N e1 N Q t0 M VI �O n m g 1 o 25 ry g g g n It g g g$ m-e g N 1 . . . . . . . . . . . . . . . . . . .+� nrvm ry rv.i .i N MN e�N e.omry n mS g$m�$eo ng mogmv1pi voi v'�i So ei N ai N N e1 N ei Ivl 'I N Q N (VI O n W Z z z z 2 > z w z J w s„a f �a y m o z z m qio � wzp� mGao W 0 0 ,0 <F d z w� 6 W m m U N O w p Q z z F C z a d z> w m z c a r o 3 c s d< w m a d6m,n "J � NN�aO��zOYIm z w p w z z Oz upo on n O n m mU' x �' O z m mry o Q m.on o.+ .y wm.y a ern nm g o e w e o m w w w m L L L L L L S S a 22222222222222222� ." �. O O O O O O O O O O O O O O O O O✓ 'u V' U' U' U' U' l•J V' V' U' U' U' U' U' U' c Y Y . . . # # # # # # # # # # # # — G C C O C C G G G C G y d G o a o 0 0 0 0 0 0 0 o o Go GO GO o o v M ei M ei ei ei e1 e1 M e1 e1 e1 e1 et '1 H M M •1 M LL v 'I n N n lG H N ti tO pi � P W b W M [0 t0 G b O 01 n n O] n W O1 N O N O] N Of Of W Of M O m q n m 1� N N m N P N n N N P N N r'I W rl Ot P A N P m 40 N b W N P Ol rl N ti O1 n VI 40 VI M N m e4 h N IN � Of V V N N N '1 110� S n N (O .i mma o tO VI T M O M N lC N m M NN M 10 P �O OJ n W O N O] O N N N W m DJ N n y� O1 n n n N P n pp� N N N N O O OI n ei ei m fi O l0 O O W 40 Ip O N N N n O] INII � O p e.W .1 M O ri p1 I� VI l0 Il1 N N m ei 10 VI M O1 P P N N N e'I 00 'N�' N b OPf 10 N N O N W O N 'I Q W Ol O y� n n O b O O P O m 40 n m N m Q M N l0 M l0 M P m CO M 0] m W m O OJ OJ O 01 n N IDS N N N M O] O] „'I l Vl N V N N t0 �-I tom$ N P O M l0 m N m n 40 N M W W V V N N P n O P , N fi n N N O1 N l0 10 O1 w o n N n n to n oo m 10 Ill N O e1 ep1 e'I N N 01 Ol S N N N W VN1 l0 b r V .'i N N M n M N Om1 O N N OI � M N P lO .N4 O p N 1m0 P 40 O P N pp� tNO T O M lO N l0 Ill S S 10/1 S S S VO1 S S S N N N 40 N P N IG P rl y 8 8 8 888 O O DJ O O O I!1 O P 1011 888 8 N� 0 O N S pN V O m '1 N W Ww tp t0 VI N S BIONp SIr�oi8� a ego roi .+ nS drS ri gri n Swo S ogSgvoi .i vi wig � c v mri g�Se rv'i "odm� 1Oom S N n a e N Id vi ri u N Z u z i o N a M V d Y a d rta W i z Iui zx w'"� 3 ap W w c o S Q S o i m W o a o f a utp s a v i N i e6 x tv N n i i i i i F c f v e li Oi 2 N d d tb � Ni Y O pC[ a i rii p x 2' 'q'l03 wUz i=aa F i0 z i I�'dd0'O'm W N„v+N.m. Neon m o n mo.�ry Pm W N nmN g g$$$lNoo lNoo lMoo$ Imoo lmoo lmoo � g g�� e$l�oo l�oo l�oo lmoo o���leoo h�� 3 C L L L L L L t L L L t 0 0 0 0 0 o Z. o 0 0 0 0 0 0 0 0 0 0 0 0 0 � 1,.... �.... t.... m c c c c c c Ii c c c c c c c v o 0 0 0 0 0 0 0 0 o v o o co o co co co 0 0 0 0 o co co O N M p N IO n D] C1 ryO� .ryi� ryN� ry M� P N lC n t0 ryP� O rl N ryas yy N l0 n O] N .N1 eN1 „ N N N N N N N .i M e1 ei eM1 M .M1 .M1 M .1 M .PSI eP1 e1 .1 .P1 H M N N « a L F_ W g o o b N 0 " m m N 00 O w N O n V n m m n b 01 N a Q b {p n m m b b m O M N O M N n� b r1 n O N O N M b N N N n CI' W V m n O a CO ri b rl Q N N W O N N N N rl N N O N ei M 6 00 pp n n Q 8 N m w ' 0 0 N N N b N m O N O 0 Q b ei b Q N .y n N N Q W M ei N ei N N n M ti m m n d' b b O N N N O a \ a �/1 vi v1 O O tp O N M n ri ri O t0 O b p0 O Q T N O N Q Q b N Q ei N Q n O NNa �-f "'� rl l0 rl Q M N N 00 O ei' N N b M N b e-I m LL °. LT N u• b O O O Q N N N M n Q N n W N M N N W OJ M c1 ei W n ri N 01 l0 M N N n M N N d v1 N ri m m t0 l�1 N Q y Q Yf 6 A'1 di O IVI Vf N N L" b O rl O1 m e•I "I 01 O V Q b b Q a N N b N ei M' ei LL d V1 N t/1 O O O N N n m b N c0 M O .-i b W 0p O M O O ap b N �D m Q Q m m eel ea .y b N b ei a O O O Q b ei m n n W EO 00 Q N o0 M b 00 .Nl o m o v o e vi ca v o o rci 0 a A m m m m .+ N o Q N m m o 0 w N N b N n N O y N O O N a N N n OI N N Q M N N lO ei ei N N V g O o b m" '' m N N N N N b N N N N O Q m o O b N b w n oo vi n ro b N W m m N rl N m m w o m l0 b b m N N m m N b M M y O N m rl .ti 00 M N �4 N N 10 M b O m' cr O ti m N m 0 ei m m M N N n N N n N n N N 9 eI N M N b ei N M u m N N vn pp \ a O O O N m N y v1 N O ri v1 O b eti n W O N N Oi n N Q M m rl W M Q e4 m N N n b C' DJ q O 1I1 b n b m N u m d 9 a m M N n m N m M M N M M N M M N n m N 8 0 0 0 00 8 S 0 0 O O O 0 0 0 0 0 0 NC N N N N N N N N N N N N N N N N N N N Y J y' a N d 'V L N a a d O '.ai J vai vai J C J ? J vai V X X C y C C U J V x J Y W W J C C Q O O C C 4L C yj C C N O LL C' N w N 0 w N G V V N O 6 w N a W R w x 0 ' a 3 �a a m O a H 5 0 a C J Z 0 0 b a c a a e o e m m ri d e d m N im n n LL a NtiA .nia Qoa e m m� e Nro m C y N M N Q 6 r n N N �O d ON1 W W N y O w w O ei N M N LL d O W � a OI vNf N \ w N m eei Obi M m Q N Q LL O' w e N e O Yf O b 00 O N � LL m Vf ' b N O n M M tl1 O V1 �-1 N N LIl O O mi a m w in n m m a m \ W rl n V M n n N n N � G a G m oo o0 8 � $ g o o aCV N N N N N N N Y o e m w n m o m o b b o ri vi o Qi ro d v vi .: .i ri m ri 'i b b m w n n o 3 m Q m .+ m N .ti O1 O b V O 01 Oi O1 Oi NVf V1 �!1 n N b N N N 'i N .-I m ilf M M O m M M ri rl M .ti rl N N 0 00 V N O 4!1 N Q Q W N W O T 01 O d' Q eti ei N vt of of w N rl N ei v1 n N n M M O A M M M M M rl ri f!1 rl 'I Q Vl Ol M N 41 O b b Q Q M V1 L!1 Vf W N ey N '1 V1 n N b m m O M N M M N M M ei ei as uml ibit W W V N O W 001 Om1 ONi M N O O ri b Vf Ol m w Of O T M N O1 b n N tD N V1 rl n .-I M N M o M M M ri M ' i ei b O N ri C 'e M b Q ei Ol O O of ' e e N O Q O M of O n N N N b N ei m b N- w n m o M b m u+ e O W e1 .ti ri N l t0 O �/1 r, ei N I� OJ Di e w v1 O1 v1 w O w N .i N n b V1 at 'i M ei 0 0 o p np o ti m p mO wO N o o .N. W J J d O O C C O W C C Y d N N W O t C C V -av C C aum J �+ vai H N W O O O O w w w �`n n v`i w� i`n n N �`n v`� n n N C C uc 0 d N LL C O O C C O LL C G Vl p W y LL C O C O C 1 O N O NV 4 U> LL N u N N N N W W O o 1 N m e n w m o J N M M M M m M M M M M a e V V e V C' Q Q e N V1 N m N N N vl vl N b a x c n a 88888 88 88 888888888888888 8888 g vin oo�Sg $o via ooNrvrv8�88�58'8m8 NomS a_ m a 8 8 8 fN O y, 6 8 O r 00 08 `de pO p p p0 O O pQ 8 & 8 8 N Q 6 COO 8 OO Cm 8 8 1 8 8 ON a � V p00 8 pp0 O p0 0 � 101f N op0 O d N O t 6 vs ^' e N O N 8 .. 8 8 8 8 s .. 8 G O 9 n � � m N 8 O O O O M 10O VOI pO O S 1/O1 O pO O •'� � N �O N T N Y1 pp a N � } m 0 0 0 0 o v n c u o C u° N o r u g 0 3 m 3 3 E m `a n A e s t> o E p u c n u °13 Yn3>i m3 miwm p ir1O �.;3z�u"amzs aEt�iw v'i in ¢vvis a J Z �9 eNi e v � n N 9 e o u b 9 L o w �9 P ° d N Y d a n °� ^y a V � t m v e n 2 88888888 8-HUlg m $ N N vi N n n V 88. 88' 8 g a O O O l0 NO .. m ms8"8 888MA o vei � e �n ry m n UI „1 N N g v g o w o H f S S O O O 1 VOl f f p Is d m 6 N d d N W N O m O M 8 8 r W n N m N IV N .N-i .tOi .n 80818 a v A C ° E _ w E E E v o z E ¢ c_ m E � 0 E g WO e '° 6o E eD E m c E v o $ m E w s ms, a v u E >> vt m s m `a & ° ° v u E E E > > o 2 a 5 e6 o m .. .. o o iza u¢�ti vvi vui°m°rccm q ry m m m m m m m m m m v e d a a e a v N C r. a a n LL M M N N I I I N !!1 N 1/p1 N N MN O A O~ p p b P V V1 10 O N N O O N N W N 8 O N t011 P rlr 'IT 1I " O �Pp O W �Ny V C N N 66 m V O M l0 V P OJ O M O tN+l tPvl N 1� N N m 4b0 N V1 N O 4p IVI 4A V O fl �-1 m M 2 N NI fV1 e1 N � lO N b N IVI N b N m O O b V N O O W fVml ti N M m W N OV1 N M a o m m ry a vt°i N b P b .Ni ry o P .+ 0 o vai a e m m o .i � of ni 1 i rni m �+i 14. C Ji u °1 - y a u u i C S c j O d W w K c v — �n a y= E N m A v< c it¢ C u c vvi y° y E v b .''" u n o v c n y Up � m v E '^o o� a z Q r 0 2 o w vui w a` lo- Z O e1 N M V N b I� M P e0i eNi �rv-I M edi P-I b-I e^i emi ePi N 0 0 0 APPENDIX B Service Fees ORO VALLEY WATER UTILITY RATE SCHEDULE BASE RATES AND COMMODITY RATES FY 2012113 FY 2013114 FY 2014115 FY 2015/16 FY 2016117 FY 2017118 All Customer Classes Base Rate Base Rate Base Rate Base Rate Base Rate Base Rate (monthly) (monthly) (monthly) (monthly) (monthly) (monthly) Meter Size (inches) Current Proposed 5/8 x 3/4 $14.19 14.19 14.19 14.19 14.19 14.19 3/4 x 3/4 $21.29 21.29 21.29 21.29 21.29 21.29 1 $35.48 35.48 35.48 35.48 35.48 35.48 1.5 $70.95 70.95 70.95 70.95 70.95 70.95 2 $113.53 113.53 113.53 113.53 113.53 113.53 3 $227.05 227.05 227.05 227.05 227.05 227.05 4 $354.77 354.77 354.77 354.77 354.77 354.77 6 $709.54 709.54 709.54 709.54 709.54 709.54 8 $1,135.26 1,135.26 1,135.26 1,135.26 1,135.26 1,135.26 FY 2012113 FY 2013114 FY 2014/15 FY 2015116 FY 2016117 FY 2017118 Customer Class Commodity Rate Commodity Rate Commodity Rate Commodity Rate Commodity Rate Commodity Rate ($/1,000 gallon) ($/1,000 gallon) ($11,000 gallon) ($11,000 gallon) ($/1,000 gallon) ($/1,000 gallon) Proposed Current Residential Tier 1 2.20 2.23 2.27 2.30 2.30 2.30 Tier 2.99 3.01 3.06 3.11 3.11 3.11 Tier 4.03 4.07 4.13 4.19 4.19 4.19 Tier 5.38 5.49 5.58 5.66 5.66 5.66 Irrigation Tier 1 2.20 2.23 2.27 2.30 2.30 2.30 Tier 2.99 3.01 3.06 3.11 3.11 3.11 Tier 3 4.03 4.07 4.13 4.19 4.19 4.19 Tier 5.38 5.49 5.58 5.66 6,66 5.66 Commercial 2.20 2.23 2.27 2.30 2.30 2.30 Master -Metered Multifamily 2.20 2.23 2.27 2.30 2.30 2.30 Turf 2.20 2.23 2.27 2.30 2.30 2.30 Construction 6.38 6.49 6.58 6.66 6.66 6.66 All Reclaimed Classes 2.20 2.20 2.23 2.27 2.27 2.27 Existing Commercial and Multifamily Tier i rate, Appendix B Rate Schedule for Base Rates and Commodity Rates Page 1 of 1 ORO VALLEY WATER UTILITY RATE SCHEDULE SERVICE FEES AND CHARGES New Development Hydraulic & Design Review Fees Hydaulic Review Design Review Base Sheet $170.00 $255.00 Each Add'[ Sheet $42.00 $42.00 Plan Revision N/A $42.00 Each Fees include 2 hydraulic reviews and 2 design reviews. Additonal reviews to be $85.00 per review. Fees to be collected prior to receipt of approved plans. New Development Construction Inspection Fees For 0 - 500 feet: $1,555.00 For inspections exceeding 500 feet: $1,555.00 + $1.50 per foot Repeat Pressure Test $95.00 per test Repeat Bacteria Test $85.00 per test Fees will be collected prior to project acceptance. For inspection services during other than normal working hours, this amount will be charged in addition to above fees: Labor Costs + 30% Benefits Late Payment Fee $5.00 or 1% of the outstanding balance owed whichever is greater. Appendix B Rate Schedule for Service Fees and Charges 1 of 1 APPENDIX C Preferred Financial Scenario N N n rl '9 M 1Il O] VI N .i ei w Ot n W N Q rl n n M O l0 .i S M O M ID O OI M M Ill ff m O W t 0 rl�A 00 Lr�w N OI cli0 M m m 01 o rl Q Q M w M 0] N O n Mmv t m m m Mm vlNfl 0 fV M m m lO Oo M M mM m '-I rli N 'j O }N LL Q Q e'I 1D V1 O1 M CO N Of N n b Vf O Vf � n M M 1I1 W � CO I� 01 N Q M O Ol N ri tll p1 Q N m n N n M '-I t•I fi tp w N mm V1 Nv N ffl N ID m ll N N m O1 M ri l0 N pJ O N Vf N iI! V! N O O N N m 0 m N .i t0 m O rl O v1 O O m M m m M MIn Y1 n N WwN SO.-lI WQ.i mQl NNQ wN N m1 m 0 O1 WO o�-1 0oO1 .NDi .NOy Mpe n rl O rl O V1 N n n O Ol Ol Q Q M M Yl N Q m m m Q OI m M� M m m N O yN LL in N N YI N O n n n Q N O Ill vl N M n O vl Ill O .i .I N N M t0 ID N N N m n ti .i M N IO N S w O S M m 10 ID Q v1 Ol Gl m N rlI rl Ill 06 0 0 vl O 0l 'I m m 0 C yl N N' I� O D? N N O1 N M M N W V1 Op ri Lr W 01 h n n Y a l.{ O1 OI Il1 N Ol rl N a Q M m m Q O ti O m rl N Vl N ei l0 1p Q rl N N M V1 N Q Ill ll n Q n I l N t0 b m m m M � N' N rN 6 � 9 > O � mminm vo oln .-I �r lnn mm In N.i In ry eti O y N N VI n N 0l N m N vl m Q Ot O O N O N OI m m m w ro ro ri of of 06 Ic ai ri Ic Is ro o vi ro ni o oc ni ai ai M O � N mmvlm to �-+w Q Q Q m moo o.. a vl m In mmm a Qvm rvm vlrvQ m wmano'. In In mmm a M O O ti ei N (r1 Vj N N rl N O �'1 O'i rl el 'I 'I t•1 N Y LL O U W aai ^d 3 g a z 22 c LL u OF c q 0 o m a w q ? a n h c o c Iu => 44 3 d 5 c o x Z ra a s 1p `a m M" a o s n w n o71 y c m« o a 0 N a o a 3 a v •' LL c 0 O e 0 3 s u o a o d n c E °.Em ccy� .d. m cL� span 'Ls0 a«« s 3 O m>> `O t uaaugd0° ah CY1717 0a00 lm7 ucdsOd 1212 V O n 1p O T m N N n ti n R M rl N N Ill O It1 N M L!1 rl M O V M a0 n ti p N b O1 b M O N vi O pt n Yf N p1 m V' Ill Ill Ill m Il1 � V' .m.. rl m N n '+ rci ni rci H 0 yN LL V! N N VT UT .-i rI b O b M n Yf ei O N ei 'i �-f 01 M N e-I O n O b O N b vt m pZ N O of m of ri pi O �O I� t-1 n O Vi pm i V1 M n N Ill Ill Ill m Il1 M '1 ei N 01 W rl PI N rl N rl Ill Ill p1 b O m V1 �-I V O }N LL .+noommo m �e n�c ry .arvmry mmn N m g m.-I ry rvinma.i a m .� o I�.+In b o0 N op O pi 00 n M N v1 01 O N m rl N v1 v1 v1 b n w M O N n co OI ei N e4 of M n ll ri ri M re; .m.`. N V �'1 O )N LL N N N M! YF O ei b W O N pl O O b M b n m w o m � a N 1l1 O N W V N N V1 n I� O1 C M Ill vt Il1 m C N M m N V b n ,0 � M N N N ti Ill m n m O O OI R O C V) M ri ri I+f N .N.•. ri of ri R � O LL !? N CY C uY. A � C p, a M b N N IA p O O O O M O N N N In W c; O O N pr O M N O O ei O pf 'I ri N p1 I� ` C �p Il1 01 V1 m N rl Vf N n m V O N N V/A N 1A H E d d u > d d C a p o $minn .rvi °' O W m y m 15 a n N N N O C Z i W O m O C o rvo d d> E E m E m y W W W m o emti 1/f J G a LL c O 6 m d C m 00 c V c acf z3za`rp 'c4 z 9 mzl.`I 0 N V O 16 vi )N LL 1/� N 25 o Lq -v o o v M N W N h e e op O O N N N Np eel M � OOt l0 MM Ie e`6N t0 V O IO V1 O N N d etl ei O O M M O I� M O N m m O n V b W O I� O IG N N N q Om O O W Om o 4ap N b m rl �i N N T W N V N 'p d O vYi V � u a t9 c � c - m 6 d a d 3 vo C j O V E W O C E K O d' W ly C O d L m W d Ip O L V m O N O N W N (p N z¢ 0 I°- 0 O u cg z r a a v a m O N M N O a n b M m O Im 8 N O N m e0i n Vf � N ID W N W lO em�l M PI PVmf ri v 0 0 e b b b n n b o b b O O V Q Q Q N N Q N Q b vl Vf .i b I -I ei lO b rl M e-1 b �y O O ry M M M M M M M M b N LL V� N N N LL VI V! N VT N N S V1 N Yf N b' b N v1 vt O pO O O M M M M O�1 T M N M iNit N Q d of O' M M �i Of tv1 Oi M N Iy O N N M M N N MINI M M � W m OJ b 1p M M b b b M H rl 'I Iy 1� rl Ol }N LL N N N +It N N Vl V! h h H O c0 M 0a I� ' N O O O o O 01 C1 Cf O N I� Q N Q O 01 N OI .I 9 C b N b O O .ti '1 O W O OI W ry W Imo w M b O b LL N ei ei ImN ei w tO .ti I� a N LLy V LL O• O 7= O O Q Q Q V o v Q Q Q h Q N 6o6.6 a6 N N N N N N au N M N b V jp O 'U \ W 00 a0 b b M M b Q b 0 m LL a OJT N hN N N N N N N NVi Vf g O m m m m m m w m w 3 0 'T Id Id d aa s ai H 0 b b ri ri N b N N N N M N M T m V m m m Q � N O Y a LL a C a > a � N N c C LL a y y w N d` o n m r�o O v W x W c Z u a a O m c da. N E m !L OV O N W 1a p U m V V U m o n o E« m e n u 0 O o O 6 L W N N« C M p 0 Z W Y 2 0 m W 0 W W d C m o O F O z F O z d O u F Z m Z W w 0 Q V LL Of w m M O w O O n w M W R M N O �U M N N N m M w W n W n M m m m O m n N m N O O m W W n n W M m Ow 00 w 0 m N n N N A n w P�1 O m MI of W n V O N O N N O of vl N Oi Oi ei M M N m M m w r n V M W YI m m m w n M w C N W w W N ON 00 m m NH N m N m m O '-i N M ti N .i M Oi M f+l ri N ei N r1 M M M '1 M n N of m N O W O O O n M M D] N ry O b N W C'vt ttpp n p M m N N O O m N O O MO N N aa C V O M O n w m 0 m C M m M 4O m M M w O m W d V M N N O O N lA p1 v d a W m M M C W M N V M O M e1 M m m w lO n O M v lD 00 n N n m M N W m m l0 M wW m m ei CO n f�l' O W W N O O g g N m w c m m o 0 0 0 0 Q O O O epi N N M nip N ri vie gcco ri M d o mm vi roam �v ice g m MMNVM W n M n W m W w n m N n M n M O M o m a W W V m M M w N M n W n W N O N � M e e-1 ryj � N N rl N n N m n O N 0 0 M w n M O m O vt 0 0 H M N N m Wm m m MNWN M W m m COONN CONON m w WNOWOOMW of m 0 0 m 0 m M w W w v W O N g N n W Y6 N N N W ll W'i ll W C r. ri w n m w N O WvOO WMm M m VV N N N W V M m N m 0 W N8 pi m w N b pNpp N N M M u m m O NOW A O V O n V m O O NON w m w W w N W W rog g .6ro 6 .6 ju d of olf .6 f oroM ui ei nC MOH n O M m m o W W w o M m W m m m m a ry O n a m a VT N N N N N O U N a a 3 a E a a Y W U a z N a c u ^ LL LL w y y w n c w o w o N T_ a w LL n a n q c o e w N fL 6 a N m C o Q a C p W 3 c o �'a^mao°'a3py' «c0 n e�coct�u�oaoya d�o0ov0�s�n`acFo W W4T C 3 R 0 F- a (7 O o Q= o C 1- 0 6 aQa�Q7coodnoo a O �i U a U U H i2 O 0 1- a U x Q u M ei N N N O N Ol O a m CO M N N N N O N ei Vf O O N v1 O 01 n Y1 O V N N N v1 Yf S N O Q N 4!1 Vf W V1 Q N n Ol ri N rl N v) b M O 01 M M M m M n M V n Q N M W M d N N N N N N Vf b b nWv6 O p0hN1 oWvrtl .vrtiit mNi cNri .Nbti rl� oON n0N1 o vNt NM bO Mp� CG Q 1 M M M b m b ei 00 N N N N N N H ti n O O m m O ay ti N n' n M m O M R 'ct b rl N M N 01 b n V N N N V1 W O Q O Vf YI M n V n Q O N O N b N O ry ai N 00' O O� w � ri O V a r-I e4 M M O N VI 111 ll1 M n N N n 01 M M pp m S M V M O M M M Q Q OI N M rl ei N 1 M M N N N N N N N N Q N a0 W n Q WN bn Mp Om OO O N V O N W Q O N 14' n i oSm OmooQ b w N M m M NHN♦Omn mO mM M O N N ryj V N N N N N 1n b of N O W O N a' CO M' M P O O O pQp N gm aVcy� ' vbf W W I S N O W m O S N b t+1 N O O ri O O� O Oi m Oi tO m N b NO ri O ei N t0 ei O O l0 Vt Ol Vl 00 1l1 pp N vt m o n m N m N m m m ti b Ol O n Q O b '+ ni '+ .i a ri rvi N N vl m � S � og ca a ap O 6 V z a) CO C _m oa a `a E E •L 1] 1I1 j O C F U V C V tia.� Jti aSS ° W N c a S eo$ E ' w w w a s a d N y LL U aci in H n v`f a p a 'So o aH Ea vaiv « u LL n m" n m a n u y y w° o a a cl ° `w o O z z 3 rr a H O¢¢ rL Ho ° K rL F-o 0 rl 0 w O b -. APPENDIX D Bill Impacts RESIDENTIAL & IRRIGATION CUSTOMER BILL IMPACT WITH 5/8" X 3/4" METER BASE RATE 14.19 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNT OF INCREASE GPF TOTAL MONTHLY INCREASE/ DECREASE TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 14.19 14.19 0.0% 0.00 14.19 0.0 1,000 16.39 16.42 0.03 0.2% 0.95 0.95 0.00 0.03 17.37 0.2% 2,000 18.59 18.65 0.06 0.3% 1.90 1.90 0.00 0.06 20.55 0.3% 3,000 20.79 20.88 0.09 0.4 % 2.85 2.85 0.00 0.09 23.73 0.4 % 4,000 22.99 23.11 0.12 0.5% 3.80 3.80 0.00 0.12 26.91 0.4 % 5,000 25.19 25.34 0.15 0.6% 4.75 4.75 0.00 0.15 30.09 0.5% 6,000 27.39 27.57 0.18 0.7% 5.70 5.70 0.00 0.18 33.27 0.5% 7,000 29.59 1 29.80 0.21 0.7% 6.65 6.65 0.00 0.21 36.45 0.6% 8,000 32.581 32.81 0.23 0.7% 7.60 7.60 0.00 0.23 40.41 0.6% 9,000 35.571 35.82 0.25 0.7% 8.55 8.55 0.00 0.25 44.37 0.6% 10,000 38.56 1 38.83 0.27 0.7% 9.50 9.50 0.00 0.27 48.33 0.6% 11,000 41.55 1 41.84 0.29 0.7% 10.45 10.45 0.00 0.29 52.29 0.6% 12,000 44.54 1 44.85 0.31 0.7% 11.40 11.40 0.00 0.31 56.25 0.6% 13,000 47.53 1 47.86 0.33 01%. 12.35 12.35 0.00 0.33 60.21 0.6% 14,000 50.52 1 50.87 0.35 0.7% 13.30 13.30 0.00 0.35 64.17 0.5% 15,000 53.51 1 53.88 0.37 0.7% 14.25 14.25 0.00 0.37 68.13 0.5% 16,000 56.50 1 56.89 0.39 0.7% 15.20 15.20 0.00 0.39 72.09 1 0.5% 17,000 60.53 60.96 0.431 0.7% 16.15 1 16.15 0.001 0.43 77.11 0.6% 18,000 64.56 65.03 0.47 0.7% 17.10 17.10 0.001 0.47 82.13 0.6% 19,000 68.59 69.10 0.51 0.7% 18.05 18.05 0.00 0.51 87.15 0.6% 20,000 72.62 73.17 0.55 0.8% 19.00 19.00 0.00 0.55 92.17 0.6 % 21,000 76.65 77.24 0.59 0.8% 19.95 19.95 0.00 0.59 97.19 0.6% 22,000 80.68 81.31 0.63 0.8% 20.90 20.90 0.00 0.63 102.21 0.6% 23,000 84.71 85.38 0.67 0.8% 21.85 21.85 0.00 0.67 107.23 0.6% 24,000 88.74 89.45 0.71 0.8% 22.80 22.80 0.00 0.71 112.25 0.6% 25,000 92.77 93.52 0.75 0.8% 23.75 23.75 0.00 0.75 117.27 0.6% 26,000 1 96.80 97.59 0.79 0.8% 24.70 24.70 0.00 0.79 122.29 0.7% 27,000 100.83 1 101.66 0.83 0.8% 25.65 25.65 0.00 0.83 127.31 1 0.7% 28,000 104.86 1 105.73 0.87 1 0.8% 26.60 1 26.60 0.00 0.87 132.33 0.7% 29,000 108.89 1 109.80 0.91 1 0.8% 27.55 27.55 0.001 0.91 137.35 0.7% 30,000 112.921 113.87 0,951 0.8% 28.50 28.50 0.00 0.95 142.37 0.7% 31,000 116.951 117.94 0.99 0.8% 29.45 29.45 0.00 0.99 147.39 0.7% 32,000 120.98 122.01 1.03 0.9% 30.40 30.40 0.00 1.03 152.41 0.7% 33,000 126.36 127.50 1.14 0.9% 31.35 31.35 0.00 1.14 158.85 0.7% 34,000 131.74 132.99 1.25 0.9% 32.30 32.30 0.00 1.25 165.29 0.8% 35,000 137.12 138.48 1.36 1.0% 33.25 33.25 0.00 1.36 171.73 0.8% 36,000 142.50 143.97 1.47 1.0% 34.20 34.20 0.00 1.47 178.17 0.8% 37,000 147.88 149.46 1.58 1.1% 35.15 35.15 0.00 1.58 184.61 0.9% 38,000 153.26 154.95 1.69 1.1% 36.10 36.10 0.00 1.69 191.05 1 0.9% 39,000 158.64 160.44 1.80 1.1% 37.05 1 37.05 0.00 1.80 197.49 0.9% 40,000 164,02 165.93 1.91 1.2% 38.00 38.00 0.001 1.91 203.93 0.9% 41,000 169.40 171.42 2.02 1 1.2% 38.95 38.95 0.00 2.02 210.37 1.0% 42,000 174.78 176.91 2.13 1.2% 39.90 39.90 0.00 2.13 216.81 1.0% 43,000 180.16 182.40 2.24 1.2% 40.85 40.85 0.00 2.24 223.25 1.0 % 44,000 185.54 187.89 2.35 1.3% 41.80 41.80 0.00 2.35 229.69 1.0% 45,000 190.92 193.38 2.46 1.3% 42.75 42.75 0.00 2.46 236.13 1.1% 46,000 196.30 198.87 2.57 1.3% 43.70 43.70 0.00 2.57 242.57 1.1% 47,000 201.68 204.36 2.68 1.3% 44.65 44.65 0.00 2.68 249.01 1.1% 48,000 207.06 209.85 2.79 1.3% 45.60 45.60 0.00 2.79 255.45 1.1% 49,000 212.44 215.34 2.90 1.4% 46.55 46.55 0.00 2.90 1 261.89 1.1 50,000 217.82 220.83 3.01 1.4% 47.50 47.50 0.00 3.01 268.33 1.1% 51,000 223.20 226.32 3.12 1.4% 48.45 48.45 0.00 3.12 274.77 1.1% 52,000 228.58 1 231.81 3.231 1.4% 49.40 49.40 0.00 3.23 281.21 1.2% 53,000 233.96 1 237.30 3.34 1.4% 50.35 50.35 0.00 3.34 287.65 1.2% 54,000 239.341 242.79 3.45 1.4% 51.30 51.30 0.00 3.45 294.09 1.2% 55,000 244.72 248.28 3.56 1.5% 52.25 52.25 0.00 3.56 300.53 1.2% 56,000 250.10 253.77 3.67 1.5% 53.20 53.20 0.00 3.67 306.97 1.2% 57,000 255.48 259.26 3.78 1.5% 54.15 54.15 0.00 3.78 313.41 1.2% 58,000 260.86 264.75 3.89 1.5% 55.10 55.10 0.00 3.89 319.85 1.2% 59,000 266.24 270.24 4.00 1.5% 56.05 56.05 0.00 4.00 326.29 1.2% 60,000 271.62 275.73 4.11 1.5% 57.00 57.00 0.00 4.11 332.73 1.3% 61,000 277.00 281.22 4.22 1.5% 57.95 57.95 0.00 4.22 1 339.171 1.3% 62,000 282.38 286.71 4.33 1.5%1 58.90 1 58.90 1 0.001 4.33 1 345.61 1 1.3% 63,000 287.76 292.20 4.441 1.5%1 59.85 1 59.85 1 0.001 4.441 352.05 1 1.3% Appendix D Monthly Charges and Percent Increase Comparison 1 of 17 RESIDENTIAL & IRRIGATION CUSTOMER BILL IMPACT WITH 3/4" X 3/4" METER BASE RATE 21.29 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNT OF INCREASE OFF TOTAL MONTHLY INCREASE/ DECREASE) TOTAL AMOUNT OF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 21.29 21.29 0.0% 0.00 21.29 0.0% 1,000 23.49 23.52 0.03 0.1% 0.95 0.95 0.00 0.03 24.47 0.1 % 2,000 25.69 25.75 0.06 0.2% 1.90 1.90 0.00 0.06 2T65 0.2% 3,000 27.89 27.98 0.09 0.3 % 2.85 2.85 0.00 0.09 30.83 0.3 % 4,000 30.09 30.21 0.12 0.4% 3.80 3.80 0.00 0.12 34.01 0.4% 5,000 32.29 32.44 0.15 0.5% 4.75 4.75 0.00 0.15 37.19 0.4% 6,000 34.49 34.67 0.18 0.5% 5.70 5.70 0.00 0.18 40.37 1 0.4% 7,000 36.69 1 36.90 0.21 0.6% 6.65 6.65 0.00 0.21 43.55 0.5% 8,000 38.89 1 39.13 0.24 0.6% 7.60 7.60 0.00 0.24 46.73 0.5% 9,000 41.091 41.36 0.27 0.7% 8.55 8.55 0.00 0.27 49.91 0.5% 10,000 43.291 43.59 0.30 0.7% 9.50 9.50 0.00 0.30 53.09 0.6% 11,000 46.28 1 46.60 0.32 0.7% 10.45 10.45 0.00 0.32 57.05 0.6% 12,000 49.271 49.61 0.34 0.7% 11.40 11.40 0.00 0.34 61.01 0.6% 13,000 52.26 1 52.62 0.36 0.7% 12.35 12.35 0.00 0.36 64.97 0.6% 14,000 55.25 1 55.63 0.38 0.7% 13.30 13.30 0.00 0.38 68.93 0.6% 15,000 58.241 58.64 0.40 0.7% 14.25 14.25 0.00 0.40 72.89 0.6% 16,000 61.23 1 61.65 0.42 0.7% 15.20 15.20 0.00 0.42 76.85 0.5% 17,000 64.22 1 64.66 0.44 1 0.7% 16.151 16.15 0.00 0.44 80.81 1 0.5% 18,000 67.21 1 67.67 0.46 1 0.7% 17.10 17.10 0.00 0.46 84.77 0.5% 19,000 70.20 70.68 0.48 1 0.7% 18.05 18.05 0.00 0.48 88.73 0.5% 20,000 73.19 73.69 0.50 0.7% 19.00 19.00 0.00 0.50 92.69 0.5% 21,000 76.18 76.70 0.52 0.7% 19.95 19.95 0.00 0.52 96.65 0.5% 22,000 79.17 79.71 0.54 0.7% 20.90 20.90 0.00 0.54 100.61 0.5% 23,000 82.16 82.72 0.56 0.7% 21.85 21.85 0.00 0.56 104.57 0.5% 24,000 85.15 85.73 0.58 0.7% 22.80 22.80 0.00 0.58 108.53 0.5% 25,000 89.18 89.80 0.62 0.7% 23.75 23.75 0.00 0.62 113.55 0.5% 26,000 93.21 93.87 0.66 0.7% 24.70 24.70 0.00 0.66 118.57 0.6% 27,000 97.24 97.94 0.70 0.7% 25.65 25.65 0.00 0.70 123.59 0.6% 28,000 101.27 102.01 0.74 0.7% 26.60 1 26.60 0.00 0.74 128.61 1 0.6% 29,000 105.30 1 106.08 0.78 0.7% 27.55 27.55 0.00 0.78 133.63 0.6% 30,000 109.331 110.15 0.82 1 0.8% 28.50 28.50 0.00 0.82 138.65 0.6% 31,000 113.361 114.22 0.86 0.8% 29.45 29.45 0.00 0.86 143.67 0.6% 32,000 117.391 118.29 0.90 0.8 % 30.40 30.40 0.00 0.90 148.69 0.6% 33,000 121,421 122.36 0.94 0.8% 31.35 31.35 0.00 0.94 153.71 0.6% 34,000 125.45 1 126.43 0.98 0.8% 32.30 32.30 0.00 0.98 158.73 0.6% 35,000 129.48 1 130.50 1.02 0.8% 33.25 33.25 0.00 1.02 163.75 0.6% 36,000 133.51 1 134.57 1.06 0.8% 34.20 34.20 0.001 1.06 168.77 0.6% 37,000 137.541 138.64 1.10 0.8% 35.15 35.15 0.00 1.10 173.79 0.6% 38,000 141.571 142.71 1.14 0.8% 36.10 36.10 0.00 1.14 178.81 0.6% 39,000 145.60 1 146.78 1.18 0.8% 37.051 37.05 0.00 1.18 183.83 1 0.6% 40,000 149.631 150.85 1.22 0.8% 38.00 38.00 0.00 1.22 188.851 0.7% 41,000 153.66 1 154.92 1.261 0.8% 38.95 38.95 0.00 1.26 193.87 0.7% 42,000 157.69 1 158.99 1.301 0.8% 39.90 39.90 0.00 1.30 198.89 0.7% 43,000 161.72 1 163.06 1.34 1 0.8% 40.85 40.85 0.00 1.34 203.91 0.7% 44,000 165.75 167.13 1.38 1 0.8% 41.80 41.80 0.00 1.38 208.93 0.7% 45,000 169.78 171.20 1.42 0.8% 42.75 42.75 0.00 1.42 213.95 0.7% 46,000 173.81 175.27 1.46 0.8% 43.70 43.70 0.00 1.46 218.97 0.7% 47,000 177.84 179.34 1.50 0.8% 44.65 44.65 0.001 1.50 223.99 0.7% 48,000 181.87 183.41 1.54 0.8% 45.60 45.60 0.00 1.54 229.01 0.7% 49,000 187.25 188.90 1.65 a9% 46.55 46.55 0.00 1.65 235.45 0.7% 50,000 192.63 194.39 1.76 0.9% 47.50 1 47.50 0.00 1.76 241.89 0.7% 51,000 198.01 199.88 1.87 0.9% 48.45 48.45 0.00 1.87 248.33 0.8% 52,000 203.39 205.37 1.98 1.0% 49.40 49.40 0.00 1.98 254.77 0.8% 53,000 208.77 210.86 2.09 1.0% 50.35 50.35 0.00 2.09 261.21 0.8% 54,000 214.15 1 216.35 2.20 1.0% 51.30 51.30 0.00 2.20 267.65 0.8% 55,000 219.53 221.84 2.31 1 1.1 % 52.25 62.25 0.00 2.31 274.09 0.8% 56,000 224,91 227.33 2.42 1.1 % 53.20 53.20 0.00 2.42 280.53 0.9% 57,000 230.29 232.82 2.53 1.1 % 54.15 54.15 0.00 2.53 286.97 0.9% 58,000 235.67 238.31 2.64 1.1% 55.10 55.10 0.001 2.64 293.41 0.9% 59,000 241.05 243.80 2.75 1.1 % 56.05 56.05 0.00 2.75 299.85 0.9% 60,000 246.43 249.29 2.86 1.2 % 57.00 57.00 0.00 2.86 306.29 0.9% 61,000 251.81 254.78 2.97 1.2% 57.95 57.95 0.00 2.97 312.73 1.0% 62,000 257.19 260.27 3.08 1.2% 58.90 58.90 0.001 3.081 319.17 1.0% 63,000 262.57 265.76 3.19 1.2%1 59.85 1 59.85 0.001 3.191 325.61 1.0% Appendix D Monthly Charges and Percent Increase Comparison 2 of 17 RESIDENTIAL & IRRIGATION CUSTOMER BILL IMPACT WITH 1" METER BASE RATE 35.48 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE GPF TOTAL MONTHLY INCREASE/ (DECREASE) TOTAL AMOUNT OF MONTHLY BILL TOTAL PERCENT INCREASE] DECREASE 0 35.48 35.48 0.0 % 0.00 35.48 0.0 % 2,000 39.88 39,94 0.06 0.2% 1.90 1.90 0.00 0.06 41.84 0.1 % 4,000 44.28 44.40 0.12 0.3% 3.80 3.80 0.00 0.12 48.20 0.2% 6,000 48.68 48.86 0.18 0.4% 5.70 5.70 0.00 0.18 54.56 0.3% 8,000 53.08 53.32 0.24 0.5% 7.60 7.60 0.00 0.24 60.92 0.4% 10,000 57.48 57.78 0.30 0.5% 9.50 9.50 0.00 0.30 67.28 0.4% 12,000 61.88 1 62.24 0,361 0.6% 11.40 11.40 0.00 0.36 73.64 0.5 14,000 66.28 66.70 0.42 0.6% 13.30 13.30 0.00 0.42 80.00 0.5% 16,000 70.68 71.16 0.48 0.7% 15.20 15.20 0.00 0.48 86.36 0.6% 17,000 72.88 73.39 0.51 0.7% 16.15 16.15 0.00 0.51 89.54 0.6% 18,000 75.87 76.40 0.53 0.7% 17.10 17.10 0.00 0.53 93.50 0.6% 20,000 81.85 82.42 0.57 0.7% 19.00 19.00 0.00 0.57 101.42 0.6% 22,000 87.83 88.44 0.61 0.7% 20.90 20.90 0.00 0.61 109.34 0.6% 24,000 93.81 94.46 0.65 0.7% 22.80 22.80 0.00 0.65 117.26 0.6% 26,000 99.79 100.48 0.69 0.7% 24.70 24.70 0.00 0.69 125.18 0.6% 28,000 105.77 106.50 0.73 0.7% 26.60 26.60 0.00 0.73 133.10 0.6% 30,000 1 111.75 112.52 0.77 0.7% 28.50 28.50 Oki) 0.77 1 141.02 0.5% 32,000 117.731 118.54 0.81 1 0.7% 30.40 30.40 0.00 0.81 148.94 0.5% 34,000 123.71 124.56 0.85 0.7% 32.30 32.30 0.00 0.85 156.86 0.5% 36,000 129.69 130.58 0.89 0.7% 34.20 34.20 0.00 0.89 164.78 0.5% 38,000 135.67 136.60 0.93 0.7% 36.10 36.10 0.00 0.93 172.70 0.5% 40,000 141.65 142.62 0.97 0.7% 38.00 38.00 0.00 0.97 180.62 0.5% 42,000 149.71 150.76 1.05 0.7% 39.90 39.90 0.00 1.05 190.66 0.6% 44,000 157.77 158.90 1.13 0.7% 41.80 41.80 0.00 1.13 200.70 0.6% 46,000 165.83 167.04 1.21 0.7% 43.70 43.70 0.00 1.21 210.74 0.6% 48,000 173.89 175.18 1.29 0.7% 45.60 45.60 0.00 1.29 220.78 0.6% 50,000 181.95 183.32 1.37 0.8% 47.501 47.50 0.001 1.37 230.821 0.6% 52,000 190.01 191.46 1.45 0.8% 49.401 49.40 0.00 1.45 240.86 0.6% 54,000 198.071 199.60 1.531 0.8% 51.30 51.30 0.00 1.53 250.90 0.6% 56,000 206.13 207.74 1.61 1 0.8% 53.20 53.20 0.00 1.61 260.94 0.6% 58,000 214.19 215.88 1.69 0.8% 55.10 55.10 0.00 1.69 270.98 0.6% 60,000 222.25 224.02 1.77 0.8% 57.00 57.00 0.00 1.77 281.02 0.6% 62,000 230.31 232.16 1.85 0.8% 58.90 58.90 0.00 1.85 291.06 0.6% 64,000 238.37 240.30 1.93 0.8% 60.80 60.80 0.00 1.93 301.10 0.6% 66,000 246.43 248.44 2.01 0.8% 62.70 62.70 0.00 2.01 311.14 0.7% 68,000 254.49 256.58 2.09 0.8% 64.60 64.60 0.00 2.09 321.18 0.7% 70,000 262.55 264.72 2.17 0.8% 66.50 66.50 0.00 2.17 331.22 0.7% 72,000 270.61 272.86 2.25 0.8% 68.40 68.40 0.00 2.25 341.26 1 0.7% 74000 1 278.67 281.00 2.33 0.8% 70.30 1 70.30 0.00 2.33 351.30 0.7% 76,000 286.73 1 289.14 2.41 0.8% 72.20 1 72.20 0.00 2.41 361.34 0.7% 78,000 294.791 297.28 2.491 0.8% 74.10 74.10 0.00 2.49 371.38 0.7% 80,000 302.851 305.42 2.571 0.8% 76.00 76.00 0.00 2.57 381.42 0.7% 82,000 313.61 1 316.40 2.79 0.9% 77.90 77.90 0.00 2.79 394.30 0.7% 84,000 324.371 327.38 3.01 0.9% 79.80 79.80 0.00 3.01 407.18 0.7% 86,000 335.131 338.36 3.23 1.0% 81.70 81.70 0.00 3.23 420.06 0.8% 88,000 345.89 1 349.34 3.45 1.0% 83.60 83.60 0.00 3.45 432.94 0.8% 90,000 356.65 1 360.32 3.67 1.0% 85.50 85.50 0.00 3.67 445.82 0.8% 92,000 367.41 371.30 3.89 1.1% 87.40 87.40 0.00 3.89 458.70 0.9% 94,000 378.17 382.28 4.11 1.1% 89.30 89.30 0.00 4.11 471.56 1 0.9% 96,000 388.93 393.26 4.33 1.1% 91.20 91.20 0.00 4.33 484.46 1 0.9% 98,000 399.69 404.24 4.55 1.1% 93.10 1 93.10 0.00 4.55 497.341 0.9% 100,000 410.45 415.22 4.77 1.2% 95.00 95.00 0.00 4.77 510.22 0.9% 102,000 421.21 426.20 4.99 1 1.2% 96.90 96.90 0.00 4.99 523.10 1.0% 104,000 431.97 437.18 5.21 1.2% 98.80 98.80 0.00 5.21 535.98 1.0% 106,000 442.73 448.16 5.43 1.2% 100.70 100.70 0.00 5.43 548.86 1.0% 108,000 453.49 459.14 5.65 1.2% 102.60 102.60 0.00 5.65 561.74 1.0% 110,000 464.25 470.12 5.87 1.3% 104.50 104,50 0.00 5.87 574.62 1.0% 112,0001 475.01 481.10 6.09 1.3% 106.40 106.40 0.00 6.09 587.50 1.0% 114,000 485.77 492.08 6.31 1.3% 108.30 108.30 0.00 6.31 600.38 1.1% 116,000 496.53 503.06 6.53 1.3% 110.20 110.20 0.00 6.53 613.26 1.1 % 118,000 507.29 514.04 6.75 1.3% 112.10 112.10 0.00 6.75 626.14 1.1% 120,000 518.05 525.02 6.97 1.3% 114.00 114.00 0.00 6.97 639.02 1.1% 122,000 528.81 536.00 7.19 1.4% 115.90 115.90 TOO 7.19 651.90 1.1% 124,000 539.57 546.98 7.41 1 1.4%1 117.80 117.80 0.00 7.41 664.78 1.1% Appendix D Monthly Charges and Percent Increase Comparison 3 of 17 RESIDENTIAL & IRRIGATION CUSTOMER BILL IMPACT WITH 1 1/2 " METER BASE RATE 70.95 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNT OF INCREASE OFF TOTAL MONTHLY INCREASEI (DECREASE) TOTAL AMOUNT OF MONTHLY BILL TOTAL PERCENT INCREASE DECREASE 0 70.95 70.95 0.0% 0.00 70.95 0.07/ 8,000 88.55 88.79 0.24 0.3% 7.60 7.60 0.00 0.24 96.39 0.2% 16,000 106.15 106.63 0.48 0.5% 15.20 15.20 0.00 0.48 121.83 0.41/6 24,000 123.75 124.47 0.72 0.6% 22.80 22.80 0.00 0.72 147.27 0.5% 32,000 141.35 142.31 0.96 0.7% 30.40 30.40 0.00 0.96 172.71 0.6% 35,000 147.95 149.00 1.05 0.7% 33.25 33.25 0.00 1.05 182.25 0.6% 40,000 1 162.90 164.05 1 1.15 0.7% 38.00 38.00 0.00 1.15 202.05 0.6% 48,000 186.82 188.13 1.31 0.7% 45.60 45.60 0.00 1.31 233.73 0.6% 56,000 210.74 212.21 1.47 0.7% 53.20 53.20 0.00 1.47 265.41 0.6% 64,000 234.66 236.29 1.63 0.7% 60,80 60.80 0.00 1.63 297.09 0.6% 72,000 258.58 260.37 1.79 0.7% 68.40 68.40 0.00 1.79 328.77 0.5% 80,000 282.50 284.45 1.95 0.7% 76.00 76.00 0.00 1.95 360.45 0.5% 88,000 314.74 317.01 2.27 0.7% 83.60 83.60 0.00 2.27 400.61 0.6% 96,000 346.98 349.57 2.59 0.7% 91.20 91.20 0.00 2.59 440.77 0.6% 104,000 379.22 382.13 2.91 0.8% 98.80 98.80 0.00 2.91 480.93 0.6% 112,000 411.46 414.69 3.23 0.8% 106.40 106.40 0.00 3.23 521.09 0.6% 120,000 443.70 447.25 3.55 0.8% 114.00 114.00 0.00 3.55 561.25 0.6% 128,000 1 475.94 479.81 1 3.87 0.8% 121.60 121.60 0.00 3.87 601.41 0.6 % 136,000 1 508A8 512.37 4.19 0.8% 129.20 129.20 0.00 4.19 641.57 0.73/ 144,000 540.42 544.93 4.51 0.8% 136.80 136.80 0.00 4.51 681.73 0.7% 152,000 572.66 577.49 4.83 0.8% 144.40 144.40 0.00 4.83 721.89 0.7% 160,000 604.90 610.05 5.15 0.9% 152.00 152.00 0.00 5.15 762.05 0.7% 168,000 647.94 653.97 6.03 0.9% 159.60 159.60 0.00 6.03 813.57 0.7% 178,000 690.98 697.89 6.91 1.0% 167.20 167.20 0.00 6.91 865.09 0.8% 184,000 734.02 741.81 7.79 1.1% 174.80 174.80 0.00 7.79 916.61 0.9% 192,000 777.06 785.73 8.67 1.1% 182.40 182.40 0.00 8.67 968.13 0.9% 200,000 820.10 829.65 9.55 1 1.2% 190.00 1 190.00 0.001 9.55 1,019.65 1 0.9% 208,000 863.14 873.67 10.43 1.2% 197.60 197.60 0.00 10.43 1,071.17 1.0% 216,000 906.18 917.49 11.31 1.2% 205.20 205.20 0.00 11.31 1,122.69 1.0% 224,000 949.22 961.41 12.19 1.3% 212.80 212.80 0.00 12.19 1,174.21 1.0% 232,000 992.26 1,005.33 13.07 1.3% 220.40 220.40 0.00 13.07 1,225.73 1.1% 240000 1035.30 1,049.25 13.95 1.3% 228.00 22&00 0.00 13.95 1,277.25 1.1% 248,000 1,078.34 1,093.17 14.83 1.4% 235.60 235.60 0.00 14.83 1,328.77 1.1% 256,000 1,121.38 1,137.09 15.71 1.4% 243.20 243.20 0.00 15.71 1,380.29 1.2% 264,000 1,164.42 1,181.01 16.59 1.4% 250.80 250.80 0.00 16.59 1,431.81 1.2% 272,000 1,207.46 1,224.93 17.47 1.4% 258.40 258.40 0.00 17.47 1,483.33 1.2% 280,000 1,250.50 1,268.85 18.35 1.5% 266.00 266.00 0.00 18.35 1,534.85 1.2% 288,000 1,293.54 1,312.77 19.231 1.5% 273.60 1 273.60 0.001 19.23 1,586.37 1 1.2% 296,000 1,336.58 1,356.69 20.11 1.5% 281.20 281.20 0.00 20.11 1,637.89 1.2% 304,000 1,379.62 1,400.61 20.99 1.5% 288.80 288.80 0.00 20.99 1,689.41 1.3% 312,000 1,422.66 1,444.53 21.87 1.5% 296.40 296.40 0.00 21.87 1 740.93 1.3% 320,000 1,465.70 1,488.45 22.75 1.6% 304.00 304.00 0.00 22.75 1,792.45 1.3% 328,000 1,508.74 1,532.37 23.63 1.6% 311.60 311.60 0.00 23.63 1,843.97 1.3% 336,000 1,551.78 1,576.29 24.51 1.6% 319.20 319.20 0.00 24.51 1,895.49 1.3% 344,000 1,594.82 1,620.21 25.39 1.6% 326.80 326.80 0.00 25.39 1,947.01 1.3% 352,000 1,637.86 1,664.13 26.27 1.6% 334.40 334.40 0.00 26.27 1,998.53 1.3% 360,000 1,680.90 1,708.05 27.15 1.6% 342.00 342.00 0.00 27.15 2,050.05 1.3% 368,000 1,723.94 1,751.97 28.03 1.6% 349.60 349.60 0.00 28.03 2,101.57 1.4% 376,000 1,766.98 1,795.89 28.91 1.6% 357.20 357.20 0.00 28.91 2,153.09 1.4% 384,000 1,810.02 1,839.81 29.79 1.6% 364.80 364.80 0.00 29.79 2204.61 1.4% 392,000 1,853.06 1,883.73 30.67 1.7% 372.40 372.40 0.00 30.67 2,256.13 1.4% 400.000 1,896.10 1,927.65 31.55 1.7% 380.00 380.00 0.00 31.55 2,307.65 1.4% 408,000 1,939.14 1,971.57 32.43 1.7% 387.60 387.60 0.00 32.43 2,359.17 1.4% 416000 1,982.18 2,015.49 33.31 1.7% 395.20 395.20 0.00 33.31 2,410.69 1.4% 424,000 2,025.22 2,059.41 34.19 1.7% 402.80 40280 0.00 34.19 2,462.21 1.4% 432,000 2,068.26 2,103.33 35.07 1.7% 410.40 410.40 0.00 35.07 2,513.73 1.4% 440,000 2,111.30 2,147.25 35.95 1.7% 418.00 418.00 0.00 35.95 2,565.25 1.4% 448000 2,154.34 2,191.17 36.83 1.7%1 425.60 425.60 0.00 36.831 2,616.77 1.4% 456,000 2,197.38 1 2,235.09 37.71 1 1.7% 433.20 433.20 0.00 37.71 2,668.29 1 1.4% 464,000 2,240.42 2,279.01 38.59 1.7% 440.80 440.80 0.00 31.11 2,719.81 1.4% 472,000 2,283.46 2,322.93 39.47 1.7% 448.40 448.40 0.00 39.47 2,771.33 1.4% 480,000 2,326.50 2,365.85 40.35 1.7 % 456.00 456.00 0.00 40.35 2 822.85 1.5% 488,000 1 2,369.54 2,410.77 41.23 1 7%1 463.60 1 463.60 0.00 41.23 2,874.37 1 1.5% 496,000 1 2,412.58 2,454.69 42.11 1 1.7%1 471.201 471.20 0.00 42.11 2,925.891 1.5% Appendix D Monthly Charges and Percent Increase Comparison 4 of 17 RESIDENTIAL & IRRIGATION CUSTOMER BILL IMPACT WITH 2"METER BASE RATE 113.53 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE MOUNTOF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNT OF INCREASE GPF TOTAL MONTHLY INCREASE/ DECREASE TOTAL AMOUNT OF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 113.53 113.53 0.0% 0.00 113.53 0.0% 12,000 139.93 140.29 0.36 0.3% 11.40 11.40 0.00 0.36 151.69 0.2% 24,000 166.33 167.05 0.72 0.4% 22.80 22.80 0.00 0.72 189.85 0.4% 36,000 192.73 193.81 1.08 0.6% 34.20 34.20 0.00 1.08 228.01 0.5% 48,000 219.13 220.57 1.44 0.7% 45.60 4&60 0.00 1.44 266.17 0.5% 56,000 236.73 238.41 1.68 0.7% 53.20 53.20 0.00 1.68 291.61 0.6% 60,000 248.69 1 250.45 1.761 0.7% 57.00 57.00 0.00 1.76 307.45 0.6% 72,000 284.57 1 286.57 2.00 0.7% 68.40 68.40 0.00 2.00 354.97 0.6% 84,000 320.45 1 322.69 2.24 0.7% 79.80 79.80 0.00 2.24 402.49 0.6% 96,000 356.33 358.81 2.48 0.7% 91.20 91.20 0.00 2.48 450.01 0.6% 108,000 392,21 394.93 2.72 0.7% 102.60 102.60 0.00 2.72 497.53 0.5% 120.000 428.09 431.05 2.96 0.7% 114.00 114.00 0.00 2.96 545.05 0.5% 128,000 452.01 455.13 3.12 0.7% 121.60 121.60 0.00 3.12 576.73 0.5% 132,000 468.13 471.41 3.28 0.7% 125.40 125.40 0.00 3.28 596.81 0.6% 144,000 51649 520.25 3.76 0.7% 136.80 136.80 0.00 3.76 657.05 0.6% 156,000 564,85 569.09 4.24 0.8% 148.20 148.20 0.00 4.24 717.29 0.6% 168,000 613.21 617.93 4.72 0.8%1 159.60 159.60 0.001 4.72 777.53 0.6% 180,000 661.57 666.77 5.20 0.8% 171.00 171.00 0.001 5.20 837.77 0.6% 192,000 1 709.93 715.61 5.68 0.8% 182.40 182.40 0.00 5.68 898.01 0.6% 204,000 758.29 1 764.45 6.16 0.8% 193.80 193.80 0.00 6.16 958.25 0.63/6 216,000 806.65 1 813.29 6.64 0.8% 205.20 205.20 0.00 6.64 1,018.49 0.7% 228,000 855.01 1 862.13 7.12 0.8% 216.60 216.60 0.00 7.12 1,078.73 0.7% 240,000 903.37 1 910.97 7.60 0.8% 228.00 228.00 0.00 7.60 1,138.97 0.7% 252,000 951.73 1 959.81 8.08 0.8% 239.40 239.40 0.00 8.08 1.199.21 0.7% 256,000 967.85 976.09 8.24 0.9% 243.20 243.20 0.00 8.24 1,219.29 0.7% 264,000 1,010.89 1,020.01 9.12 0.9% 250.80 250.80 0.00 9.12 1,270.81 0.7% 276,000 1,075.45 1.085.89 10.441 1.0% 262.20 262.20 0.00 10.441 1,348.09 0.8% 288,000 1,140.01 1,151.77 11.76 1 1.0% 273.60 273.60 0.00 11.76 1,425.37 0.8% 300,000 1,204.57 1,217.65 13.08 1.1% 285.00 285.00 0.00 13.08 1,502.65 0.9% 312,000 1,269.13 1,283.53 14.40 1.1% 296.40 296.40 0.00 14.40 1,579.93 0.9% 324,000 1,333.69 1,349.41 15.72 1.2% 307.80 307.80 0.00 15.72 1,657.21 1.0% 336,000 1,398.25 1,415.29 17.04 1.2% 319.20 319.20 0,00 17.04 1,734.49 1.0% 348,000 1,462.81 1,481.17 18.36 1.3% 330.60 330.60 0.00 18.36 1,811.77 1.0% 360,000 1,527.37 1,547.05 19.68 1.3% 342,D0 342.00 0.00 19.68 1,889.05 1.1% 372,000 1,591.931 1,612.93 21.00 1.3% 353.40 353.40 0.00 21.00 1,966.33 1.1% 384,000 1,656.491 1,678.81 22.32 1.3% 364.80 364.80 0.00 22.32 2,043.61 1.1% 396,000 1,721.05 1,744.69 23.64 1.4% 376.201 376.20 0.00 23.64 2,120.89 1 1.1% 408,000 1,785.61 1,810.57 24.96 1.4% 387.60 387.60 0.00 24.96 2,198.17 1.1% 420,000 1,850.17 1,876.45 26.28 1.4% 399.00 399.00 0.00 26.28 2,275.45 1.2% 432,000 1,914.73 1,942.33 27.60 1.4% 410.40 410.40 0.00 27.60 2,352.73 1.2% 444,000 1,979.29 2,008.21 28.92 1.5% 421.80 421.80 0.00 28.92 2,430.01 1.2% 456,000 2,043.85 2,074.09 30.24 1.5% 433.20 433.20 0.00 30.24 2,507.29 1.2% 468,000 2,108.41 2,139.97 31.56 1.5% 444.60 444.60 0.00 31.56 2,584.57 1.2% 480,000 2,172.97 2,205.85 32.88 1.5% 456.00 456.00 0.00 32.88 2,661.85 1.3% 492,000 2,237,53 2,271.73 34.20 1.5% 467.40 467.40 0.00 34.20 2,739.13 1.3% 504,000 2.302.09 2,337.61 35.52 1.5% 478.80 478.80 0.00 35.52 2,816.41 1.3% 516,000 2,366.651 2,403.49 36.84 1.6 % 490.20 490.20 0.00 36.84 2 893.69 1.3% 528,000 2,431.21 1 2,469.37 38.16 1.6% 501.60 1 501.60 0.001 38.16 2,970.971 1.3% 540,000 2,495.77 2,535.25 39.48 1.6% 513.00 513.00 0.00 39.48 3,048.25 1.3% 552,000 2,560.33 2 601.13 40.80 1.6% 524.40 524.40 0.00 40.80 3,125.53 1.3% 564,000 2,624.89 2,667.01 4212 1.6% 535.80 535.80 0.00 42.12 3,202.81 1.3% 576,000 2,689.45 2,732.89 43.44 1.6% 547.20 547.20 0.00 43.44 3,280.09 1.3% 588,000 2,754.01 2.798.77 44.76 1.6% 558.60 558.60 0.00 44.76 3,357.37 1.4% 600,000 2,818.57 2,864.65 46.08 1.6% 570.00 570.00 0.00 46.08 3,434.65 1.4% 612,000 2,883.13 2,930.53 47.40 1.6% 581.40 581.40 0.00 47.40 3,511.93 1.4% 624,000 2,947.69 2,996,41 48.72 1.7% 592.80 592.80 0.00 48.72 3,589.21 1.4% 636,000 3,012.25 3,062.29 50.04 1.7% 604.20 604.20 0.00 50.04 3,666.49 1.4% 648,000 3,076.81 3,128.17 1 51.36 1.7'/.l 615.60 615.60 OM-51.361 3.743.77 1.4% 000 3,141.37 3,194.05 52.68 1.7% 627.00 627.00 0.00 52.68 3,821.05 1.4% 1 0 3,205.93 3,259.93 54.00 1.7% 638.40 639840 0.00 54.00 3,898.33 1.4% 00 3,270.49 3,325.8155.32 1.7% 649.80 649.80 0.00 55.32 3,975.61 1.4% 003,335.05 N72 3,391.69 56.64 1.7% 661.20 661.20 0.00 56.64 4,052.89 1.4% 00 3,399.61 3,457.57 57.96 1.7 % 672.60 672.60 0.00 57.96 4,130.171.4 %00 3,464.17 3,523.45 59.28 1.7% 684.00 684.00 0.00 59.28 1 4,207.45 1.4% Appendix D Monthly Charges and Percent Increase Comparison 5 of 17 RESIDENTIAL & IRRIGATION CUSTOMER BILL IMPACT WITH 3" METER BASE RATE 227.05 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE GPF TOTAL MONTHLY INCREASE/ (DECREASE) TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 227.05 227.05 0.0 % 0.00 227.05 0.03% 22,000 275.45 276.11 0.66 0.2% 20.90 20.90 0.00 0.66 297.01 0.2% 44,000 323.85 325.17 1.32 0.4% 41.80 41.80 0.00 1.32 366.97 0.4% 66,000 372.25 374.23 1.98 0.5% 62.70 62.70 0.00 1.98 436.93 0.5% 88,000 420.65 423.29 2.64 0.6% 83.60 83.60 0.00 2.64 506.89 0.5% 110,000 469.05 472.35 3.30 0.7% 104.50 104.50 0.00 3.30 576.85 0.6% 112,000 1 473.45 476.81 1 3.36 0.7% 106.40 106.40 0.00 3.36 583.21 0.6% 132,000 533.25 537.01 3.76 0.7% 125.40 125.40 0.00 3.76 662.41 0.6% 154,000 599.03 603.23 4.20 0.7% 146.30 146.30 0.00 4.20 749.53 0.6% 176,000 664.81 669.45 4.64 0.7% 167.20 167.20 0.00 4.64 836.65 0.6% 198,000 730.59 735.67 5.08 0.7% 188.10 188.10 0.00 5.08 923.77 0.6% 220,000 796.37 801.89 5.52 0.7% 209.00 209.00 0.00 5.52 1,010.89 0.5% 242,000 862.15 868.11 5.96 0.7% 229.90 229.90 0.00 5.96 1,098.01 0.5% 256,000 904.01 910.25 6.24 0.7% 243.20 243.20 0.00 6.24 1,153.45 0.5% 264,000 936.25 942.81 6.56 0.7% 250.80 250.80 0.00 6.56 1,193.61 0.6% 286,000 1,024.91 1,032.35 7.44 0.7% 271.70 271.70 0.00 7.44 1,304.05 0.6% 308000 1,113.57 1 1,121.89 8.32 1 0.7% 292.60 1 292.60 0.00 8.32 1,414.49 0.6% 330,000 1,202.23 1,211.43 9.20 0.8% 313.50 313.50 0.00 9.20 1,524.93 0.6% 352,000 1,290.89 1,300.97 10.08 0.8% 334.40 334.40 0.00 10.08 1,635.37 0.6% 374,000 1,379.55 1,390.51 10.96 0.8% 355.30 355.30 0.00 10.96 1,745.81 0.6% 396000 1,468.21 1450.05 11.84 0.8% 376.20 376.20 0.00 11.84 1,856.25 0.6% 418,000 1,556.87 1,569.59 12.72 0.8% 397.10 397.10 0.00 12.72 1,966.69 0.7% 440,000 1,645.53 1,659.13 13.60 0.8% 418.00 418.00 0.00 13.60 2,077.13 0.7% 462,000 1,734.19 1,748.67 14.48 0.8% 438,90 438.90 0.00 14.48 2,187.57 0.7% 484,000 1,822.85 1838.21 15.36 0.8% 459.80 459.80 0.00 15.36 2,298.01 0.7% 506,000 1,911.51 1,927.75 16.24 0.8% 480.70 480.70 0.00 16.24 2,408.45 0.7% 512,000 1,935.69 1,952.171 16.48 0.9% 486.40 486.40 0.00 16.48 2,438.57 0.7% 528,000 2,021.77 2,040.01 18.241 0.9% 501.60 501.60 0.00 18.24 2,541.61 0.7% 550,000 2,140.13 2,160.79 20.66 1.0% 522.50 522.50 0.00 20.66 2,683.29 0.8% 572,000 2,258.49 2,281.57 23.08 1.0% 543.40 543.40 0.00 23.08 2,824.97 0.8% 594,000 2,376.85 2,402.35 25.50 1.1% 564.30 564.30 0.00 25.50 2,966.65 0.9% 616,000 2,495.21 2,523.13 27.92 1.1% 585.20 585.20 0.00 27.92 3,108.33 0.9% 638,000 2,613.57 2,643.91 30.34 1.2% 606.10 606.10 0.00 30.34 3,250.01 0.9% 660,000 2,731.93 2,764.69 32.76 1.2% 627.00 627.00 0.00 32.76 3,391.69 1.0% 682,000 2,850.29 2,885.47 35.18 1.2% 647.90 647.90 0.00 35.18 3,533.37 1.0% 704,000 2,968.65 3,006.25 37.60 1.3% 668.80 668.80 0.00 37.60 3,675.05 1.0% 726,000 3,087.01 1 3,127.03 40.02 1.3% 689.70 689.70 0.001 40.02 3,816.73 1 1.1 748,000 3,205.37 1 3,247.81 42.44 1.3% 710.60 710.60 0.00 42.44 3,958.41 1.1% 770,000 3,323.73 1 3,368.59 44.861 1.3% 731.50 1 731b0 0.00 44.86 4,100.09 1.1% 792,000 3,442.09 1 3,489.37 47.28 1.4% 752.40 752AO 0.00 47.28 4,241.77 1.1% 814,000 3,560.45 1 3,610.15 49.70 1.4% 773.30 773.30 0.00 49.70 4,383,45 1.17% 836,000 3,678.81 1 3,730.93 52.12 1.4% 794.20 794.20 0.00 52.12 4,525.13 1.2% 858,000 3,797.171 3,851.71 54.54 1.4% 815.10 815.10 0.00 54.54 4,666.81 1.29/6 880,000 3,915.531 3,972.49 56.96 1.5% 836.00 836.00 0.00 56.96 4,808.49 1.2% 902,000 4,033.89 1 4,093.27 59.38 1.5% 856.90 856.90 0.00 59.38 4,950.17 1.2% 924,000 4,152.25 1 4,214.05 61.80 1.5% 877.80 877.80 0.00 61.80 5,091.85 1.2% 946,000 4,270.61 1 4,334.83 64.22 1.5% 898.70 898.70 0.00 64.22 5,233.53 1.2% 968,000 4,388.97 1 4,455.61 66.64 1.5% 919.60 919.60 1 0.00 66.64 5,375.21 1.3% 990,000 4,507.33 1 4,576.39 69.06 1.5% 940.50 940.50 0.00 69.06 5,516.89 1.3% 1,012,000 4,625.69 1 4,697.17 71.481 1.5% 961.40 961.40 0.00 71.48 5,658.57 1.3% 1,034,000 4,744.05 1 4,817.95 73.901 1.6% 982.30 982.30 0.00 73.90 5,800.25 1.3% 1,056,000 4,862.41 1 4,938.73 76.32 1.6% 1,003.20 1,003.20 0.00 76.32 5941.93 1.3% 1,078,000 4,980.77 1 5,059.51 78.74 1.6% 1,024.10 1,024.10 0.00 78.74 6,083.61 1.3% 1,100,000 5,099.13 1 5,180.29 81.16 1.6% 1,045.00 1,045.00 0.00 81.16 6,22529 1.3% 1,122,000 5,217.491 5,301.07 83.58 1.6% 1,065.90 1,065.90 0.00 83.58 6,366.97 1.3% 1,144,000 5,335.85 5,421.85 86.00 1.6% 1,086.80 1,086.80 0.00 86.00 6,508.65 1.3% 1,166,000 5,454.21 5,542.63 88.42 1.6% 1,107.70 1,107.70 0.00 88.42 6,650.33 1.3% 1,188,000 5,572.57 5,663.41 90.84 1.6% 1128.60 1 1128.60 0.00 90.84 6,792.01 1.4% 1,210,000 5,690.93 5,784.19 93.26 1.6% i,149.50 1,149.50 0.00 93.26 6,933.69 1.4% 1,232,000 5,809.29 5,904.97 95.68 1.6% 1,170.40 1,170.40 0.00 95.68 7075.37 1.4% 1,254,000 5,927.65 6,025.75 98.10 1.7% 1,191.30 1,191.30 0.00 98.10 7,217.05 1.4% 1,276,000 6046.01 6,146.53 100.52 1.7% 11212.20 1212.20 0.00 100.52 7,358.73 1.4% 1,298,000 6,164.37 6,267.31 1 102.94 1 1.7% 1,233.10 1,233.10 0.00 162.94 7,500.41 1.4% 1,320,000 6,282.73 6,388.09 1 105.36 1 1.7% 1,254.00 1,254.00 0.00 105.36 7,642.09 1.4% Appendix D Monthly Charges and Percent Increase Comparison 6 of 17 RESIDENTIAL & IRRIGATION CUSTOMER BILL IMPACT WITH 4" METER BASE RATE 354.77 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE GPF TOTAL MONTHLY INCREASE/ (DECREASE) TOTAL AMOUNT OF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 354.77 354.77 0.0% 0.00 354.77 0.0% 22,000 403.17 403.83 0.66 0.2% 20.90 20.90 0.00 0.66 424.73 0.2% 44,000 451.57 452.89 1.32 0.3% 41.80 41.80 0.00 1.32 494.69 0.3% 66,000 499.97 501.95 1.98 0.4% 62.70 62.70 0.00 1.98 564.65 0.4% 88,000 548.37 551.01 2.64 0.51 83.60 83.60 0.00 2.64 634.61 0.4% 110,000 596.77 600.07 3.30 0.6% 104.50 104.50 0.00 3.30 704.57 0.5% 132.0001 645.17 649.131 3.96 0.6%1 125.40 125.40 0.00 3.96 774.53 0.5% 154,000 693.57 698.19 4.62 0.7% 146.30 146.30 0.00 4.62 844.49 0.6% 175,000 739.77 745.02 5.25 0.7% 166.25 166.25 0.00 5.25 911.27 0.6% 176,000 742.76 748.03 5.27 0.7% 167.20 167.20 0.00 5.27 915.23 0.6% 198,000 808.54 814.25 5.71 0.7% 188.10 188.10 0.00 5.71 1,002.35 0.6% 220,000 874.32 880.47 6.15 0.7% 209.00 209.00 0.00 6.15 1,089.47 0.6% 242,000 940.10 946.69 6.59 0.7% 229.90 229.90 0.00 6.59 1,176.59 0.6% 264,000 1,005.88 1,012.91 7.03 0.7% 250.80 250.80 0.00 7.03 1,263.71 0.6% 286,000 1,071.66 1,079.13 7.47 0.7% 271.70 271.70 0.00 7.47 1,350.83 0.6% 308,000 1,137.44 1,145.35 7.91 0.7% 292.60 292.60 0.00 7.91 1,437.95 0.6% 330,000 1,203.22 1 1,211.57 8.35 0.7% 313.50 313.50 0.00 8.35 1,525.07 0.6% 352,000 1,269.00 1 1,277.79 8.79 0.7% 334.40 334.40 0.00 8.79 1,612.19 0.5% 374,000 1,334.78 1,344.01 9.23 0.7% 355.30 355.30 0.00 9.23 1,699.31 0.5% 396,000 1,400.56 1,410.23 9.67 0.7 % 376.20 376.20 0.00 9.67 1,786.43 0.5% 400,000 1,412.52 1,422.27 9.75 0.7% 380.00 380.00 0.00 9.75 1 802.27 0.5% 418,000 1,485.06 1,495.53 10.47 0.7% 397.10 397.10 0.00 10.47 1,892.63 0.6% 440,000 1573.72 1,585.07 11.35 0.7% 418.00 418.00 0.00 11.35 2,003.07 0.6% 462,000 1662.38 1,674.61 12.23 0.7% 438.90 438.90 0.00 12.23 2,113.51 0.6% 484,000 1,751.04 1,764A 5 13.11 0.7% 459,80 459.80 0.00 13.11 2,223.95 0.67 506,000 1,839.70 1,853.69 13.99 0.8% 480.70 480.70 0.00 13.99 2,334.39 0.6% 528,000 1,928.36 1,943.23 14.87 0.8% 501.60 501.60 0.001 14.87 2,444.831 0.6% 550,000 2.017.02 2,032.77 15.75 0.8% 522.50 522.50 0.00 15.75 2,555.27 0.6% 572,000 2,105.68 1 2,122.31 16.63 0.8% 543.40 543.40 0.00 16.63 2,665.71 0.6% 594,000 2,194.34 2,211.85 17.51 0.8% 564.30 564.30 0.00 17.51 2,776.15 0.6% 616,000 2,283.00 2,301.39 18.39 0.8% 585.20 585.20 0.00 18.39 2,886.59 0.6% 638,000 2,371.66 2,390.93 19.27 0.8% 606.10 606.10 0.00 19.27 2,997.03 0.6% 660,000 2,460.32 2,480.47 20.15 0.8% 627.00 627.00 0.00 20.15 3,107.47 0.7% 682,000 2,548.98 2,570.01 21.03 0.8% 647.90 647.90 0.00 21.03 3,217.91 0.7% 704,000 2,637.64 2,659.55 21.91 0.8% 668.80 668.80 0.00 21.91 3,328.35 0.7% 726,000 2,726.30 2,749.09 22.79 0.8% 689.70 689.70 0.00 22.79 3,438.79 0.7% 748,000 2,814.96 2.838.63 23.67 0.8% 710.60 710.60 0.00 23.67 3,649.23 0.7% 770,000 2,903.62 2,928.17 24.55 0.8% 731.50 731.50 0.00 24.55 3,659.67 0.7% 792.000 2,992.28 3,017.71 25.43 0.8% 752.40 752.40 0.00 25.43 3,770.11 0.7% 800,000 3,024.521 3,050.27 25.75 0.9% 760.00 760.00 0.00 25.75 3,810.27 0.7% 814,000 3,099.84 3,127.13 27.29 0.9% 773.30 773.30 0.00 27.29 3,900.43 0.7% 836,000 3,218.20 3,247.91 29.71 0.9% 794.20 794.20 0.00 29.71 4,042.11 0.7% 858,000 3,336.56 1 3,368.69 32.13 1.0% 815.10 815.10 0.00 32.13 4,183.79 0.8% 880,000 3,454.92 1 3,489.47 34.55 1.0% 836.00 836.00 0.00 34.55 4,325.47 0.8% 902,000 3,573.28 1 3,610.25 36.97 1.0% 856.90 856.90 0.00 36.97 4,467.15 0.8% 924,000 3,691.64 1 3,731.03 39.39 1.1% 877.80 877.80 0.00 39.39 4,608.83 0.9% 946,000 3,810.00 3,851.81 41.81 1 1.1% 898.70 1 898.70 0.001 41.81 4,750.51 0.9% 968,000 3,928.36 3972.59 44.23 1.1% 919.60 919.60 0.00 44.23 4,892.19 0.9% 990,000 4,046.72 4,093.37 46.65 1.2 % 940.50 940.50 0.00 46.65 5,033.87 0.9 1,012,000 4,165.08 4,214.15 49.07 1.2 % 961.40 961.40 0.00 49.07 5,175.55 1.0% 1,034,000 4,283.44 4,334.93 51.49 1.2 % 982.30 982.30 0.00 51.49 51317.23 1.0% 1,056,000 4,401.80 4,455.71 53.91 1.2 % 1,003.20 1,003.20 0.00 53.91 5,458.91 1.0% 1,078,000 4,520.16 4,576.49 56.33 1.2 % 1,024.10 1,024.10 0.00 56.33 5,600.59 1.0% 1,100,000 4,638.52 4,697.27 58.75 1.3% 1,045.00 1,045.00 0.00 58.75 5,742.27 1.0% 1,122,000 4,756.88 4,818.05 61.17 1.3% 1,065.90 1,065.90 0.00 61.17 5,883.95 1.1% 1,144,000 4,875.24 4,938.83 63.59 1.3% 1,086.80 1,086.80 0.00 63.59 6,025.63 1.1% 1,166,000 4,993.60 5,059.61 66.01 1.3%1 1,107.70 1,107.70 0.00 66.01 1 6,167.31 1.1 1,188,000 5,111.96 5, 180.39 68.43 1.3% 1,128.60 1 1,128.60 0.00 68.431 6,308.99 1 1.1 1,210.000 5,230.32 5,301.17 70.85 1.4% 1,149.50 1,149.50 0.00 70.85 6,450.67 1.1 1,232,000 5,348.68 5,421.95 73.27 1.4% 1,170.40 1,170.40 0.00 73.27 6,592.35 1.1 1,254 000 5,467.04 5,542.73 75.69 1.4% 1,191.30 1,191.30 0.00 75.69 6,734.03 1.1 1,276,000 5,585.40 5,663.51 78.11 1.4% 1,212.20 1,212.20 0.00 78.11 6,875.71 1.1 1,298,000 5,703.76 5,784.29 80.53 1.4% 1,233.10 1,233.10 0.00 80.53 7,017.39 1.2 1320,000 5822.12 5,905.07 82.95 1.4% 1254.00 1,254.00 0.00 82.95 7,159.07 1.2% Appendix D Monthly Charges and Percent Increase Comparison 7 of 17 RESIDENTIAL & IRRIGATION CUSTOMER BILL IMPACT WITH 6" METER BASE RATE 709.54 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASEI DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE OFF TOTAL MONTHLY INCREAS& (DECREASE) TOTAL AMOUNT OF MONTHLY BILL TOTAL PERCENT INCREASE DECREASE 0 709.54 709.54 0.0% 0.00 709.54 0.07/ 60,000 841.54 843.34 1.80 0.2% 57.00 57.00 0.00 1.80 900.34 0.2% 120,000 973.54 977.14 3.60 0.4% 114.00 114.00 0.00 3.60 1,091.14 0.3% 180,000 1,105.54 1.110.94 5.40 0.5% 171.00 171.00 0.00 5.40 1,281.94 0.4% 240,000 1,237.54 1,244.74 7.20 0.6% 228.00 228.00 0.00 7.20 1,472.74 0.5% 300,000 1,369.54 1,378.54 9.00 0.7% 285.00 285.00 0.00 9.00 1,663.54 0.5% 360000 1,501.54 1,512.341 10.80 0.7% 342.00 342.00 0.00 10.80 1854.34 0.6% 420,000 1 1,633.54 1,646.14 12.60 0.8% 399.00 399.00 0.00 12.60 2,045.14 0.6% 480.000 1 1,765.54 1,779.94 14.40 0.8% 456.00 456.00 0.00 14.40 2,235.94 0.6% 540,000 1,897.54 1,913.74 16.20 0.9% 513.00 513.00 0.00 16.20 2,426.74 0.7% 600,000 2029.54 2,047.54 18.00 0.9% 570.00 570.00 0.00 18.00 2,617.54 0.7% 660,000 2,161.54 2,181.34 19.80 0.9% 627.00 627.00 0.00 19.80 2,808.34 0.7% 720,000 2,293.54 2,315.14 21.60 0.9% 684.00 684.00 0.00 21.60 2,999.14 0.7% 780,000 2,425.54 2,448.94 23.40 1.0% 741.00 741.00 0.00 23.40 3,189.94 0.7% 840,000 2,557.54 2,582.74 25.20 1.0% 798.00 798.00 0.00 25.20 3,380.74 0.8% 860,000 2,601.54 2,627.34 25.80 1.0% 817.00 817.00 0.00 25.80 3,444.34 0.8% 900,000 2,721.14 2,747.74 26.60 1 1.0% 855.00 855.00 0.00 26.60 3,602.74 0.7% 960,000 2,900.54 1 2,928.34 27.80 1 1.0% 912.00 912.00 0.00 27.80 3,840.34 0.7% 1,020,000 3,079.94 3,108.94 29.00 0.9% 969.00 969.00 0.00 29.00 4,077.94 0.7% 1,080,000 3,259.34 3,289.54 30.20 0.9% 1,026.00 1,026.00 0.00 30.20 4,315.54 0.7% 1140,000 3,438.74 3,470.14 31,40 0.9% 1,083.00 1,083.00 0.00 31.40 4,553.14 0.7% 1,200,000 3,618.14 3,650.74 32.60 0.9% 1,140.00 1,140.00 0.00 32.60 4,790.74 0.7% 1,260,000 3,797.54 3,831.34 33.80 0.9% 1,197.00 1,197.00 0.00 33.80 5,028.34 0.7% 1,320,000 3,976.94 4,011.94 35.00 0.9% 1,254.00 1,254.00 0.00 35.00 5,265.94 0.7% 1380,000 4,156.34 4,192.54 36.20 0.9% 1,311.00 1.311.00 0.00 36.20 5,503.54 0.7% 1,440,000 4,335.74 4,373.14 37.40 0.9% 1,368.00 1,368.00 0.00 37.40 5,741.14 0.7% 1,500,000 4,515.14 4,553.74 38.60 0.9% 1,425.00 1 1,425.00 0.001 38.60 5,978.74 1 0.6% 1,560,000 4,694.54 4,734.34 39.80 0.8% 1,482.00 1 1,482.00 0.001 39.80 6,216.34 0.6% 1,620,000 4873.94 4,914.94 41.00 0.8% 1539.00 1,539.00 0.00 41.00 6,453.94 0.6% 1,680,000 5,053.34 5,095.54 42.20 0.8% 1,596.00 1,596.00 0.00 42.20 6,691.54 0.6% 1,740,000 5,232.74 5,276.14 43.40 0.8% 1,653.00 1,653.00 0.00 43.40 6,929.14 0.6% 1,800,000 5,412.14 5,456.74 44.60 0.8% 1,710.00 1,710.00 0.00 44.60 7,166.74 0.6% 1,860,000 5,591.54 5,637.34 45.80 0.8% 1,767.00 1,767.00 0.00 45.80 7,404.34 0.6% 1,920,000 5,770.94 5,817.94 47.00 0.8% 1,824.00 1,824.00 0.00 47.00 7,641.94 0.6% 1,980,000 5,950.34 5,998.54 48.20 0.8% 1,881.00 1,881.00 0.00 48.20 7,879.54 0.6% 2,040,000 6,129.74 6,179.14 49.40 0.8% 1,938.00 1,938.00 0.00 49.40 8,117.14 0.6% 2,000,000 6,010.14 6,058.74 48.60 0.8% 1,900.00 1.900.00 0.00 48.60 7,958.74 0.6% 2,100,000 6,413.14 6,465.74 52.60 0.8% 1,995.00 1995.00 0.00 52.60 8,460.74 1 0.6% 2,160,000 6,654.94 6,709.94 55.00 0.8% 2,052.00 2,052.00 0.00 55.00 8,761.94 0.6% 2,220,000 6,896.74 6,954.14 57.40 0.8% 2109.00 2,109.00 0.00 57.40 9,063.14 0.6% 2,280,000 7,138.54 7,198.34 59.80 0.8% 2,166.00 2,166.00 0.00 59.80 9,364.34 0.6% 2,340,000 7,380.34 7,442.54 62.20 0.8% 2,223.00 2,223.00 0.00 62.20 9,665.54 0.6% 2,400,000 7,622.14 7,686.74 64.60 0.8% 2,280.00 2,280.00 0.00 64.60 9,966.74 0.7% 2460,000 7,863.94 7935.94 67.00 0.9% 2,337.00 2,337.00 0.00 67.00 10,267.94 0.7% 2,520,000 8,105.74 8,175.14 69.40 0.9% 2,394.00 2,394.00 0.00 69.40 10,569.14 0.7% 2,580,000 8,347.54 8,419.34 71.80 0.9% 2,451.00 2,451.00 0.00 71.80 10,870.34 0.7% 2,640,000 8,589.34 8,663.54 74.20 0.9% 2,508.00 2,608.00 0.00 74.20 11,171.54 0.7% 2,700,000 8,831.14 8,907.74 76.60 0.9% 2,565.00 2,565.00 0.00 76.60 11,472.74 0.7% 2,760,000 9,072.94 9,151.94 79.00 0.9% 2,622.00 2,622.00 0.00 79.00 11,773.94 0.7% 2,820,000 9,314.74 9,396.14 81.40 0.9% 2,679.00 2,679.00 0.00 81.40 12075.14 0.7% 2,880,000 9,556.54 9,640.34 83.80 0.9% 2,736.00 2,736.00 0.00 83.80 12,376.34 0.7% 2,940,000 9,798.34 9,884.54 86.20 0.9% 2,793,00 2,793.00 0.00 86.20 12,677.54 0.7% 3,000,000 10,040.14 10,128.74 88.60 0.9% 2,850.00 2,850.00 0.00 88.60 12978.74 0.7% 3,060,000 10,281.94 10,372.94 91.00 0.9% 2,907.00 2,907.00 0.00 91.00 13,279.94 0.7% 3,120,000 10,523.74 10,617.14 93.40 0.9% 2,964,00 2,964.00 0.00 93.40 13,581.14 0.7% 3,180,000 10,765.54 10,861.34 95.80 0.9% 3,021.00 3,021.00 0.00 95.80 13,882.34 0.7% 3,240,000 11,007.34 11,105.54 98.20 0.9% 3,078.00 3,078.00 0.00 98.20 14,183.54 07 3,300,000 11,249.14 11,349.741 100.60 0.9% 3,135.00 3,135.00 0.00 100.60 14,484.74 0.7% 3,360,000 11,490.94 11.593.94 103.00 0.9% 3,192.00 3,192.00 0.00 103.00 14,785.94 0.7% 3,420,000 11,732.74 11,838.14 105.40 0.9% 3,249.00 3,249.00 0.00 105.40 15,087.14 0.7% 3,480,000 11,974.54 12,082.34 107.80 0.9% 3,306.00 3,306.00 0.00 107.80 15,366.34 0.7% 3,500,000 12,055.14 12,163.74 108.60 0.9% 3,325.00 3,325.00 0.00 108.60 15,488.74 0.7% 3'540,000 12,270.34 12,383.34 113.00 0.9% 3,363.00 3,363.00 0.00 113.00 15,746.34 0.7% 3,600,000 12,593.14 12,712.74 119.60 0.9% 3,420.00 3,420.00 0.00 119.60 16,132.74 0.7% Appendix D Monthly Charges and Percent Increase Comparison 8 of 17 COMMERCIAL & MASTER METERED MULTIY FAMILY CUSTOMER BILL IMPACT WITH 5/81, X 3/41, METER BASE RATE 14.19 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNT OF INCREASE OFF TOTAL MONTHLY INCREASE DECREASE TOTAL AMOUNT OF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 14.19 14.19 0.0% 0.00 14.19 0.01 2,000 18.59 18.65 0.06 0.3 % 1.90 1.90 0.00 0.06 20.55 0.3 % 4,000 22.99 23.11 0.12 0.5 % 3.80 3.80 0.00 0.12 26.91 0.4 % 6,000 27.39 27.57 0.18 0.7% 5.70 5.70 0.00 0.18 33.27 0.5% 8,000 31.79 32.03 0.24 0.8 % 7.60 7.60 0.00 0.24 39.63 0.6 % 7,000 29.59 29.80 0.21 0.7 % 6.65 6.65 0.001 36.45 0.6 % 10,000 38.56 1 36.49 2.07 -5.4% 9.50 9.50 0.00 2.07 45.99 -4.3% 12,000 44.54 1 40.95 3.59 -8.1 % 11.40 11.40 0.00 3.59 52.35 -6.4% 14,000 50.52 1 45.41 5.11 -10.1% 13.30 13.30 0.00 5.11 58.71 -8.0% 16,000 56.50 49.87 6.63 -11.7 % 15.20 15.20 0.00 6.63 65.07 -9.2 % 18,000 64.56 54.33 10.23 -15.8% 17.10 17.10 0.00 10.23 71.43 -12.5% 20,000 72.62 58.79 13.83 -19.0 % 19.00 19.00 0.00 13.83 77.79 -15.1 22,000 80.68 63.25 17.43 -21.6% 20.90 20.90 0.00 17.43 84.15 -17.2% 24,000 68.74 67.71 21.03 -23.7 % 22.80 22.80 0.00 21.03 90.51 -18.9 % 26,000 96.80 72.17 24.63 -25.4 % 24.70 24.70 0.00 24.63 96.87 -20.3 % 28,000 104.86 76.63 28.23 -26.9 % 26.60 26.60 0.00 28.23 103.23 -21.5 30,000 112.92 81.09 31.83 -28.2%1 28.50 28.50 0.00 31.83 109.59 -22.5% 32,000 120.98 85.55 35,43 -29.3% 30.40 1 30.40 0.00 35.43 115.95 -23.4% 34,0001 131.74 90.01 41.73 -31.7% 32.30 32.30 0.00 41.73 122.31 -25.4% 36,000 142.50 94.47 48.03 -33.7% 34.20 34.20 0.00 48.03 128.67 -27.2% 38,000 153.26 98.93 54.33 -35.4% 36.10 36.10 0.00 54.33 135.03 -28.7% 40,000 164.02 103.39 60.63 -37.0 % 38.00 38.00 0.00 60.63 141.39 -30.0 % 42,000 174.78 107.85 66.93 -38.3% 39.90 39.90 0.00 66.93 147.75 -31.2 % 44,000 185.54 112.31 73.23 -39.5% 41.80 41.80 0.00 73.23 154.11 -32.2% 46,000 196.30 116.77 79.53 40.5% 43.70 43.70 0.00 79.53 160.47 -33.1 % 48,000 207.06 121.23 85.83 -41.5% 45.60 45.60 0.00 85.83 166.83 -34.0% 50,000 217.82 125.69 92.13 -42.3% 47.50 47.50 0.00 92.13 173.19 1 -34.7% 52,000 228.58 130.15 98.43 -43.1 % 49.40 49.40 0.00 98.43 179.55 1 -35.4% 54,000 239.34 134.61 104.73 -43.8% 51.30 51.30 0.00 104.73 185.91 -36.0% 56,000 250.10 139.07 111.03 -44.4% 53.20 53.20 0.00 111.03 192.27 .36.6% 58,000 260.86 143.53 117.33 -45.0% 55.10 55.10 0.00 117.33 198.63 -37.1% 60,000 271.62 147.99 123.63 -45.5 % 57.00 57.00 0.00 123.63 204.99 -37.6 % 62,000 282.38 152.45 129.93 -46.0% 58.90 58.90 0.00 129.93 211.35 -38.1% 64,000 293.14 156.91 136.23 -46.5 % 60.80 60.80 0.00 136.23 217.71 -38.5 % 66,000 303.90 161.37 142.53 46.9 % 62.70 62.70 0.00 142.53 224.07 -38.9 % 68,000 314.66 165.83 148.83 -47.3 % 64.60 64.60 0.00 148,83 230.43 -39.2 % 70,000 325.42 170.29 155.13 47.7% 66.50 66.50 0.00 155.13 236.79 -39.6% 72,000 336.18 174.75 161,43 -48.0% 68.40 68.40 0.00 161.43 243.15 -39.9% 74,000 346.94 179.21 167.73 -48.3% 70.30 70.30 0.00 167.73 249.51 1 -40.2% 76,000 357.70 183.67 174.03 48.7% 72.20 72.20 0.00 174.03 255.87 -40.5% 78,000 368.46 188.13 180.33 48.9% 74.10 74.10 0.00 180.33 262.23 -40.7% 80,000 379.22 192.59 166.63 49.2% 76.00 76.00 0.00 186.63 268.59 -41.0% 82,000 389.98 197.05 192.93 -49.5% 77.90 77.90 0.00 192.93 274.95 -41.2% 84,000 400.74 201.51 199.23 49.7 % 79.80 79.80 0.00 199.23 281.31 -41.5 % 86,000 411.50 205.97 205.53 -49.9% 81.70 81.70 0.00 205.53 287.67 -41.7% 88,000 422,26 210.43 211.83 -50.2% 83.60 83.60 0.00 211.83 294.03 -41.9% 90,000 433.02 214.89 218.13 -50.4% 85.50 85.50 0.00 218.13 300.39 -42.1 % 92,000 443.78 219.35 224.43 -50.6 % 87.40 87.40 0.00 224.43 306.75 -42.3 94,000 454.54 223.81 230.73 -50.8% 89.30 89.30I 0 230.73 313.11 -42.4% 96,000 465.30 228.27 237.03 -50.9% 91.20 91.200 237.03 319.47 -42.6% 98,000 476.06 232.73 243,33 -51.1% 93.10 93.100 243.33 325.83 -42.8% 100,000 486.82 237.19 249.63 -51.3% 95.00 95.000 249.63 332.19 -42.9% 102,000 497.58 241.65 255.93 -51A 96.90 96.900 255.93 338.55 -43.1% 104,000 508.34 246.11 262.23 -51.6% 98.80 98.800 262.23 344.91 -43.2% 106,000 519.10 250.57 268.63 -51.7% 100.70 100.700 268.53 351.27 -43.3% 108,000 529.86 255.03 274.83 -51.9 % 102.60 102.600 274.83 357.63 -43.5% 110,000 540.62 259.49 281.13 -52.0% 104.50 104.500 281.13 363.99 -43.6% 112,000 551.38 263.95 287.43 -52.1% 106.40 106.400 287.43 370.35 -43.7% 114,000 562.14 268.41 293.73 -52.3% 108.30 108.300 293.73 376.71 -43.8 116,000 572.90 272.87 300.03 -52.4% 110.20 110.200 300.03 383.07 -43.9% 118,000 583.66 277.33 306.33 -52.5% 112.10 112.100 306.33 389.43 -44.0% 120,000 594.42 281.79 312.63 -52.6% 114.00 114.000 312.63 395.79 -44.1% 122,000 605.18 286.25 318.93 -52.7% 115.90 115.900 318.93 402.15 -44.2% 124,000 615.94 290.71 325.23 -52.8% 117.80 117.80o 325.23 408.51 -44.3% Appendix D Monthly Charges and Percent Increase Comparison 9 of 17 COMMERCIAL & MASTER METERED MULTIY FAMILY CUSTOMER BILL IMPACT WITH 3/4" X 3/4" METER BASE RATE 21.29 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNTOF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE GPF TOTAL MONTHLY INCREASEI DECREASE TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE DECREASE 0 21.29 21.29 0.0% 0.00 21.29 0.07/ 2,000 25.69 25.75 0.06 U 1.90 1.90 0.00 0.06 27.65 0.2% 4,000 30.09 30.21 0.12 0.4% 3.80 3.80 0.00 0.12 34.01 0.4% 6,000 34.49 34.67 0.18 0.5% 5.70 5.70 0.00 0.18 40.37 0.4% 8,000 38.89 39.13 0.24 0.6% 7.60 7.60 0.00 0.24 46.73 0.5% 7,000 36.69 36.90 0.21 0.6% 6.65 6.65 0.00 0.21 43.55 0.5% 10,000 43.29 1 43.59 0.30 1 0.7% 9.501 9.50 0.00 0.30 53.09 0.6% 12,000 49.271 48.05 1.22 -2.5 % 11.40 11.40 0.00 1.22 59.45 -2.0 % 14,000 55.25 1 52.51 2.74 -5.0% 13.30 13.30 0.00 2.74 65.81 -4.0% 16,000 61.23 1 56.97 4.26 -7.0% 15.20 15.20 0.00 4.26 72.17 -5.6% 18,000 67.21 61.43 5.78 -8.6% 17.10 17.10 0.00 5.78 78.53 -6.9% 20,000 73.19 65.89 7.30 -10.0% 19.00 19.00 0.00 7.30 84.89 -7.9% 22,000 79.17 70.35 8.82 -11,1 % 20.90 20.90 0.00 8.82 91.25 -8.8% 24,000 85.15 74.81 10.34 -12.1% 22.80 22.80 0.00 10.34 97.61 -9.6% 26,000 93.21 79.27 13.94 -15.0% 24.70 24.70 0.00 13.94 103.97 -11.8% 28,000 101.27 83.73 17.54 -17.3% 26.60 26.60 0.00 17.54 110.33 73.7% 30,000 109.33 88.19M53.544 -19.3% 28.50 28.50 0.00 21.14 116.69 -15.3% 32,000 117.39 92.65 -21.1% 30.40 30.40 0.00 24.74 123.05 -16.7% 34,000 125.45 97.11 -22.6% 32.30 32.30 0.00 28.34 129.41 -18.0% 36,000 133.51 101.57 -23.9% 34.20 34.20 0.00 31.94 135.77 -19.0% 38,000 141.57 106.03 -25.1 % 36.10 36.10 0.00 35.54 142.13 -20.0% 40,000 149.63 110.49 -26.2% 38.00 38.00 0.00 39.14 148.49 -20.9% 42,000 157.69 114.95 -27.1% 39.90 39.90 0.00 42.74 154.85 -21.6% 44,000 165.75 119.41 -28.0% 41.80 41.80 0.00 46.34 161.21 -22,3% 46,000 173.81 123.87 -28.7% 43.70 43.70 0.00 49.94 167.57 -23.0% 48,000 181.87 128.33 -29.4% 45.60 45.60 0.00 53.54 173.93 -23.5% 50,000 192.63 132.79 59.84 -31.1 % 47.50 47.50 0.00 59.84 180.29 1 -24.9 % 52,000 203.39 137.251(122w844) -32.5% 49.40 49.40 0.00 66.14 186.65 -26.2% 54,000 214.15 141.71 -33.8 % 51.30 5-30 0.00 72.44 193.01 -27.3 % 56,000 224.91 146.17 -35.0% 53.20 53.20 0.00 78.74 199.37 -28.3% 58,000 235.67 150.63 -36.1 % 55.10 55.10 0.00 85.04 205.73 -29.2% 60,000 246.43 155.09 -37.1 % 57.00 57.00 0.00 91.34 212.09 -30.1 % 62,000 257.19 159:55 -38.0% 58.90 58.90 0.00 97.64 218.45 -30.9% 64,000 267.95 164.01 -38.8% 60.80 60.80 0.00 103.94 224.81 -31.6% 66,000 278.71 168.47 -39.6% 62.70 62.70 0.00 110.24 231.17 -32.3% 68,000 289.47 172.93 -40.3% 64.60 64.60 0.00 116.54 237.53 -32.9% 70,000 300.23 177.39 -40.9% 66.50 66.50 0.00 122.84 243.89 -33.5% 72,000 310.99 181.85 129.14 41.5 % 68.40 68.40 0.00 129.14 250.25 -34.0 % 74,000 321.75 186.31 135.44 42.1 % 70.30 70.30 0.00 135.44 256.61 -34.5% 76,000 332.51 190.77 141.74 -42.6% 72.20 72.20 0.00 141.74 262.97 -35.0% 78,000 343.27 195.23 148.04 -43.1 % 74.10 74.10 0.00 148.04 269.33 -35.5% 80,000 354.03 199.69 154.34 43.6% 76.00 76.00 0.00 154.34 275.69 -35.9% 82,000 364.79 204.15 160.64 -44.0% 77.90 77.90 0.00 160.64 282.05 -36.3% 84,000 375.55 208.61 166.94 -44.5% 79.80 79.80 0.00 166.94 288.41 -36.7% 86,000 386.31 213.07 173.24 -44.8% 81.70 81.70 0.00 173.24 294.77 -37.0% 88,000 397.07 217.53 179.54 -45.2% 83.60 83.60 0.00 179.54 301.13 737.4% 90,000 407.831 221.99 185.84 -45.6%1 85.50 85.50 0.00 185.84 307.49 -37.7% 92000 418.59 226.45 192.14 -45.9% 87.40 87.40 0.00 192.14 313.85 -38.0% 94,000 429.35 230.91 198.44 462 89.30 89.30 0.00 198.44 320.21 -383 96,000 440.11 235.37 204.74 -46.5% 91.20 91.20 0.00 204.74 326.57 -38.5% 98,000 450.87 239.83 211.04 46.8% 93.10 93.10 0.00 211.04 332.93 -38.8% 100,000 461.63 244.29 217.34 47.1 % 95.00 95.00 0.00 217.34 339.29 -39.0% 102,000 472.39 248.75 223.64 -47.3% 96.90 96.90 0.00 223.64 345.65 -39.3% 104,000 483.15 253.21 229.94 -47.6% 98.80 98.80 0.00 229.94 352.01 -39.5% 106,000 493.91 257.67 236.24 -47.8% 100.70 100.70 0.00 236.24 358.37 -39.7% 108,000 504.67 262.13 242.54 -48.1 % 102.60 102.60 0.00 242.54 364.73 -39.9% 110,000 1 515.43 266.59 248.84 483 104.50 104.50 0.00 248.84 371.09 -40.1% 112,000 526.19 271.05 255.14 -48.5% 106.40 106.40 0.00 255.14 377.45 -40.3% 114,000 536.95 275.51 261.44 -48.7% 108.30 108.30 0.00 261.44 383.81 -4"' 116,000 547.71 279.97 267.74 -48.9% 110.20 110.20 0.00 267.74 390.17 -40.7% 118,000 558.47 284.43 274,04 -49.1% 112.10 112.10 1.00 274.04 396.53 -40.9% 120,000 569.23 288.89 280.34 -49.2 % 114.00 114.00 0.00 280.34 402.89 -41.0 % 122,000 579.99 293.35 286.64 -49.4 % 115.90 115.90 0.00 286.64 409.25 -41.2 124,000 590.75 297.At 292.94 -49.61 117.80 117.80 0.00 292.94 415.61 1 41.3% Appendix D Monthly Charges and Percent Increase Comparison 10 of 17 COMMERCIAL & MASTER METERED MULTIY FAMILY CUSTOMER BILL IMPACT WITH 1" METER BASE RATE 35.48 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE OFF TOTAL MONTHLY INCREASE/ (DECREASE) TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 35.48 35.48 0.0% 0.00 35.48 O.F. 4,000 44.28 44.40 0.12 0.3% 3.80 3.80 0.00 0.12 48.20 0.2% 8,000 53.08 53.32 0.24 0.5% 7.60 7.60 0.00 0.24 60.92 0.4% 12,000 61.88 62.24 0.36 0.6% 11.40 11.40 0.00 0.36 73.64 0.5% 16,000 70.68 71.16 0.48 0.7% 15.20 15.20 0.00 0.48 86.36 0.6% 17,000 72.88 73.39 0.51 0.7 % 16.15 16.15 0.00 0.51 89.54 0.6% 20,000 81.85 1 80.08 1.77 -2.2 % 19.00 1 19.00 0.00 1.77 99.08 -1.8 % 24,000 93.81 1 89.00 4.81 -5.1 % 22.80 22.80 0.00 4.81 111.80 -4.1 % 28,000 105,771 97.92 7.85 -7.4% 26.60 26.60 0.00 7.85 124.52 -5.9% 32,000 117.731 106.84 10.89 42% 30.40 30.40 0.00 10.89 137.24 -7.4% 36,000 129.69 115.76 13.93 -10.7% 34.20 34.20 0.00 13.93 149.96 -8.5% 40,000 141.65 124.68 16.97 -12.0% 38.00 38.00 0.00 16.97 162.68 -9.4% 44,000 157.77 133.60 24.17 -15.3% 41.80 41.80 0.00 24.17 175.40 -12.1% 48,000 173.89 142.52 31.37 -18.0% 45.60 45.60 0.00 31.37 188.12 -14.3% 52,000 190.01 151.44 38b7 -20.3% 49.40 49.40 0.00 38.57 200.84 -16.1 % 56,000 206.13 160.36 45.77 -22.2 % 63.20 53.20 0.00 45.77 213.56 -17.6 60,000 222.25 169.28 52.97 -23.8%1 57.00 57.00 0.00 52.97 226.28 -19.0% 64,000 238.37 178.20 60.17 -25.2% 60.80 1 60.80 0.00 60.17 239.00 -20.1 % 68,000 254.49 187.12 67.37 -26.5% 64.60 64.60 0.00 67.37 251.72 -21.1% 72,000 1 270.61 196.04 74.57 -27.6% 68.40 68.40 0.00 74.57 264.44 -22.0% 76,000 286.73 1 204.96 81.77 -28.5% 72.20 72.20 0.00 81.77 277,16 -22.8% 80,000 302.85 1 213.88 88.97 -29.4% 76.00 76.00 0.00 88.97 289.88 -23.5% 84,000 324.37 1 222.80 101.57 -31.3% 79.80 79.80 0.00 101.57 302.60 -25.1 88,000 345.89 231.72 114.17 -33.0% 83.60 83.60 0.00 114.17 315.32 -26.67 92,000 367.41 240.64 126.77 -34.5% 87.40 87.40 0.00 126.77 328.04 -27.9% 96,000 388.93 249.56 139.37 -35.8% 91.20 91.20 0.00 139.37 340.76 -29.0% 100,000 410.45 258.48 151.97 -37.0% 95.00 95.00 0.00 151.9 353.48 -30.1% 104,000 431.97 267.40 164.57 -38.1%1 98.80 98.80 0.00 164.57 366.20 -31.0% 108,000 453.49 276.32 177.17 -39.1 % 102.60 1 102.60 0.00 177.17 378.92 -31.9 % 112,000 475.01 285.24 189.77 -40.0% 106.40 106.40 0.00 189.77 391.64 -32.6% 116,000 496.53 294.16 202.37 -40.8% 110.20 110.20 0.00 202.37 404.36 -33.4% 120,000 518.05 303.08 214.97 41.5% 114.00 114.00 0.00 214.97 417.08 -34.0% 124,000 539.57 312.00 227.57 42.2 % 117.80 117.80 0.00 227.57 429.80 -34.6% 128,000 561.09 1 320.92 240.17 42.8 % 121.60 121.60 0.00 240.17 442.52 -35.2% 132,000 582.61 329.84 252.77 -43.4% 125.40 125.40 0.00 252.77 455.24 -35.7% 136,000 604.13 338.76 265.37 43.9% 129.20 129.20 0.00 265.37 467.96 -36.2% 140,000 625.65 347.66 277.97 44.4% 133.00 133.00 0.00 277.97 480.68. -36.6% 144,000 647.17 356.60 290.57 -44.9% 136.80 136.80 0.00 290.57 493.40 -37.1% 148,000 668.69 365.52 303.17 -45.3% 140.60 140.60 1 0.001 (303.171 506.12 -37.5 152,000 690.21 374.44 315.77 -45.7% 144.40 144.40 0.00 315.77 518.84 -37.8% 156,000 711.73 383.36 328.37 -46A % 148.20 148.20 0.00 328.37 531.56 -38.2% 160,000 733.25 392.28 340.97 -46.5% 152.00 152.00 0.00 340.97 544.28 -3&5% 164,000 754.77 401.20 353.57 -46.8% 155.80 155.80 0.00 353.57 557.00 -36.8% 168,000 1 776.29 410.12 366.17 47.2% 159.60 159.60 0.00 366.17 569.72 -39.1 % 172,000 797.81 1 419.04 378.77 47.5% 163.40 163.40 0.00 378.77 582.44 -39.4% 176,000 819.331 427.96 391.37 -47.8% 167.20 167.20 0.00 391.37 595.16 -39.7% 180,000 840.85 1 436.88 403.97 -48.0% 171.00 171.00 0.00 403.97 607.88 -39.9% 184,000 862.37 1 445.80 416.57 48.3% 174.80 174.80 0.00 416.57 620.60 -40.2% 188,000 883.89 454.72 429.17 -48.6%1 178.60 178.60 0.00 429.17 633.32 -47% 192,000 905.41 463.64 441.77 -48.8% 182.40 182.40 0.00 441.77 646.04 -40.6% 196,000 926.93 472.56 454.37 -49.0% 186.20 186.20 0.00 454.37 658.76 1 -40.8% 200,000 948.45 481.48 466.97 49.2% 190.00 190.00 0.00 466.97 671.48 -41.0% 204,000 969.97 490.40 479.57 -49.4% 193.80 193.80 0.00 479.57 684.20 -41.2% 208,000 991.49 499.32 492.17 49.6% 197.60 197.60 0.00 492.17 696.92 -41.4% 212,000 1,013.01 508.24 504.77 49.8% 201.40 201.40 0.00 504.77 709.64 -41.6% 216,000 1,034.53 517.16 517.37 -50v() 205.20 205.20 0.00 517.37 722.36 -41.7% 220,000 1,056.05 526.06 529.97 -50.2% 209.00 209.00 0.00 529.97 735.08 -41.9% 224,000 1,077.57 535.00 542.57 -50.4% 212.80 212.80 0.00 542.57 747.80 -42.0% 228,000 1,099.09 1 543.92 555.17 -50.5% 216.60 216.60 0.00 555.1 760.52 -422% 232,000 1,120.61 552.84 567.77 -50.7% 220.40 220.40 0.00 567.7 773.24 -42.3% 236,000 1,142.13 561.76 580.37 -50.8% 224.20 224.20 0.00 580.37 785.96 -42.5% 240,000 1,163.65 570.68 592.97 -51.0% 228.00 228.00 0.00 592.97 798.68 -42.6% 244,000 1,185.17 579.60 605.57 -51.1%1 231.801 231.80 1 0.00 605.57 811.40 -42.7% 248,000 1,206.69 1 588.52 618.17 -51.2%1 235.60 1 235.60 1 0.00 618.17 824.12 Appendix D Monthly Charges and Percent Increase Comparison 11 of 17 COMMERCIAL & MASTER METERED MULTIFAMILY CUSTOMER BILL IMPACT WITH 1 1/2" METER BASE RATE 70.95 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE GPF TOTAL MONTHLY INCREASE DECREASE TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 70.95 70.95 0.0 % 0.00 70.95 0.0 % 5,000 81.95 82.10 0.15 0.2 % 4.75 4.75 0.00 0.15 86.85 0.2 % 10,000 92.95 93.25 0.30 0.3% 9.50 9.50 0.00 0.30 102.75 0.3% 15,000 103.95 104.40 0.45 0.4% 14.25 14.25 0.00 0.45 118.65 0.4% 20,000 114.95 115.55 0.60 0.5% 19.00 19.00 0.00 0.60 134.55 0.4% 25000 125.95 126.70 0.75 0.6% 23.75 23.75 0.00 0.75 150.45 0.5% 30,000 136.95 137,85 0.90 0.7%1 28.50 28.50 0.00 0.90 166.35 0.5% 35,000 147.95 149.00 1.05 1 0.7% 33.25 33.25 0.00 1.05 182.25 0.6% 40,000 162.90 160.15 2.75) -1.7% 38.00 38.00 0.00 2.75 198.15 -1.4% 45,000 177.85 171.30 6.55 -3.7 % 42.75 42.75 0.00 6.55 214.05 -3.0 % 50,000 192,80 182.45 10.35 -5.4% 47.50 47.50 0.00 10.35 229.95 -4.3% 55,000 207.75 193.60 14.15 -6.8% 52.25 52.25 0.00 14.15 245.85 -5.4% 60,000 222.70 204.75 17.95 -8.1% 57.00 57.00 0.o0 17.95 261.75 -6.4% 65,000 237.65 215.90 21,75 -9.2% 61.75 61.75 0.00 21.75 277.65 -7.3% 70,000 252.60 227.05 25.55 -10.1 % 66.50 66.50 0.00 25.55 293.55 -8.0% 75,000 267.55 238.20 29.35 A 1.0 % 71.25 71.25 0.00 29.35 309.45 -8.7% 80,000 1 282.50 249.35 33.15 -11.7% 76.00 76.00 0.00 33.15 325.35 -9.2% 85,000 302.65 260.50 42.15 -13.9% 80.75 80.75 0.00 42.15 341.25 -11.0% 90,000 322.80 271.65 51.15 -15.8% 85.50 85.50 0.00 51.15 357.15 -12.5% 95,000 342.95 282.80 60.15 -17.5% 90.25 90.25 0.00 60.15 373.05 -13.9% 100,000 363.10 293.95 69.15 -19.0% 95.00 95.00 0.00 69.15 388.95 -15.1% 105,000 383.25 305.10 78.15 -20A% 99.75 99.75 0.00 78.15 404.85 -10% 110,000 403.40 316.25 87.15 -21.6% 104.50 104.50 0.00 87.15 420.75 -17.2% 115,000 423.55 327.40 96.15 -22.7% 109.25 109.25 0.00 96.15 436.65 -18.0% 120,000 443.70 338.55 105.15 -23.7% 114.00 114.00 0.00 105.15 452.55 -18.9% 125,000 463.85 349.70 114.15 -24.6% 118.75 118.75 0.00 114.15 468.45 -19.6% 130,000 484.00 360.85 123.15 -25.4%1 123.50 123.50 0.00 123.15 484.35 -20.3% 135,000 1 504.15 372.00 132.15 -26.2% 128.25 128.25 0.00 132.15 500.25 -20.9% 140,000 524.30 383.15 141.15 -2&9% 133.00 133.00 0.00 141.15 516.15 -21.5% 145,000 544.45 394.30 150.15 -27.6% 137.75 137.75 0.00 150.15 532.05 -22.0% 150,000 564.60 405.45 159.15 -28.2% 142.50 142.50 0.00 159.15 547.95 -22.5% 155,000 584.75 416.60 168.15 -28.8% 147.25 147.25 0.00 168.15 563.85 -23.0% 160,000 604.90 427.75 177.15 -29.3% 152.00 152.00 0.00 177.15 579.75 -23.4% 165,000 625.05 438.90 186.15 -29.8 % 156.75 156.75 0.00 186.15 595.65 -23.8% 170,000 658.70 450.05 208.65 -37.7% 161.50 161.50 0.00 208.65 611.55 -25.4% 175,000 685.60 461.20 224.40 -32.7% 166.25 166.25 0.00 224.40 627.45 -26.3% 180,000 712.50 472.35 240.15 -33.7% 171.00 171.00 0.00 240.15 643.35 -27.2% 185,000 739.40 483.50 255.90 -34.6% 175.75 175.75 0.00 255.90 659.25 -28.0% 190,000 766.30 494.65 271.65 -35A% 180.50 180.50 0.00 271.65 675.15 1 -28.7% 195,000 793.20 505.80 287.40 -36.2% 185.25 185.25 0.00 287.40 691.05 -29.4% 200,000 820.10 516.95 303.15 -37.0% 190.00 190.00 0.00 303.15 706.95 -30.0% 205,000 847.00 528.10 318.90 -37.7% 194.75 194.75 0.00 318.90 722.85 -30.6% 210,000 873.90 539.25 334.65 -38.3% 199.50 199.50 0.00 334.65 738.75 -31.2% 215,000 900.80 550.40 350.40 -38.9% 204.25 204.25 0.00 350.40 754.65 -31.7% 220,000 927.70 561.55 366.15 -39.5 % 209.00 209.00 0.00 366.15 770.55 -32.2 % 225,000 954.60 572.70 381.90 -40.0 % 213.75 213.75 0.00 381.90 786.45 -32.7% 230,000 981.50 583.85 397.65 -40.5% 218.50 218.50 0.00 397.65 802.35 -33.1% 235,000 1,008.40 595.00 413.40 -41.0% 223.25 223.25 0.00 413.40 818.25 -33.6% 240,000 1,035.30 606.15 429.15 -41.5% 228.00 228.00 0.00 429.15 834.15 -34.0% 245,000 1,062.20 617.30 444.90 41.9% 232.75 232.75 0.00 444.90 850.05 1 -34.4% 250,000 1,089.i0 628.45 460.65 4243% 237.50 237.50 0.00 460.65 865.95 -34.7% 255,000 1,116.00 639.60 476.40 42.7% 242.25 242.25 0.00 476A0 881.85 -35.1% 260,000 1,142.90 650.75 492.15 -43.1 % 247.00 247.00 0.00 492.15 897.75 -35.4% 265,000 1,169.80 661.90 507.90 -43.4% 251.75 251.75 0.00 507.90 913.65 -35.7% 270,000 1,196.70 673.05 523.65 -43.8% 256.50 256.50 0.00 523.65 929.55 -36.0% 275,000 1,223.60 684.20 539.40 -44.1 % 261.25 261.25 0.00 539.40 MA5 -36.3% 280,000 1,250.50 695.35 555.15 -44.4%1 266.00 266.00 0.00 555.15 961.35 -36.6% 1,277.40 706.50 570.90 -44.7% 270.75 270.75 0.00 570.90 977.25 -36.9% 1,304.30 717.65 586.65 -45.0% 275.50 275.50 0.00 586.65 993.15 -37.1% 1,331.20 728.80 602.40 -45.3% 280.25 280.25 0.00 602.40 1,009.05 -37.4% N3O5,000 1,358.10 739.95 618.15 285.00 285.00 0.00 618.15 1,024.95 -37.6% 1,385.00 751.10 633.90 -45.8% 289.75 289.75 0.00 633.90 1,040.85 -37.9% 1,411.90 762.25 649.65 -46.0% 294.50 294.50 0.00 649.65 1,056.75 -38.1% 1,438.80 773.40 665.40 -46.2% 299.25 299.25 0.00 665.40 1,072.65 1 -38.3% Appendix D Monthly Charges and Percent Increase Comparison 12 of 17 COMMERCIAL & MASTER METERED MULTIFAMILY CUSTOMER BILL IMPACT WITH 2" METER BASE RATE 113.53 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE GPF TOTAL MONTHLY INCREASE DECREASE TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE! DECREASE 0 113.53 113.53 0.0% 0.00 113.53 0.0% 5,000 124.53 124.68 0.15 0.1 % 4.75 4.75 0.00 0.15 129.43 0.1% 10,000 135.53 135.83 0.30 0.2 % 9.50 9.50 0.00 0.30 145.33 0.2 % 15,000 146.53 146.98 0.45 0.3% 14.25 14.25 0.00 0.45 161.23 0.3% 20,000 157.53 158.13 0.60 0.4% 19.00 19.00 0.00 0.60 177.13 0.3% 25,000 168.53 169.28 0.75 0.4% 23.75 23.75 0.00 0.75 193.03 0.4% 30,000 1 179.53 180.43 0.90 0.5% 28.50 28.50 0.00 0.90 208.93 0.4% 35,000 190.53 191.58 1.05 0.6% 33.25 33.25 0.00 1.05 224.83 0.5% 40,000 201.53 202.73 1.20 0.6% 38.00 38.00 0.00 1.20 240.73 0.5 % 45,000 212.53 213.88 1.35 0.6% 42.75 42.75 0.00 1.35 256.63 0.5% 50,000 223.53 225.03 1.50 0.7% 47.50 47.50 0.00 1.50 272.53 0.6% 55,000 234.53 236.18 1.65 0.7% 52.25 52.25 0.00 1.65 288.43 0.6% 56,000 236.73 238.41 1.68 0.7% 53.20 53.20 0.00 1.68 291.61 0.6% 60,000 248.69 247,33 1.36 -0.5% 57.00 57.00 0.00 1.36 304.33 -0.4% 66,000 263.64 258.48 5.16 -2.0% 61.75 61.75 0.00 5.16 320.23 -1.6% 70,000 278.59 269.63 8.96 -3.2% 66.50 66.50 0.00 8.96 336.13 -2.6% 75,000 293.54 1 280.78 12.76 -4.3 % 71.25 71.25 0.00 12.76 352.03 -3.5 80,000 308.49 1 291.93 16.56 -5.4% 76.00 76.00 0.00 16.56 367.93 -4.3% 85,000 323.441 303.08 20.36 -6.3% 80.75 80.75 0.00 20.36 383.83 -5.0% 90,000 338.39 1 314.23 24.16 -7.1 % 85.50 85.50 0.00 24.16 399.73 -5.7% 95,000 353.34 1 325.38 27.96 -7.9% 90.25 90.25 0.00 27.96 415.63 -6.3% 100,000 368.29 1 336.53 31.76 -&6% 95.00 95.00 0.00 31.76 431.53 -6.9% 105,000 383.24 1 347.68 35.56 -9.3% 99.75 99.75 0.00 35.56 447.43 -7.4% 110,000 398.19 1 358.83 39.36 -9.9% 104.50 104.50 0.00 39.36 463.33 -7.8% 115,000 413.14 1 369.98 43.16 -10.4% 109.25 109.25 0.00 43.16 479.23 -8.3% 120,000 428.09 381.13 46.96 -11.0% 114.00 114.00 0.00 46.96 495.13 -8.7% 125,000 443.04 392.28 50.76 -11.5 % 118.75 1 118.75 0.00 50.76 511.03 -9.0% 128,000 452.01 398.97 53.04 -11.7% 121.60 1 121.60 0.00 53.04 520.57 -9.2% 130,000 460.07 403.43 56.64 -12.3% 123.50 123.50 0.00 56.64 526.93 -9.7% 135,000 480.22 414.58 65.64 -13.7% 128.25 128.25 0.00 65.64 542.83 -10.8% 140,000 500.37 425.73 74.64 -14.9% 133.00 133.00 0.00 74.64 558.73 -11.8% 145,000 520.52 436.88 83.64 -16.1 % 137.75 137.75 0.00 83.64 574.63 .12.7% 150,000 540.67 448.03 92.64 -17.1% 142.50 142.50 0.00 92.64 590.53 -13.6% 155,000 560.82 459.18 101.64 -18.1 % 147.25 147.25 0.00 101.64 606.43 -14.4% 160,000 580.97 470.33 110.64 -19.0% 152.00 152.00 0.00 110.64 622.33 -15.1% 165,000 601.12 481.46 119.64 -19.9% 156.75 156.75 0.00 119.64 638.23 -15.8% 170,000 621.27 492.63 128.64 -20.7% 161.50 161.50 0.00 128.64 654.13 -16.4% 175,000 641.42 503.78 137.64 -21.5% 166.25 166.25 0.00 137.64 670.03 -17.0% 180,000 661.57 514.93 146.64 -22.2 % 171.00 171.00 0.00 146.64 685.93 -17.6 % 185,000 681.72 526.08 155.64 -22.8% 175.75 175.75 0.00 155.64 701.83 -18.2% 190,000 701.87 537.23 164.64 -23.5% 180.50 180.50 0.00 164.64 717.73 -18.7% 195,000 722.02 548.38 173.64 -24.0% 185.25 185.25 0.00 173.64 733.63 -19.1% 200,000 742.17 559.53 182.64 -24115 190.00 190.00 0.00 182.64 749.53 -19.6% 205,000 762.32 570.68 191.64 -25.1 % 194.75 194.75 0.00 191.64 765.43 -20.0% 210,000 782.47 581.83 200.64 -25.6% 199.50 199.50 0.00 200.64 781.33 -20.4% 215,000 802.62 592.98 209.64 -26.1 % 204.25 204.25 0.00 209.64 797.23 -20.8 % 220,000 822.77 604.13 218.64 -26.6% 209.00 209.00 0.00 218.64 813.13 -21.2% 225,000 842.92 615.28 227.64 -27.0 % 213.75 213.75 0.00 227.64 829.03 -21.5 % 230,000 863.07 626.43 236.64 -27.4% 218.50 218.50 0.00 236.64 844.93 -21.9% 235,000 883.22 637.58 245.64 -27.8% 223.25 223.25 0,00 245.64 860.83 1 -22.2% 240,000 903.37 648.73 254.64 -28.2% 228.00 228.00 0.00 254.64 876.73 1 -22.5% 245,000 923.52 659.88 263.64 -28.5%1 232.75 232.75 0.00 263.64 892.63 -22.8% 250,000 943.67 671.03 272.64 -28.9% 237.50 237.50 0.00 272.64 908.53 -23.1% 255,000 963.82 682.18 281.64 -29.2% 242.25 242.25 0.00 281.64 924.43 -23.4/ 256,000 967.85 684.41 283.44 -29.3% 243.20 243.20 0.00 283.44 927.61 -23.4% 260,000 989.37 693.33 296.04 -29.9% 247.00 247.00 0.00 296.04 940.33 -2. 9% 1,016.27 704.48 311.79 -30.7% 251.75 251.75 0.00 311.79 956.23 -24.6% 1,043.17 715.63 327.54 -31.4% 256.50 256.50 0.00 327.54 972.13 -25.2% 1,070.07 726.78 343.29 -32.1% 261.25 261.25 0.00 343.29 988.03 -25.8% 1,096.97 737.93 359.04 -32.7% 266.00 266.00 0.00 359.04 1,003.93 -26.3% K 1,123.87 749.08 374.79 -33.3% 270.75 270.75 0.00 374.79 1,019.83 -26.9% 1,150.77 760.23 390.54 -33.9% 275.50 275.50000 390.541,035.73 -2 1,177.67 771.38 406.29 -34.5% 280.25 28US 0.00 405.29 1,051.63% 1,204.57 782.53 422.04 -35.0% 285.00 285.00 0.00 422.04 1,067.53 -28.3% Appendix D Monthly Charges and Percent Increase Comparison 13 of 17 COMMERCIAL & MASTER METERED MULTIFAMILY CUSTOMER BILL IMPACT WITH 3" METER BASE RATE 227.05 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE GPF TOTAL MONTHLY INCREASEI DECREASE TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 227.05 227.05 0.0 % 0.00 227.05 0.0 % 20,000 271.05 271.65 0.60 0.2% 19.00 19.00 0.00 0.60 290.65 0.2% 40,000 315.05 316.25 1.20 0.4% 38.00 38.00 0.00 1.20 354.25 0.3% 60,000 359.05 360.85 1.80 0.5% 57.00 57.00 0.00 1.80 417.85 0.4% 80,000 403.05 405.45 2.40 0.6% 76.00 76.00 0.00 2.40 481.45 0.5% 100,000 447.05 450.05 3.00 0.7% 95.00 95.00 0.00 3.00 545.05 0.6% 112,0001 473.45 476.81 3.36 0.7 % 106.40 106.40 0.00 3.36 583.21 0.6% 120,000 497.37 1 494.65 2.72 -0.5% 114.00 114.00 0.00 2.72 608.65 -0.4% 140,000 557.17 539.25 17.92 -3.2% 133.00 133.00 0.00 17.92 672.25 -2.6% 160,000 616.97 583.85 33.12 -5.4% 152.00 152.00 0.00 33.12 735.85 -4.3% 180,000 676.77 628.45 48.32 -7.1% 171.00 171.00 0.00 48.32 799.45 -5.7% 200,000 736.57 673.05 63.52 -8.6% 190.00 190.00 0.00 63.52 863.05 -6.9% 220,000 796.37 717.65 78.72 -9.9% 209.00 209.00 0.00 78.72 926.65 -7.8% 240,000 856.17 762.25 93.92 -11.0% 228.00 228.00 0.00 93.92 990.25 -8.7% 256,000 904.01 797.93 106.08 -11.7% 243.20 243.20 0.00 106.08 1041.13 -9.2% 260,000 920.13 806.85 113.28 -12.3% 247.00 247.00 0.00 113.28 1,053.85 -9.7% 280,000 1,000.73 851.45 149.28 -14.9% 266.00 266.00 0.00 149.28 1,117.45 -11.8% 300,000 1 1,081.33 896.05 185.28 -17.1% 285.00 285.00 0.00 185.28 1,181.05 -13.6% 320,000 1,161.93 940.65 221.28 -19.0% 304.00 304.00 0.00 221.28 1,244.65 -15.1% 340,000 1,242.53 985.25 257.28 -20.7% 323.00 323.00 0.00 257.28 1,308.25 -16.4% 360,000 1,323.13 1,029.85 293.28 -22.2% 342.00 342.00 0.00 293.28 1,371.85 -17.6% 380,000 1,403.73 1,074.45 329.28 -23.5% 361.00 361.00 0.00 329.28 1,435A5 -18.7% 400,000 1,484.33 1,119.05 365.28 -24.6% 380.00 380.00 0.00 365.28 1,499.05 -19.6% 420,000 1,564.93 1,163.65 401.28 -25.6% 399.00 399.00 0,00 401.28 1,562.65 -20.4% 440,000 1,645.53 1,208.25 437.28 -26.6% 418.00 418.00 0.00 437.28 1,626.25 -21.2% 460,000 1,726.13 1,252.85 473.28 -27.4% 437.00 437.00 0.00 473.28 1,689.85 -21.9% 480,000 1,806.73 1,297.45 509.28 -28.2% 456.00 456.00 0.00 509.28 1,753.45 -22.5% 500,000 1,887.33 1,342.05 545.28 -28.9% 475.00 475.00 0.00 545.28 1,817.05 -23.1% 512,000 1,935.69 1,368.81 566.88 -29.3% 486.40 486.40 0.00 566.88 1,855.21 -23.4% 520,000 1,978.73 1 386.65 592.08 -29.9% 494.00 494.00 0.00 592.08 1,880.65 -23.9% 540,000 2,086.33 1,431.25 655.08 -31.4% 513.00 513.00 0.00 655.08 1,944.25 -25.2% 560,000 2,193.93 1,475.85 718.08 =32.7% 532.00 532.00 0.00 718.08 2,007.85 -26.3% 580,000 2,301.53 1,520.45 781.08 -33.9% 551.00 551.00 0.00 781.08 2,071.45 -27.4% 600,000 2,409.13 1,565.05 844.08 -35.0% 570.00 570.00 0.00 844.08 2,135.05 -28.3% 620,000 2,516.73 1,609.65 907.08 -36.0% 589.00 589.00 0.00 907.08 2,198.65 -29.2% 640,000 2,624.33 1,654.25 970.08 -37.0% 608.00 608.00 0.00 970.08 2,262.25 -30.6% 660,000 2,731.93 1,698.85 1,033.08 -37.8 % 627.00 1 627.00 0.00 1,033.08 2,325.85 -30.8% 680,000 2,839.53 1,743.45 1,096.08 -38.6 % 646.00 646.00 0.00 1,096.08 2,389.45 -31.4% 700,000 2,947.13 1,788.05 1 159.08 -39.3% 665.00 665.00 0.00 (11159.08) 2,453.05 -32.1% 720,000 3,054.73 1,832.65 1,222.08 40.0 % 684.00 684.00 0.00 (1,222.08) 2,516.65 -32.7% 740,000 3,162.33 1,877.25 1,285.08 40.6 % 703.00 703.00 0.00 1,285.08 2,580.25 -33.2% 760,000 3,269.93 1,921.85 1,348.08 -41.2% 722.00 722.00 0.00 1,348.08 2,643.85 -33.8% 780,000 3,377.53 1,966.45 1,411.08 -41.8 % 741.00 741.00 0.00 1,411.08 2,707.45 -34.3% 800,000 3,485.13 2,011.05 1,474.08 42.3 % 760.00 760.00 0.00 1,474.08 2,771.05 -34.7% 820,000 3,592.73 2,055.65 1,537.08 42.8% 779.00 779.00 0.00 1537.08 2,834.65 -35.2% 840,000 3,700.33 2,100.25 1,600.08 43.2% 798.00 798.00 0.00 1,600.08 2,898.25 -35.6% 860,000 3,807.93 2,144.85 1663.08 -43.7% 817.00 817.00 0.00 1,663.08 2,961.85 -36.6% 880,000 3,915.53 2,189.45 1,726.08 -44.1% 836.00 1 836.00 0.00 1,726.08 3,025.45 -36.3% 900,000 4,023.13 2,234.05 1,789.08 -44.5% 855.00 855.00 0.00 (1,789.08)1 3,089.05 -36.7% 920,000 4,130.73 2,278.65 1,852.08 -44.8% 874.00 874.00 0.00 (1.852.08) 3,152.65 -37.0 % 940,000 4,238.33 2,323.25 1,915.08 45.2% 893.00 893.00 0.00 1,915.08 3,216.25 -37.3 % 960,000 4,345.93 2,367.85 1,978.08 45.5% 912.00 912.00 0.00 (1,978.08) 3,279.85 -37.63/6 980,000 4,453.53 2,412.45 2,041.08 -45.8% 931.00 931.00 0.00 (2,041.08) 3,343.45 -37.9% 1,000,000 4,561.13 2,457.05 2,104.08 -46.1 % 950.00 950.00 0.00 2,104.08 3,407.05 -38.2% 1,020,000 4,668.73 2,501.65 2,167.08 -46.4% 969.00 969.00 0.00 2,167.08 3,470.65 -38.4% 1,040,000 4,776.33 2,546.25 2,230.08 -46.7% 988.00 988.00 0.00 2230.08 3534.25 -38.7% 1,060,000 4,883.93 2,590.85 2,293.08 -47.0 % 1,007.00 1,007.00 0.00 2,293.08 3,597.85 -38.9 % 1,080,000 4,991.53 1 2,635.45 2,356.08 -47.2% 1,026.00 1,026.00 0.00 2,356.09 3,661.45 -39.2% 1,100,000 5,099.13 2,680.05 2,419.08 -47.4 % 1,045.00 1,045.00 0.00 2,419.08 3,725.05 -39.4% 1,120,000 5,206.73 2,724.65 2,482.08 47.7 % 1,064.00 1,064.00 0.00 2,482.08 3 788.65 -39.6% 1,140,000 5,314.33 2,769.25 2,545.08 -47.9 % 1,083.00 1,083.00 0.00 2,545.08 3,852.25 -39.8 1,160 000 5,421.93 2,813.85 2,608.08 48.1 % 1,102.00 1,102.00 0.00 2,608.08 3,915.85 -40.0 % 1,180,000 5,529.53 2,858.45 2,671.08 48.3 % 1,121.00 1,121.00 0.00 2,671.08 3,979.45 -40.2 1,200,000 5,637.13 2,903.05 2,734.08 -48.5 % 1,140.00 1,140.00 0.00 2,734.08 4,043.05 -40.3 Appendix D Monthly Charges and Percent Increase Comparison 14 of 17 COMMERCIAL & MASTER METERED MULTIFAMILY CUSTOMER BILL IMPACT WITH 4" METER BASE RATE 354.77 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNTOF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNT OF INCREASE OFF TOTAL MONTHLY INCREASE/ DECREASE TOTAL AMOUNT OF MONTHLY BILL TOTAL PERCENT INCREASE DECREASE 0 354.77 354.77 0.0% 0.00 354.77 0.0% 30,000 420.77 421.67 0.90 0.2% 28.50 28.50 0.00 0.90 450.17 0.21/6 60,000 486.77 488.57 1.80 0.4% 57.00 57.00 0.00 1.80 545.57 0.3% 90,000 552.77 555.47 2.70 0.5% 85.50 85.50 0.00 2.70 640.97 0.4% 120,000 618.77 622.37 3.60 0.6% 114.00 114.00 0.00 3.60 736.37 0.5% 150,000 684.77 689.27 4.50 0.7 % 142.50 142.50 0.00 4.50 831.77 0.5 % 175,000 1 739.77 745.02 1 5.25 07% 166.25 166.25 0.00 5.25 911.27 0.6% 180,000 754.72 756.17 1.45 0.2 % 171.00 171.00 0.00 1.45 927.17 0.2 % 210,000 844.42 823.07 21.35 -2.5% 199.50 199.50 0.00 21.35 1,022.57 -2.0% 240,000 934A2 889.97 44.15 -4.7% 228.00 228.00 0.00 44.15 1,117.97 -3.8% 270,000 1,023.82 956.87 66.95 -6.5% 256.50 256.50 0.00 66.95 1213.37 -5.2% 300,000 1,113.52 1,023.77 89.75 -8.1 % 285.00 285.00 0.00 89.75 1,308.77 -6.4% 330,000 1,203.22 1,090.67 112.55 -9.4% 313.50 313.50 0.00 112.55 1.404.17 -7.4% 360,000 1,292.92 1,157.57 135.35 -10.5% 342.00 342.00 0.00 135.35 1.499.57 -8.3% 390,000 1,382.62 1,224.47 158.15 -11.4% 370.50 370.50 0.00 158.15 1,594.97 -9.0% 400,000 1,412.52M1,246.770.77 165.75 -11.7% 380.00 380.00 0.00 165.75 1,626.77 -9.2% 420,000 1,493.12,37 201.75 -13.5 % 399.00 399.00 0.00 201.75 1,690.37 -10.7% 450,000 1,614.02.27 255.75 -15.8% 427.50 427.50 0.00 255.75 1,785,77 -12.5% 480,000 1,734.9217 309.75 -17.9% 456.00 456.00 0.00 309.75 1,881.17 -14.1% 510,000 1,855.8207 363.75 -19.6% 484.50 484.50 0.00 363.75 1,976.57 -15.5%540,000 1,976.7297 417.75 -21.1% 513.00 513.00 0.00 417.75 2,071.97 -16.8% 570,000 2,097.6287 471.75 -22.5% 541.50 541.50 0.00 471.75 2,167.37 -17.9% 600,000 2,218.5277 525.75 -23.7% 570.00 570.00 0.00 525.75 2,262.77 -18.9% 630,000 2,339.42.67 579.75 -24.8% 598.50 598.50 0.00 579.75 2,358.17 -19.7% 660,000 2,460.32.57 633.75 -25.8% 627.00 627.00 0.00 633.75 2,453.57 -20.5% 690,000 2,581.22 1,893.47 687.75 -26.6% 655.50 655.50 0.00 687.75 2,548.97 -21.2% 720,000 2,702.12 1,960.37 741.75 -27.5% 684.00 684.00 0.00 741.75 2,644.37 -21.9% 750,000 2,823.02 2,027.27 795.75 -28.2% 712.50 712.50 0.00 795.75 2,739.77 -22.5% 780,000 2,943.92 2,094.17 849.75 -28.9% 741.00 741.00 0.00 849.75 2,835.17 -23.1% 800,000 3,024.52 2,138.77 885.75 -29.3% 760.00 760.00 0.00 885.75 2,898.77 -23.4% 810,000 3,078.32 2,161.07 917.25 -29.8% 769.50 769.50 0.00 917.25 2,930.57 -23.8% 840,000 3,239.72 2,227.97 1,011.75 -31.2% 798.00 798.00 0.00 (1,011.75) 3,025.97 -25.1% 870,000 3,401.12 2,294.87 1,106.25 -32.5% 826.50 826.50 0:00 1,106.25 3,121.37 -26.2% 900,000 3,562.52 2,361.77 1,200.75 -33.7% 855.00 855.00 0.00 1200.75 3,216.77 -27.2% 930,000 3,723.92 2,428.67 1,295.25 -34.8% 883.50 883.50 0.00 1,295.25 3,312.17 -28.1% 960000 3,885.32 2,495.57 1,389.75 -35.8% 912.00 912.00 0.00 1389.75 3,407.57 -29.0% 990,000 4,046.72 2,562.47 1,484.25 -36.7% 940.50 940.50 0.00 (1,484.25) 3,502.97 -29.8% 1,020,000 4,208.12 2,629.37 1,578.75 -37.5 % 969.00 969.00 0.00 1,578.75 3,598.37 -30.5% 1,050,000 4,369.52 2,696.27 1 673.25 -38.3 % 997.50 997.50 0.00 (1,673.25) 3,693.77 -31.2% 1,080,000 4,530.92 2,763.17 1,767.75 -39.0 % 1,026.00 1,026.00 0.00 1,767.75 3,789.17 -31.8% 1,110,000 4,692.32 2,830.07 1,862.25 -39.7% 1,054.50 1,054.50 0.00 (1,862.25) 3,884.57 -32.4 % 1,140,000 4,853.72 2,896.97 1,956.75 -40.3% 1,083.00 1,08300 0.00 1,956.75 3,979.97 -33.0% 1,170,000 5,015.12 2,963.87 2,051.25 -40.9 % 1,111.50 1,111.50 0.00 2,051.25 4,075.37 -33.5% 1,200,000 5,176.52 3,030.77 2,145.75 -41.5 % 1,140.00 1,140.00 0.00 2,145.75 4,170.77 -34.0% 1,230000 5337.92 3,097.67 2,240.25 -42.0% 1,168.50 1,168.50 0.00 2,240.25 4,266.17 -34.4% 1,260,000 5,499.32ffi3,699.773,090.75 .57 2,334.75 -42.5 % 1,197.00 1,197.00 0.00 2,334.75 4,361.57 -34.9% 1,290,000 5,660.7247 2,429.25 -42.9% 1,225.50 1,225.50 0.00 2,429.25 4,456.97 -35.3 % 1,320,000 5,822.1237 2,523.75 -43.3 % 1,254.00 1,254.00 0.00 2,523.75 4,552.37 -35.7% 1350,000 5,983.5227 2,618.25 -43.8% 1,282.50 1,282.50 0.00 2618.25 4647.77 -36.0% 1,380,000 6,144.9217 2,712.75 -44.1 % 1,311.00 1,311.00 0.00 2,712.75 4,743.17 -36.4% 1,410,000 6,306.32.07 2,807.25 -44.5 % 1,339.50 1,339.50 0.00 2,807.25 4,838.57 -36.7% 1,440,000 63467.72.97 2,901.75 -44.9 % 1,368.00 1,368.00 0.00 2,901.75 4,933.97 -37.0% 1,4703000 63629.12.87 2,996.25 -45.2 % 1,396.50 1,396.50 0.00 (2,996.25) 5,029.37 -37.3% 1,500,000 6,790.52.77 3,090.75 -455% 142500 13425.00 0.00 3 090.75 5,124.77 -37.6 %1,530,000 6,951.92.67 3,185.25 -45.8 % 1,453.50 13453.50 0.00 3,185.25 5,220.17 -37.9 % 1,560,000 7,113.32 3,833.57 3,279.75 -46.1 % 1,482.00 1,482.00 0.00 3,279.75 53315.57 -38.2 % 1,590,000 7,274.72 3,900.47 3,374.25 -46.4 % 1,510.50 1,510.50 0.00 (3,374.25) 53410.97 -38.4% 1,620,000 7,436.12 3,967.37 3,468.75 -46.6 % 1,539.00 1,539.00 0.00 (3,468.75) 5,506.37 -38.6% 1,650,000 7,597.52 4,034.27 3,563.25 -46.9 % 1,567.50 1,567.50 0.00 3,563.25 5,601.77 -38.9 % 1,680,000 73758.92 4,101.17 3,657.75 47.1 % 1,596.00 1,596.00 0.00 (3,657.75) 5,697.17 -39.1 % 1,710,000 73920.32 4,168.07 3,752.25 -47.4% 1,624.50 1,624.50 0.00 (3,752.25) 5,792.57 -39.3 1,740,000 8,081.72 4,234.97 33846.75 -47.6 % 1,653.00 1,653.00 0.00 (3,846.75) 5,887.97 -39.5 % 1,770,000 8,243.12 4,301.87 3,941.25 -47.8 % 1,681 w50 1,681.50 0.00 3,941.25 5,983.37 -39.7% 1,800,000 8,404.52 4,368.77 4,035.75 48.0 % 1,710.00 1,710.00 0.00 4,035.75 6,078.77 -39.9 Appendix D Monthly Charges and Percent Increase Comparison 15 of 17 COMMERCIAL & MASTER METERED MULTIFAMILY CUSTOMER BILL IMPACT WITH 6" METER BASE RATE 709.54 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE OFF TOTAL MONTHLY INCREASE/ DECREASE TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 709.54 709.54 0.0 % 0.00 709.54 0.07. 50,000 819.54 821.04 1.50 0.2% 47.50 47.50 0.00 150 868.54 0.2% 100,000 929.54 932.54 3.00 0.3% 95.00 95.00 0.00 3.00 1,027.54 0.3% 150,000 1,039.54 1,044.04 4.50 0.4% 142.50 142.50 0.00 4.50 1,186.54 0.4% 200,000 1,149.54 1,155.54 6.00 0.5% 190.00 190.00 0.00 6.00 1,345.54 0.4% 250,000 1,259.54 1,267.04 7.50 0.6% 237.50 237.50 0.00 7.50 1,504.54 0.5% 300,000 1,369.54 1 1,378.54 9.001 0.7% 285.00 1 285.00 0.00 9.00 1,663.54 0.5% 350,000 1,479.54 1,490.04 10.50 0.7% 332.50 332.50 0.00 10.50 1,822.54 0.6% 400,000 1,589.54 1,601.54 12.00 0.8% 380.00 380.00 0.00 12.00 1,981.54 0.6% 450,000 1,699.54 1,713.04 13.50 0.8% 427.50 427.50 0.00 13.50 2,140.54 0.6% 500,000 1,809.54 1,824.54 15.00 0.8% 475.00 475.00 0.00 15.00 2,299.54 0.7% 550,000 1,919.54 1,936.04 16.50 0.9% 522.50 522.50 0.00 16.50 2,458.54 0.7% 600,000 2,029.54 2,047.54 18.00 0.9% 570.00 570.00 0.00 18.00 2,617.54 0.7% 650,000 2,139.54 2,159.04 19.50 0.9% 617.50 617.50 0.00 19.50 2,776.54 0.7% 700,000 2,249.54 2,270.54 21.00 0.9% 665.00 665.00 0.00 21.00 2,935.54 0.7% 750,000 2,359.54 2.382.04 22.50 1.0% 712,50 712.50 0.00 22.50 3,094.54 0.7% 800,000 2,469.54 2,493.54 24.00 1.0% 760.00 760.00 0.001 24.00 3,253.54 0.7% 850,000 2,579.54 2,605.04 25.50 1 1.0% 807.50 1 807.50 0.00 25.50 3,412.54 0.8% 860,000 2,601.54 2,627.34 25.80 1.0% 817.00 817.00 0.00 25.80 3,444.34 0.8% 900,000 2,721.14 2,716.54 4.60 -0.2 % 855.00 855.00 0.00 4.60 3,571.54 -0.1 950,000 2,870.64 2,828.04 42.60 -1.5 % 902.50 902.50 0.00 42.60 3,730.54 -1.1 1,000,000 3,020.14 2,939.54 80.60 -2.7% 950.00 950.00 0.00 80.60 3,889.54 -2.0% 1,050000 3,169.64 3,051.04 118.60 -3.7% 997.50 997.50 0.00 118.60 4,048.54 -2.8% 1,100,000 3,319.14 3,162,54 156.60 -4.7% 1,045.00 1,045.00 0.00 156.60 4,207.54 -3.6% 1,150,000 3,468.64 3,274.04 194.60 -5.6% 1,092.50 1,592.50 0.00 194.60 4,366.54 -4.3% 1,200,000 3,618.14 3,385.54 232.60 -6.4% 1,140.00 1140.00 0.00 232.60 4,525.54 -4.9% 1,250,000 3,767.64 3,497.04 270.60 -7.2% 1,187.50 1,187.50 0.00 270.60 4,684.54 -5.5% 1,300,000 3,917.14 3,608.54 308,60 -7.9% 1235.00 1,235.00 0.00 308.60 4,843.54 -6.0% 1,350,000 4,066.64 3,720.04 346.60 -8.5% 1,282.50 1,282.50 0.00 346.60 51002m54 -6.5% 1,400,000 4,216.14 3,831.54 384.60 -9.1% 1,330.00 1,330.00 0.00 384.60 5,161.54 -6.9% 1,450,000 4,365.64 3,943.04 422.60 -9.7% 1,377.50 1,377.50 0.00 422.60 5,320.54 -7.4% 1,500,000 4,515.14 4 054.54 460.60 -10.2% 1,425.00 1,425.00 0.00 460.60 5,479.54 -7.8% 1,55I)XI) 4,664.64 4,166.04 498.60 -10.7% 1,472.50 1,472.50 0.00 498.60 5,638.54 -8.1 % 1,600,000 4,814.14 4,277.54 536.60 -11.1% 1,520.00 1,520.00 0.00 536.60 5,797.54 -8.5% 1,650,000 4,963.64 4,389.04 574,60 A1.6% 1,567.50 1,567.50 0.00 574.60 5,956.54 -8.8% 1,700,000 5,113.14 4,500.54 612.60 -12.0% 1,615.00 1,615.00 0.00 112.60 6,115.54 -9.1% 1750,000 5,262.64 4,612.04 650.60 -12.4% 1,662.50 1,662.50 0.00 650.60 6,274.54 -9.4% 1,800,000 5,412.14 1 4,723.54 688.60 A2.7% 1,710.00 1,710.00 0.00 688.60 6,433.54 1 1,850,000 5,561.641 4,835.04 726.60 -13.1%1 1,757.50 1,757.50 0.00 726.60 6,592.54 -9.9% 1,900,000 5,711.141 4,946.54 764.60 -13.4% 1,805.00 1,805.00 0.00 764.60 6,751.54 -10.2% 1,950,000 5,860w64 1 5,058.04 802.60 -13.7% 1,852.50 1,852.50 0.00 802.60 6,910.54 7.4% 2,000,000 6,010.14 1 5,169.54 840.60 -14.0% 1,900.00 1,900.00 0.0l) 840.60 7,069.54 -10.6% 2,050,000 6,211.64 1 5,281.04 930.60 -15.0% 1,947.50 1,947.50 0.00 930.60 7,228.54 -11.4% 2,100,000 6,413.14 1 5,392.54 1,020.60 -15.9% 1,995.00 1,995.00 0.00 1,020.60 7,387.54 -12.1 % 2,150,000 6,614.64 1 5,504.04 1,110.60 -16.8% 2,042.50 2,042.50 0.00 1,110.60 7,546.54 -12.8% 2,200,000 6,816.14 1 5,615.54 1,200.60 -17.6% 2,090.00 2,090.00 0.00 1,200.60 7,705.54 -13.5% 2,250,000 7017.64 5,727.04 1,290.60 -18.4% 2,137.50 2,137.50 0.00 1,290.60 7,864.54 2,300,000 7,219.14 5,838.54 1,380.60 ASS % 2,185.00 2,185.00 0.00 11380.60 8,023.54 -14.7% 2,350,000 7,420.64 5,950.04 1,470.60 A9.8% 2,232.50 2,232.50 0.00 1470.60 8,182.54 -15.2% 2,400,000 7622.14 6,061.54 1,5"60 -20.5% 2,280.00 2280.00 0.00 1,560.60 8,341.54 -15.8% 2,450,000 7,823.64 6,173.04(1,650.60)1-21.1 % 2,327.50 2,327.50 0.00 1,650.60 8,500.54 -16.3% 2,500,000 8,025.14 6,284.54 1,740.60 -21.7% 2,375.00 2,375.00 0.00 1740.60 8,659.54 -16.7% 2,550,000 8,226.64 6,396.04 1,830.60 -22.3% 2,422.50 23422.50 0.00 13830.60 8,818.54 -17.2% 2,600000 83428.14 6,507.54 1,920.60 -22.8% 2,470.00 2,470.00 0.00 1,920.60 8,977.54 -17.6% 2,650,000 8,629.64 6,619.04 2,010.60 -23.3% 2,577.50 2,517.50 0.00 2,010.60 9,136.54 -18.0% 23700,000 8,831.14 6,730.54 2,100.60 -23.8% 2,565.00 2,565.00 0.00 2100.60 9295.54 -18.4% 2,750,000 9,032.64 6,842.04 2,190.60 -243 2,612.50 2,612.50 0.00 2,190.60 9,454.54 -18.8% 2,800,000 9,234.14 6,953.54 2,280.60 -24.7% 23660.00 2660.00 0.00 2,280.60 9,613.54 -19.2% 2,850,000 9,435.64 7,065.04 2,370.60 -25.1 % 23707.50 2,707.50 0.00 2,370.60 9,772.54 -19.5% 2,900,000 9,637.14 7,176.54 2,460.60 -25.5% 2,755.00 2,755.00 0.00 2460.60 9,931.54 -19.9% 2,950,000 9,838.64 7,288.04 2,550.60 -25.9% 2,802.50 2,802.50 0.00 2,550.60 10,090.54 -20.2% 3000,000 10,040.14 7,399.54 2,640.60 -26.3% 2,850.00 2,850.00 0.00 2,640.60 10,249.54 -20.5% 3,050,000 10,241.64 7,511.04 2,730.60 -26.7% 2,897.50 2,897.50 0.00 2,730.60 10,408.54 -20.8% 3,100,000 10,443.14 7,622.54 2,820.60 -27.0% 2,945.00 2,945.00 0.00 2820.60 10,567.54 -21.1% Appendix D Monthly Charges and Percent Increase Comparison 16 of 17 TURF CUSTOMER BILL IMPACT WITH 4" METER BASE RATE 354.77 GALLONS USED CURRENT WATER RATE PROPOSED WATER RATE AMOUNT OF INCREASE/ (DECREASE) WATER RATE PERCENT INCREASE/ DECREASE WATER RATE CURRENT GROUNDWATER PRESERVATION FEE PROPOSED GROUNDWATER PRESERVATION FEE AMOUNTOF INCREASE OFF TOTAL MONTHLY INCREASE/ DECREASE TOTAL AMOUNTOF MONTHLY BILL TOTAL PERCENT INCREASE/ DECREASE 0 354.77 354.77 0.0% 0.00 354.77 0.0% 150,000 684.77 689.27 4.50 0.7% 142.50 142.50 0.00 4.50 831.77 0.5% 300,000 1,014.77 1,023.77 9.00 0.9% 285.00 285.00 0.00 9.00 1,308.77 0.7% 450,000 1,344.77 1,358.27 13.50 1.0% 427.50 427.50 0.00 13.50 1,785.77 0.8% 600,000 1,674.77 1,692.77 18.00 1.1 % 570.00 570.00 0.00 18.00 2,262.77 0.8% 750,000 2,004.77 2,027.27 22.50 1.1 % 712.50 712.50 0.00 22.50 2,739.77 0.8% 900,000 1 2,334.77 2,361.771 27.00 1.2%1 855.00 855.00 0.001 27.00 3,216.77 0.8% 1,050,0001 2,664.77 2,696.27 31.50 1.2% 997.50 997.50 0.00 31.50 3,693.77 0.9% 1,200,000 2,994.77 3,030.77 36.00 1.2% 1,140.00 1,140.00 0.00 36.00 4,170.77 0.9% 1,350,000 3,324.77 3,365.27 40.50 1.2% 1,282.50 1,282.50 0.00 40.50 4,647.77 0.9% 1500,000 3,654.77 3,699.77 45.00 1.2% 1,425.00 1,425.00 0.00 45.00 5,124.77 0.9% 1,650,000 3,984.77 4,034.27 49.50 1.2% 1,567.50 1,567.50 0.00 49.50 5,601.77 0.9% 1,800,000 4,314.77 4368.77 54.00 1.3% 1,710.00 1,710.00 0.00 54.00 6,078.77 0.9% 1,950,000 4,644.77 4,703.27 58.50 1.3% 1,852.50 1,852.50 0.00 58.50 6,555.77 0.9% 2100,000 4,974.77 5,037.77 63.00 1.3% 1,995.00 1,995.00 0.00 63.00 7,032.77 0.9% 2,250,000 5,304.77 5,372.27 67.50 1.3% 2,137.50 2,137.50 0.00 67.50 7,509.77 0.9% 2,400,000 5,634.77 5,706.77 72.00 1.3% 2,280.00 2,280.00 0.00 72.00 7,986.77 0.9% 2,650,000 5,964.77 6,041.27 76.50 1.3% 2,422.50 2,422.50 0.00 76.50 8,463.77 0.9% 2,700,000 1 6,294.77 6,375.77 81.00 1.3% 2,565.00 2,565.00 0.00 81.00 8,940.77 0.9% 2,850,000 6,624.77 6,710.27 85.50 1.3% 2,707.50 2,707.50 0.00 85.50 9,417.77 0.9% 3,000,000 6,954.77 7,044.77 90.00 1.3% 2,850.00 2,850.00 0.00 90.00 9,894.77 0.9% 3,150,000 7,284.77 7,379.27 94.50 1.3% 2,992.50 2,992.50 0.00 94.50 10,371.77 0.9% 3,300,000 7,614.77 7,713.77 99.00 1.3% 3,135.00 3,135.00 0.00 99.00 10,848.77 0.9% 3,450,000 7,944.77 8,048.27 103.50 1.3% 3,277.50 3,277.50 0.00 103.50 11,325.77 0.9% 3,600,000 8,274.77 8,382.77 108.00 1.3% 3,420.00 3,420.00 0.00 108.00 11,802.77 0.9% 3,750,000 8,604.77 8,717.27 112.50 1.3% 3,562.50 3,562.50 0.00 112.50 12,279.77 0.9% 3,900,000 8,934.77 9,091.77 117.00 1.3% 3,705.001 3,705.00 0.00 117.00 12,756.771 0.9% 4,050,000 9,264.77 9,386.27 121,501 1.3% 3,847.50 3,847.50 0.001 121.50 13233.77 0.9% 4,200,000 9,594.77 9,720.77 126.00 1.3% 3,990.00 3,990.00 0.00 126.00 13,710.77 0.9% 4,350,000 1 9,924.77 10,055.27 130.50 1.3% 4,132.50 4,132.50 0.00 130.50 14,187.77 0.9% 4,500,000 10,254.77 10,389.77 135.00 1.3% 4,275.00 4,275.00 0.00 135.00 14,664.77 0.9% 4,650,000 10,584.77 10,724.27 139.50 1.3% 4,417.50 4,417.50 0.00 139.50 15,141.77 0.9% 4,800,000 10,914.77 11,058.77 144.00 1.3% 4,560.00 4,560.00 0.00 144.00 15,618.77 0.9% 4,950,000 11,244.77 11,393.27 148.50 1.3% 4,702.50 4,702.50 0.00 148.50 16,095.77 0.9% 5,100,000 11,574.77 11,727.77 153.00 1.3% 4,845.00 4,845.00 0.00 153.00 16,572.77 0.9% 5,250,000 11,904.77 12,062.27 157.50 1.3% 4,987.50 4,987.50 0.00 157.50 17,049.77 0.9% 5,400,000 12,234.77 12,396.77 162.00 1.3% 5,130.00 5,130.00 0.00 162.00 17,526.77 0.9% 5,550,000 12,564.77 12,731.27 166.50 1.3% 5,272.501 5,272.50 0.00 166.50 18,003.771 0.9% 5,700,000 12,894.771 13,065.77 171.001 1.3% 5,415.001 5415.00 0.001 171.00 18,480.771 0.9% 5,850,000 13,224.77 13,400.27 175.50 1.3% 5,557.50 5,557.50 0.00 175.50 18,957.77 0.9% 6,000,000 13,554.77 13,734.77 180.00 1.3% 5,700.00 5,700.00 0.00 180.00 19,434.77 0.9% 6,150,000 13,884.77 14,099.27 184.50 1.3% 5,842.50 5,842.50 0.00 184.50 19,911.77 0.9% 6,300,000 14,214.77 14,403.77 189.00 1.3% 5,985.00 5,985.00 0.00 189.00 20,388.77 0.9% 6,450,000 14,544.77 14,738.27 193.50 1.3% 6,127.50 6,127.50 0.00 193.50 20,865.77 0.9% 6,600,000 14,874.77 15,072.77 198.00 1.3% 6,270.00 6,270.00 0.00 198.00 21,342.77 0.9% 6,750,000 15,204.77 15,407.27 202.50 1.3% 6,412.50 6,412.50 0.00 202.50 21,819.77 0.9% 6,900,000 15,534.77 15 741.77 207.00 1.3% 6,555.00 6,555.00 0.00 207.00 22,296.77 0.9 7,050,000 15,864.77 16,076.27 211.50 1.3% 6,697.50 6,697.50 0.00 211.50 22,773.77 0.9% 7,200,000 16,194.77 16,410.77 216.00 1.3% 6,840.00 6,840.00 0.00 216.00 23,250.77 0.9% 7,350,000 16,524.77 16,745.27 220.501 1.3% 6,982.50 1 6,982.50 0.00 220.50 23,727.77 0.9% 7,500,000 16,854.77 17,079.77 225.00 1 1.3% 7,125.00 7,125.00 0.00 225.00 24,204.77 0.9% 7,650,000 17,184.77 17,414.27 229.50 1 1.3% 7,267.50 7,267.50 0.00 229.50 24,681.77 0.9% 7,800,000 17,514.77 17,748.77 234.00 1.3% 7,410.00 7,410.00 0.00 234.00 25,158.77 0.9% 7,950,000 17,844.77 18,083.27 238.50 1.3% 7,552.50 7552.50 0.00 238.50 25,635.77 0.9% 8,100,000 18,174.77 18,417.77 243.00 1.3% 7,695.00 7,695.00 0.00 243.00 26,112.77 0.9% 8,250,000 18,504.77 18,752.27 247.50 1.3% 7,837.50 7,837.50 0.00 247.50 26,589.77 0.9% 8,400,000 18,834.77 19,086.77 252.00 1.3% 7,980.00 7,980.00 0.00 252.00 27,066.77 0.9% 8,550,000 19,164.77 19,421.27 256.50 1.3% 8,122.50 8,122.50 0.00 256.50 27,543.77 0.9% 8,700,000 19,494.77 19,755.77 261.00 1.3% 8,265.00 8,265.00 0.00 261.00 28,020.77 0.9% 8,850,000 19,824.77 20,090.27 265.50 1.3% 8,407.50 8,407.50 0.00 265.50 28,497.77 0.9% 9,000,000 20,154.77 20,424.77 270.00 1.3% 8,550.00 8,550.00 0.00 270.00 28,974.77 0.9% 9,150,000 20,484.77 20,759.27 274.50 1.3% 8,692.50 8692.50 0.00 274.50 29,451.77 0.9% 9,300,000 20,814.77 21,093.77 279.00 1.3%1 8835.00 8,835.00 0.00 279.00 29,928.77 0.9% 9,450,000 21,144.77 21,428.271 283.50 1.3% 8:977.50 8,977.50 0.00 283.50 30,405.77 0.9% Appendix D Monthly Charges and Percent Increase Comparison 17 of 17