Loading...
Ordinance 2015-32 ORDINANCE NO. 2015-32 AN ORDINANCE OF THE CITY OF WYLIE, TEXAS; AMENDING SUBSECTION B (WATER RATES) AND SUBSECTION C (SEWAGE COLLECTION AND TREATMENT RATES) OF SECTION 1 (WATER AND SEWER FEES) OF THE WYLIE COMPREHENSIVE FEE SCHEDULE; PROVIDING FOR A PENALTY FOR THE VIOLATION OF THIS ORDINANCE; PROVIDING FOR REPEALING, SAVINGS AND SEVERABILITY CLAUSES; PROVIDING FOR AN EFFECTIVE DATE OF THIS ORDINANCE; AND PROVIDING FOR THE PUBLICATION OF THE CAPTION OF THIS ORDINANCE. WHEREAS, the City Council of the City of Wylie, Texas ("City Council") has adopted Ordinance No. 2009-12 establishing a comprehensive fee schedule ("Comprehensive Fee Ordinance") for the City of Wylie, Texas ("Wylie"); and WHEREAS,the Comprehensive Fee Ordinance includes fees for water and sewer; and WHEREAS, the City Council has investigated and determined that it would be advantageous and beneficial to the citizens of Wylie to amend Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF WYLIE,TEXAS: SECTION l: Findines Incorporated. The findings set forth above are incorporated into the body of this Ordinance as if fully set forth herein. SECTION 2: Amendment to Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule. Amendment to the Wylie Comprehensive Fee Schedule Subsection B (Water Rates) and Subsection C (Sewage Collection and Treatment Rates) of Section 1 (Water and Sewer Fees) of the Wylie Comprehensive Fee Schedule are hereby amended as identified in Exhibit "A", attached hereto and incorporated herein for all purposes. SECTION 3: Penalty Provision. Any person, firm, corporation or entity that violates this Ordinance shall be deemed guilty of a misdemeanor and upon conviction thereof shall be fined a sum not exceeding two thousand dollars ($2,000.00) if the violation relates to the public health and sanitation, otherwise the fine shall be a sum not exceeding five hundred dollars ($500.00). Each continuing day's violation shall constitute a separate offense. The penal provisions imposed under this Ordinance shall not preclude the Wylie from filing suit to enjoin the violation. Wylie retains all legal rights and remedies available to it pursuant to local, state and federal law. Ordinance No.2015-32 Amendment to the Wylie Comprehensive Fee Schedule Page 1 597838.1 SECTION 4: Savings/Repealing Clause. All provisions of any ordinance in conflict with this Ordinance are hereby repealed to the extent they are in conflict; but such repeal shall not abate any pending prosecution for violation of the repealed ordinance, nor shall the repeal prevent a prosecution from being commenced for any violation if occurring prior to the repeal of the ordinance. Any remaining portions of said ordinances shall remain in full force and effect. SECTION 5: Severability. Should any section, subsection, sentence, clause or phrase of this Ordinance be declared unconstitutional or invalid by a court of competent jurisdiction, it is expressly provided that any and all remaining portions of this Ordinance shall remain in full force and effect. Wylie hereby declares that it would have passed this Ordinance, and each section, subsection, clause or phrase thereof irrespective of the fact that any one or more sections, subsections, sentences, clauses, and phrases be declared unconstitutional or invalid. SECTION 6: Effective Date. This Ordinance shall become effective from and after its passage and publication as required by the City Charter and by law. DULY PASSED AND APPROVED BY THE CITY COUNCIL OF THE CITY OF WYLIE,TEXAS, on this 8h day of September, 2015. V'0't k�-� Eric Hogue, M yo ATTESTED AND CORRECTLY RECORDED: d1 Carole Ehrlich, Secretary ul.fCOLO R400 Date to be published in The Wylie News—September 16,2015 ypNSp FE R'kW4" s018870 s TArE OF TEXA Ordinance No.2015-32 Amendment to the Wylie Comprehensive Fee Schedule Page 2 597838.1 Exhibit"A" WYLIE COMPREHENSIVE FEE SCHEDULE I. WATER AND SEWER FEES. B. Water Rates. (1) The following monthly water rates shall apply to all domestic residential customers within the corporate limits of the City of Wylie, Texas. ALL PRICES ARE FOR 1,000 GALLONS OF METERED WATER. (a) Monthly minimum charge for first 1,000 gallons of metered water consumption: .............................................................$11.77 (b) Volume charge for all consumption exceeding 1,000 gallons: 1,001 to 10,000 gallons: ........................................................$4.01 Over10,000 gallons: .............................................................$5.20 (2) The following monthly water rates shall apply to all domestic commercial customers, (other than apartments, mobile home parks and other multi-unit dwellings not individually metered) within the corporate limits of the City of Wylie, Texas: (a) Monthly minimum charge for first 1,000 gallons of metered water consumption: ...............................................$16.08 (b) Volume charge for all consumption exceeding 1,000 gallons: ........................................................................$4.55 (3) The following water rates shall apply to all domestic apartments, mobile home parks, and other multi-unit dwellings, not individually metered, within the corporate limits of the City of Wylie, Texas: (a) Monthly minimum charge for first 1,000 gallons of metered water $16.08 (b) Volume charge for all consumption exceeding 1,000 gallons .........................................................................$4.55 (4) The following monthly water rates shall apply to all irrigation meters within the corporate limits of the City of Wylie, Texas: (a) Monthly minimum charge for first 1,000 gallons of metered water: (1) Residential irrigation .....................................................$11.77 (2) Commercial &Multifamily...........................................$16.08 (b) Volume charge for all consumption exceeding 1,000 gallons: (1) Residential irrigation .......................................................$5.74 (2) Commercial irrigation......................................................$5.74 Ordinance No.2015-32 Amendment to the Wylie Comprehensive Fee Schedule Page 3 597838.1 (5) The monthly water charge for any customers (residential, commercial, apartment, mobile home park, or other multi-unit dwelling not individually metered) located outside the corporate limits of the City of Wylie, Texas, shall be at the rate of one hundred fifteen percent (115%) of the rate charged customers inside the corporate limits of the City. (6) Any bulk water customer who desires to withdraw water from a hydrant or other source not metered and charged directly to them, shall fill out a water application form and sign the form in the same manner as a regular metered customer. Bulk water rate charges are to be charged in twenty-five (25) gallon increments at the same rates as the commercial customers. C. Sewage Collection and Treatment Rates. (1) The following monthly sewage collection and treatment rates shall apply to all residential customers of the City of Wylie, Texas: (a) Customers who are 65 years of age or older and have a homestead exemption on the service address which appears in the tax records..................... ....................................................$26.36 (b) Customers who are disabled and have a homestead exemption on the service address which appears in the tax records................$26.36 (c) All other customers ............................................................$37.37 (2) The following monthly sewage collection and treatment rates shall apply to all commercial customers of the City of Wylie, Texas: (a) Monthly minimum charge first 1,000 gallons of metered water...... $28.45 (b) Volume charge for all consumption exceeding 1,000 gallons.........$ 2.40 (3) The following monthly sewage collection and treatment rates shall apply to each apartment unit, multiple-family unit, or mobile home space and special areas such as washateria, swimming pools, etc., where the apartment, multiple-family development or mobile home park is on a master meter for water consumption with the City of Wylie,Texas: (a) Monthly charge...............................................................$37.37 (4) The monthly sewer charge for any customers (residential, commercial, apartment, mobile home park, or other multi-unit dwelling not individually metered) located outside the corporate limits of the City of Wylie, Texas, shall be at the rate of one hundred fifteen percent (115%) of the rate charged customers inside the corporate limits of the City. (5) The monthly water and sewer rate charge for residential and commercial customers located outside the corporate limits of the City of Wylie, Texas, shall be at the rate of one hundred fifteen percent (115%) of the rate charged customers inside the Ordinance No.2015-32 Amendment to the Wylie Comprehensive Fee Schedule Page 4 597838.1 corporate limits of the City. Ordinance No.2015-32 Amendment to the Wylie Comprehensive Fee Schedule Page 5 597838.1 REPORT ON WATER & WASTEWATER RATES CITY OF WYLIE, TEXAS OCTOBER 23, 2013 McLain Decision 41 Support Systems • Government Utility Rate Group 1932 Robin Lane Flower Mound, TX 75028 (214)488-8808 bob(cDmclaindss.com City of Wylie, Texas Update of Water & Wastewater Rates October 23,2013 Linda Bantz Director of Finance City of Wylie 300 Country Club Road Wylie, TX 75098 Re: Final Report on Water& Wastewater Rates Dear Ms. Bantz: Enclosed is the Final Report on Water & Wastewater Rates, prepared by McLain Decision Support Systems (McLainDSS) for the City of Wylie. The report conveys the findings, conclusions, and recommendations of our firm with respect to the development of water rates to cover the projected water and wastewater costs for the period 2014-2023. The report is structured to provide the reader with a clear and accurate presentation of the revenue and rate issues facing the City of Wylie. However, this study does not constitute an examination of the financial statements of the City of Wylie, and, as such, we cannot and do not express any opinion regarding the validity or accuracy of the financial information provided. The report includes a significant amount of assumptions and detailed tables and worksheets. The detailed tables, exhibits, and worksheets provide an understanding of where the numbers come from and the related impact the rates will have on the City's customers. We have appreciated the courtesies and professional relationship extended to us during this engagement by the City's management and staff. Very truly yours, A� Mc Robert McLain McLain Decision Support Systems Table of Contents I. Executive Summary................................................................................................................ 1 1.1 Purpose of Report................................................................................................................ 1 1.2 Questions to be Answered with this Report........................................................................ 1 1.3 Findings/Analysis Related to the Cost of Service............................................................... 2 1.4 Findings/Analysis Related to the Existing Rate Design ..................................................... 6 II. Identify Revenue Requirements ............................................................................................ 17 2.1 Purpose of This Section ...................................................................................................... 17 2.2 Key Cost of Service Assumptions ...................................................................................... 17 2.2.1 Growth Assumptions........................................................................................................ 18 2.2.2 Additional Staffing...........................................................................................................20 2.2.3 Salaries& Benefits...........................................................................................................21 2.2.4 NTMWD Water Purchase Costs......................................................................................22 2.2.5 NTMWD Wastewater Treatment Costs...........................................................................24 2.2.6 Other Operating& Maintenance Costs............................................................................28 2.2.7 Non-Operating Costs........................................................................................................33 2.2.8 Existing and planned debt.................................................................................... 2.2.9 Revenue Offsets...............................................................................................................37 Appendix A—Supporting Worksheets List of Figures I. Executive Summary................................................................................................................ 1 Figure 1:NTMWD Water Rate/1,000 Gallons............................................................................... 2 1.1 Impact of Financing Scenarios.................................................................................................. 4 1.2 Impact on Average Combined Residential Water& Wastewater Bills @ 8,000 Gallons........ 5 1.3 Impact on Average Combined Commercial Water& Wastewater Bills @ 27,000 Gallons.... 7 1.4 Impact on Average Combined Industrial Water&Wastewater Bills @ 300,000 Gallons....... 8 1.5 Impact on Average 2 Inch Sprinkler Bills @ 60,000 Gallons.................................................. 9 1.6 Illustration of Proposed Rates- Water...................................................................................... 10 1.7 Illustration of Proposed Rates- Wastewater............................................................................. 13 II. Identify Revenue Requirements............................................................................................ 17 2.1 Growth - Water......................................................................................................................... 18 2.2 Growth—Water Billed for Wastewater.................................................................................... 19 2.3 Existing&Projected Staffing Levels........................................................................................20 2.4 Existing&Projected Salary&Benefit Costs...........................................................................21 2.5 Water Purchases from NTMWD...............................................................................................22 2.6 Calculation of the Incremental Increase in NTMWD Water Purchase Cost per Th. Gallons ..23 2.7 Wastewater Treatment Costs—NTMWD Muddy Creek Wastewater Treatment Plant...........24 2.8 Wastewater Treatment Costs—NTMWD Muddy Creek Interceptor.......................................25 2.9 Recap of Wastewater Treatment Costs.....................................................................................26 2.10 Calculation of the Incremental Increase in NTMWD Wastewater Cost per Th. Gallons.......27 2.11 Recap of Operating and Maintenance Costs—Utility Administration(5711)........................28 2.12 Recap of Operating and Maintenance Costs—Water Distribution (5712).............................29 2.13 Recap of Operating and Maintenance Costs—Engineering(5713)........................................30 2.14 Recap of Operating and Maintenance Costs—Sewer Collection(5714)................................31 2.15 Recap of Operating and Maintenance Costs—Utility Billing (5715)..................................... 32 2.16 Recap of Existing Water and Wastewater Debt Service Payments........................................34 2.17 Recap of Non-Operating Costs...............................................................................................35 2.18 Recap of the Gross Cost of Service ........................................................................................36 2.19 Recap of Revenue Offsets- Services......................................................................................37 2.20 Recap of Revenue Offsets—All Other Revenue Offsets........................................................38 2.21 Existing& Projected Total Sources of Funds.........................................................................39 2.22 Recap of the Sources& Uses of Funds...................................................................................40 Appendix A—Supporting Worksheets SECTION I : EXECUTIVE SUMMARY McLain Decision Support Systems City of Wylie, Texas Update of Water & Wastewater Rates f : SECTION I: EXECUTIVE SUMMARY 1.1. PURPOSE OF REPORT: The following report describes the findings of the water and wastewater rate study performed for the City of Wylie, and makes recommendations with respect to the rates to be charged to the City's customers. The objectives to be achieved within the scope of the engagement are as follows: ■ To develop the bases to be used to project the water and wastewater units of service and cost of service over a multi-year planning period, FY 2014 -2023; ■ To identify the full cost of the water and wastewater services over the multi-year planning period,based on the FY 2014 preliminary budget; ■ To develop water and wastewater rates which will provide sufficient annual revenues to meet expenditures for all operating and non-operating costs; ■ To prepare financial projections using the developed rates, supplemented by a description of the key assumptions underlying the projections; ■ To create an executive summary documenting our findings and recommendations. 1.2. QUESTIONS TO BE ANSWERED WITH THIS REPORT: There are several questions that will be answered with this report: ■ What is the impact of the increased North Texas Municipal Water District(NTMWD) water purchase costs on overall water revenues required from water rates over the next ten years?(From $1.70 in FY 2013 to$3.02 in FY 2023). ■ What is the impact of the increased North Texas Municipal Water District(NTMWD) wastewater collection and treatment costs on overall wastewater revenues required from wastewater rates over the next ten years? ■ What is the impact of the planned FY 2014 $3,540,000 bond issue on the overall water and wastewater revenues over the next several years? SECTION I-EXECUTIVE SUMMARY PAGE 1 City of Wylie, Texas Update of Water & Wastewater Rates 1.3. FINDINGS/ANALYSIS RELATED TO THE COST OF SERVICE: ■ The water and wastewater enterprise fund was in good financial condition as of 09/30/2012. The water and wastewater fund ended FY 2012 with $5,719,913 in operating reserves(working capital)(126 days of total expenditures). ■ The fund should end FY 2013 in good financial condition. The water and wastewater fund should end FY 2013 with $5,651,882 in operating reserves (working capital) (153 days of total expenditures). ■ The cost of water charged to the City of Wylie by the NTMWD is expected to almost double over the next ten years. Following is a chart illustrating these increases. Figure 1 NTMWD Water Rate/1,000 Gallons $0.00 $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 i FY 2011 $1.37 FY 2012 $1.49 FY 2013 $1.70 FY 2014 $1.88 I FY 2015 $2.06 FY 2016 $2.24 FY 2017 $2.42 FY 2018 $2.57 FY 2019 f $2.7p FY 2020 ( $x.81 FY 2021 I, $2.90 FY 2022 $2.97 FY 2023 $3.02 The increased cost per 1,000 gallons, along with increased water purchase volume due to growth, with increase the water payments to NTMWD from $2,561,495 in FY 2012 to $5,606,338 in FY 2023 SECTION I-EXECUTIVE SUMMARY PAGE 2 City of Wylie, Texas Update of Water & Wastewater Rates ■ Additionally, the average cost per 1,000 gallons for wastewater collection and i treatment charged to the City of Wylie is expected to increase substantially over the next ten years. Wastewater payments to NTMWD are expected to increase from $4,517,012 to$5,729,212 in FY 2023. ■ Financial Plan Notice. Water and wastewater costs have been projected for the period FY 2014 through FY 2023, based on the FY 2014 preliminary budget. We believe the underlying assumptions that drive the cost of service through the FY 2023 provide a reasonable basis for management's forecast. However, some assumptions inevitably will not materialize as presented and anticipated events and circumstances may not occur; therefore, the actual results achieved during the forecast periods will vary from the forecast, and the variances may be material. Monitor expenditures very carefully over the planning period, compared to the expenditure levels shown in this report. Because the forecasts are developed upon expenditure levels outlined in this report, any significant increases of expenditures over the planned expenditure levels will affect the sufficiency of revenues over the study period. SECTION I-EXECUTIVE SUMMARY PAGE 3 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.1 shows the impact of the rate increases. Table 1.1 Impact of Different Financing Scenarios Financing Scenario 1: Financing Scenario 2: Wait Until You have to Increase Spread Increases Over Several Years Days of Days of Percentage Expenditures Percentage Expenditures Fiscal Change in Operating Target Change in Operating Target Year Revenues Reserves 90 Days Revenues Reserves 90 Days 2012 N/A 5,719,913 126 N/A $ 5,719,913 126 2013 N/A 5,651,882 153 N/A 5,651,882 153 2014 0.0% 5,175,088 133 3.0% 5,574,632 143 2015 0.0% 3,892,430 95 3.0% 5,122,037 125 2016 11.0% 3,867,642 91 4.0% 4,998,327 118 2017 6.0% 4,082,833 91 4.0% 4,796,753 107 2018 3.0% 4,242,085 91 4.0% 4,685,636 100 2019 4.0% 4,471,903 92 4.0% 4,632,851 95 2020 3.0% 4,660,566 92 4.0% 4,707,355 93 2021 3.0% 4,847,138 92 3.0% 4,775,756 91 2022 3.0% 5,071,265 94 3.0% 4,877,561 90 2023 3.0% 5,373,179 96 3.0% 5,052,860 90 SECTION I-EXECUTIVE SUMMARY PAGE 4 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.2 illustrates the impact of the financial forecast on the average residential users. Table 1.2 Key Findings - Rate Design Alternatives Impact on Avg. Combined Residential Water & Wastewater Bills @ 8,000 Gallons Financing Scenario 1: Financing Scenario 2: Wait Until You have to Increase Spread Increases Over Several Years Fiscal Change Change Year Bill $ % Bill $ % 2012 $ 63.61 N/A N/A $ 63.61 N/A N/A 2013 67.78 4.17 6.6% 67.78 4.17 6.6% 2014 67.78 - 0.0% 69.81 2.03 3.0% 2015 67.78 - 0.0% 71.91 2.09 3.0% 2016 75.24 7.46 11.0% 74.78 2.88 4.0% 2017 79.75 4.51 6.0% 77.78 2.99 4.0% 2018 82.14 2.39 3.0% 80.89 3.11 4.0% 2019 85.43 3.29 4.0% 84.12 3.24 4.0% 2020 87.99 2.56 3.0% 87.49 3.36 4.0% 2021 90.63 2.64 3.0% 90.11 2.62 3.0% 2022 93.35 2.72 3.0% 92.81 2.70 3.0% 2023 96.15 2.80 3.0% 95.60 2.78 3.0% $ 28.37 41.9% $ 27.82 41.0% SECTION I-EXECUTIVE SUMMARY PAGE 5 City of Wylie, Texas Update of Water & Wastewater Rates 1.4. FINDINGS/ANALYSIS RELATED TO THE EXISTING RATE DESIGN: ■ Water Monthly Minimum Bills: The existing water rate design consists of a water residential monthly minimum bill of$10.67. The monthly minimum bill for the non-residential meters is $14.57. One thousand gallons (1,000) is included in the monthly minimum bill for both residential and non-residential. ■ Water Volumetric Rates: The volumetric water rates for the residential class consists of a conservation rate, where a rate per thousand gallons of$3.59 is charged for any monthly consumption up to 10,000 gallons, and $4.67 for any monthly consumption greater than 10,000 gallons. The rate per thousand gallons for the non-residential class is $4.08, and the sprinkler rate per 1,000 gallons is $5.16. The existing rate design for water is illustrated on Table 1.6. ■ Wastewater Monthly Minimum Bills: The existing residential wastewater rate design consists of a monthly minimum bill of $33.98, regardless of meter size for customer class. The existing non-residential wastewater rate design consists of a monthly minimum bill of$25.79, regardless of meter size or customer class. One thousand gallons (1,000) is included in the monthly minimum bill for the non-residential class. ■ Wastewater Volumetric Rates: There is no volumetric rate charged to residential customers. The non-residential volumetric wastewater water rate design consists of a rate per 1,000 gallons of$2.18 for any water consumption over 1,000 gallons. The existing rate design for wastewater is illustrated on Table 1.7. SECTION I-EXECUTIVE SUMMARY PAGE 6 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.3 Key Findings- Rate Design Alternatives Impact on Avg. Combined Commercial 1 Inch Water&Wastewater Bills @ 27,000 Gallons Financing Scenario 1: Financing Scenario 2: Wait Until You have to Increase Spread Increases Over Several Years Fiscal Change Change Year Bill $ % Bill $ % 2012 $ 190.17 N/A N/A $ 190.17 N/A N/A 2013 203.12 12.95 6.8% 203.12 12.95 6.8% 2014 203.12 - 0.0% 209.21 6.09 3.0% 2015 203.12 - 0.0% 215.49 6.28 3.0% 2016 225.46 22.34 11.0% 224.11 8.62 4.0% 2017 238.99 13.53 6.0% 233.07 8.96 4.0% 2018 246.16 7.17 3.0% 242.40 9.32 4.0% 2019 256.01 9.85 4.0% 252.09 9.70 4.0% 2020 263.69 7.68 3.0% 262.18 10.08 4.0% 2021 271.60 7.91 3.0% 270.04 7.87 3.0% 2022 279.75 8.15 3.0% 278.14 8.10 3.0% 2023 288.14 8.39 3.0% 286.49 8.34 3.0% $ 85.02 41.9% $ 83.37 41.0% SECTION I-EXECUTIVE SUMMARY PAGE 7 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.4 Key Findings- Rate Design Alternatives Impact on Avg. Combined Industrial 3/4 Inch Water&Wastewater Bills @ 300,000 Gallons Financing Scenario 1: Financing Scenario 2: Wait Until You have to Increase Spread Increases Over Several Years Fiscal Change Change Year Bill $ % Bill $ % 2012 $ 1,789.95 N/A N/A $ 1,789.95 N/A N/A 2013 1,912.10 122.15 6.8% 1,912.10 122.15 6.8% 2014 1,912.10 - 0.0% 1,969.46 57.36 3.0% 2015 1,912.10 - 0.0% 2,028.55 59.08 3.0% 2016 2,122.43 210.33 11.0% 2,109.69 81.14 4.0% 2017 2,249.78 127.35 6.0% 2,194.08 84.39 4.0% 2018 2,317.27 67.49 3.0% 2,281.84 87.76 4.0% 2019 2,409.96 92.69 4.0% 2,373.11 91.27 4.0% 2020 2,482.26 72.30 3.0% 2,468.04 94.92 4.0% 2021 2,556.73 74.47 3.0% 2,542.08 74.04 3.0% 2022 2,633.43 76.70 3.0% 2,618.34 76.26 3.0% 2023 2,712.43 79.00 3.0% 2,696.89 78.55 3.0% $ 800.33 41.9% $ 784.79 41.0% SECTION I-EXECUTIVE SUMMARY PAGE 8 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.5 Key Findings- Rate Design Alternatives Impact on Avg. Combined Sprinkler 2 Inch Water Only @ 60,000 Gallons Financing Scenario 1: Financing Scenario 2: Wait Until You have to Increase Spread Increases Over Several Years Fiscal Change Change Year Bill $ % Bill $ % 2012 $ 294.97 N/A N/A $ 294.97 N/A N/A 2013 315.11 20.14 6.8% 315.11 20.14 6.8% 2014 315.11 - 0.0% 324.56 9.45 3.0% 2015 315.11 - 0.0% 334.30 9.74 3.0% 2016 349.77 34.66 11.0% 347.67 13.37 4.0% 2017 370.76 20.99 6.0% 361.58 13.91 4.0% 2018 381.88 11.12 3.0% 376.04 14.46 4.0% 2019 397.16 15.28 4.0% 391.08 15.04 4.0% 2020 409.07 11.91 3.0% 406.73 15.64 4.0% 2021 421.34 12.27 3.0% 418.93 12.20 3.0% 2022 433.98 12.64 3.0% 431.50 12.57 3.0% 2023 447.00 13.02 3.0% 444.44 12.94 3.0% $ 131.89 41.9% $ 129.33 41.0% SECTION I-EXECUTIVE SUMMARY PAGE 9 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.6 Proposed Rates -Water Monthly Minimum Bills-FY 2014 Number Annual Consumption Existing Proposed of Consumption Passing thru Rates Rates Meters Billed Brackets Scenario 2 1 Outside to Inside Ratio 1.15 1.15 2 Gallons in Minumum Bill 1,000 1,000 3 5/8 x 3/4 Inch 131,265 1,075,027 N/A $ 10.67 $ 10.99 4 llnch 156 2,417 N/A 10.67 10.99 5 1.5 Inch 25 326 N/A 10.67 10.99 0 21nch 36 904 N/A 10.67 10.99 7 Residential 131,482 1,078,674 N/A 8 Gallons in Minumum Bill 1,000 1,000 5/8 x 3/4 Inch 61 11,587 N/A $ 14.57 $ 15.01 10 1.5 Inch 13 1,058 N/A 14.57 15.01 11 21nch 12 1,539 N/A 14.57 15.01 12 61nch 25 26,168 N/A 14.57 15.01 13 Multi-Family 111 40,352 N/A 14 Gallons in Minumum Bill 1,000 1,000 15 5/8 x 3/4 Inch 4,003 70,347 N/A $ 14.57 $ 15.01 16 llnch 568 18,924 N/A 14.57 15.01 17 1.5 Inch 96 2,162 N/A 14.57 15.01 18 21nch 641 65,049 N/A 14.57 15.01 19 31nch - - N/A 14.57 15.01 20 41nch 24 21,122 N/A 14.57 15.01 21 61nch 36 11,963 N/A 14.57 15.01 22 81nch 12 9,134 N/A 14.57 15.01 23 Commercial 5,380 198,701 N/A 24 Gallons in Minumum Bill 1,000 1,000 25 5/8 x 3/4 Inch 689 5,085 N/A $ 10.67 $ 10.99 26 llnch 14 114 N/A 10.67 10.99 27 21nch 3 8 N/A 10.67 10.99 28 Sprinklers-Residential 706 5,207 N/A 29 Gallons in Minumum Bill 1,000 1,000 30 21nch - - N/A $ 14.57 $ 15.01 31 Sprinklers-Multi-Family - - N/A 32 Gallons in Minumum Bill 1,000 1,000 33 5/8 x 3/4 Inch 1,260 46,026 N/A $ 14.57 $ 15.01 34 llnch 322 12,601 N/A 14.57 15.01 35 1.5 Inch 60 1,054 N/A 14.57 15.01 36 21nch 761 71,468 N/A 14.57 15.01 37 31nch - N/A 14.57 15.01 38 Sprinklers-Commercial 2,403 131,150 N/A SECTION I-EXECUTIVE SUMMARY PAGE 10 City of Wylie, Texas _.. Update of Water & Wastewater Rates Table 1.6 (Continued) Proposed Rates -Water Volumetric Rates-Proposed Annual Consumption Existing Proposed Annual Consumption Passing thru Rates Rates Billings Billed Brackets Scenario 2 1 Outside to Inside Ratio 2 3 0-1,000 4,449 1,964 128,997 $ - $ - 4 1,001-5,000 50,041 164,281 422,208 3.59 3.70 5 5,001-10,000 44,525 313,840 253,550 3.59 3.70 6 10,001-15,000 16,033 194,841 116,681 4.67 4.81 7 15,001-20,000 7,497 129,321 61,551 4.67 4.81 8 Over 20,000 8,937 274,427 95,687 4.67 4.81 9 Residential 131,482 1,078,674 1,078,674 10 0-1,000 1 - 110 $ - $ - 11 1,001-5,000 - 440 4.08 4.20 12 5,001-10,000 1 10 550 4.08 4.20 13 10,001-15,000 6 77 532 4.08 4.20 14 15,001-20,000 - - 515 4.08 4.20 15 Over 20,000 103 40,266 38,206 4.08 4.20 16 Multi-Family 111 40,352 40,352 17 0-1,000 1,213 499 4,666 $ - $ - 18 1,001-5,000 1,602 3,941 12,599 4.08 4.20 19 5,001-10,000 694 5,008 10,893 4.08 4.20 20 10,001-15,000 359 4,405 8,375 4.08 4.20 21 15,001-20,000 225 3,904 6,964 4.08 4.20 22 Over 20,000 1,287 180,942 155,202 4.08 4.20 23 Commercial 5,380 198,701 198,701 24 0-1,000 384 21 343 $ - $ - 25 1,001-5,000 94 269 1,087 5.16 5.31 26 5,001-10,000 76 563 943 5.16 5.31 27 10,001-15,000 49 613 638 5.16 5.31 28 15,001-20,000 23 404 459 5.16 5.31 29 Over 20,000 80 3,337 1,737 5.16 5.31 30 Sprinkler-Residential 706 5,207 5,207 31 0-1,000 4 0 8 $ - $ - 32 1,001-5,000 1 2 29 5.16 5.31 33 5,001-10,000 1 6 31 5.16 5.31 34 10,001-15,000 - 30 5.16 5.31 35 15,001-20,000 1 16 26 5.16 5.31 36 Over 20,000 5 339 239 5.16 5.31 37 Sprinkler-Multi-Family 12 364 364 SECTION I-EXECUTIVE SUMMARY PAGE 11 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.6 (Continued) Proposed Rates -Water Volumetric Rates-Proposed Annual Consumption Existing Proposed Annual Consumption Passing thru Rates Rates Billings Billed Brackets Scenario 2 38 0-1,000 1,030 52 1,437 $ - $ - 39 1,001-5,000 198 528 5,078 5.16 5.31 40 5,001-10,000 168 1,252 5,507 5.16 5.31 41 10,001-15,000 100 1,232 4,827 5.16 5.31 42 15,001-20,000 81 1,403 4,378 5.16 5.31 43 Over 20,000 838 126,809 110,049 5.16 5.31 44 Sprinkler-Commercial 2,415 131,276 131,276 45 0-1,000 7,081 2,537 135,562 46 1,001-5,000 51,936 169,021 441,441 47 5,001-10,000 45,465 320,679 271,474 48 10,001-15,000 16,547 201,168 131,083 49 15,001-20,000 7,827 135,050 73,895 50 Over 20,000 11,250 626,119 401,119 51 System Totals 140,106 1,454,574 1,454,574 52 From Monthly Minimum Bill $ 1,577,731 $ 1,625,063 53 From Volume Rates 5,979,446 6,158,830 54 Total Revenues Generated $ 7,557,177 $ 7,783,893 55 Change in Revenues-> 3.0% SECTION I-EXECUTIVE SUMMARY PAGE 12 City of Wylie, Texas ... Update of Water & Wastewater Rates Table 1.7 Proposed Rates -Wastewater Monthly Minimum Bills-FY 2014 Number Annual Consumption Existing Proposed of Consumption Passing thru Rates Rates Meters Billed Brackets Scenario 2 2 5/8 x 3/4 Inch 123,190 1,023,086 N/A $ 33.98 $ 35.00 3 llnch 159 2,357 N/A 33.98 35.00 4 1.5 Inch 12 134 N/A 33.98 35.00 5 21nch 36 1,664 N/A 33.98 35.00 6 Residential 123,397 1,027,240 N/A 7 5/8 x 3/4 Inch 85 12,712 N/A $ 33.98 $ 35.00 8 1.5 Inch 12 1,239 N/A 33.98 35.00 9 21nch 12 1,482 N/A 33.98 35.00 10 61nch 24 12,411 N/A 33.98 35.00 11 Multi-Family 133 27,844 N/A 12 5/8 x 3/4 Inch 3,327 90,736 N/A $ 25.79 $ 26.56 13 11nch 359 4,062 N/A 25.79 26.56 14 1.5 Inch 96 2,294 N/A 25.79 26.56 15 21nch 553 27,396 N/A 25.79 26.56 16 31nch 24 2,500 N/A 25.79 26.56 17 41nch 103 14,717 N/A 25.79 26.56 18 61nch 24 589 N/A 25.79 26.56 19 81nch 12 8,973 N/A 25.79 26.56 20 Commercial 4,498 151,266 N/A 21 East Fork Residential 16,447 - N/A $ 33.98 $ 35.00 22 East Fork Seniors 902 - N/A 25.59 26.36 23 East Fork Commercial 9 415 N/A 25.79 26.56 24 Total East Fork 17,358 415 N/A 25 Northeast Residential 4,310 - N/A $ 33.98 $ 35.00 26 Northeast Seniors 204 - N/A 25.59 26.36 27 Northeast Commercial 15 836 N/A 25.79 26.56 28 Total Northeast 4,529 836 N/A SECTION I-EXECUTIVE SUMMARY PAGE 13 City of Wylie, Texas AL Update of Water & Wastewater Rates Table 1.7 (Continued) Proposed Rates - Wastewater Volumetric Rates Annual Consumption Existing Proposed Annual Consumption Passing thru Rates Rates Billings Billed Brackets Scenario 2 38 Outside to Inside Ratio 39 0-1,000 5,065 1,859 120,185 $ $ 40 1,001-5,000 43,888 143,965 397,853 41 5,001-10,000 42,260 299,481 249,101 42 10,001-15,000 16,027 195,033 115,548 43 15,001-20,000 7,580 130,569 59,754 44 Over 20,000 8,577 256,332 84,792 45 Residential 123,397 1,027,240 1,027,234 46 0-1,000 133 27,844 27,844 $ $ 47 1,001-5,000 - - - 48 5,001-10,000 49 10,001-15,000 50 15,001-20,000 51 Over 20,000 - - - 52 Multi-Family 133 27,844 27,844 53 0-1,000 1,006 475 3,967 $ - $ - 54 1,001-5,000 1,484 3,622 10,170 2.18 2.25 55 5,001-10,000 534 3,841 8,541 2.18 2.25 56 10,001-15,000 271 3,325 6,630 2.18 2.25 57 15,001-20,000 156 2,768 5,663 2.18 2.25 58 Over 20,000 1,047 137,236 116,296 2.18 2.25 59 Commercial 4,498 151,266 151,266 60 0-1,000 16,447 - - $ - $ - 61 1,001-5,000 - 62 5,001-10,000 63 10,001-15,000 64 15,001-20,000 65 Over 20,000 - 66 East Fork SUD Residential 16,447 67 0-1,000 902 $ $ 68 1,001-5,000 - 69 5,001-10,000 70 10,001-15,000 71 15,001-20,000 72 Over 20,000 - 73 East Fork SUD Seniors 902 SECTION I-EXECUTIVE SUMMARY PAGE 14 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.7 (Continued) Proposed Rates - Wastewater Volumetric Rates Annual Consumption Existing Proposed Annual Consumption Passing thru Rates Rates Billings Billed Brackets Scenario 2 74 0-1,000 9 $ _ $ _ 75 1,001-5,000 3 14 35 2.18 2.25 76 5,001-10,000 3 20 20 2.18 2.25 77 10,001-15,000 - 15 2.18 2.25 78 15,001-20,000 1 19 14 2.18 2.25 79 Over 20,000 2 362 322 2.18 2.25 80 East Fork SUD Commercial 9 415 415 81 0-1,000 4,310 - - $ - $ _ 82 1,001-5,000 - 83 5,001-10,000 84 10,001-15,000 85 15,001-20,000 86 Over 20,000 - 87 Northeast SUD Residential 4,310 88 0-1,000 204 $ $ 89 1,001-5,000 - 90 5,001-10,000 91 10,001-15,000 92 15,001-20,000 93 Over 20,000 - 94 Northeast SUD Seniors 204 95 0-1,000 15 $ - $ - 96 1,001-5,000 60 2.18 2.25 97 5,001-10,000 2 17 72 2.18 2.25 98 10,001-15,000 65 2.18 2.25 99 15,001-20,000 - - 65 2.18 2.25 100 Over 20,000 13 820 560 2.18 2.25 101 Northeast SUD Commercial 15 836 836 102 0-1,000 28,067 30,178 152,020 103 1,001-5,000 45,375 147,601 408,118 104 5,001-10,000 42,799 303,358 257,733 105 10,001-15,000 16,298 198,359 122,259 106 15,001-20,000 7,737 133,356 65,496 107 Over 20,000 9,639 394,749 201,969 108 System Totals 149,915 1,207,601 1,207,595 SECTION I-EXECUTIVE SUMMARY PAGE 15 City of Wylie, Texas Update of Water & Wastewater Rates Table 1.7 (Continued) Proposed Rates - Wastewater Comparison of Average Monthly Bills Annual Consumption Existing Proposed Annual Consumption Passing thru Rates Rates Billings Billed Brackets Scenario 2 109 From Monthly Minimum Bill $ 5,364,730 $ 5,525,672 110 From Volume Rates 396,234 408,121 111 Total Revenues Generated $ 5,760,964 $ 5,933,793 112 Change in Revenues-> 3.0% SECTION I—EXECUTIVE SUMMARY PAGE 16 SECTION II : IDENTIFY REVENUE REQUIREMENTS McLain t?ecision Support Systems City of Wylie, Texas Update of Water & Wastewater Rates SECTION II: IDENTIFY REVENUE REQUIREMENTS 2.1. PURPOSE OF THIS SECTION: A ten-year financial plan has been created for the water and wastewater fund using a "bottom- up" approach. Highlights of the City's water and wastewater costs over the planning period are presented in this section. Salaries have been supported by staffing tables. Operating and maintenance costs have been calculated in considerable detail. 2.2. KEY COST OF SERVICE ASSUMPTIONS: Water and wastewater costs were projected for the period FY 2014 through FY 2023, based on the proposed FY 2014 budget. We believe the underlying assumptions that drive the cost of service through the FY 2023 provide a reasonable basis for management's forecast. However, some assumptions inevitably will not materialize as presented and anticipated events and circumstances may not occur; therefore, the actual results achieved during the forecast periods will vary from the forecast, and the variances may be material. These financial projections were based on the following essential assumptions: ■ Growth; ■ Additional staffing; ■ Inflation; SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 17 City of Wylie, Texas ~` Update of Water & Wastewater Rates ■ 2.2.1. Growth assumptions. There is no assumption more critical than the growth assumptions that drive the financial plan. Table 2.1 shows the number of water meters that will be added per year. Table 2.2 shows the number of wastewater connections that will be added per year. Table 2.1 Key Findings Growth - Water Annual Annual Consumption Fiscal Additional Billed Year Meters Annual Billings (Th. Gals.) 2013 250 141,989 2.2% 1,576,429 9.3% 2014 250 144,989 2.1% 1,603,114 1.7% 2015 250 147,989 2.1% 1,629,799 1.7% 2016 250 150,989 2.0% 1,656,484 1.6% 2017 160 152,909 1.3% 1,673,563 1.0% 2018 160 154,829 1.3% 1,690,641 1.0% 2019 80 155,789 1.9% 1,699,180 1.5% 2020 80 156,749 1.2% 1,707,719 1.0% 2021 80 157,709 1.2% 1,716,259 1.0% 2022 80 158,669 1.2% 1,724,798 1.0% 2023 80 159,629 1.2% 1,733,337 1.0% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 18 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.2 Key Findings Growth - Water Billed for Wastewater Annual Annual Consumption Fiscal Additional Billed Year Meters Annual Billings (Th. Gals.) 2013 250 156,022 2.0% 1,353,701 9.5% 2014 250 159,022 1.9% 1,380,230 2.0% 2015 250 162,022 1.9% 1,406,759 1.9% 2016 250 165,022 1.9% 1,433,288 1.9% 2017 160 166,942 1.2% 1,450,266 1.2% 2018 160 168,862 1.2% 1,467,245 1.2% 2019 80 169,822 1.7% 1,475,734 1.8% 2020 80 170,782 1.1% 1,484,223 1.2% 2021 80 171,742 1.1% 1,492,713 1.2% 2022 80 172,702 1.1% 1,501,202 1.1% 2023 80 173,662 1.1% 1,509,691 1.1% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 19 City of Wylie, Texas Update of Water & Wastewater Rates ■ 2.2.2. Additional staffing. Table 2.3 illustrates the projected staffing levels over the next ten years. Table 2.3 Existing & Projected Operating & Maintenance Costs Stang Levels Utility Water Sewer Utility Fiscal Admin Dist. Engineering Collection Billing Total Year 5711 5712 5713 5714 5715 Staffing 2012 3.00 11.00 3.00 4.00 6.00 27.00 2013 2.00 15.00 3.00 6.00 4.00 30.00 2014 2.00 15.00 4.00 6.00 4.00 31.00 2015 4.00 15.00 4.00 8.00 4.00 35.00 2016 4.00 15.00 4.00 8.00 4.00 35.00 2017 4.00 15.00 4.00 8.00 6.00 37.00 2018 5.00 15.00 4.00 9.00 6.00 39.00 2019 5.00 15.00 4.00 9.00 6.00 39.00 2020 5.00 15.00 4.00 9.00 6.00 39.00 2021 5.00 15.00 4.00 9.00 6.00 39.00 2022 5.00 15.00 4.00 9.00 6.00 39.00 2023 5.00 15.00 4.00 9.00 6.00 39.00 Staffing assumptions were provided by the City of Wylie SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 20 City of Wylie, Texas Update of Water & Wastewater Rates ■ 2.2.3. Salaries & Benefits. Salaries were increased annually using expenditure drivers of 5%, based on the FY 2014 budget. Medical insurance was increased annually at 5%. Other benefits were increased as a ratio of salaries. Table 2.4 Existing & Projected Operating & Maintenance Costs Salaries & Benefits Utility Water Sewer Utility Fiscal Admin Dist. Engineering Collection Billing % Year 5711 5712 5713 5714 5715 Total Incr. 2012 205,369 667,182 337,454 285,506 369,808 1,865,318 4.8% 2013 223,451 953,249 365,842 462,772 239,886 2,245,200 20.4% 2014 211,468 926,628 365,750 333,828 206,686 2,044,360 -8.9% 2015 247,277 1,013,774 401,307 456,901 234,408 2,353,667 15.1% 2016 259,641 1,064,463 421,372 479,746 246,128 2,471,350 5.0% 2017 272,623 1,117,686 442,441 503,733 385,672 2,722,154 10.1% 2018 300,861 1,173,570 464,563 593,312 404,955 2,937,261 7.9% 2019 315,904 1,232,249 487,791 622,977 425,203 3,084,124 5.0% 2020 331,699 1,293,861 512,181 654,126 446,463 3,238,330 5.0% 2021 348,284 1,358,554 537,790 686,833 468,786 3,400,246 5.0% 2022 365,698 1,426,482 564,679 721,174 492,225 3,570,259 5.0% 2023 383,983 1,497,806 592,913 757,233 516,837 3,748,772 5.0% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 21 City of Wylie, Texas Update of Water & Wastewater Rates ■ 2.2.4. NTMWD water purchase costs. We have assumed the rate per thousand gallons charged by the North Texas Municipal Water District will increase as follows: Table 2.5 Existing & Projected Operating & Maintenance Costs Water Purchases from NTMWD Planned Annual Consumption Take-or- Actual & Amount Take-or- NTMWD Fiscal Pay Planned Over/(Under) Pay Annual % Year Minimum Usage (000's) Minimum Minimum Charges Change 2012 1,721,763 1,711,680 (10,083) 1.49 2,561,495 8.9% 2013 1,721,763 1,695,602 (26,161) 1.70 2,945,110 15.0% 2014 1,721,763 1,724,304 2,541 1.88 3,360,000 14.1% 2015 1,724,304 1,753,006 28,702 2.06 3,563,547 6.1% 2016 1,753,006 1,781,709 28,702 2.24 3,938,215 10.5% 2017 1,781,709 1,800,079 18,370 2.42 4,319,083 9.7% 2018 1,800,079 1,818,448 18,369 2.57 4,633,550 7.3% 2019 1,818,448 1,827,632 9,185 2.70 4,913,483 6.0% 2020 1,827,632 1,836,817 9,185 2.81 5,139,321 4.6% 2021 1,836,817 1,846,002 9,186 2.90 5,330,443 3.7% 2022 1,846,002 1,855,187 9,185 2.97 5,486,301 2.9% 2023 1,855,187 1,864,371 9,185 3.02 5,606,338 2.2% Note-the increases projected in the rate per th.gallons are based on a presentation by NTMWD management last year. SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 22 f City of Wylie, Texas Update of Water & Wastewater Rates Table 2.6 illustrates that the effective cost per 1,000 gallons paid to the NTMWD is significantly higher, due to the take-or-pay provision of the NTMWD agreement. Table 2.6 Existing & Projected Operating & Maintenance Costs Calculation of Incremental Increase in NTMWD Water Purchase Cost per Th. Gallons Actual & Actual& Effective Projected Projected Average Incremental NTMWD Annual Water Increase Water Volume Purchase Average Fiscal Purchase Billed Cost/ Cost/ Year Costs - (Th. Gals.) = Th. Gals. = Th. Gals. From From Table 2.5 Table 2.1 2012 2,561,495 _ 1,442,936 = 1.78 = 0.42 2013 2,945,110 _ 1,576,429 = 1.87 = 0.09 2014 3,360,000 - 1,603,114 = 2.10 = 0.23 2015 3,563,547 - 1,629,799 = 2.19 = 0.09 2016 3,938,215 = 1,656,484 = 2.38 = 0.19 2017 4,319,083 - 1,673,563 = 2.58 = 0.20 2018 4,633,550 _ 1,690,641 = 2.74 = 0.16 2019 4,913,483 - 1,699,180 = 2.89 = 0.15 2020 5,139,321 _ 1,707,719 = 3.01 = 0.12 2021 5,330,443 _ 1,716,259 = 3.11 = 0.10 2022 5,486,301 _ 1,724,798 = 3.18 = 0.07 2023 5,606,338 _ 1,733,337 = 3.23 = 0.05 SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 23 City of Wylie, Texas T Update of Water & Wastewater Rates ■ 2.2.5. NTMWD wastewater treatment costs. Tables 2.7 — 2.9 illustrate the assumptions used to forecast the wastewater treatment costs. Table 2.7 Existing & Projected Operating & Maintenance Costs NTMWD Muddy Creek Wastewater Treatment Plant Avg. Cost per Th. Planned Gallons Planned Muddy Inflated WWTP Creek Fiscal at 3% Flow WWTP % Year Per Year x (000's) = Costs Incr. 2013 1.81 x 1,948,091 = 3,531,290 - 2014 1.87 x 1,986,269 = 3,708,509 5.0% 2015 1.92 x 2,024,446 = 3,893,183 5.0% 2016 1.98 x 2,062,624 = 4,085,600 4.9% 2017 2.04 x 2,087,057 = 4,258,016 4.2% 2018 2.10 x 2,111,491 = 4,437,102 4.2% 2019 2.16 x 2,123,707 = 4,596,657 3.6% 2020 2.23 x 2,135,924 = 4,761,792 3.6% 2021 2.30 x 2,148,141 = 4,932,701 3.6% 2022 2.37 x 2,160,358 = 5,109,576 3.6% 2023 2.44 x 2,172,574 = 5,292,623 3.6% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 24 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.8 Existing & Projected Operating & Maintenance Costs NTMWD Muddy Creek Interceptor Average Cost per Th. Planned Gallons Planned Muddy Inflated Interceptor Creek Fiscal at 3% Flow Interceptor % Year Per Year x (000's) = Costs Incr. 2013 0.11 x 1,948,091 = 220,836 2014 0.12 x 1,986,269 = 231,919 5.0% 2015 0.12 x 2,024,446 = 243,468 5.0% 2016 0.12 x 2,062,624 = 255,501 4.9% 2017 0.13 x 2,087,057 = 266,284 4.2% 2018 0.13 x 2,111,491 = 277,483 4.2% 2019 0.14 x 2,123,707 = 287,461 3.6% 2020 0.14 x 2,135,924 = 297,788 3.6% 2021 0.14 x 2,148,141 = 308,476 3.6% 2022 0.15 x 2,160,358 = 319,538 3.6% 2023 0.15 x 2,172,574 = 330,985 3.6% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 25 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.9 Existing & Projected Operating & Maintenance Costs Recap of Wastewater Treatment Costs Muddy Muddy Creek Creek WWTP Interceptor Costs Costs Wylie Fiscal From From WWTP Pretreatment % Year Table 2.7 Table 2.8 Costs Costs Total Incr. 2013 3,531,290 220,836 35,105 62,534 3,849,766 2014 3,708,509 231,919 36,158 64,410 4,040,996 5.0% 2015 3,893,183 243,468 37,243 66,342 4,240,236 4.9% 2016 4,085,600 255,501 38,360 68,332 4,447,794 4.9% 2017 4,258,016 266,284 39,511 70,382 4,634,193 4.2% 2018 4,437,102 277,483 40,697 72,494 4,827,776 4.2% 2019 4,596,657 287,461 41,917 74,668 5,000,704 3.6% 2020 4,761,792 297,788 43,175 76,909 5,179,664 3.6% 2021 4,932,701 308,476 44,470 79,216 5,364,863 3.6% 2022 5,109,576 319,538 45,804 81,592 5,556,510 3.6% 2023 5,292,623 330,985 47,178 84,040 5,754,827 3.6% Percentage Increase FY 2014-FY 2023-> $ 1,713,830 42.4% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 26 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.10 Existing & Projected Operating & Maintenance Costs Calculation of NTMWD Incremental Wastewater Increase in Cost per Th. Gallons Effective Actual & Actual& Average Projected Projected Waste- Incremental NTMWD Annual Water Increase Wastewater Volume Treatment Average Fiscal Treatment Billed Cost/ Cost/ Year Costs - (Th. Gals.) = Th. Gals. = Th. Gals. From From Table 2.9 Table 2.2 2013 3,849,766 _ 1,353,701 = 2.84 = 2.77 2014 4,040,996 _ 1,380,230 = 2.93 = 0.08 2015 4,240,236 _ 1,406,759 = 3.01 = 0.09 2016 4,447,794 _ 1,433,288 = 3.10 = 0.09 2017 4,634,193 - 1,450,266 = 3.20 = 0.09 2018 4,827,776 _ 1,467,245 = 3.29 = 0.09 2019 5,000,704 _ 1,475,734 = 3.39 = 0.10 2020 5,179,664 - 1,484,223 = 3.49 = 0.10 2021 5,364,863 _ 1,492,713 = 3.59 = 0.10 2022 5,556,510 _ 1,501,202 = 3.70 = 0.11 2023 5,754,827 _ 1,509,691 = 3.81 = 0.11 Note-the effective increase in the average cost per thousand gallons. SECTION I I—IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 27 City of Wylie, Texas Update of Water & Wastewater Rates ■ 2.2.6. Other Operating & Maintenance Costs. Most other operating and maintenance costs were driven by an annual inflation factor of 3 Table 2.11 Key Findings Recap of Operating Department Cost Utility Administration (5711) Salaries Materials Fiscal & For Contractural % Year Benefits Supplies Maint. Services Total Change From Supports Table 2.4 Table 2.18 2012 205,369 4,268 31,035 36,331 277,002 11.5% 2013 223,451 6,750 250 42,588 293,039 5.8% 2014 211,468 6,500 250 46,650 281,868 -3.8% 2015 247,277 6,695 258 48,050 319,789 13.5% 2016 259,641 6,896 265 49,491 334,328 4.5% 2017 272,623 7,103 273 50,976 349,551 4.6% 2018 300,861 7,316 281 52,505 380,097 8.7% 2019 315,904 7,535 290 54,080 397,517 4.6% 2020 331,699 7,761 299 55,703 415,760 4.6% 2021 348,284 7,994 307 57,374 434,867 4.6% 2022 365,698 8,234 317 59,095 454,879 4.6% 2023 383,983 8,481 326 60,868 475,839 4.6% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 28 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.12 Key Findings Recap of Operating Department Cost Water Distribution (5712) Salaries Materials Fiscal & For Contractural Capital % Year Benefits Supplies Maint. Services Outlay Total Change From Supports Table 2.4 Table 2.18 2012 667,182 42,428 83,089 193,022 39,396 1,025,116 2.9% 2013 953,249 59,324 125,750 248,950 212,126 1,599,399 56.0% 2014 926,628 68,799 129,450 249,510 365,751 1,740,138 8.8% 2015 1,013,774 70,863 133,334 256,995 377,034 1,852,000 6.4% 2016 1,064,463 72,989 137,334 264,705 388,664 1,928,155 4.1% 2017 1,117,686 75,179 141,454 272,646 400,535 2,007,499 4.1% 2018 1,173,570 77,434 145,697 280,826 412,768 2,090,294 4.1% 2019 1,232,249 79,757 150,068 289,250 425,262 2,176,586 4.1% 2020 1,293,861 82,150 154,570 297,928 438,135 2,266,644 4.1% 2021 1,358,554 84,614 159,207 306,866 451,397 2,360,638 4.1% 2022 1,426,482 87,153 163,983 316,072 465,061 2,458,750 4.2% 2023 1,497,806 89,767 168,903 325,554 479,138 2,561,168 4.2% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 29 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.13 Key Findings Recap of Operating Department Cost Engineering (5713) Salaries Materials Fiscal & For Contractural Capital % Year Benefits Supplies Maint. Services Outlay Total Change From Supports Table 2.4 Table 2.18 2012 337,454 8,542 148 67,397 250 413,791 5.8% 2013 365,842 11,170 2,000 65,870 - 444,882 7.5% 2014 365,750 11,170 2,000 6,750 135,000 520,670 17.0% 2015 401,307 11,505 2,060 6,953 - 421,825 -19.0% 2016 421,372 11,850 2,122 7,161 - 442,505 4.9% 2017 442,441 12,206 2,185 7,376 - 464,208 4.9% 2018 464,563 12,572 2,251 7,597 - 486,983 4.9% 2019 487,791 12,949 2,319 7,825 - 510,884 4.9% 2020 512,181 13,338 2,388 8,060 - 535,966 4.9% 2021 537,790 13,738 2,460 8,302 - 562,289 4.9% 2022 564,679 14,150 2,534 8,551 - 589,913 4.9% 2023 592,913 14,574 2,610 8,807 - 618,904 4.9% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 30 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.14 Key Findings Recap of Operating Department Cost Sewer Collection (5714) Salaries Materials Fiscal & For Contractural % Year Benefits Supplies Maint. Services Total Change From Supports Table 2.4 Table 2.18 2012 285,506 21,116 63,843 102,191 540,734 -11.7% 2013 462,772 33,800 81,000 137,026 908,048 67.9% 2014 333,828 39,600 86,500 136,750 785,678 -13.5% 2015 456,901 40,788 89,095 140,853 727,636 -7.4% 2016 479,746 42,012 91,768 145,078 758,603 4.3% 2017 503,733 43,272 94,521 149,430 790,956 4.3% 2018 593,312 44,570 97,357 153,913 889,152 12.4% 2019 622,977 45,907 100,277 158,531 927,693 4.3% 2020 654,126 47,284 103,286 163,287 967,983 4.3% 2021 686,833 48,703 106,384 168,185 1,010,105 4.4% 2022 721,174 50,164 109,576 173,231 1,054,145 4.4% 2023 757,233 51,669 112,863 178,428 1,100,192 4.4% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 31 City of Wylie, Texas = Update of Water & Wastewater Rates Table 2.15 Key Findings Recap of Operating Department Cost Utility Billing (5715) Salaries Materials Fiscal & For Contractural Capital % Year Benefits Supplies Maint. Services Outlay Total Change From Supports Table 2.4 Table 2.18 2012 369,808 15,740 18,183 122,748 70,279 596,757 9.0% 2013 239,886 11,530 20,830 84,490 - 356,736 -40.2% 2014 206,686 9,730 17,330 112,500 - 346,246 -2.9% 2015 234,408 10,022 17,850 115,875 - 378,155 9.2% 2016 246,128 10,323 18,385 119,351 - 394,188 4.2% 2017 385,672 10,632 18,937 122,932 - 538,172 36.5% 2018 404,955 10,951 19,505 126,620 - 562,031 4.4% 2019 425,203 11,280 20,090 130,418 - 586,991 4.4% 2020 446,463 11,618 20,693 134,331 - 613,105 4.4% 2021 468,786 11,967 21,314 138,361 - 640,427 4.5% 2022 492,225 12,326 21,953 142,512 - 669,016 4.5% 2023 516,837 12,695 22,612 146,787 - 698,931 4.5% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 32 City of Wylie, Texas Update of Water & Wastewater Rates ■ 2.2.7. Non-operating costs. The following tables illustrate the other non-operating costs that are incorporated into the financial plan. ■ 2.2.8. Existing and planned debt. The following tables show the principal and interest payments incorporated into the cost of service. SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 33 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.16 Key Findings Components of Non-Departmental Costs (5719) Recap of Existing Water& Wastewater Debt Service Payments PPFCO All All Fiscal Series GO Combo Fiscal Year 2005 Debt Debt Fees Total Supports Table 2.17 2012 151,454 598,400 579,275 500 1,329,629 2013 135,342 606,113 576,875 2,000 1,320,330 2014 - 762,763 578,975 2,000 1,343,738 2015 - 757,763 580,475 5,000 1,343,238 2016 - 462,413 576,475 5,000 1,043,888 2017 - 396,838 576,975 5,000 978,813 2018 - 293,025 576,875 5,000 874,900 2019 - 291,088 576,175 5,000 872,263 2020 - 184,888 579,513 5,000 769,401 2021 - 36,663 576,606 5,000 618,269 2022 - 35,569 577,694 5,000 618,263 2023 - - 577,931 5,000 582,931 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 34 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.17 Key Findings Components of Non-Departmental Costs (5719) Transfer All NTMWD NTMWD to Other Fiscal Water Sewer Existing Planned General Non- Year Costs Costs Debt Debt Fund Dept. Total From From From Supports Table 2.5 Table 2.9 Table 2.16 Table 2.18 2013 2,945,110 3,849,766 1,320,330 - 1,767,296 265,710 10,148,212 2014 3,360,000 4,040,996 1,343,738 260,479 1,789,098 309,500 11,103,812 2015 3,563,547 4,240,236 1,343,238 260,479 1,842,771 318,785 11,569,057 2016 3,938,215 4,447,794 1,043,888 260,479 1,898,054 328,349 11,916,779 2017 4,319,083 4,634,193 978,813 260,479 1,954,996 338,199 12,485,763 2018 4,633,550 4,827,776 874,900 260,479 2,013,646 348,345 12,958,696 2019 4,913,483 5,000,704 872,263 260,479 2,074,055 358,795 13,479,780 2020 5,139,321 5,179,664 769,401 260,479 2,136,277 369,559 13,854,700 2021 5,330,443 5,364,863 618,269 260,479 2,200,365 380,646 14,155,066 2022 5,486,301 5,556,510 618,263 260,479 2,266,376 392,065 14,579,994 2023 5,606,338 5,754,827 582,931 - 2,334,367 403,827 14,682,290 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 35 City of Wylie, Texas 4%= T Update of Water & Wastewater Rates Table 2.18 Recap of the Gross Cost of Service Utility Water Sewer Utility Non- Fiscal Admin Dist. Engineering Collection Billing Dept % Year 5711 5712 5713 5714 5715 5719 Total Incr. From From From From From From Supports Table 2.11 Table 2.12 Table 2.13 Table 2.14 Table 2.15 Table 2.17 Table 2.17 2012 277,002 1,025,116 413,791 540,734 596,757 9,327,028 12,180,429 6.3% 2013 293,039 1,599,399 444,882 908,048 356,736 10,148,212 13,750,315 12.9% 2014 281,868 1,740,138 520,670 785,678 346,246 11,103,812 14,778,412 7.5% 2015 319,789 1,852,000 421,825 727,636 378,155 11,569,057 15,268,461 3.3% 2016 334,328 1,928,155 442,505 758,603 394,188 11,916,779 15,774,558 3.3% 2017 349,551 2,007,499 464,208 790,956 538,172 12,485,763 16,636,149 5.5% 2018 380,097 2,090,294 486,983 889,152 562,031 12,958,696 17,367,252 4.4% 2019 397,517 2,176,586 510,884 927,693 586,991 13,479,780 18,079,450 4.1% 2020 415,760 2,266,644 535,966 967,983 613,105 13,854,700 18,654,158 3.2% 2021 434,867 2,360,638 562,289 1,010,105 640,427 14,155,066 19,163,392 2.7% 2022 454,879 2,458,750 589,913 1,054,145 669,016 14,579,994 19,806,698 3.4% 2023 475,839 2,561,168 618,904 1,100,192 698,931 14,682,290 20,137,325 1.7% Percentage Increase FY 2014-FY 2023-> $ 5,358,914 36.3% SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 36 City of Wylie, Texas Update of Water & Wastewater Rates ■ 2.2.9. Revenue offsets. The following tables illustrate the projection of the non-rate revenues. Note-these revenues are used to reduce the revenues required from rates. Table 2.19 Key Findings Recap of Revenue Offsets -Service Charges Utility Weekend Water Sewer Turn On/ Water Pre- Inspection Tap Tap Turn Off Sales Treatment Fiscal Fees Penalties Fees Fees Fees Bulk Fees Year (44315) (44515) (44516) (44517) (44518) (44519) (44520) Total Supports Table 2.21 2012 3,150 186,034 46,754 10,170 71,615 10,774 56,674 385,172 2013 1,000 170,000 40,000 9,000 65,000 25,000 55,000 365,000 2014 1,000 180,000 45,000 12,000 65,000 25,000 55,000 383,000 2015 1,000 188,485 45,931 12,248 66,345 25,517 56,138 395,665 2016 1,000 199,234 46,862 12,497 67,690 26,035 57,276 410,593 2017 1,000 209,339 47,458 12,655 68,551 26,366 58,004 423,373 2018 1,000 219,934 48,054 12,814 69,411 26,697 58,733 436,643 2019 1,000 229,886 48,352 12,894 69,842 26,862 59,097 447,933 2020 1,000 240,283 48,650 12,973 70,272 27,028 59,461 459,667 2021 1,000 248,729 48,948 13,053 70,703 27,193 59,825 469,450 2022 1,000 257,465 49,246 13,132 71,133 27,359 60,189 479,524 2023 1,000 266,502 49,544 13,212 71,563 27,524 60,554 489,898 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 37 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.20 Key Findings Recap of Revenue Offsets -All Other Revenue Offsets Fiscal Interest Contributions Year Income Misc. Sewer Total Supports Table 2.21 2012 120,363 71,698 214,440 406,500 2013 10,000 40,000 - 50,000 2014 7,000 42,000 - 49,0.00 2015 7,000 30,000 - 37,000 2016 7,000 30,000 - 37,000 2017 7,000 30,000 - 37,000 2018 7,000 30,000 - 37,000 2019 7,000 30,000 - 37,000 2020 7,000 30,000 - 37,000 2021 7,000 30,000 - 37,000 2022 7,000 30,000 - 37,000 2023 7,000 30,000 - 37,000 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 38 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.21 Existing & Projected Total Sources of Funds Waste- Non- Non- Total Water Water Rate Rate Sources Revenues Revenues Operating Operating of Generated Generated Revenue Revenue Funds Fiscal From From From From Supports Year Rates Rates Table 2.19 Table 2.20 Table 2.22 2012 6,392,093 5,207,775 385,172 406,500 12,391,540 2013 7,431,473 5,665,024 365,000 50,000 13,511,498 2014 7,783,893 5,933,793 383,000 49,000 14,149,686 2015 8,150,769 6,213,590 395,665 37,000 14,797,024 2016 8,615,494 6,567,988 410,593 37,000 15,631,075 2017 9,052,431 6,901,164 423,373 37,000 16,413,968 2018 9,510,534 7,250,485 436,643 37,000 17,234,662 2019 9,940,878 7,578,607 447,933 37,000 18,004,418 2020 10,390,433 7,921,378 459,667 37,000 18,808,479 2021 10,755,628 8,199,835 469,450 37,000 19,461,914 2022 11,133,379 8,487,871 479,524 37,000 20,137,774 2023 11,524,115 8,785,808 489,898 37,000 20,836,821 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 39 City of Wylie, Texas Update of Water & Wastewater Rates Table 2.22 Key Findings Recap of the Sources & Uses of Funds Less Total Gross Equals Beginning Sources Cost of Sources Operating of Funds Service Minus Equals Fiscal Reserve From From Uses of Ending Year Balance Table 2.21 Table 2.18 Funds Balance 2012 13,409,964 12,391,540 (12,180,429) 211,111 13,621,075 2013 5,719,913 13,511,498 (13,750,315) (238,818) 5,481,095 2014 5,651,882 14,149,686 (14,778,412) (628,726) 5,023,156 2015 5,574,632 14,797,024 (15,268,461) (471,437) 5,103,195 2016 5,122,037 15,631,075 (15,774,558) (143,483) 4,978,554 2017 4,998,327 16,413,968 (16,636,149) (222,182) 4,776,145 2018 4,796,753 17,234,662 (17,367,252) (132,591) 4,664,162 2019 4,685,636 18,004,418 (18,079,450) (75,032) 4,610,604 2020 4,632,851 18,808,479 (18,654,158) 154,320 4,787,171 2021 4,707,355 19,461,914 (19,163,392) 298,522 5,005,877 2022 4,775,756 20,137,774 (19,806,698) 331,076 5,106,832 2023 4,877,561 20,836,821 (20,137,325) 699,496 5,577,057 SECTION I I-IDENTIFICATION OF REVENUE REQUIREMENTS PAGE 40 APPENDIX A: SUPPORTING WORKSHEETS 41 McLain Decision Support Systems City of Wylie, Texas Update of Water & Wastewater Rates Worksheet 1 Financial Summary•Combined Water&Wastewater Scenario 2:Smaller Increases annually Actual Revised Planned Planned Planned Planned planned Planned Panned Planned Planned Planned 2012 2013 2014 2015 2016 2017 2019 2019 2020 2021 2022 2023 Description 0) (k) (1) (2) (3) (4) (5) (6) (7) (8) (9) (SO) Beginning Working Capital Reserve $ 13,409,964 $ 5,719,913 $ 5,651,982 $ 5,574,632 $ 5,122,037 $ 4,998,327 $ 4,796,753 $ 4,685,636 $ 4,632,851 $ 4,707,355 $ 4,775,756 $ 4,877,561 Water Sales $ 6,392,093 $ 7,431,473 $ 7,783,893 $ 8,150,769 $ 8,615,494 $ 9,052,431 $ 9,510,534 $ 9,940,878 $ 10,390,433 $ 10,755,628 $ 11,133,379 $ 11,524,115 Sewer Treatment 5,207,775 5,665,024 5,933,793 6,213,590 6,567,988 6,901,164 7,250,485 7,578,607 7,921,378 8,199,835 8,487,871 8,785,808 Bulk Water Sales 10,774 25,000 25,000 25,517 26,035 26,366 26,697 26,862 27,028 27,193 27,359 27,524 Penalties 186,034 170,000 180,000 188,485 199,234 209,339 219,934 229,986 240,283 248,729 257,465 266,502 All Other Service Fees 188,363 170,000 178,000 181,662 185,325 187,669 190,012 191,184 192,356 193,528 194,700 195,872 Interest Income 120,363 10,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 Miscellaneous Income 71,698 40,000 42,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Transfer from Impact Fee Fund Transfer from Fleet Fund - - - - - - - - - - Contributions 393,140 Service Fees $ 12,570,240 $ 13,511,496 $ 14,149,686 $ 14,797,024 $ 15,631,075 $ 16,413,968 $ 17,234,662 $ 18,004,418 $ 18,808,479 $ 19,461,914 $ 20,137,774 $ 20,836,821 Utility Administration(5711) $ 277,002 $ 293,039 $ 281,868 $ 319,789 $ 334,328 $ 349,551 $ 380,D97 $ 397,517 $ 415,760 S 434,867 S 454,1379 $ 475,839 Water Distribution(5712) 1,025,116 1,599,399 1,740,138 1,852,000 1,928,155 2,007,499 2,090,294 2,176,586 2,266,644 2,360,638 2,458,750 2,561,168 Engineering(5713) 413,791 444,882 520,670 421,825 442,505 464,208 486,983 510,884 535,966 562,289 589,913 618,904 Sewer Collection(S714) 540,734 908,048 785,678 727,636 758,603 790,956 889,152 927,693 967,983 1,010,305 1,054,145 1,100,192 Utility Billing(5715) 596,757 356,736 346,246 378,155 394,188 538,172 562,031 586,991 613,105 640,427 669,016 698,931 NTMWD-Water Purchases 2,561,495 2,945,110 3,360,000 3,563,547 3,938,215 4,319,083 4,633,550 4,913,483 5,139,321 5,330,443 5,486,301 5,606,338 NTMWD-Sewer Treatment 4,517,012 3,540,481 3,750,000 4,221,394 4,428,020 4,613,585 4,806,301 4,978,458 5,156,618 5,340,990 5,531,781 5,729,212 All Other O&M Expenditures 3,664,112 265,710 309,500 318,785 328,349 338,199 348,345 358,795 369,559 380,646 392,065 403,827 Total Operating Expenditures $ 13,596,020 $ 10,353,405 $ 11,094,100 $ 11,803,131 $ 12,552,363 $ 13,421,254 $ 14,196,7S3 $ 14,950,406 $ 15,464,956 S 16,060,406 $ 16,636,850 $ 17,194,412 Debt Service-Existing $ 1,319,987 5 1,320,330 $ 1,343,738 $ 1,343,238 $ 1,043,888 $ 978,813 $ 874,900 $ 872,263 $ 872,263 $ 872,263 S 872,263 $ 872,263 Debt Service-Planned 3,500,000 260,479 260,479 260,479 260,479 260,479 260,479 260,479 260,479 260,479 Total Debt Service $ 4,819,987 $ 1,320,330 $ 1,343,738 $ 1,603,717 $ 1,304,367 $ 1,239,292 $ 1,135,379 $ 1,132,742 $ 1,132,742 $ 1,132,742 $ 1,134742 $ 1,132,742 Transfer to General Fund S 1676 997 $ 1,767,296 $ 1 769 098 $ 1842 771 $ 1,898,054 $ 1,954 996 $ 2,013,646 $ 2,074,055 S 2,136,277 $ 2,200,365 $ 2,266,376 $ 2,334 367 Non-Operating Expenditures $ 1,676,997 $ 1,767,296 $ 1,789,098 $ 1,842,771 $ 1,898,OS4 $ 1,954,996 $ 2,013,646 $ 2,074,055 $ 2,136,277 $ 2,200,365 $ 2,266,376 $ 2,334,367 Total Uses of Funds $ 20,093,004 $ 13,441,031 $ 14,226,936 $ 15,249,619 $ 15,754,785 $ 16,615,542 $ 17,345,778 $ 18,057,204 $ 18,733,974 $ 19,393,513 $ 20,035,969 $ 20,661,522 Sources Minus Uses of Funds $ (7,522,764) $ 70,467 $ (77,250) $ (452,S95) $ (123,710) $ (201,574) $ (111,1161 $ (52,785) $ 74,504 $ 68,401 $ 101,805 $ 175,299 Ending Working Capital Reserve $ 5,719,913 $ 5,651,882 $ 5,574,632 $ 5,122,037 $ 4,998,327 $ 4,796,753 $ 4,685,636 $ 4,632,851 $ 4,707,355 $ 4,77S,756 $ 4,877,S61 $ 5,052,860 %of Operating Expenditures 28% 42% 39% 34% 32% 29% 27% 26% 25% 25% 24% 24% Targeted Days of Operating Reserves Days of Working Capital 126 153 143 125 118 107 100 9S 93 91 90 90 Revenue Increases Suseested: Water N/A N/A 3,00% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 3.00% 3.00% 3.00% Wastewater N/A N/A 3.00% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 3.OD% 3.OD% 3.00% Overall Water&Wastewater N/A N/A 3.OD% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 3.00% 3.00% 3.00% APPENDIX A PAGE 41 City of Wylie, Texas Update of Water & Wastewater Rates Worksheet 2 Rate Design Alternatives-Water Rate Design Alternative 1(Across-the-Board Increase) Monthly Minimum Bills Number Annual Consumption Existing Proposed Planned Planned Planned Planted Planned Planned Planned Planned Planned of Consumption Passing thru 2014 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Meters Billed Brackets (1) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Outside to Inside Ratio 1.15 1.15 1.15 1.15 1.15 1.15 1.15 Lis 1.15 1.15 1.15 Gallons in Minumum Bill 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 5/8 x 3/4 Inch 131,265 1,075,027 N/A $ 10.67 $ 10.99 5 11.32 5 11.77 $ 12.24 $ 12.73 $ 13.24 $ 13.77 5 14.19 5 14.61 $ 15.05 1 Inch 156 2,417 N/A 10.67 10.99 11.32 11.77 12.24 12.73 13.24 13.77 14.19 14.61 15.05 1.5 Inch 25 326 N/A 10.67 10.99 11.32 11.77 12.24 12.73 13.24 13.77 14.19 14.61 15.05 21nch 36 904 N/A 10.67 10.99 11,32 11.77 12.24 12.73 13.24 13.77 14.19 14.61 1505 Residential 131,482 1,078,674 N/A Gallons in Minumum Bill 1,000 1,000 1,000 1,D00 1,000 1,000 1,000 1,000 1,000 1,000 1,000 5/8 x 3/4 Inch 61 11,587 N/A $ 14.57 $ 15.01 S 15.46 $ 16.08 $ 16.72 $ 17.39 $ 18.08 $ 18.81 $ 19.37 $ 19.95 $ 20.55 1.5 Inch 13 1,058 N/A 14.57 15.01 15.46 16.08 16.72 17.39 18.08 18.81 1937. 19.95 2055. 2 Inch 12 1,539 N/A 14.57 15.01 15.46 16.08 16.72 17.39 18.08 18.81 1937. 1995. 20.55 .. 61nch 25 261168 N/A 14.57 15.01 15.46 16.08 16.72 17.39 18.08 18.81 19.37 1995. 2055, Multi-Family 111 40,352 N/A II Gallons In Minumum BIII 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 5/8 x 3/4 Inch 4,003 70,347 N/A $ 14.57 $ 15.01 $ 15.46 $ 16.08 $ 16.72 $ 17.39 $ 18.08 $ 18.81 $ 1937. $ 1995. $ 20.55 I Inch 568 18,924 N/A 14.57 15.0115.46 16.08 16.72 17.39 18.08 18.81 19.37 1995. 2055. 1.5 Inch 96 2,162 N/A 14.57 1 5.0 1 15.46 16.08 16.72 17.39 18.08 18.81 1937. 1935 2055. 21nch 641 65,049 N/A 14.57 15.01 15.46 16,08 16.72 17.39 18.08 18.81 19.37 19.95 2055 31nch - - N/A 14.57 15.01 15.46 16.08 16.72 17.39 18.08 18.81 1937. 19.95 20.55 41nch 24 21,122 N/A 14.57 15,01 15.46 16.08 16.72 17.39 18.08 18.81 1937. 19.95 2055. 61nch 36 11,963 N/A 14.57 15.01 15.46 16.08 16.72 17.39 18.08 18.81 1937. 1995. 2055, .. 9inch 12 9,134 N/A 14.57 15.01 15.46 16,08 16.72 17.39 18.08 18.81 1937. 1995. 2055. Commercial 5,380 198,701 N/A Gallons in Minumum Bill 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 5/8 x 3/4 Inch 689 5,085 N/A $ 10.67 $ 10.99 5 11.32 $ 11.77 $ 12.24 S 12.73 $ 1314 $ 1377 $ 14.19 $ 14.61 $ 15.05 . IInch 14 114 N/A 10.67 10.99 11.32 11.77 12.24 12.73 1314 13.77 14.19 14.61 15.05 21nch 3 8 N/A 10.67 10.99 11.32 11.77 12.24 12.73 13.24 13.77 14.19 14.61 15.05 ... Sprinklers-Residential 706 5,207 N/A Gallons in Minumum Bill 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 21nch N/A $ 14.57 $ 15.01 $ 15.46 $ 16.08 $ 16.72 $ 17.39 $ 18.08 $ 18.81 $ 19.37 $ 19.95 $ 20.55 Sprinklers-Multi-Family - - N/A . Gallons in Minumum BIII 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 5/8 x 3/4 Inch 1,260 46,026 N/A $ 14.57 $ 15.01 $ 15.46 $ 16.08 $ 16.72 $ 17.39 $ 18.08 $ 18.81 $ 19.37 $ 1995. $ 20.55 1 1Inch 322 12,601 N/A 14.57 ism 15.46 16.08 1672 17.39 18,08 18.81 19.37 19.95 2055. 1.5 Inch 60 1,054 N/A 14.57 15.01 15,46 16.08 16.72 17.39 18.08 18.81 19.37 19.95 2055. 21nch 761 71,468 N/A 14.57 15.01 15.46 16.08 16.72 17.39 18.08 18.81 19.37 1995. 2055. 31nch N/A 14.57 15.01 15.46 16,08 16.72 17.39 18.08 18.81 19.37 19.95 20.55 Sprinklers-Commercial 2,403 131,150 N/A APPENDIX A PAGE 42 City of Wylie, Texas ,.. Update of Water & Wastewater Rates Worksheet 2(Continued) Rate Design Alternatives-Water Rate Design Alternative 1(Across-the-Board Increase) Volumetric Rates Annual Consumption Existing Proposed Planned Planned Planned Planned Planned Planned Planned Planned Planned Annual Consumption Passing thru 2014 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Billings _ Billed Brackets (1) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Outside to Inside Ratio 0-1,000 4,449 1,964 128,997 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 1,001-5,000 50,041 164,281 422,208 3.59 3.70 3.81 3.96 4.12 4.28 4.46 4,63 4.77 4.92 5.06 - 5,001-10,000 44,525 313,840 253,550 3.59 3.70 3.81 3.96 4.12 4.28 4.46 4.63 4.77 4.92 5.06 10,001-15,000 16,033 194,841 116,681 4.67 4.81 4.95 5.15 5.36 5.57 5.80 6.03 6.21 6,39 6.59 7 15,001-20,000 7,497 129,321 61,551 4.67 4,81 4.95 5.15 5.36 5,57 5.80 6.03 6.21 6.39 6,59 Over 20,000 8,937 274,427 95,687 4.67 4.81 4.95 5.15 5,36 5.57 5.80 6,03 6.21 6.39 6.59 9 Residential 131,482 1,078,674 1,078,674 19 0-1,000 1 - 110 5 - $ - $ - $ - 5 - $ - $ - $ - $ - $ - $ - 11 1,001-5,000 . - 440 408 4.20 4.33 4.50 4.68 4.87 5,06 5.27 5.42 5.59 5.75 .2 5,001-10,000 1 10 550 4.08 4.20 4.33 4.50 4.68 4.87 5.06 5.27 5.42 5.59 5.75 17 10,001-15,000 6 77 532 4,08 4.20 4.33 4.50 4.68 4.87 5.06 5.27 5.42 5.59 5.75 12 15,001-20,000 - - 515 4.08 4.20 4.33 4.50 4.68 4.87 5.06 5.27 5.42 5.59 5.75 15 Over 20,000 103 40,266 38,206 4,08 4.20 4.33 4.50 4.68 4.87 5.06 5,27 5.42 5.59 5,75 1F Multi-family 111 40,352 40,352 17 0-1,000 1,213 499 4,666 $ - $ - $ - $ - $ - 5 - $ - $ - 5 - $ - $ - 1R 1,001-5,000 1,602 3,941 12,599 4.08 4.20 4.33 4.50 4.68 4.87 5.06 5.27 5.42 5.59 5.75 19 5,001-10,000 694 5,008 10,893 4.08 4.20 4.33 4.50 4.68 4.87 5.06 5.27 5.42 5.59 5.75 20 10,001-15,000 359 4,405 8,375 4.08 4,20 4.33 4.50 4.68 4.87 5.06 5.27 5.42 5.59 5.75 21 15,001-20,000 225 3,904 6,964 4,08 4.20 4.33 4.50 4.68 4.87 5.06 5.27 5.42 5.59 5.75 2- Over 20,000 1,287 180,942 155,202 4,08 4.20 4.33 4.50 4.68 4.87 5.06 5.27 5,42 5.59 5.75 23 Commercial 5,380 198,701 198,701 29 0-1,000 384 21 343 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 25 1,001-5,000 94 269 1,087 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 2,3 5,001-10,000 76 563 943 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 27 10,001-15,000 49 613 638 5,16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7,28 28 15,001-20,000 23 404 459 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 29 Over 20,000 80 3,337 1,737 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 30 Sprinkler-Residential 706 5,207 5,207 31 0-1,000 4 0 8 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 3.. 1,001-5,000 1 2 29 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 13 5,001-10,000 1 6 31 5.16 5.31 5.47 5.69 5.92 6.16 6,40 6.66 6.86 7.07 7.28 3» 10,001-15,000 - - 30 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 5 15,001-20,000 1 16 26 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 Over 20,000 5 339 239 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 $2 Sprinkler-Multi-Family 12 364 364 APPENDIX A PAGE 43 City of Wylie, Texas Update of Water & Wastewater Rates Worksheet 2(Continued) Rate Design Alternatives-Water Rate Design Alternative 1(Across-the-Board Increase) Volumetric Rates Annual Consumption Existing Proposed Planned Planned Planned Planned Planned Planned Planned Planned Planned Annual Consumption Passing thou 2014 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Billings Billed Brackets (1) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) 0-1,000 1,030 52 1,437 $ - $ - $ - $ $ - $ - $ - $ - $ - $ $ - 1,001-5,000 198 528 5,078 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 5,001-10,000 168 1,252 5,507 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 1 10,001 15,000 100 1,232 4,827 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 15,001-20,000 81 1,403 4,378 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 Over 20,000 838 126,809 110,049 5.16 5.31 5.47 5.69 5.92 6.16 6.40 6.66 6.86 7.07 7.28 Sprinkler-Commercial 2,415 131,276 131,276 From Monthly Minimum Bill $ 1,577,731 $ 1,625,063 $ 1,707,774 $ 1,811,403 5 1,907,367 $ 2,008,109 $ 2,101,147 $ 2,198,414 $ 2,277,984 $ 2,360,350 $ 2,445,608 From Volume Rates 5,979,446 6,158,830 6,442995 6,804,091 7145,064 7,502425 7,839,732 8,192,019 8,477,644 8,773,029 9,0784506 .. Total Revenues Generated $ 7,557,177 $ 7,783,893 $ 8,150,769 $ 8,615,494 $ 9,052,431 $ 9,510,534 $ 9,940,878 $ 10,390,433 $ 10,755,628 $ 11,133,379 $ 11,524,115 Change in Revenues-> 3.0% 3.0% 4,0% 4.0% 4.0% 4.0% 4.0% 3.0°/6 3.0% 3.0% Avg.Res.Mon.Bill @ 8,000 Gallons $ 35.80 $ 36.87 $ 37.98 $ 39.50 $ 41.08 $ 42.72 $ 44.43 5 46.21 $ 47.60 $ 49.02 $ 50.49 Monthly Difference$ N/A $ 1.07 $ I.11 $ 1.52 $ 1.58 $ 164 $ 1.71 $ 178 $ 1.39 $ 1.43 S 1.47 Monthly Difference-% N/A 3-DO'% 3.00% 4-00% 400% 4.00'% 4.00% 4.00% 3.00% 3.00% 3.00% '1 Avg.Commercial 1 Inch Mon.Bili @ 27,000 Gallons $ 120.65 $ 124.27 $ 128.00 $ 133.12 5 138.44 $ 143.98 $ 149.74 5 155.73 $ 160.40 5 165.21 $ 170.17 Monthly Difference-$ N/A $ 3.62 $ 3.73 $ 5.12 5 5.32 $ 5.54 $ 5.76 $ 5.99 $ 4.67 $ 4,81 $ 4.96 Monthly Difference-% N/A 3.00% 3.00% 4.00% 4.00% 4.00% 4.00% 400% 3.00°% 3.00% 3.00% Avg.Sprinkler 21nch Mon.Bill @ 60,000 Gallons $ 31901 $ 328.58 $ 338.44 $ 351.98 $ 366.05 $ 380.70 $ 395.92 $ 411.76 $ 424.11 $ 436.84 $ 449.94 Monthly Difference-$ N/A $ 9.57 $ 9.86 $ 13.54 $ 14.08 $ 14.64 5 1523 5 15.84 $ 12.35 $ 1272 $ 13.11 Monthly Difference% N/A 3.00% 3.00% 4.00% 4,00% 4.00% 4.00% 4.00% 3.00% 3.00% 3.00% Avg.Industrial 314 Inch Mon.Bill @ 300,000 Gallons $ 1,234.49 $ 1,271.52 $ 1,309.67 $ 1,362.06 $ 1,416.54 $ 1,473.20 $ 1,532.13 $ 1,593.41 $ 1,641.22 $ 1,690.45 $ 1,741.17 Monthly Di fferencer$ N/A $ 37.03 5 38.15 $ 52.39 $ 54.48 $ 56.66 $ 58.93 $ 6129 $ 47.80 $ 49.24 $ 50.71 Monthly Difference-% N/A 3.00% 3.00% 4.00% 4.00% 4,00% 4.00% 4.00% 3.00% 3.00% 3.00% APPENDIX A PAGE 44 City of Wylie, Texas Update of Water & Wastewater Rates Worksheet 3 Rate Design Alternatives-Wastewater Rate Design Alternative 1(Across-the-Board Increase) Monthly Minimum Bills Existing Proposed Planned Planned Planned Planned Planned Planned Planned Planned Planned 2014 2014 2016 2016 2017 2018 2019 2020 2021 2022 2023 (1) (1) (2) (3) (4) (6) (6) (7) (8) (9) (10) 1 Outside to Inside Ratio - - - - - - - - - - - 2 Residential&Multi-Family Includes $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00 3 5/8 x 3/4 Inch $ 33.98 $ 34.94 $ 35.93 $ 37.28 $ 38.70 $ 40.16 $ 41.69 $ 43.28 $ 44.52 $ 45.79 $ 47.11 4 1Inch 33.98 34.94 35.93 37.28 38.70 40.16 41.69 43.28 44.52 45.79 47.11 1.5 Inch 33.98 34.94 35.93 37.28 38.70 40.16 41.69 43.28 44.52 45.79 47.11 6 21nch 33.98 34.94 35.93 37.28 38.70 40.16 41.69 43.28 44.52 45.79 47.11 7 Residential 8 5/8 x 3/4 Inch $ 33.98 $ 34.94 $ 35.93 $ 37.28 $ 38.70 $ 40.16 $ 41.69 $ 43.28 $ 44.52 $ 45.79 $ 47.11 9 1.5 Inch 33.98 34.94 35.93 37.28 38.70 40.16 41.69 43.28 44.52 45.79 47.11 10 21nch 33.98 34.94 35.93 37.28 38.70 40.16 41.69 43.28 44.52 45.79 47.11 11 61nch 33.98 34.94 35.93 37.28 38.70 40.16 41.69 43.28 44.52 45.79 47.11 12 Multi-Family 13 5/8 x 3/4 Inch $ 25.79 $ 26.56 $ 27.36 $ 28.46 $ 29.59 $ 30.78 $ 32.01 $ 33.29 $ 34.29 $ 35.32 $ 36.38 14 llnch 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 15 1.5 Inch 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 16 21nch 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 17 31nch 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 18 41nch 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 111 61nch 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 20 81nch 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 21 Commercial 22East Fork Residential $ 33.98 $ 34.94 $ 35.93 $ 37.28 $ 38.70 $ 40.16 $ 41.69 $ 43.28 $ 44.52 $ 45.79 $ 47.11 23 East Fork Seniors 25.59 26.30 27.03 28.03 29.07 30.15 31.28 32.45 33.36 34.30 35.27 24 East Fork Commercial 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 25 Total East Fork 2.6 Northeast Residential $ 33.98 $ 34.94 $ 35.93 $ 37.28 $ 38.70 $ 40.16 $ 41.69 $ 43.28 $ 44.52 $ 45.79 $ 47.11 27 Northeast Seniors 25.59 26.30 27.03 28.03 29.07 30.15 31.28 32.45 33.36 34.30 35.27 28 Northeast Commercial 25.79 26.56 27.36 28.46 29.59 30.78 32.01 33.29 34.29 35.32 36.38 29 Total Northeast APPENDIX A PAGE 45 City of Wylie, Texas � Update of Water & Wastewater Rates Worksheet 3(Continued) Rate Design Alternatives-Wastewater Rate Design Alternative 1(Across-the-Board Increase) Volumetric Rates Existing Proposed Planned Planned Planned Planned Planned Planned Planned Planned Planned 2014 2014 2015 2015 2017 2018 2018 2020 2021 2022 2023 (1) (1) (2) (3) (4) (6) (6) (7) (8) (9) (10) '.) Outside to Inside Ratio G 0-1,000 $ - $ - $ - $ $ - $ - $ - $ - -1 1,001-S,000 - 5,001-10,000 > 10,001-15,000 t 15,001-20,000 - - - - - - - - - - • Over 20,000 Residential 11 0-1,000 $ $ $ 5 S $ $ $ $ $ $ I<: 1,001-5,000 , 5,001 10,000 10,001 15,000 15,001-20,000 Over 20,000 - Multi-Family ,. 0-1,000 5 - 5 - $ - $ - $ - $ _ $ - $ _ $ - $ 1,001-5,000 2.18 2.2S 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 5,001-10,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 10,001-15,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 - 15,001-20,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 Over 20,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 Commercial 0-1,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 1,001-5,000 - _ _ _ _ _ _ _ _ b: 5,001-10,000 10,001-15,000 15,001-20,000 - . Over 20,000 East Fork SUD Residential -. 0-1,000 $ - $ - $ - $ - $ - $ _ $ _ $ _ $ - $ - 5 - i.. 1,001-5,000 ... 5,001-10,000 - 10,001-15,000 - 15,001-20,000 > Over 20,000 East Fork SUD Seniors APPENDIX A PAGE 46 City of Wylie, Texas Update of Water & Wastewater Rates Worksheet 3 (Continued) Rate Design Alternatives-Wastewater Rate Design Alternative 1(Across-the-Board Increase) Volumetric Rates _Existing Proposed Planned Planned Planned Planned Planned Planned Planned Planned Planned 2014 2014 2016 2016 2017 2018 2019 2020 2021 2022 2023 (1) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) 75 0-1,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 7G 1,001-5,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 77 5,001-10,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 78 10,001-15,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 79 15,001-20,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 80 Over 20,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 81 East Fork SUD Commercial 82 0-1,000 $ - $ $ - $ - $ $ $ - $ $ - $ - $ - 83 1,001-5,000 84 5,001-10,000 85 10,001-15,000 86 15,001-20,000 - - - - - - - - - - 87 Over 20,000 88 Northeast SUD Residential 89 0-1,000 $ $ $ $ $ $ $ $ $ $ $ 90 1,001-5,000 91 5,001-10,000 92 10,001-15,000 - - - - - - - - - - - 93 15,001-20,000 94 Over 20,000 - - - - - - - - - - - 95 Northeast SUD Seniors 96 0-1,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 97 1,001-5,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 98 5,001-10,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 99 10,001-15,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 100 15,001-20,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 101 Over 20,000 2.18 2.25 2.31 2.41 2.50 2.60 2.71 2.81 2.90 2.99 3.07 102 Northeast SUD Commercial APPENDIX A PAGE 47 City of Wylie, Texas Update of Water & Wastewater Rates Worksheet 3 (Continued) Rate Design Alternatives-Wastewater Rate Design Alternative 1(Across-the-Board Increase) Comparison of Average Monthly Bills Existing Proposed Planned Planned Planned Planned Planned Planned Planned Planned Planned 2014 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 (1) (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) 112 From Monthly Minimum Bill $ 4,573,378 $ 5,525,672 $ 5,793,225 $ 6,130,808 $ 6,446,497 $ 6,777,631 $ 7,086,840 $ 7,409,940 $ 7,673,054 $ 7,945,286 $ 8,226,946 III From Volume Rates 396,234 408,121 420,365 437,179 454,667 472,853 491,767 511,438 526,781 542,S85 558,862 11:' Total Revenues Generated $ 4,969,612 $ 5,933,793 $ 6,213,590 $ 6,567,988 $ 6,901,164 $ 7,250,485 $ 7,578,607 $ 7,921,378 $ 8,199,835 $ 8,487,871 $ 8,785,808 I? Change in Revenues-> 3.0% 3.0% 4.0% 4.0% 4.0% 4.0% 4.0% 3.0% 3.0% 3.0% 11-1 Avg.Res.Mon.Bill @ 8,000 Gallons $ 33.98 $ 34.94 $ 35.93 $ 37.28 $ 38.70 $ 40.16 $ 41.69 $ 43.28 $ 44.52 $ 45.79 $ 47.11 l i, Monthly Difference-$ N/A $ 0.96 $ 0.99 $ 1.36 $ 1.41 $ 1.47 $ 1.53 $ 1.59 $ 1.24 $ 1.28 $ 1.31 I ISS Monthly Difference-% N/A 2.82% 2.83% 3.78% 3.79% 3.79% 3.80% 3.81% 2.86% 2.87% 2.87% I I/ Avg.Commercial 1 Inch Mon.Bill @ 27,C $ 82.47 $ 84.94 $ 87.49 $ 90.99 $ 94.63 $ 98.42 $ 102.35 $ 106.45 $ 109.64 $ 112.93 $ 116.32 i Ir Monthly Difference-$ N/A $ 2.47 $ 2.55 $ 3.50 $ 3.64 $ 3.79 $ 3.94 $ 4.09 $ 3.19 $ 3.29 $ 3.39 !� Monthly Difference-% N/A 3.00% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 3.00% 3.00% 3.00% Avg.Industrial 3/4 Inch Mon.Bill @ 300, $ 677.61 $ 697.94 $ 718.88 $ 747.63 $ 777,54 $ 808.64 $ 840.98 $ 874.62 $ 900.86 $ 927.89 $ 955.72 1?1 Monthly Difference-$ N/A $ 20.33 $ 20.94 $ 28.76 $ 29.91 $ 31.10 $ 32.35 $ 33.64 $ 26.24 $ 27.03 $ 27.84 12.' Monthly Difference-% N/A 3.00% 3.00% 4.00% 4.00% 4.00% 4.00% 4.00% 3.00% 3.00% 3.00% APPENDIX A PAGE 48 NORTH TE MUNICIPAL WATER DISTRICT i's FUND BALANCE & MEMBER RATE MeetingNTMWD's Vision Regional Service Through Unity... Our Region'sPreliminary Rates are Adopted by the Board Annually in September TodayNeeds Tomorrow $125 $5.00 NTMWD's Mum Meet the Various Needs of Member Cities and Customers =Current Rate ProjeTop 5 ction Priorities:. . $100 - $4.00 Providewater.wastewaterand solid waste q 000 services today. 0 ! 10% 10% 4/14 Rate ProjectionSecure the future 70 •r waterS_ • - G $75 10'x° t11% 7% - $3.00 � solid •• j 11% 9% services. V I 10% 't Maintain (� 10% relationships voth Member Cities, $50 $2.000 partners. 3Customers,and 0 Maintain our - . provide `L $25 ! $1.00 s � through maintenanceon preventive; predictive I Take care of our people develop $O FY15 FY16 FY17 FY18 FY19 FY20 FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 FY32 FY33 FY34 $0.00 • . _. • Oper Fund $28 $29 $30 $31 $34 $37 $39 $41 $43 $45 $47 $49 $51 $53 $57 $59 $62 $64 $66 $70 rightand retain the people.build our Cap Imp Fund $21 $26 $22 $16 $16 $19 $20 $24 $33 $45 $44 $45 $45 $43 $33 $63 $30 $43 $45 $28 • • • ��+�Current Projection $2.06 $2.29 $2.53 $L.82 $3.10 $3.40 $3.64 $3.80 $3.89 $3.95 $4.00 $4.04 $4.08 $4.12 $4.15 $4.18 $4.21 $4.23 $4.25 $4.26 ��4/14 Projection 1$2.06 1$2.29 1$2.52 $2.76 $3.00 $3.22 1$3.39 1$3.50 1$3.58 $3.63 $3.67 $3.70 $3.73 $3.76 $3.78 $3.80 $3.81 $3.82 $3.83 � &STl)o;}fat uu>cs[3itfk,'Lrunes, • Nturphr;t-1unitur ihc I'rinct,lon I teralil THE t>iYL[E NEWSi STATE OF TEXAS COUNTY OF COLLIN Before me, the undersigned authority, on this day personally appeared Chad Engbrock, publisher of C & S Media, dba The Wylie News, a newspaper regularly published in Collin County, Texas and having general circulation in Collin County, Texas, who being by me duly sworn, deposed and says that the foregoing attached: City of Wylie Ordinance No. 2015-32 was published in said newspaper on the following dates, to-wit: September 16 and September 23, 2015 IF jvle__� Chad Engbrock, Publisher Subscribed and sworn before me on this, the day of ' 2015 to certify which witness my hand and seal of office. j�,�j ,e Sonia A. Duggan Commission Expires Notary Public in or F� 09-02-2016 The State of Texas My commission expires / %1urhhSach'c-W 0"U117cr- 1 10 N 11allard-1'.O Box',69•Wi lic.1 972•1-11 i t i•i:i�97 k41 l" fiarnKn-illc Princcwn Office- 10IS Main+1'.O.BoA 512•I airllcis%Mc, I Y 7>442•97' 784 6.797•I:iv 9-' 782 70',3 1 1 September 16-17,2015 7C Ordinance No.2015-32 An Ordinance of the City of Wy- lie, Texas; amend- ing subsection b (water rates) and subsection c (sew- age collection and treatment rates) of section 1 (water and sewer fees) of the Wylie Compre- hensive Fee Sched- ule;providing for a penalty for the vio- lation of this ordi- nance; providing for repealing, sav- ings and severabil- ity clauses;provid- ing for an effective date of this ordi- nance;and provid- ing for the.publica- tion of the caption of this ordinance. 19-2t-145-339