Water & Sewer Rate Study 1997
\j J\y 19q-7
) -
ENGINEERING REPORT
WATER AND SEWER UTILITY
RATE STUDY
Prepared for
The City of Salina, Kansas
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
ENGINEERING REPORT
WATER AND SEWER UTILITY
RATE STUDY
Prepared for
The City of Salina, Kansas
Kristin Seaton, Mayor
Peter Brungardt, City Commissioner
Don Heath, City Commissioner
Alan Jilka, City Commissioner
Monte Shadwick, City Commissioner
Dennis Kissinger, City Manager
Don Hoff, P.E., Director of Engineering & Utilities
Rod Franz, Director of Finance and Administration
Hank Corcoran, Water Office Supervisor
Wilson & Company
P. O. Box 850
Wichita, Kansas 67201-0850
(316) 946-9800
Address all communication
regarding this work to:
IN, IS " IV
& COM PANY
August 1997
97-410-032
*
'""'" ~ """'" '"^"
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
TABLE OF CONTENTS
PaJ!.e No.
Summary and Recommendations
Sewer User Charge Evaluation
Water Rate Evaluation
S-1
S-1
Section One - General
Purpose
Scope
Sewer User Charge Evaluation
Water Rate Evaluation
1-1
1-1
1-1
1-1
Section Two - Sewer User Charge Evaluation
Projected Revenue Requirements
Revenue Generated at Current Rates
Proposed Sewer User Rate Schedule
Estimated Monthly Sewer Charges
2-1
2-2
2-3
2-5
Section Three - Water Rate Evaluation
Projected Revenue Requirements
Revenue Generated at Current Rates
Existing Rate Structure
Proposed Water Rate Schedule
Estimated Monthly Water Use Charges
3-1
3-2
3-3
3-4
3-5
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Table 2-1
Table 2-2
Table 2-3
Table 2-4
Table 2-5
Table 3-1
Table 3-2
Table 3-3
Table 3-4
Table 3-5
Table 3-6
Table 3-7
TABLES
Projected Revenue Requirements - Sewer Division
Revenue Generated at Current Rates
Proposed Sewer User Rate Schedule
Estimated Monthly Sewer Charges for Typical Customers
Monthly Sewer Charge Percent Increases
Projected Revenue Requirements - Water Division
Revenue Generated at Current Rates
Percent Consumption vs. Percent Revenue
Percent Increase in Revenue Required
Proposed Water User Rate Schedule
Estimated Monthly Water Use Charges for Typical Customers
Monthly Water Use Charge Percent Increase
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
APPENDICES
Appl
Administrative Costs - Sewer Division
App2
Commodity Costs - Sewer Division
App3
Administrative and General Costs
App4
Customer Accounting and Collection Fees
App5
O&M Costs - Sewer Division
App6
Total Principal and Interest due by Year
App7
Billed Sewage Volume
App8
Metered Water Consumption and Sales
App9
Administrative Costs - Water Division
App 10
Commodity Costs - Water Division
App 11
Water Division O&M Costs
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I~~;
Summary and
Recommendations
This study evaluates existing and future revenue requirements for the City's Sewer
Division and Water Division and makes recommendations for adjustments to the
current rate schedules. These adjustments will be required to finance the
anticipated operation, maintenance, replacement, and capital improvement costs of
the water and sewer utilities for the next five years. The sewer and water rates
proposed in this study should be reviewed annually and adjusted as necessary to
assure adequate revenue is being generated. Minimum monthly charges have been
modified by removing the commodity charge associated with the minimum
monthly charge. This was done to enable customers to be charged for their actual
water usage, rather than for a minimum quantity whether it was used or not.
Sewer User Charge Evaluation
The latest change in the sewer rate ordinance has an effective date of 1 July 1997.
This rate will generate adequate revenue for the remainder of 1997, but will not
generate adequate revenue for the period from 1998-2002. It is recommended that
the current schedule of sewer user charges be adjusted as shown in Table 2-3. The
rate schedule has been changed to a calendar year basis and would be implemented
on 1 January 1998.
Water Rate Evaluation
The latest change in the water rate ordinance has an effective date of 1 January
1997. This rate will generate adequate revenue for 1997, but will not generate
adequate revenue for the period from 1998-2002. It is recommended that water
rates be adjusted in accordance with the proposed rates given in Table 3-5. The
proposed rates would become effective on 1 January 1998.
Wilson & Company
S - 1
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1~17
Section One
General
Purpose
This Water and Sewer Rate Study has been prepared for the City of Salina's Water
and Sewage Utility to evaluate the revenue requirements of both the Sewer
Division and the Water Division. It will make recommendations for rate
adjustments that will be required to finance anticipated operational, maintenance
and capital improvement costs during the next five years.
Scope
Sewer User Charge Evaluation
The Sewer User Charge Evaluation included a review of current Sewer Division
revenues and expenditures and the development of anticipated revenue
requirements for the 5-year period from 1998 through 2002. A schedule of sewer
user charges was developed which will provide the revenue to meet the projected
requirements throughout the study period. This evaluation is based on the
methodology established in the Water and Sewer Rate Study prepared by Wilson &
Company (July 1992, WCEA File: 92-017). Minimum monthly charges were
modified by removing the commodity charge associated with the current minimum
monthly charge.
Water Rate Evaluation
The Water Rate Evaluation included a review of current revenues and expenditures
of the Water Division and development of anticipated revenue requirements for the
5-year period from 1998 through 2002. The current stepped rate structure, which
provides for a decreasing unit cost of water with increasing usage, was developed in
the 1987 water rate study prepared by Wilson & Company ("Salina, Kansas, Water
Wilson & Company
1 - 1
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I ~17
Section One
General
Rate Study", August 1987, WCEA File: 86-332A). The unit cost allocations for
base costs, customer costs, and extra-capacity costs and usage blocks established in
the 1987 water rate study are assumed to be valid for this study. However, the
equitability of the current stepped rate schedule was reviewed by comparing the
percent of consumption to the percent of revenue generated for each user class.
Minimum monthly charges were modified by removing the commodity charge
associated with the minimum monthly charge for each meter size.
Annual revenue requirements were compared with the requirements of the previous
year to determine a percent increase in the amount of revenue required in each year
of the study period. Based on these percentages, a schedule of proposed water rates
was developed by applying the necessary annual percent increase uniformly to the
administrative and commodity rates for meter sizes and usage blocks defined in the
current rate structure.
Wilson & Company
1 - 2
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1~7
Section Two
Sewer User Charge Evaluation
Projected Revenue Requirements
Projections of total revenue requirements for the Sewer Division for 1998 through
2002 are shown in Table 2-1. Projected revenue requirements are based on
historical Sewer Division expenditures and on information provided by the City
and developed by Wilson & Company for anticipated future expenditures. A brief
description of the line items included in Table 2-1 follows.
1.
Administrative Costs: Includes administrative and general costs allocated to
the Sewer Division. (Ref. Appendix Table App1.)
2.
Customer Costs: Includes customer accounting and collection costs
allocated to the Sewer Division. (Ref. Appendix Table App4.)
3.
O&M Costs: Includes operation and maintenance costs for the existing
wastewater collection and treatment facilities. (Ref. Appendix Table App5.)
4.
Capital Improvements: Amount allocated annually for replacement of major
equipment items for wastewater collection and treatment. None is allocated
for the five year period because debt service from the previous year and
funded reserves are available for capital improvements.
5.
Debt Service: Includes the 1992 revenue bonds for WWTP#I, the 1994
refunding of revenue bonds for WWTP# 1, and the 1994 revenue bonds for
6.
the belt filter press at WWTP#I. (Ref. Appendix Table App6.)
Bond Coverage: Includes an annual amount added to the normal revenue
requirements in order to meet the required 125 percent bond coverage on the
Sewer Division's principal and interest portion of the existing revenue
bonds.
Wilson & Company
2 -1
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1~27
Section Two
Sewer User Charge Evaluation
Table 2-1
Projected Revenue Requirements
Sewer Division
1998
$
1999
$
2000
$
2001
$
2002
$
Administrative
Customer
Subtotal
O&M
Capital Impr.
Debt Service
Bond Coverage
Subtotal
378,990
162,466
541,456
2,320,308
0
1,688,595
422,149
4,431,052
397,940
170,590
568,529
417,837
179,119
596,956
2,459,527 2,607,098
0 0
...~,678,5~0) 1,662,036
.4T9,633 415,509
4,557,689 4,684,643
Total 4,972,508 (5,126,21
438,729
188,075
626,804
2,763,524
0
1,634,001
408,500
4,806,025
460,665
197,479
658,144
2,929,336
0
1,645,419
411,355
4,986,109
.... .
5,281,599 5,432,829 5,644,253
Revenue Generated at Current Rates
The projected revenue requirements were compared to the revenue to be generated
at the current rates. Projections for the number of sewer accounts and billed
sewage volume are given in Appendix Table App8. As shown in Table 2-2, the
revenue generated at current rates will fall short of the revenue required and there
will be a revenue deficit.
Wilson & Company
2-2
I
I
1
1
I
I
1
1
1
1
1
I
1
I
1
I
I
I
Section Two
Sewer User Charge Evaluation
Table 2-2
Revenue Generated at Current Rates
1998 1999 2000 2001 2002
Administrative Charge
No. of Accounts 18,657 18,899 19,144 19,392 19,644
MMC,$ 1.76 1.76 1.76 1.76 1.76
Projected Revenue, $ 394,036 399,147 404,321 409,559 414,881
Commodity Charge
Billed Sewage, 10000 hcf 246.27 249.47 252.70 255.97 259.30
Unit Cost, $/hcf 1.80 1.80 1.80 1.80 1.80
Projected Revenue, $ 4,432,903 4,490,402 4,548,614 4,607,539 4,667,414
Total Revenue
Administrative Charge 394,036 399,147 404,321 409,559 414,881
Commodity Charge 4,432,903 4,490,402 4,548,614 4,607,539 4,667,414
Total 4,826,939 4,889,549 4,952,936 5,017,098 5,082,296
Revenue Required 4,972,508 5,126,218 5,281,599 5,432,829 5,644,253
Surplus/(Deficit) (145,569) (236,669) (328,663) (415,731) (561,957)
Proposed Sewer User Rate Schedule
The system of sewer user charges established by ordinance for the City of Salina
divides the costs of collecting and treating sewage equitably among all users by
means of a minimum monthly charge plus a commodity charge.
The minimum monthly charge allocates all administrative costs (i.e. administrative
and customer costs allocated to the sewer division) equally among all users
regardless of the user's sewage flow volume. The minimum monthly charge
(MMC) is calculated as follows:
C $ Annual Admin. Costs
MM, =
(No. of Accounts)(12 months)
Sect2
1817197
Wilson & Company
2-3
1
1
1
I
1
1
I
1
1
I
I
1
1
I
I
I
I
1
1~7
Section Two
Sewer User Charge Evaluation
The commodity charge in dollars per hundred cubic feet ($/hcf) allocates all
operation, maintenance and replacement costs (i.e., O&M costs, capital
improvements, debt service and bond coverage) proportionally to all users based on
the user's volume of sewage flow. For a residential user, the commodity charge is
based on the average monthly water meter consumption records for the winter
months of January, February and March. Commercial and industrial charges are
based on monthly water meter consumption records. The unit commodity charge is
calculated as follows:
Annual Commodity Costs
Unit Cost,($ / hcf) = Ann I S V I
ua ewage 0 ume
Table 2-3 shows the results of the Commodity Charge and Minimum Monthly
Charge calculations for 1998 through 2002 based on the projected revenue
requirements.
Table 2-3
Proposed Sewer User Rate Schedule
1998 1999 2000 2001 2002
Administrative Charge
Revenue Required, $ 541,456 568,529 596,956 626,804 658,144
No. of Accounts 18,657 18,899 19,144 19,392 19,644
MMC,$ 2.42 2.51 2.60 2.69 2.79
Commodity Charge
Revenue Required, $ 4,431,052 4,557,689 4,684,643 4,806,025 4,986,109
Billed Sewage, 1000 hcf 246.27 249.47 252.70 255.97 259.30
Unit Cost, $/hcf 1.80 1.83 1.85 1.88 1.92
Wilson & Company
2-4
1
1
1
1
I
1
I
1
1
I
I
I
I
I
I
I
I
I
1=27
Section Two
Sewer User Charge Evaluation
Estimated Monthly Sewer Charges
Estimated total monthly sewer charges resulting from the proposed rates are shown
in Table 2-4 for typical customers and selected usage ranges. Table 2-5 shows the
percent increase from the previous year for the same customers.
Table 2-4
Estimated Monthly Sewer Charges
for Typical customers
Based on Schedule of Proposed Rates
Customer Type Average
and Usage Usage,* 1997 1998 1999 2000 2001 2002
Range cu.ft. $ $ $ $ $ $
Residential <}-1f
0-300 200 5.36 6.02 ~'6.17 6.30 6.45 6.63
301-500 400 8.96 9.62 '2?~ 9.83 10.00 10.21 10.47
501-800 700 14.36 15.02 1/( 15.32 15.55 15.85 16.23
801-1100 1000 19.76 20.42 20.81 21.10 21.49 21.99
1101-1500 1300 25.16 25.82 d5' 26.30 26.65 27.13 27.75
1501-2000 1700 32.36 33.02 33.62 34.05 34.65 35.43
Commercial
2000-5000 3200 59.36 60.02 61.07 61.80 62.85 64.23
5001-10000 6900 125.96 126.62 128.78 130.25 132.41 135.27
10001-50000 21900 395.96 396.62 403.28 407.75 414.41 423.27
Large Users
In City 100000 1801.76 1802.42 1832.51 1852.60 1882.69 1922.79
In City 600000 10801.76 10802.42 10982.51 11102.60 11282.69 11522.79
Outside City 600000 13503.52 13504.84 13730.02 13880.60 14105.38 14405.78
* Residential usage is based on the average monthly metered water consumption for
January, February, and March. Commercial and Large User usage is based on monthly
metered water consumption.
Wilson & Company
2-5
1
I
1
1
1
I
I
I
1
I
I
I
1
I
1
I
I
1
I ~7
Section Two
Sewer User Charge Evaluation
Table 2-5
Monthly Sewer Charge Percent Increases
for Typical customers
Based on Schedule of Proposed Rates
Customer Type Average V
and Usage Usage, 1998 1999 2000 2001 2002
Range cu.ft. % % % % %
Residential
0-300 200 12.31 % 2.49% 2.11% 2.38% 2.79%
301-500 400 7.37% 2.18% 1.73% 2.10% 2.55%
501-800 700 4.60% 2.00% 1.50% 1.93% 2.40%
801-1100 1000 3.34% 1.91 % 1.39% 1.85% 2.33%
1101-1500 1300 2.62% 1.86% 1.33% 1.80% 2.29%
1501-2000 1700 2.04% 1.82% 1.28% 1.76% 2.25%
Commercial
2000-5000 3200 1.11% 1.75% 1.20% 1.70% 2.20%
5001-10000 6900 0.52% 1.71% 1.14% 1.66% 2.16%
10001-50000 21900 0.17% 1.68% 1.11% 1.63% 2.14%
Large Users
In City 100000 0.04% 1.67% 1.10% 1.62% 2.13%
In City 600000 0.01% 1.67% 1.09% 1.62% 2.13%
Outside City 600000 0.01% 1.67% 1.10% 1.62% 2.13%
Wilson & Company
2-6
1
1
1
I
I
1
I
1
1
I
1
1
1
I
1
I
I
I
1=7
Section Three
Water Rate Evaluation
Projected Revenue Requirements
Projected revenue requirements for the Water Division for 1998 through 2002 are
shown in Table 3-1. Projected revenue requirements are based on historical Water
Division expenditures and on information provided by the City and developed by
Wilson & Company for anticipated future expenditures. These requirements
consist of the following expenditures:
1.
Administrative Costs: Includes administration and general costs and
allocated to the Water Division. (Ref. Appendix Table App9.)
2.
Customer Costs: Includes customer accounting and collection costs
allocated to the Water Division. (Ref. Appendix Table App4.)
3.
O&M Costs: Includes expenditures for the operation and maintenance of the
City's water supply, treatment and distribution facilities. (Ref. Appendix
4.
Table Appl1.)
Capital Improvements: Includes an amount allocated annually to the Water
5.
Division from the Water and Sewer Utility's Capital Outlay budget.
Debt Service: Includes the 1990 refunding of 1987 and 1988 revenue bonds,
6.
new revenue bonds for 1990, plus projected debt service requirements for the
proposed 1998 revenue bonds. (Ref. Appendix Table App6.)
,- -
Bond Coverage: Includes an annual amount added to the normal revenue
requirements in order to meet the required 125 percent bond coverage on the
Water Division's principal and interest payment portion ofthe existing and
7.
proposed revenue bonds.
Misc. Revenue: Includes miscellaneous revenue from outside sources. It
does not include non-rate generated revenue from sources such as water
protection fee, franchise fees, and water sales taxes.
Wilson & Company
3 - 1
1
I
I
I
I
1
1
1
1
I
1
I
1
I
I
I
I
I
1=7
Section Three
Water Rate Evaluation
Table 3-1
Projected Revenue Requirements
Water Division
1998 1999 2000 2001 2002
$ $ $ $ $
Administrative 703,839 739,031 775,982 814,782 855,521
Customer 920,642 966,674 1,015,008 1,065,758 1,119,046
Subtotal 1,624,481 1,705,705 1,790,990 1,880,540 1,974,567
O&M 2,976,032 3,154,594 3,343,870 3,544,502 3,757,172
Capital Impr. 100,000 100,000 100,000 100,000 100,000
Debt Service 895,451 ( ~ 1,266,109 1,343,547 1,229,091
~-----_/
Bond Coverage 223,863 307,082 316,527 335,887 307,273
Misc. Revenue (200,000) (200,000) (200,000) (200,000) 0
Subtotal 3,995,346 4,590,002 4,826,506 5,123,936 5,393,536
Total 5,619,827 6,295,706 6,617,496 7,004,475 7,368,102
Revenue Generated at Current Rates
The projected revenue requirements were compared to the revenue to be generated
at the current rates. As shown in Table 3-2, the revenue generated at current rates
will fall short of the revenue required and there will be a revenue deficit.
Table 3-2
Revenue Generated at Current Rates
1998 1999 2000 2001 2002
$ $ $ $ $
Projected Revenue 5,429,151 5,594,391 5,763,947 5,939,527 6,119,229
Revenue Required 5,619,827 6,295,706 6,617,496 7,004,475 7,368,102
Surplus/(Deficit) (190,676) (701,316) (853,550) (1,064,948) (1,248,874)
Wilson & Company
3-2
II
I
1
1
1
1
I
I
1
1
I
I
I
I
1
1
I
I
1=7
Section Three
Water Rate Evaluation
Existing Rate Structure
The current stepped rate structure was established in the 1987 study prepared by
Wilson & Company. The equitability of the rate structure was verified by
comparing the percent of total consumption for each meter size and usage class to
the percent of total revenue generated. The results of the comparison are shown in
Table 3-3. As shown in the table, the current stepped rate structure provides an
adequate level of equitability in the distribution of the water utility costs.
Table 3-3
Percent Consumption vs. Percent Revenue
1994 1995 1996
Consum Revenue Consum Revenue Consum Revenue
% % % % % %
Meter Size
5/8" 62.7 67.1 58.8 64.5 61.3 66.3
3/4" 4.7 4.7 4.0 4.2 3.9 4.1
1" 6.6 6.6 6.5 6.4 6.6 6.5
1-112" 3.1 2.8 3.1 2.8 3.0 2.7
2" 17.7 14.9 19.6 15.9 19.5 15.8
3" 1.9 1.5 1.6 1.2 1.5 1.2
4" 2.8 1.9 4.2 3.3 3.4 2.6
6" 0.5 0.5 0.4 0.4 0.7 0.5
8" 1.8 1.4 0.2 0.2
Range, cu. ft.
0-300 2.4 4.7 2.6 4.6 2.7 4.8
301-1700 54.3 58.1 53.6 58.8 55.4 59.9
1701-8400 18.0 17.5 15.1 14.4 16.6 15.8
8400-10000 1.6 1.4 1.6 1.4 1.1 1.0
Over 10000 23.7 18.3 27.2 20.7 24.2 18.5
Wi/son & Company
3-3
I
I
I
I
1
I
I
I
1
1
I
I
I
I
I
1
1
I
1~37
Section Three
Water Rate Evaluation
Proposed Water Rate Schedule
The projected revenue requirements for both the administrative and commodity
categories for each of the planning years was compared to the revenue requirement
in each of these categories for the previous year to determine a percent increase in
the amount of revenue required. The percent increase required in Water Division
revenues is shown in Table 3-4. Percent increases were applied to the
administrative and commodity rates for the years 1998 to 2002.
Table 3-4
Percent Increase in Revenue Required
1998 1999 2000 2001 2002
Administrative Charge
Previous Revenue, $ 1,547,125 1,624,481 1,705,705 1,790,990 1,880,540
Projected Revenue, $ 1,624,481 1,705,705 1,790,990 1,880,540 1,974,567
Increase, % 5.0% 5.0% 5.0% 5.0% 5.0%
.:
Commodity Charge
Previous Revenue, $ 3,886,961 3,995,346 4,590,002 4,826,506 5,123,936
Projected Revenue, $ 3,995,346 4,590,002 4,826,506 5,123,936 5,393,536
Increase, % 2.8% (14.9% ì 5.2% 6.2% 5.3%
.J.
A schedule of proposed water rates is presented in Table 3-5. These rates are based
on the annual percent increase given in Table 3-4 being applied to minimum
monthly charges (MMC) for all meter sizes, as well as the commodity charges for
each usage block.
Wilson & Company
3-4
I
I
I
I
I
I
I
I
I
I
1
I
I
I
1
I
1
I
1 ~37
Section Three
Water Rate Evaluation
Table 3-5
Proposed Water Rate Schedule
Base* 1998 1999 2000 2001 2002
MMC,$
Meter Size
5/8" 2.30 2.42 2.54 2.66 2.80 2.94
3/4" 3.68 3.86 4.06 4.26 4.47 4.70
1" 4.99 5.24 5.50 5.78 6.07 6.37
1-1/2" 7.75 8.14 8.54 8.97 9.42 9.89
2" 12.54 13.17 13.83 14.52 15.24 16.00
3" 32.82 34.46 36.18 37.99 39.89 41.89
4" 47.19 49.55 52.03 54.63 57.36 60.23
6" 87.49 91.86 96.46 101.28 1 06.34 111.66
8" 184.33 193.55 203.22 213.39 224.05 235.26
Commodity Charge
Unit Cost, $/hcf
Range, cu. ft.
0-2000 1.74 1.79 2.05 2.16 2.29 2.41
2001-10000 1.56 1.60 1.84 1.94 2.06 2.16
Over 10000 1.39 1.43 1.64 1.73 1.83 1.93
* Current Rate Schedule
Estimated Monthly Water Use Charges
Estimated total monthly water use charges resulting from the proposed rates are
shown in Table 3-6 for typical customers and a number of usage ranges. Table 3-7
shows the percent increase from the previous year for the same customers.
Wilson & Company
3-5
I
I
1
I
1
1
I
1
1
1
1
I
1
1
I
I
I
I
1=7
Section Three
Water Rate Evaluation
Table 3-6
Estimated Monthly Water Use Charges
for Typical Customers
Based on Schedule of Proposed Rates
Customer Type Average
and Usage Usage, Meter 1997* 1998 1999 2000 2001 2001
Range cu.ft. Size $ $ $ $ $ $
Residential
0-300 200 5/8" 7.52 6.00 6.64 6.98 7.38 7.76
301-500 400 5/8" 9.26 9.58 10.74 11.30 11.96 12.58
501-800 700 5/8" 14.48 14.95 16.89 17.78 18.83 19.81
801-1100 1000 5/8" 19.70 20.32 23.04 24.26 25.70 27.04
1101-1500 1300 5/8" 24.92 25.69 29.19 30.74 32.57 34.27
1501-2000 1700 5/8" 31.88 32.85 37.39 39.38 41.73 43.91
Over 2000 5000 5/8" 83.90 86.22 98.74 104.06 110.40 115.94
Commercial
2000-5000 3200 5/8" 55.82 57.42 65.62 69.14 73.32 77.06
5001-10000 6900 2" 123.78 127.37 144.99 152.78 161.98 170.04
10001-50000 21900 2" 337.55 347.14 397.19 418.79 443.61 466.67
50001-100000 72200 4" 1071.37 1102.81 1260.31 1329.09 1406.22 1481.69
Large Users
In City 200000 4" 2847.49 2930.35 3356.23 3540.03 3744.96 3948.23
In City 600000 6" 8448.09 8692.66 9960.66 10506.68 11113.94 11719.66
Outside City 600000 6" 10625.73 10934.72 12523.19 13209.31 13972.18 14733.32
* Current Rate Schedule
Wilson & Company
3-6
1
I
1
1
I
1
1
1
I
1
I
I
1
I
I
1
1
1
1~37
Section Three
Water Rate Evaluation
Table 3-7
Monthly Water Use Charge Percent Increase
for Typical Customers
Based on Schedule of Proposed Rates
Customer Type Average
and Usage Usage, Meter 1998 1999 2000 2001 2001
Range cu.ft. Size % % % % %
Residential
0-300 200 5/8" -20.21% 10.67% 5.12% 5.73% 5.15%
301-500 400 5/8" 3.46% 12.11 % 5.21% 5.84% 5.18%
501-800 700 5/8" 3.25% 12.98% 5.27% 5.91% 5.20%
801-1100 1000 5/8" 3.15% 13.39% 5.30% 5.94% 5.21%
1101-1500 1300 5/8" 3.09% 13.62% 5.31 % 5.95% 5.22%
1501-2000 1700 5/8" 3.04% 13.82% 5.32% 5.97% 5.22%
Over 2000 5000 5/8" 2.77% 14.52% 5.39% 6.09% 5.02%
Commercial
2000-5000 3200 5/8" 2.87% 14.28% 5.36% 6.05% 5.10%
5001-10000 6900 2" 2.90% 13.83% 5.37% 6.02% 4.98%
10001-50000 21900 2" 2.84% 14.42% 5.44% 5.93% 5.20%
50001-100000 72200 4" 2.93% 14.28% 5.46% 5.80% 5.37%
Large Users
In City 200000 4" 2.91% 14.53% 5.48% 5.79% 5.43%
In City 600000 6" 2.89% 14.59% 5.48% 5.78% 5.45%
Outside City 600000 6" 2.91% 14.53% 5.48% 5.78% 5.45%
Wilson & Company
3-7
I
I
1
1
1
I
I
I
I
1
I
1
I
1
1
I
1
1
1
I
I
1
1
1
1
I
1
I
1
1
1
I
1
1
1
1
1
1
App1
Administrative Costs
Sewer Division
1989 1990 1991 1994 1995 1996
Historic $ $ $ $ $ $
Administrative and General 133,907 166,577 194,102 290,569 286,899 343,755
Accounting and Collection 55,969 58,389 71,287 92,733 104,266 147,362
Total 189,876 224,966 265,389 383,302 391,165 491,117
1997 1998 1999 2000 2001 2002
Projected $ $ $ $ $ $
Administrative and General 360,943 378,990 397,940 417,837 438,729 460,665
Accounting and Collection 154,730 162,466 170,590 179,119 188,075 197,479
Total 515,673 541,456 568,529 596,956 626,804 658,144
1
1
1
1
1
1
1
I
1
1
1
I
1
I
1
1
1
1
1
App2
Commodity Costs
Sewer Division
1997 1998 1999 2000 2001 2002
Projected $ $ $ $ $ $
Operation and Maintenance 2,188,970 2,320,308 2,459,527 2,607,098 2,763,524 2,929,336
Capital Improvement 0 0 0 0 0 0
Debt Service 1,693,038 1,688,595 1,678,530 1,662,036 1,634,001 1,645,419
Bond Coverage 423,260 422,149 419,633 415,509 40&,500 411,355
Total 4,305,268 4,431,052 4,557,689 4,684,643 4,806,025 4,986,109
1
1
I
I
I
I
1
1
1
1
I
1
1
I
I
I
1
1
I
App3
Administrative & General Costs
1989 1990 1991 1994 1995 1996
Historic $ $ $ $ $ $
Combined Water and Sewer 382,591 475,934 554,576 830,196 819,712 982,158
Allocate 65% to Water 248,684 309,357 360,474 539,627 532,813 638,403
Allocate 35% to Sewer 133,907 166,577 194,102 290,569 286,899 343,755
1997 1998 1999 2000 2001 2002
Projected $ $ $ $ $ $
Combined Water and Sewer 1,031,266 1,082,829 1,136,971 1,193,819 1,253,510 1,316,186
Allocate 65% to Water 670,323 703,839 739,031 775,982 814,782 855,521
Allocate 35% to Sewer 360,943 378,990 397,940 417,837 438,729 460,665
I
1
I
I
I
1
1
I
1
1
I
I
I
1
1
I
I
I
1
App4
Customer Accounting and Collection Fees
1989 1990 1991 1994 1995 1996
Historic $ $ $ $ $ $
Combined Water and Sewer 373,128 389,262 475,246 618,222 695!106 982,411
Allocate 85% to Water 317,159 330,873 403,959 525,489 590,840 835,049
Allocate 15% to Sewer 55,969 58,389 71,287 92,733 104!266 147,362
1997 1998 1999 2000 2001 2002
Projected $ $ $ $ $ $
Combined Water and Sewer 1,031,532 1,083,108 1,137,264 1,194,127 1,253!833 1,316,525
Allocate 85% to Water 876,802 920,642 966,674 1,015,008 1,065,758 1,119,046
Allocate 15% to Sewer 154,730 162,466 170,590 179,119 188,075 197,479
I
1
1
I
I
I
1
1
1
1
:1
1
1
1
1
I
I
I
1
App5
O&M Costs
Sewer Division
Historic
1989
$
1990
$
1991
$
1994
$
1995
$
1996
$
Total System
642,242
780,172
850,561
1,566,912
1,250,154 2,006,831
Projected
1997
$
1998
$
1999
$
2000
$
2001
$
2002
$
Total System 2,188,970 2,320,308 2,459,527 2,607,098 2,763,524 2,929,336
I
1
I
I
1
I
1
1
1
I
1
1
1
1
1
I
I
1
1
App6
Total Principal and Interest due by Year
1997 1998 1999 2000 2001 2002
$ $ $ $ $ $
Water - 1990A refunding 156,240 156,240 156,240 156,240 156,240 156,240
Water - 1990B 627,267 628,362 628,689 666,472 743,910 629,454
Sewer - 1992A 1,325,544 1,320,909 1,311 ,318 979,344 0 0
Sewer - 1993A 262,719 261,741 262,857 260,067 258,477 258,549
Sewer - 1994 refunding 0 0 0 316,191 1,268,490 1,281,474
Sewer - 1994B 104,775 105,945 104,355 106,434 107,034 105,396
Water 1998A 0 110,849 443,397 v 443,397 443,397 443,397
Total 2,476,545 2,584,046 2,906,856 2,928,145 2,977,548 2,874,510
Total Water 783,507 895,451 1,228,326 1,266,109 1,343,547 1,229,091
Total Sewer 1,693,038 1,688,595 1,678,530 1,662,036 1,634,001 1,645,419
)~ f U) )" L.. F ù¿,1j Cj'-iõ Lt '-I -~ '"5 "i ì
/
I,
I
1
I
I
I
1
I
I
1
1
1
1
1
1
1
1
I
I
1
App7
Billed Sewage Volume
Historic 1989 1990 1991 1994 1995 1996
Number of Accounts 17,049 17,092 17,408 17,906 18,058 18,182
Billed Volume, 1000 hcf 218.09 223.27 226.00 238.28 232.20 239.51
Avg Volume per Acct., 1000 hcf 128 131 130 133 129 132
Projected 1997 1998 1999 2000 2001 2002
Number of Accounts 18,418 18,657 18,899 19,144 19,392 19,644
Billed Volume, 1000 hcf 243.12 246.27 249.47 252.70 255.97 259.30
A vg Volume per Acct., 1000 hcf 132 132 132 132 132 132
1
1
I
II
App8
Metered Water Consumption and Sales
Historic 1989 1990 1991 1994 1995 1996
Number of Accounts 17,049 17,092 17,408 20,488 20,416 20,424
Annual Water Sold 317.68 285.08 305.40 277.80 273.73 264.86 .~
Volume per Account 186 167 175 136 134 130
I
1
I
1
I
I
I
1
1
I
1
I
I
I
1
Projected 1997 1998 1999 2000 2001 2002
Number of Accounts 20,629 20,836 21,045 21,256 21,469 21,684
Annual Water Sold 278.49 281.29 284.11 286.96. -.289.83 . .29'2..D.
Volume per Account 135 135 135 135 135 135
I
I
1
App9
Administrative Costs
Water Division
II
I
1989 1990 1991 1994 1995 1996
Historic $ $ $ $ $ $
Administrative and General 248,684 309,357 360,474 539,627 532,813 638,403
Accounting and Collection 317,159 330,873 403,959 525,489 590,840 835,049
Total 565,843 640,230 764,434 1,065,116 1,123,653 1,473,452
I
I
1
I
I
1
I
I
I
I
I
I
I
I
I
1997 1998 1999 2000 2001 2002
Projected $ $ $ $ $ $
Administrative and General 670,323 703,839 739,031 775,982 814,782 855,521
Accounting and Collection 876,802 920,642 966,674 1,015,008 1,065,758 1,119,046
Total 1,547,125 1,624,481 1,705,705 1,790,990 1,880,540 1,974,567
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1
I
I
App10
Commodity Costs
Water Division
1997 1998 1999 2000 2001 2002
Projected $ $ $ $ $ $
Operation and Maintenance 2,807,577 2,976,032 3,154,594 3,343,870 3,544,502 3,757,172
Capital Improvement 100,000 100,000 100,000 100,000 100,000 100,000
Debt Service 783,507 895,451 1,228,326 1,266,109 1,343,547 1,229,091
Bond Coverage 195,877 223,863 307,082 316,527 335,887 307,273
Misc. Revenue 0 (200,000) (200,000) (200,000) (200,000) 0
Total 3,886,961 3,995,346 4,590,002 4,826,506 5,123,936 5,393,536
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1
I
I
I
App11
Water Division O&M Costs
1989 1990 1991 1994 1995 1996
Historic $ $ $ $ $ $
Distribution 507,011 433,801 535,461 690,957 795,066 987,662
Service 159,337 216,088 270,167
Pumping 205,860 231,825
Softening 997,067 919,601 1,440,814 1,600,203 1,565,999 1,660,996
Supply 116,284 173,942
Total 1,826,222 1,918,506 2,192,363 2,561,327 2,361,065 2,648,658
Projected
1997
$
1998
$
1999
$
2000
$
2001
$
2002
$
Total 2,807,577 2,976,032 3,154,594 3,343,870 3,544,502 3,757,172