HomeMy WebLinkAboutWater Rates Analysis Report - 3/1/2022Town of Oro Valley
2022
Water Rate Study and Long-Term
Financial Plan
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 1
TOWN OF ORO VALLEY, ARIZONA
2022 WATER RATE STUDY
TABLE OF CONTENTS
Executive Summary .......................................................................................................................... 3
Introduction and Demographic Profile ............................................................................................. 11
Background ......................................................................................................................... 11
Report Organization ............................................................................................................. 11
Community Overview ........................................................................................................... 12
Current Water Rates ............................................................................................................ 13
Water Rate Comparison ....................................................................................................... 14
Water Test Year and Forecast Volumes ........................................................................................... 16
Water Customers and Meters – Test Year & Ten-Year Forecast ............................................... 16
Historical and Forecast Water Consumption ........................................................................... 18
Peaking Factors ................................................................................................................... 19
Water Forecast Revenue Requirement ............................................................................................ 21
Operating Expenses and Capital Outlays – Test Year.............................................................. 22
Cost of Service – Ten Year Forecast...................................................................................... 23
Capital Improvement Plan ..................................................................................................... 24
Existing and Forecast Debt Service ....................................................................................... 26
Non-Rate Revenues ............................................................................................................. 27
Net Revenue Requirement .................................................................................................... 28
Water Utility Cost Functionalization ........................................................................................ 29
Water Utility Cost Classification ............................................................................................. 30
Water Utility Cost Allocation .................................................................................................. 31
Water Rate Design ........................................................................................................................... 32
Proposed Rate Plan ............................................................................................................. 33
Notes on Rate Recommendations ......................................................................................... 36
Appendix A – Water Rate Model – Proposed Rate Plan
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 2
Acknowledgements
During the course of this rate study, several Town of Oro Valley employees expended considerable time and
effort in assisting the project team. These employees included the Mayor and Council, Mr. Peter Abraham,
and Ms. Mary Rallis. The project team owes a debt of gratitude to the hard work, dedication and
professionalism of these and other staff members, without whom this project would not have been
successfully completed.
The project team has relied upon the extensive data supplied by the Town of Oro Valley. Thus, the integrity
of the study is largely dependent upon the accuracy of this financial and customer data. Every effort has been
made by the project team to validate and confirm the information contained herein prior to the preparation of
the final study documents. This report presents no assurance or guarantee that the forecast contained
herein will be consistent with actual results or performances. These represent forecasts based on a
series of assumptions about future behavior and are not guarantees. Any changes in assumptions or actual
events may result in significant revisions to the forecast and its conclusions. The cash flow projections and
debt service coverage calculations are not intended to present overall financial positions, results of
operations, and/or cash flows for the periods indicated, which is in conformity with guidelines for presentation
of a forecast established by the American Institute of Certified Public Accountants.
Executive Summary
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 3
Executive Summary
Background
In June 2021, the Town of Oro Valley,
Arizona (the “Town”) engaged Willdan
Financial Services to conduct a water
rate study and long-term financial plan.
The Town was interested in developing an
updated comprehensive water rate plan
for FY 2022 and beyond. The objective is
to develop a long-term rate plan that will
enable the Town to recover sufficient
funds to meet operating expenses, capital
outlays, debt service and coverage
requirements, while at the same time
minimizing the impact on ratepayers.
The Town identified numerous objectives
for this study, including but not limited to
the following:
• A comprehensive analysis and evaluation of the water systems’ current cost of service and revenue
requirements.
• A forecast of operating expenses over the next decade, taking into consideration salient factors such
as cost of water treatment, inflation, system growth, and increases in staffing levels.
• A thorough review of the water systems’ known capital improvement needs, as well as a
determination of the need for funding capital requirements, such as, through rate revenues (Pay-As-
You-Go) and the issuance of long-term debt for the existing identified capital improvements.
• An estimate of current and forecast accounts, volumes, and billing units for the ten-year forecast
period.
• An analysis of alternative rate structures for water rates that will recover sufficient revenues and will
distribute costs equitably.
• A detailed analysis and comparison of the Town’s current and proposed rates to rates in other
surrounding communities.
• Work with the Town to achieve compliance with Arizona Revised Statutes 9-511.01 requirements for
any changes in its current rates.
Figure-1
https://www.facebook.com/shoporovalleymarketplace/photos/a.36689918335
5223/2376581572386964
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 4
Water Rate Comparison
Tables ES-1 compares Oro Valley’s current monthly water charges to those of nearby cities in the region. A
billing volume of 7,000 gallons for water was used for the residential comparison as it represents typical
usage levels for an average household in the Town. The rate data is based on published rates and ordinances
posted by each municipality on their websites as of October 2021 and Arizona Water and Wastewater Rates
Dashboard (prepared by UNC). These rates do not include sales tax, activation or other charges beyond the
basic minimum and volume charges. The table reveals that the Town’s rates are among the lowest when
compared to most other cities in the region.
TABLE ES-1
Water Customers and Meters – Test Year & Forecast
The majority of the water accounts served by Oro Valley are residential accounts. Table ES-2 presents total
water connections (customers) by customer class for the Town for the test year and forecast period. As
shown, overall water accounts are forecast to increase from 21,331 in the test year (FY 2022) to 22,887 in
FY 2031, an average annual increase of 0.79%. The addition of these new connections will result in both
non-recurring connection fees and increasing monthly water revenues.
TOWN OF ORO VALLEY AZ
Water
Oro Valley 5/8" Meter 35.79$
Marana 40.08
Tucson 39.80
Phoenix 8.37
Anway Manville Water Co.54.50
Arizona Water Co. (Oracle)64.26
Metro-main Metro-Hub 43.55
Pima County 46.97
Mammoth 33.73
Flowing Wells Irr. District 29.15
Flagstaff 54.44
Sample Average 40.97$
State Survey Median 41.61$
MONTHLY RESIDENTIAL CHARGES --
7,000 GALLONS WATER
Source: Citys' Website; and Arizona Water and Wastewater
Rates Dashboard (prepared by UNC)
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 5
TABLE ES-2
Net Revenue Requirement
Table ES-3 presents the Town’s forecast Net Revenue Requirement for the ten-year period FY 2022 through
FY 2031. The table reveals that the total net revenue requirement is expected to remain relatively constant
over the ten-year forecast period. The total net revenue requirement is expected to decrease from
$17,387,509 in FY 2022 to $16,781,235 in FY 2031. Detailed calculations are presented in the rate model
contained in Appendix A of this report. In most part, the decrease in revenue requirement forecast over the
next ten years is a result of debt retirement without a need for new debt. These net revenue requirements
must be raised from rates in the test year FY 2022 and the forecast period.
TABLE ES-3
TOWN OF ORO VALLEY AZ
Residential &
Irrigation 5/8"
Residential &
Irrigation 3/4"
Residential &
Irrigation 1"
Residential &
Irrigation 1.5"
Residential &
Irrigation 2"
Residential &
Irrigation 3"
Residential &
Irrigation 4"
Commercial,
Turf &
Multifamily Construction
Reclaimed
Water Total
WATER Total Customers
FY 2019 17,525 1,429 549 52 73 2 5 544 31 6 20,216
FY 2020 17,666 1,529 568 54 73 2 5 555 27 6 20,485
FY 2021 17,933 1,743 587 53 73 2 5 561 30 12 20,999
TY 2022 18,221 1,771 596 54 74 2 5 565 30 12 21,331
FY 2023 18,476 1,796 605 55 75 2 5 569 30 12 21,625
FY 2024 18,665 1,814 611 55 76 2 5 573 30 12 21,844
FY 2025 18,793 1,827 615 56 77 2 5 577 30 12 21,993
FY 2026 18,920 1,839 619 56 77 2 5 581 30 12 22,142
FY 2027 19,048 1,851 623 56 78 2 5 585 30 12 22,291
FY 2028 19,175 1,864 628 57 78 2 5 589 30 12 22,440
FY 2029 19,303 1,876 632 57 79 2 5 593 30 12 22,589 FY 2030 19,430 1,889 636 57 79 2 5 597 30 12 22,738 FY 2031 19,558 1,901 640 58 80 2 5 601 30 12 22,887
WATER Annual New Customers
FY 2020 141 100 19 2 - 262
FY 2021 267 214 19 (1) - - - 6 3 6 514
TY 2022 288 28 9 1 1 0 0 4 - - 332
FY 2023 255 25 8 1 1 0 0 4 - - 294
FY 2024 189 18 6 1 1 0 0 4 - - 219 FY 2025 127 12 4 0 1 0 0 4 - - 149 FY 2026 127 12 4 0 1 0 0 4 - - 149
FY 2027 127 12 4 0 1 0 0 4 - - 149
FY 2028 127 12 4 0 1 0 0 4 - - 149
FY 2029 127 12 4 0 1 0 0 4 - - 149
FY 2030 127 12 4 0 1 0 0 4 - - 149
FY 2031 127 12 4 0 1 0 0 4 - - 149
FORECAST TOTAL CUSTOMERS
WATER Customer Classes
TOWN OF ORO VALLEY AZ
SCENARIO:2022 02 18 -- Equal Percent Adjustments
Operating
Expenses
Capital
Outlays Debt Service Cost of Service
Non-Rate
Revenues
Revenue
Requirement
TOTAL Revenue Requirement
TY 2022 12,310,079$ 3,511,650$ 4,935,311$ 20,757,039$ 3,369,530$ 17,387,509$
FY 2023 12,796,184 1,670,650 5,380,668 19,847,502 3,396,614 16,450,888
FY 2024 13,420,608 3,250,650 4,279,034 20,950,293 3,415,149 17,535,144
FY 2025 13,265,139 3,250,650 4,026,510 20,542,299 3,427,650 17,114,650
FY 2026 13,733,851 3,250,650 4,027,705 21,012,205 3,440,150 17,572,056
FY 2027 14,097,050 3,250,650 3,878,868 21,226,568 3,452,650 17,773,918
FY 2028 14,527,577 3,250,650 2,234,774 20,013,001 3,465,151 16,547,850
FY 2029 14,973,661 3,250,650 1,951,588 20,175,900 3,477,651 16,698,249
FY 2030 15,435,727 3,250,650 1,224,556 19,910,933 3,490,151 16,420,782
FY 2031 15,919,371 3,250,650 1,113,865 20,283,887 3,502,652 16,781,235
CURRENT AND FORECAST NET REVENUE REQUIREMENT
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 6
One of the key assumptions used in the development of the long-term revenue requirement is the Town’s
Capital Improvement Plan. The Town’s CIP assumptions are summarized in Table ES-4. The table reveals
that the Town’s CIP over the next five years is estimated to be $6,941,000 for the water system Operating
Fund Projects.
TABLE ES-3
It should be noted that if the Town materially revises its CIP, the rate plan may be subject to potentially
significant revision.
TOWN OF ORO VALLEY AZ
SCENARIO:2022 02 18 -- Equal Percent Adjustments
HP Tank Replacement ( 1-Tank & 1 Booster tank/Year)1,350,000$
Well Rehab. (2-Wells per year)930,000
Booster Rehab (2-Boosters- Study/Design/Construct)870,000
Reservoir Relining (4 Reservoirs)700,000
Palisades Area Supply Redundancy (Design & Const.)520,000
SCADA Equipment 500,000
Instrumentation Replacement 500,000
Water Meters for New Connections 375,000
El Con/Cmo Diestro Main & Valve Replacement 200,000
Vehicle Replacements 331,000
Well D8 Replacement Design 100,000
Other Future Projects 565,000
Total Operating Fund Projects 6,941,000$
OPERATING FUND PROJECTS
CAPITAL IMPROVEMENT PLAN FOR EXISTING SYSTEM IMPROVEMENTS
FY 2022 - FY 2026
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 7
Water Rate Design
The water rates developed in this study are designed to recover the test year and forecast revenue
requirement while providing funding for the current identified capital, transfers, and debt service. The following
is notable regarding this rate proposal:
• While the rate model presents a forecast of rates for ten years, the project team recommends that
the Town adopt a rate plan for FY 2022/2023, with rates to be implemented on July 1, 2022.
• One of the most significant impacts on rates will be the cost of the Central Arizona Project water.
Should the Central Arizona Project make material changes to its rate forecasts, the Town should
undertake an immediate review of its rate plan.
• Another significant impact on rates will be debt issued to fund the CIP. The initial cost of service and
rate proposal assumes that the utility rate adjustments will fund debt on a stand-alone basis, whereby
debt service will be fully funded through rates. If the Town issues additional debt not currently
anticipated, the Town should undertake an immediate review of its rate plan to confirm the debt costs
will be fully funded through rates.
• The rate plan also assumes that Ground Preservation Fees and Operating Fund revenues as well
as debt will be used to fund the current 5-year Capital Improvement Plan.
• Uniform adjustments are applied to the existing base and volumetric rates for each rate class. There
is no change to the basic rate structure other than the uniform annual adjustments in the base case
rate plan. The rate plan and forecast revenues and expenses under this scenario is presented in
Appendix A.
Table ES-5 presents a summary of the rate plan proposed for the majority of the Town’s Residential
customers. Table ES-6 presents a summary of the rate plan proposed for residential customers using 2, 3,
or 4 inch meter sizes and Table ES-7 is the proposed rate plan for commercial, multifamily, turf, and reclaimed
water customers. These tables present the rate plan selected by the Town out of three alternatives developed
by the project team. Table ES-8 presents the customer rate impact assuming the proposed rate structure is
adopted by Town Council. The schedules show the proposed rate plan and the forecast rates for subsequent
years.
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 8
TABLE ES-5
TABLE ES-6
TOWN OF ORO VALLEY AZ
Proposed
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26
Residential & Irrigation 5/8"
Monthly Base Charge 5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$
Commodity Rate/1,000 Gal
Tier 1 1 7,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 7,001 16,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 16,001 32,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 32,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 3/4"
Monthly Base Charge 3/4"28.48$ 28.48$ 29.90$ 31.39$ 32.96$ 34.61$ 36.00$
Commodity Rate/1,000 Gal
Tier 1 1 10,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 10,001 24,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 24,001 48,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 48,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 1"
Monthly Base Charge 1"47.46$ 47.46$ 49.83$ 52.32$ 54.94$ 57.68$ 59.99$
Commodity Rate/1,000 Gal
Tier 1 1 17,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 17,001 40,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 40,001 80,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 80,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 1.5"
Monthly Base Charge 1.5"94.91$ 94.91$ 99.66$ 104.64$ 109.87$ 115.36$ 119.98$
Commodity Rate/1,000 Gal
Tier 1 1 35,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 35,001 80,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 80,001 160,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 160,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Forecast
TOWN OF ORO VALLEY AZ
Proposed
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26
Residential & Irrigation 2"
Monthly Base Charge 2"151.87$ 151.87$ 159.46$ 167.44$ 175.81$ 184.60$ 191.98$
Commodity Rate/1,000 Gal
Tier 1 1 56,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 56,001 128,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 128,001 256,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 256,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 3"
Monthly Base Charge 3"303.71$ 303.71$ 318.90$ 334.84$ 351.58$ 369.16$ 383.93$
Commodity Rate/1,000 Gal
Tier 1 1 112,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 112,001 256,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 256,001 512,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 512,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 4"
Monthly Base Charge 4"474.56$ 474.56$ 498.29$ 523.21$ 549.37$ 576.83$ 599.91$
Commodity Rate/1,000 Gal
Tier 1 1 175,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 175,001 400,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 400,001 800,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 800,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Forecast
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 9
TABLE ES-7
TOWN OF ORO VALLEY AZ
Proposed
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26
Commercial, Turf & Multifamily
Monthly Base Charge
5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93
4"474.56 474.56 498.29 523.21 549.37 576.83 599.91
6"949.12 949.12 996.58 1,046.41 1,098.73 1,153.67 1,199.81
8"1,518.60 1,518.60 1,594.53 1,674.25 1,757.97 1,845.86 1,919.70
Commodity Rate/1,000 Gal
1 Above 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Construction Rate/1,000 Gal
1 Above 7.29 7.29 7.65 8.04 8.44 8.86 9.22
W9 Construction
Monthly Base Charge
5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93
4"474.56 474.56 498.29 523.21 549.37 576.83 599.91
6"949.12 949.12 996.58 1,046.41 1,098.73 1,153.67 1,199.81
8"1,518.60 1,518.60 1,594.53 1,674.25 1,757.97 1,845.86 1,919.70
Commodity Rate/1,000 Gal
1 Above 7.29 7.29 7.65 8.04 8.44 8.86 9.22
W10 Reclaimed Water
Monthly Base Charge
5/8"14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$
3/4"21.93 21.93 21.93 21.93 21.93 21.93 21.93
1"36.54 36.54 36.54 36.54 36.54 36.54 36.54
1 1/2"73.08 73.08 73.08 73.08 73.08 73.08 73.08
2"116.94 116.94 116.94 116.94 116.94 116.94 116.94
3"233.86 233.86 233.86 233.86 233.86 233.86 233.86
4"365.41 365.41 365.41 365.41 365.41 365.41 365.41
6"730.83 730.83 730.83 730.83 730.83 730.83 730.83
8"1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32
Commodity Rate/1,000 Gal
1,001 Above 2.25 2.25 2.25 2.25 2.25 2.25 2.25
Forecast
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 10
TABLE ES-8
TOWN OF ORO VALLEY AZ
Proposed
Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26
Residential Monthly Charges - 5/8"
7,000 Water 35.79$ 35.79$ 37.58$ 39.46$ 41.43$ 43.50$ 45.24$
Increase -- $- 1.79 1.88 1.97 2.07 1.74
Increase -- %0.0%5.0%5.0%5.0%5.0%4.0%
10,000 Water 45.84 45.84 48.13 50.54 53.07 55.72 57.95
Increase -- $- 2.29 2.41 2.53 2.65 2.23
Increase -- %0.0%5.0%5.0%5.0%5.0%4.0%
Commercial Monthly Charge -- 2"
50,000 Water 271.87 271.87 285.46 299.74 314.72 330.46 343.68
Increase -- $- 13.59 14.27 14.99 15.74 13.22
Increase -- %0.0%5.0%5.0%5.0%5.0%4.0%
Forecast
Section I
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 11
SECTION I
Introduction and Demographic Profile
Background
In June 2021, the Town of Oro Valley, Arizona (the
“Town”) engaged Willdan Financial Services to
conduct a water rate study and long-term financial plan.
The Town was interested in developing an updated
comprehensive water rate plan for FY 2021/2022 and
beyond. The objective of this study is to develop a long-
term rate plan that will enable the Town to recover
sufficient funds to meet operating expenses, capital
outlays, debt service and coverage requirements, while
at the same time to the best extent possible minimizing
the impact of any adjustments on ratepayers.
The Town identified numerous objectives for this study, including but not limited to the following:
• A comprehensive analysis and evaluation of the water systems’ current cost of service and revenue
requirements.
• A forecast of operating expenses over the next decade, taking into consideration such factors as
inflation, system growth, and increases in staffing levels.
• A thorough review of the water systems’ known capital improvement needs, as well as a
determination of the need for funding capital requirements, such as, through rate revenues (Pay-As-
You-Go) and the issuance of long-term debt for the existing identified capital improvements.
• An estimate of current and forecast accounts, volumes, and billing units for the ten-year forecast
period.
• An analysis of alternative multi-year water rate plans that will distribute costs equitably.
• A detailed analysis and comparison of the Town’s current and proposed rates to rates in other
surrounding communities.
• Work with the Town to achieve compliance with Arizona Revised Statutes 9-511.01 requirements for
any changes in its current rates.
Report Organization
This report is organized into the following sections:
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 12
Section I – Introduction and Demographic Profile - outlines the background, objectives and scope of this
rate study and long-term financial plan. It also presents the Town’s current rate structure and a community
profile of the Town of Oro Valley. This includes a comparison of the Town’s water charges with other local
cities.
Section II – Water Test Year and Forecast Volumes – analyzes the Town’s customer base, total accounts
and current volumes of treated water. This section presents totals for the current year and a forecast ten
years into the future.
Section III – Water Test Year and Forecast Revenue Requirement – outlines the process of analyzing the
Town’s current water utility cost structure. The total current or “test year” revenue requirements are
developed, and costs are functionalized between treatment, distribution/collection, administration, and
customer billing. Using the test year as a basis, costs are forecast for a ten-year period.
Section IV – Water Rate Design – presents rate recommendations for the Town of Oro Valley Town Council
and Staff to consider which would enable it to meet its revenue requirements over the next decade. This
section also presents an analysis of the impact of the proposed plan.
Appendix A – presents a hard copy printout of the interactive Microsoft Excel spreadsheet model summary
developed for the Town of Oro Valley to calculate water current and future revenue requirements. The model
automatically generates all calculations based on a set of defined user inputs and has an executive
dashboard for users to develop real-time “what-if” scenarios.
Community Overview
The Town of Oro Valley, Arizona is located approximately
6 miles north of Tucson, Arizona. The Town is
approximately 34.991 square miles and has an estimated
January 1, 2021, population of 47,502 2. The Town is
located in Pima County.
The Town of Oro Valley has a Council-Manager form of
government in which the elected Mayor and City Council
Members establish policy. Those policies are then
implemented by the Town Manager who is appointed by,
and reports to, the Town Council. The Oro Valley Town
Council consists of five Council Members, a Vice Mayor
and a Mayor.
The Town Manager operates in much the same way as a Chief Executive Officer of a corporation. The Town
Manager's Office is responsible for the day-to-day administration of Oro Valley's Town government, including
managing the Town's budget, the Town's departments and operations, and programs for communicating with
residents and employees.
1 Wikipedia - https://en.wikipedia.org/wiki/Oro_Valley,_Arizona
2 https://worldpopulationreview.com/us-cities/oro-valley-az-population
Figure 2 -
https://www.realtor.com/realestateandhomes-
detail/6602-Mediterranean-
Dr_McKinney_TX_75071_M86649-91383
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 13
Current Water Rates
Table I-1 summarizes the Town of Oro Valley’s current water rate structure.
TABLE I-1
The Town of Oro Valley last adjusted its rates effective with the July 2021 billing cycle. The water rate
structure assesses a base charge that varies by meter size for all rate classes. The Commercial and Irrigation
customers have a base charge that increases based on meter size. For Residential and Irrigation customers,
TOWN OF ORO VALLEY AZ
Base Charge 5/8"18.99$ Commodity Rate (per 1,000 Gallons)
3/4"28.48 Tier 1 2.40
1"47.46 Tier 2 3.35
1 1/2"94.91 Tier 3 4.80
2"151.87 Tier 4 6.70
3"303.71
4"474.56
6"949.12 Commodity Rate (per 1,000 Gallons)
8"1,518.60 Tier 1 2.40
Tier 2 3.35
Tier 3 4.80
Commodity Rate (per 1,000 Gallons)Tier 4 6.70
Tier 1 2.40$
Tier 2 3.35
Tier 3 4.80 Commodity Rate (per 1,000 Gallons)
Tier 4 6.70 Tier 1 2.40
Tier 2 3.35
Tier 3 4.80
Commodity Rate (per 1,000 Gallons)Tier 4 6.70
Tier 1 2.40$
Tier 2 3.35
Tier 3 4.80 Commodity Rate (per 1,000 Gallons)
Tier 4 6.70 Tier 1 2.40
Tier 2 3.35
Tier 3 4.80
Commodity Rate (per 1,000 Gallons)Tier 4 6.70
Tier 1 2.40$
Tier 2 3.35 Commercial, Turf & MF ($/1k Gal)2.40
Tier 3 4.80
Tier 4 6.70 Construction ($/1,000 Gal.)7.29
CURRENT WATER RATES
Potable Water Meter Base Charge
Water Rates
Residential & Irrigation 3/4"
Residential & Irrigation 1"
Residential & Irrigation 5/8"
Residential & Irrigation 1.5"
Residential & Irrigation 2"
Residential & Irrigation 3"
Residential & Irrigation 4"
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 14
volume is billed based on tiered rates per 1,000 gallons. Commercial and Municipal customers are billed a
uniform rate per 1,000 gallons for all metered water.
Chart I-2 presents the percentage rate adjustments implemented by the Town since 2010. While the average
water and wastewater utility across the USA has implemented adjustments of as much as 5.0% -- 6.0%
annually, the chart reveals that the Town’s adjustments have been much more moderate over the past
decade.
Chart I-2
Water Rate Comparison
Chart I-3 and Table I-4 compare the Town’s monthly water charges to surrounding cities in Arizona. Volumes
of 7,000 gallons for water were used for the residential comparison as it represents typical usage levels for
an average household. The comparison is based on residential rates for households with a 5/8’’ meter size.
The rate data is based on published rates and ordinances posted by each municipality on their website and
the 2021 TML water rate survey. These rates do not include sales tax, activation or other charges beyond
the basic minimum and volume charges.
The following points are also notable:
• Many cities do not assess rates that recover the full cost of service, choosing instead to subsidize
their water utilities with other revenues or to defer needed repairs and maintenance at the expense
of system reliability and integrity.
• Some cities use tax bonds to fund water system construction. This results in lower rates but higher
ad valorem taxes.
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 15
CHART I-3
TABLE I-4
TOWN OF ORO VALLEY AZ
Water
Oro Valley 5/8" Meter 35.79$
Marana 40.08
Tucson 39.80
Phoenix 8.37
Anway Manville Water Co.54.50
Arizona Water Co. (Oracle)64.26
Metro-main Metro-Hub 43.55
Pima County 46.97
Mammoth 33.73
Flowing Wells Irr. District 29.15
Flagstaff 54.44
Sample Average 40.97$
State Survey Median 41.61$
MONTHLY RESIDENTIAL CHARGES --
7,000 GALLONS WATER
Source: Citys' Website; and Arizona Water and Wastewater
Rates Dashboard (prepared by UNC)
Section II
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 16
SECTION II
Water Test Year and Forecast Volumes
In order to accurately forecast future revenues and
expenses, it is necessary to examine current water
utility conditions. The first step in developing cost of
service rates is to analyze patterns of usage, both for
the system as a whole, and for specified customer
classes.
For the Town of Oro Valley, monthly water records
were reviewed for the period July 2005 through June
2021. These records provided summary information
on the monthly water volumes distributed system
wide as well as the number of accounts for each
period by defined customer class and the associated
revenues.
According to standard utility ratemaking
methodology, in order to allocate revenue
requirements equitably among system users,
customers must be classified into relatively
homogeneous groups with similar usage
characteristics or service demands. Costs are then
allocated to the customer classes in proportion to the
usage characteristics of each class. For the water system, costs are typically allocated to customers based
on their average and peak water demands.
After thoroughly examining volume and customer data, the project team made no revisions to the Town’s
existing rate classifications. The project team finds these customer class distinctions to be reasonable and
appropriate, meeting the criteria of homogenous groups with similar usage patterns.
In this section, the Town’s functional customer classes and test year usage patterns will be thoroughly
analyzed. A ten-year projection of customers and usage will also be presented. These forecasts, along with
the revenue requirements, will form the basis of the proposed rate designs.
Water Customers and Meters – Test Year & Ten-Year Forecast
The majority of the water accounts served by Oro Valley are residential accounts, with the balance being split
between commercial, turf and multifamily, construction, and reclaimed water. Table II-1 and Chart II-2
present total water accounts for the Town for the test year and forecast period.
Figure 3 -
https://www.55places.com/arizona/communities/sun-city-oro-
valley
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 17
TABLE II-1
CHART II-2
TOWN OF ORO VALLEY AZ
Residential &
Irrigation 5/8"
Residential &
Irrigation 3/4"
Residential &
Irrigation 1"
Residential &
Irrigation 1.5"
Residential &
Irrigation 2"
Residential &
Irrigation 3"
Residential &
Irrigation 4"
Commercial,
Turf &
Multifamily Construction
Reclaimed
Water Total
WATER Total Customers
FY 2019 17,525 1,429 549 52 73 2 5 544 31 6 20,216
FY 2020 17,666 1,529 568 54 73 2 5 555 27 6 20,485
FY 2021 17,933 1,743 587 53 73 2 5 561 30 12 20,999
TY 2022 18,221 1,771 596 54 74 2 5 565 30 12 21,331
FY 2023 18,476 1,796 605 55 75 2 5 569 30 12 21,625
FY 2024 18,665 1,814 611 55 76 2 5 573 30 12 21,844
FY 2025 18,793 1,827 615 56 77 2 5 577 30 12 21,993
FY 2026 18,920 1,839 619 56 77 2 5 581 30 12 22,142
FY 2027 19,048 1,851 623 56 78 2 5 585 30 12 22,291
FY 2028 19,175 1,864 628 57 78 2 5 589 30 12 22,440
FY 2029 19,303 1,876 632 57 79 2 5 593 30 12 22,589
FY 2030 19,430 1,889 636 57 79 2 5 597 30 12 22,738
FY 2031 19,558 1,901 640 58 80 2 5 601 30 12 22,887
WATER Annual New Customers
FY 2020 141 100 19 2 - 262
FY 2021 267 214 19 (1) - - - 6 3 6 514
TY 2022 288 28 9 1 1 0 0 4 - - 332
FY 2023 255 25 8 1 1 0 0 4 - - 294
FY 2024 189 18 6 1 1 0 0 4 - - 219
FY 2025 127 12 4 0 1 0 0 4 - - 149
FY 2026 127 12 4 0 1 0 0 4 - - 149
FY 2027 127 12 4 0 1 0 0 4 - - 149
FY 2028 127 12 4 0 1 0 0 4 - - 149
FY 2029 127 12 4 0 1 0 0 4 - - 149
FY 2030 127 12 4 0 1 0 0 4 - - 149
FY 2031 127 12 4 0 1 0 0 4 - - 149
FORECAST TOTAL CUSTOMERS
WATER Customer Classes
20,216 21,331 22,291 22,887
-
5,000
10,000
15,000
20,000
25,000
2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Town of Oro Valley AZ
Actual and Forecast Water Accounts
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 18
For each of the historical years, the average number of accounts for the year is shown and the growth reflects
the difference from one fiscal year end to the next. Overall water accounts (potable and reclaimed) are
forecast to increase from 21,331 in the test year to 22,887 in FY 2031, an average annual increase of 0.79%
for all customer classes.
Historical and Forecast Water Consumption
Total water system consumption data was analyzed over the same time period as customer data. A
combination of consumption over the past 12 months and historical trends was used as the basis for the
development of the forecast water usage within the rate model.
The project team prepared a ten-year forecast of water usage based on the same principles on which
customer accounts were projected. The results of this forecast for water usage are presented in Table II-5.
Chart II-6 presents the same water usage forecast in chart form and includes a three-year history of usage
(FY 2019 – 2021). FY 2021 was a dry year which created a significant increase in water usage. Working
with the Town staff, the project team determined that FY 2020 water usage was a more appropriate starting
base for the rate study forecast.
With these adjustments water usage is expected to increase at an average annual rate of approximately
0.68% over the next decade. By FY 2031 water usage is expected to reach 2,498,376,903 gallons.
TABLE II-5
TOWN OF ORO VALLEY AZ
Residential &
Irrigation 5/8"
Residential &
Irrigation 3/4"
Residential &
Irrigation 1"
Residential &
Irrigation 1.5"
Residential &
Irrigation 2"
Residential &
Irrigation 3"
Residential &
Irrigation 4"
Commercial,
Turf &
Multifamily Construction Total
TY 2022 1,444,476,233 188,922,762 152,687,088 38,938,765 93,165,025 16,881,063 50,041,170 327,014,495 38,337,280 2,350,463,880
FY 2023 1,464,689,421 191,566,441 154,823,705 39,483,652 94,468,724 17,117,287 50,741,418 329,329,642 38,337,280 2,380,557,569
FY 2024 1,479,675,060 193,526,410 156,407,749 39,887,620 95,435,259 17,292,418 51,260,567 329,329,642 38,337,280 2,401,152,005
FY 2025 1,489,781,654 194,848,249 157,476,057 40,160,064 96,087,109 17,410,530 51,610,691 329,329,642 38,337,280 2,415,041,276
FY 2026 1,499,888,248 196,170,089 158,544,366 40,432,507 96,738,958 17,528,642 51,960,815 329,329,642 38,337,280 2,428,930,547
FY 2027 1,509,994,842 197,491,928 159,612,675 40,704,951 97,390,808 17,646,754 52,310,939 329,329,642 38,337,280 2,442,819,819
FY 2028 1,520,101,436 198,813,767 160,680,983 40,977,395 98,042,657 17,764,867 52,661,063 329,329,642 38,337,280 2,456,709,090
FY 2029 1,530,208,030 200,135,607 161,749,292 41,249,838 98,694,507 17,882,979 53,011,187 329,329,642 38,337,280 2,470,598,361
FY 2030 1,540,314,624 201,457,446 162,817,600 41,522,282 99,346,356 18,001,091 53,361,311 329,329,642 38,337,280 2,484,487,632
FY 2031 1,550,421,218 202,779,286 163,885,909 41,794,725 99,998,206 18,119,203 53,711,435 329,329,642 38,337,280 2,498,376,903
FY 2023 20,213,188 2,643,679 2,136,617 544,887 1,303,699 236,224 700,248 2,315,147 - 30,093,689
FY 2024 14,985,639 1,959,969 1,584,044 403,968 966,535 175,132 519,149 - - 20,594,437
FY 2025 10,106,594 1,321,839 1,068,309 272,444 651,849 118,112 350,124 - - 13,889,271
FY 2026 10,106,594 1,321,839 1,068,309 272,444 651,849 118,112 350,124 - - 13,889,271
FY 2027 10,106,594 1,321,839 1,068,309 272,444 651,849 118,112 350,124 - - 13,889,271
FY 2028 10,106,594 1,321,839 1,068,309 272,444 651,849 118,112 350,124 - - 13,889,271
FY 2029 10,106,594 1,321,839 1,068,309 272,444 651,849 118,112 350,124 - - 13,889,271
FY 2030 10,106,594 1,321,839 1,068,309 272,444 651,849 118,112 350,124 - - 13,889,271
FY 2031 10,106,594 1,321,839 1,068,309 272,444 651,849 118,112 350,124 - - 13,889,271
FORECAST BILLED POTABLE WATER CONSUMPTION
WATER Customer Classes
WATER Annual Consumption
WATER Increase/(Decrease) from Prior Year
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 19
CHART II-6
Peaking Factors
The cost of providing water to customers depends not only on the amount of water each class uses, but also
on how that usage occurs over time. The maximum-day and maximum-hour peaking requirements of a water
utility’s customers are an important influence on the utility’s costs. Because water utilities attempt to meet all
of the demands of their customers, water systems are sized to meet customers’ peak requirements.
Therefore, during off-peak periods, there are usually significant costs associated with the unused capacity of
the system. These costs must be allocated to customers in proportion to the contribution of each customer
class to the system peak, in order to develop equitable cost-based rates. Thus, it is necessary to determine
the peak rate of use relative to the average rate of use for each class. This ratio is called a Peaking Factor.
The calculation of peaking factors for individual classes relies on available pumping and consumption
information as well as professional judgment. If customer meters could record daily flow rates for each
customer, more refined information could be obtained on peaking factors. This is not feasible because of the
enormous cost that would be imposed on the utility. Therefore, it is accepted practice in the water industry to
develop peaking factor estimates based on standard formulas using system peak day information and
monthly customer class usage records. This is a conservative methodology, since customer class peaking
factors based on peak months will inevitably be lower than the system-wide peaking factor, which is based
on the peak day.
Based on AWWA guidelines, the customer class peaking factors calculated in this study are for non-
coincidental peaks. The peaking factors developed for this analysis are based on the annualized water
consumption by customer class for FY 2022. The calculations of the peaking factors by class are presented
graphically in Chart II-7.
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 20
CHART II-7
Section III
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 21
SECTION III
Water Forecast Revenue Requirement
In this section of the water rate study and long-
term financial plan, the Town of Oro Valley’s test
year and forecast water utility revenue
requirements are developed. The test year
consists of the town’s fiscal year, July 1, 2021,
through June 30, 2022. The estimates presented
in this section are based on the Town’s proposed
budget for FY 2022.
The calculation of a revenue requirement differs
from a utility’s budget in that it represents only that
amount that must be raised through the Town’s
user rates. This means that non-rate revenue
(such as reconnection fees, late payment charges
and interest) must be subtracted from the
budgeted operating and capital expenditures to
determine the net revenue requirement to be
raised from rates.
As is typical for publicly owned utilities, the Town
of Oro Valley’s system revenue requirements were developed using the cash basis of ratemaking. Under the
cash basis, as defined by the AWWA Manual M-1, system revenue requirements consist of cash expenditures
and other financial commitments (such as debt service coverage or reserves) that must be met through
system operating revenues and other revenue sources.
All data used in the development of the revenue requirements was obtained from the financial statements,
budgets, and other information provided by the Town. Detailed calculations are presented in the rate model
contained in Appendix A of this report. For rate design purposes, revenue requirements are developed
separately for the water system.
The assumptions utilized in this expense forecast will be thoroughly detailed in this section of the report.
These assumptions are critical to the development of both the revenue requirement and the ultimate rate
recommendation. The project team reviewed these assumptions with the Town staff and considers all to be
consistent with staff recommendations.
In this section, current and forecast Operating Costs, Capital Outlays, Transfers, and Debt Service will be
examined first. Non-rate revenues will be subtracted from the total to yield the Net Revenue Requirement.
Figure 4 - https://www.gouldturner.com/portfolio-
posts/northwest-medical-center-oro-valley/
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 22
Operating Expenses and Capital Outlays – Test Year
Table III-1 on the following page summarizes the test year FY 2022 water system operating expenses and
capital outlays in detail by expense category item.
The following is noteworthy about Table III-1:
• There are nine (9) divisions within the Town’s Water Operating Fund: Administration, Customer,
Conservation, Water Resources, Engineering, Capital Improvement, Construction Inspection,
Operations, and Control Systems.
• These divisions include the following expense categories:
o Personnel, which includes all personnel costs, such as salary and benefit expenses, and payroll
taxes.
o Operation/Maintenance, which captures the primary operating expenses associated with the
day-to-day management and maintenance of the water production and distribution operations.
o CAP Fees, a 336 mile system that brings Colorado River water to central and southern Arizona.
CAP is the state’s single largest renewable water supply and serves 80% of the state’s
population.
o Supplies, which includes postage, office equipment and supplies, IT costs, chemicals, etc.
o Capital Improvements funded through the water utility budget.
o Contractual or Miscellaneous, these expenses include such items as utility (electricity, gas, etc.)
expense, fuels, small tools, maintenance supplies and contractual services.
o Reclaimed operating and equipment costs.
Table III-1 shows, total operating expenses, transfers, and capital outlays in the test year are $15,821,729
TABLE III-1
TOWN OF ORO VALLEY AZ
SCENARIO:2022 02 18 -- Equal Percent Adjustments
Net Budget Production Distribution Admin
Customer
Billing
Reclaimed
Water
Operating & Maintenance
Personnel 3,662,217$ 563,573$ 525,742$ 1,675,531$ 656,778$ 240,593$
Central Arizona Project 4,062,888 4,062,888 - - - -
Operations & Maintenance 2,580,788 520,975 338,610 1,407,608 313,595 -
Administrative Expense 205,116 - - 188,128 - 16,988
Utilities 850,000 850,000 - - - -
Reclaimed Water 949,070 - - - - 949,070
Northwest Recharge, Recovery & Delivery System 0 0 - - - -
Total Operating & Maintenance 12,310,079 5,997,436 864,352 3,271,266 970,373 1,206,652
Contingencies & Transfers - - - - - -
Capital Outlays 3,511,650 2,500 3,351,000 150,000 8,150 -
Total WATER Operating Expenses,
Transfers and Capital Outlays 15,821,729 5,999,936 4,215,352 3,421,266 978,523 1,206,652
WATER Operating Expenses, Transfers and Capital Outlays
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 23
Cost of Service – Ten Year Forecast
Table III-3 presents the water utility operating expense and capital outlay forecast for the ten-year period FY
2022 – FY 2031. Details behind these calculations can be found in the rate model contained in Appendix A.
This forecast is based on the following set of assumptions:
• Most operating costs are expected to increase at an annual rate of 2.0%, which is used by the Town
in its Water Rates Analysis Report (March 2021).
• Certain expenses will increase at above-inflation rates, to reflect the rapid rate of increase of these
costs. These expenses include chemicals, workers compensation, Medicare, and insurance.
• CAP water and delivery cost is one of the largest items in operating expenses. These costs are $4.1
million in FY 2022 and estimated to increase to $5.7 by FY 2031.
TABLE III-3
TOWN OF ORO VALLEY AZ
SCENARIO:
2022 02 18 -- Equal Percent Adjustments
Operating
Expense Capital Outlays Total
TY 2022 12,310,079$ 3,511,650$ 15,821,729$
FY 2023 12,796,184 1,670,650 14,466,834
FY 2024 13,420,608 3,250,650 16,671,258
FY 2025 13,265,139 3,250,650 16,515,789
FY 2026 13,733,851 3,250,650 16,984,501
FY 2027 14,097,050 3,250,650 17,347,700
FY 2028 14,527,577 3,250,650 17,778,227
FY 2029 14,973,661 3,250,650 18,224,311
FY 2030 15,435,727 3,250,650 18,686,377
FY 2031 15,919,371 3,250,650 19,170,021
FORECAST OPERATING EXP. AND CAPITAL OUTLAYS
Water
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 24
Capital Improvement Plan
The Town has developed a comprehensive long-term capital improvements plan for the next five years. The
purpose of the CIP is to rehabilitate and maintain the existing system, expand the system and to service new
growth. In addition, the project team consulted with Town Staff to forecast CIP through the end of the rate
plan period.
The capital improvement plan is an integral part of any long-term rate and financing plan. The Town finances
its capital improvements through a combination of GPF3 and Operating Fund revenue (Pay-as-You-Go) and
revenue-funded long-term debt.
Chart III-4 and Table III-5 summarize the Town’s CIP. The CIP involves repairs and upgrades to pumps and
distribution system and construction of pump stations. The tables reveal that the Town’s CIP over the next
five years is estimated to be $6,941,000 for the operating fund projects and $26,000,000 for the Northwest
Recharge, Recovery and Delivery System (NWRRDS).
The NWRRDS is a Central Arizona Project (CAP) water transmission/delivery system under construction that,
when completed in FY 2025 – 2026, will be capable of delivering up to an additional 4,000 acre feet per year
of CAP water into the Town’s water service area.
The Town intends to fund the existing system improvements’ CIP through the direct contributions from
rates/operating fund.
CHART III-4
3 Groundwater Preservation Fees (GPF) funds are restricted to costs related to renewable water resources, infrastructure, and associated debt.
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 25
TABLE III-5
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 26
Existing and Forecast Debt Service
Table III-6 presents current and forecast debt service. Central to this forecast is the assumption that the
Town issues new $8,000,000 in water bonds in FY 2022 - 2023 to fund a portion of the NWRRDS CIP.
The Town currently has eight water bond issues outstanding in the Test Year that were issued to fund the
water system improvements. Debt service on these issues is currently being paid from Utility System
Revenue. For FY 2022 forward, it is projected that bonds will be repaid entirely with utility system revenues.
The FY 2022 - 2023 debt is assumed to have a 20-year term, 4.0% interest rate and level principal and
interest payments.
These assumptions are preliminary in nature and subject to change. Should the Town Council choose to
issue more or less revenue debt than assumed in this study or should different financing terms be available
at the time the debt is issued, then the rate plans contained in this study may require revision.
It is important to note that the water system debt service will be decreasing significantly over the next ten
years. This is a result of debt retirements starting in FY 2027 decreasing debt service by almost 80% in FY
2031. Currently, the Town does not plan to issue any new debt other than the $8 million that will be issued
in FY 2023.
TABLE III-6
TOWN OF ORO VALLEY AZ
SCENARIO:2022 02 18 -- Equal Percent Adjustments
Year Current Forecast Total
TY 2022 4,935,311$ -$ 4,935,311$
FY 2023 4,780,241 600,427 5,380,668
FY 2024 3,678,607 600,427 4,279,034
FY 2025 3,426,083 600,427 4,026,510
FY 2026 3,427,277 600,427 4,027,705
FY 2027 3,278,441 600,427 3,878,868
FY 2028 1,634,346 600,427 2,234,774
FY 2029 1,351,161 600,427 1,951,588
FY 2030 624,129 600,427 1,224,556
FY 2031 513,438 600,427 1,113,865
Water Debt Service
CURRENT AND FORECAST DEBT SERVICE
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 27
Non-Rate Revenues
Although sales revenues constitute the majority of the revenue received by the Town of Oro Valley for water
service, a certain amount of revenue is accrued from non-rate sources. These revenues include other general
revenues, miscellaneous charges, and contractual receipts. It also includes the forecast GPF surcharge
revenue. This is a fixed fee per 1,000 gallons charged to all potable and reclaimed customers. The potable
customer’s charge is different from the fee charged reclaimed customers. Neither fee is forecast to change
during the rate planning period. Increases in annual revenue represents growth in water usage.
These non-rate revenues are subtracted from the overall budget to determine the revenue requirement to be
raised from rates. Non-rate revenues are conservatively forecasted not to increase during the next ten years.
Annual non-rate revenue totals are presented in Table III-7.
TABLE III-7
TOWN OF ORO VALLEY AZ
SCENARIO:
2022 02 18 -- Equal Percent Adjustments
Water GPF Revenue Total Water & GPF
TY 2022 975,000$ 2,394,530$ 3,369,530$
FY 2023 975,000 2,421,614 3,396,614
FY 2024 975,000 2,440,149 3,415,149
FY 2025 975,000 2,452,650 3,427,650
FY 2026 975,000 2,465,150 3,440,150
FY 2027 975,000 2,477,650 3,452,650
FY 2028 975,000 2,490,151 3,465,151
FY 2029 975,000 2,502,651 3,477,651
FY 2030 975,000 2,515,151 3,490,151
FY 2031 975,000 2,527,652 3,502,652
FORECAST NON-RATE REVENUES
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 28
Net Revenue Requirement
Table III-8 and Chart III-9 presents the test year and ten-year forecast for the Town’s net revenue
requirement to be raised from rates for the water utility for the test year 2022 and forecast period. The water
net revenue requirement is expected to decrease from $17,387,509 in FY 2022 to $16,781,235 in FY 2031.
TABLE III-8
CHART III-9
TOWN OF ORO VALLEY AZ
SCENARIO:2022 02 18 -- Equal Percent Adjustments
Operating
Expenses
Capital
Outlays Debt Service Cost of Service
Non-Rate
Revenues
Revenue
Requirement
TOTAL Revenue Requirement
TY 2022 12,310,079$ 3,511,650$ 4,935,311$ 20,757,039$ 3,369,530$ 17,387,509$
FY 2023 12,796,184 1,670,650 5,380,668 19,847,502 3,396,614 16,450,888
FY 2024 13,420,608 3,250,650 4,279,034 20,950,293 3,415,149 17,535,144
FY 2025 13,265,139 3,250,650 4,026,510 20,542,299 3,427,650 17,114,650
FY 2026 13,733,851 3,250,650 4,027,705 21,012,205 3,440,150 17,572,056
FY 2027 14,097,050 3,250,650 3,878,868 21,226,568 3,452,650 17,773,918
FY 2028 14,527,577 3,250,650 2,234,774 20,013,001 3,465,151 16,547,850
FY 2029 14,973,661 3,250,650 1,951,588 20,175,900 3,477,651 16,698,249
FY 2030 15,435,727 3,250,650 1,224,556 19,910,933 3,490,151 16,420,782
FY 2031 15,919,371 3,250,650 1,113,865 20,283,887 3,502,652 16,781,235
CURRENT AND FORECAST NET REVENUE REQUIREMENT
$17,387,509
16,781,235
$15,500,000
$16,000,000
$16,500,000
$17,000,000
$17,500,000
$18,000,000
TY 2022 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 FY 2031
Town of Oro Valley
WATER Revenue Requirement
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 29
Water Utility Cost Functionalization
Once the total water system costs have been identified, the next step in the rate development process is to
isolate the costs associated with each system function. Some of these expenditures are a function of base
water demand; others are based on the peak demands placed on the system. Certain costs are associated
with serving customers regardless of the volume of water use. The basic steps used to allocate the Town’s
water revenue requirements include the following:
1. Each system’s costs (revenue requirements) are categorized by utility function (i.e., treatment,
distribution, administrative, customer). This process is known as functionalization.
2. Functionalized costs are classified based on the service characteristics or the types of demand
served by the utility (base and maximum day). This process is known as classification.
3. Costs by service characteristic are allocated to customer classes in proportion to the service
demands demonstrated by each class.
The approaches described in this section follow standard industry practices. Water system costs are allocated
to the following functions:
Production – the process by which water is produced.
Distribution – the lines that carry water to individual customers’ properties.
Administration – miscellaneous overhead and other non-operating costs.
Customer Billing – the processes involved in billing and providing other services to customers.
The project team allocated operating budget line-item expenses individually to system functions based on
general guidelines, specific research, and input from the Town of Oro Valley staff. The results of the allocation
process for the test year are summarized in Table III-10. The revenue requirement includes costs allocated
to reclaimed water. Reclaimed water rates was not part of this rate study, however, it was necessary to
include the reclaimed water costs to confirm all water utility costs are allocated equitably.
TABLE III-10
TOWN OF ORO VALLEY AZ
SCENARIO:2022 02 18 -- Equal Percent Adjustments
Revenue
Function Requirement Percent
Production 6,894,057$ 39.6%
Distribution 5,797,116 33.3%
Administration 2,865,886 16.5%
Customer 819,677 4.7%
Reclaimed Water 1,010,774 5.8%
Total 17,387,509 100.0%
TEST YEAR WATER COST FUNCTIONALIZATION
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 30
Water Utility Cost Classification
The allocation of functionalized water system costs to service characteristics follows the base-extra capacity
cost allocation method recommended by AWWA. Using this method, costs are segregated into the following
categories:
Base costs – capital costs and O&M expenses associated with service to customers under average
demand conditions. This category does not include any costs attributable to variations in water use
resulting from peaks in demand. Base costs tend to vary directly with the total quantity of water used.
Maximum Day/Extra Capacity costs – costs attributable to facilities that are designed to meet peaking
requirements. These costs include capital and operating charges for additional plant and system capacity
beyond that required for average usage.
Customer Billing costs – costs associated with any aspect of customer service, including billing,
accounting, and meter services. These costs are independent of the amount of water used and the size
of the customer’s meter and are not subject to peaking factors.
According to AWWA Manual M-1, in the base-extra capacity method, care must be taken in separating costs
between those devoted to base capacity and those devoted to extra capacity. The peak to average factor is
calculated by dividing the volume on the peak day of the year by the average daily volume. Facilities designed
to meet maximum-day requirements, such as the treatment and distribution functions, are allocated 67%
(1/1.50) to base, and 33% to extra capacity (Max Day). This means that facilities designed to meet maximum-
day requirements, such as the treatment and distribution functions, are allocated 67% to base, and 33% to
extra capacity.
All customer service-related costs are allocated 100% to customer billing. Administration costs are generally
not directly assignable to individual classifications. Therefore, it is standard rate-making practice to allocate
these costs on an indirect basis to service characteristics.
The system-wide costs by service characteristic are shown in Table III-11. As with cost functionalization,
these percentages are not expected to change significantly in the forecast period.
TABLE III-11
TOWN OF ORO VALLEY AZ
SCENARIO:2022 02 18 -- Equal Percent Adjustments
Revenue
Function Requirement Percent
Base 10,894,456$ 62.66%
Maximum Day 5,447,228 31.33%
Customer 1,045,825 6.01%
Total 17,387,509 100.0%
TEST YEAR WATER COST CLASSIFICATION
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 31
Water Utility Cost Allocation
Allocation of costs by service characteristic to customer classes is based on the proportionate use levels of
each characteristic by each class. The total water utility costs by customer class for the test year are
summarized in Table III-12 and for the ten-year forecast period in Table III-13.
TABLE III-12
TABLE III-13
TOWN OF ORO VALLEY AZ
SCENARIO: 2022 02 18 -- Equal Percent Adjustments
Revenue
Function Requirement Percent
Residential & Irrigation 5/8"10,151,012$ 58.4%
Residential & Irrigation 3/4"1,319,530 7.6%
Residential & Irrigation 1"1,100,798 6.3%
Residential & Irrigation 1.5"362,450 2.1%
Residential & Irrigation 2"802,695 4.6%
Residential & Irrigation 3"187,284 1.1%
Residential & Irrigation 4"441,466 2.5%
Commercial, Turf & Multifamily 1,658,752 9.5%
Construction 156,324 0.9%
Reclaimed Water 1,207,199 6.9%
Total 17,387,509 100.0%
TEST YEAR WATER COST ALLOCATION
TOWN OF ORO VALLEY AZ
SCENARIO:2022 02 18 -- Equal Percent Adjustments
Year
Residential &
Irrigation 5/8"
Residential &
Irrigation 3/4"
Residential &
Irrigation 1"
Residential &
Irrigation 2"
Commercial,
Turf &
Multifamily Construction
Reclaimed
Water Total
TY 2022 10,151,012$ 1,319,530$ 1,100,798$ 802,695$ 1,658,752$ 156,324$ 1,207,199$ 17,387,509$
FY 2023 9,539,029 1,239,984 1,034,423 754,228 1,548,459 144,931 1,258,515 16,450,888
FY 2024 10,189,062 1,324,497 1,104,914 805,541 1,637,883 153,321 1,325,293 17,535,144
FY 2025 9,944,803 1,292,756 1,078,430 786,178 1,588,260 148,684 1,304,843 17,114,650
FY 2026 10,208,845 1,327,091 1,107,067 807,000 1,619,935 151,656 1,354,086 17,572,056
FY 2027 10,319,665 1,341,508 1,119,088 815,709 1,627,049 152,329 1,391,472 17,773,918
FY 2028 9,525,763 1,238,314 1,032,999 752,908 1,492,338 139,723 1,436,269 16,547,850
FY 2029 9,597,860 1,247,696 1,040,821 758,559 1,494,144 139,899 1,482,783 16,698,249
FY 2030 9,398,816 1,221,831 1,019,239 742,783 1,453,984 136,144 1,531,002 16,420,782
FY 2031 9,600,872 1,248,107 1,041,154 758,705 1,475,989 138,210 1,581,585 16,781,235
FORECAST WATER COST ALLOCATION
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 32
SECTION IV
Water Rate Design
Rate design involves determining charges for
each class of customers that will generate a
desired level of revenue in accordance with
AWWA and other industry cost of service rate-
making principles. The water rates developed in
this section are designed to recover the test year
and forecast revenue requirements while
providing funding for the identified capital
improvements and existing debt service.
The following is notable regarding the rate plan
proposed in this study:
• Town staff, the Finance Subcommittee
and the Water Utility Commission evaluated
numerous alternative rate plans before ultimately recommending the rate plan presented in this
study. The general consensus was that this plan was the most fair, just and reasonable alternative
presented.
• While the rate model presents a forecast of rates for ten years, the project team recommends that
the Town adopt a rate plan for FY 2022/2023, with rates to be implemented on July 1, 2022.
• One of the most significant impacts on rates will be the cost of the Central Arizona Project water.
Should the Central Arizona Project make material changes to its rate forecasts, the Town should
undertake an immediate review of its rate plan.
• Another significant impact on rates will be debt issued to fund the CIP. If the Town issues additional
debt not currently anticipated, the Town should undertake an immediate review of its rate plan to
confirm the debt costs will be fully funded through rates.
• Uniform adjustments are applied to the existing base and volumetric rates for each rate class. There
is no change to the basic rate structure other than the uniform annual adjustments in the base case
rate plan. The rate plan and forecast revenues and expenses under this scenario is presented in
Appendix A.
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 33
Proposed Rate Plan
Table IV-1 presents a summary of the rate plan proposed for the majority of the Town’s Residential
customers. Table IV-2 presents a summary of the rate plan proposed for residential customers using 2, 3, or
4 inch meter sizes and Table IV-3 is the proposed rate plan for commercial, multifamily, turf, and reclaimed
water customers. These tables present the rate plan (“Alternative C”) recommended by the Water Utility
Commission out of three alternatives developed by the project team. Table IV-4 presents the customer rate
impact assuming the proposed rate structure is adopted by Town Council.
TABLE IV-1
TOWN OF ORO VALLEY AZ Proposed
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26
Residential & Irrigation 5/8"
Monthly Base Charge 5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$
Commodity Rate/1,000 Gal
Tier 1 1 7,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 7,001 16,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 16,001 32,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 32,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 3/4"
Monthly Base Charge 3/4"28.48$ 28.48$ 29.90$ 31.39$ 32.96$ 34.61$ 36.00$
Commodity Rate/1,000 Gal
Tier 1 1 10,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 10,001 24,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 24,001 48,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 48,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 1"
Monthly Base Charge 1"47.46$ 47.46$ 49.83$ 52.32$ 54.94$ 57.68$ 59.99$
Commodity Rate/1,000 Gal
Tier 1 1 17,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 17,001 40,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 40,001 80,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 80,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 1.5"
Monthly Base Charge 1.5"94.91$ 94.91$ 99.66$ 104.64$ 109.87$ 115.36$ 119.98$
Commodity Rate/1,000 Gal
Tier 1 1 35,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 35,001 80,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 80,001 160,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 160,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Forecast
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 34
TABLE IV-2
TOWN OF ORO VALLEY AZ
Proposed
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26
Residential & Irrigation 2"
Monthly Base Charge 2"151.87$ 151.87$ 159.46$ 167.44$ 175.81$ 184.60$ 191.98$
Commodity Rate/1,000 Gal
Tier 1 1 56,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 56,001 128,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 128,001 256,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 256,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 3"
Monthly Base Charge 3"303.71$ 303.71$ 318.90$ 334.84$ 351.58$ 369.16$ 383.93$
Commodity Rate/1,000 Gal
Tier 1 1 112,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 112,001 256,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 256,001 512,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 512,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Residential & Irrigation 4"
Monthly Base Charge 4"474.56$ 474.56$ 498.29$ 523.21$ 549.37$ 576.83$ 599.91$
Commodity Rate/1,000 Gal
Tier 1 1 175,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Tier 2 175,001 400,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23
Tier 3 400,001 800,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07
Tier 4 800,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47
Forecast
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 35
TABLE IV-3
TABLE IV-4
TOWN OF ORO VALLEY AZ
Proposed
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26
Commercial, Turf & Multifamily
Monthly Base Charge
5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93
4"474.56 474.56 498.29 523.21 549.37 576.83 599.91
6"949.12 949.12 996.58 1,046.41 1,098.73 1,153.67 1,199.81
8"1,518.60 1,518.60 1,594.53 1,674.25 1,757.97 1,845.86 1,919.70
Commodity Rate/1,000 Gal
1 Above 2.40 2.40 2.52 2.65 2.78 2.92 3.03
Construction Rate/1,000 Gal
1 Above 7.29 7.29 7.65 8.04 8.44 8.86 9.22
W9 Construction
Monthly Base Charge
5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93
4"474.56 474.56 498.29 523.21 549.37 576.83 599.91
6"949.12 949.12 996.58 1,046.41 1,098.73 1,153.67 1,199.81
8"1,518.60 1,518.60 1,594.53 1,674.25 1,757.97 1,845.86 1,919.70
Commodity Rate/1,000 Gal
1 Above 7.29 7.29 7.65 8.04 8.44 8.86 9.22
W10 Reclaimed Water
Monthly Base Charge
5/8"14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$
3/4"21.93 21.93 21.93 21.93 21.93 21.93 21.93
1"36.54 36.54 36.54 36.54 36.54 36.54 36.54
1 1/2"73.08 73.08 73.08 73.08 73.08 73.08 73.08
2"116.94 116.94 116.94 116.94 116.94 116.94 116.94
3"233.86 233.86 233.86 233.86 233.86 233.86 233.86
4"365.41 365.41 365.41 365.41 365.41 365.41 365.41
6"730.83 730.83 730.83 730.83 730.83 730.83 730.83
8"1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32
Commodity Rate/1,000 Gal
1,001 Above 2.25 2.25 2.25 2.25 2.25 2.25 2.25
Forecast
TOWN OF ORO VALLEY AZ
Proposed
Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26
Residential Monthly Charges - 5/8"
7,000 Water 35.79$ 35.79$ 37.58$ 39.46$ 41.43$ 43.50$ 45.24$
Increase -- $- 1.79 1.88 1.97 2.07 1.74
Increase -- %0.0%5.0%5.0%5.0%5.0%4.0%
10,000 Water 45.84 45.84 48.13 50.54 53.07 55.72 57.95
Increase -- $- 2.29 2.41 2.53 2.65 2.23
Increase -- %0.0%5.0%5.0%5.0%5.0%4.0%
Commercial Monthly Charge -- 2"
50,000 Water 271.87 271.87 285.46 299.74 314.72 330.46 343.68
Increase -- $- 13.59 14.27 14.99 15.74 13.22
Increase -- %0.0%5.0%5.0%5.0%5.0%4.0%
Forecast
Town of Oro Valley 2022 Water Rate Study – FINAL
Page: 36
The projected rate revenues developed are forecast to be sufficient to fund all operating and current
scheduled capital obligations in each of the next ten years (FY 2022 through FY 2031). Rate revenues are
sufficient to fund the water existing debt service and future debt service over the forecast period. Forecast
rate revenues by year are presented in Appendix A.
Notes on Rate Recommendations
The forecast and recommendations presented in this study represent a combination of the best information
available from the Town of Oro Valley and the project team’s expertise. However, this forecast relies in part
on assumptions about future events and events beyond the control of the project team (such as account
growth rates within the Town). The forecast and recommendations contained in this study may be subject to
revision if any of the following events occurs:
• Actual growth in accounts and consumed volumes is less than (or significantly greater than) forecast.
• Capital improvement plan funding costs increase significantly due to the rising cost of materials or
other factors such as NWRRDS costs.
• An unforeseen event impacts the Town, such as an extended recession, natural catastrophe, or
terrorist attack.
• Significant and long-lasting changes in weather patterns.
• Increases or decreases in interest rates, coverage requirements, or reserve requirements for long-
term debt.
• The Town of Oro Valley budget levels or priorities change significantly from those forecast in this
study.
It should be noted that none of these events are foreseen by the project team or the Town of Oro Valley at
this time.
If any of these events occur, the Town may be compelled to consider further adjustments to its water
rates.
Appendix A
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Main Dashboard
Future Debt Term
Alternative Proposed
2022 8,000,000$
2023 -$
2024 -$
2025 -$
2026 -$
2027 -$
2028 -$
2029 -$
2030 -$
2031 -$
Alternative Proposed
2022 -$
2023 -$
2024 -$
2025 -$
2026 -$
2027 -$
2028 -$
2029 -$
2030 -$
2031 -$
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Water Rate Adjustments
Meter Charge 0.00%5.00%5.00%5.00%5.00%4.00%0.00%2.00%0.00%2.00%
Volume Charge 0.00%5.00%5.00%5.00%5.00%4.00%0.00%2.00%0.00%2.00%
Water Future Bond Issues
Sewer Future Bond Issues
Utility System
Dashboard
Customer Class
`
$-
$5.00
$10.00
$15.00
$20.00
$25.00
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031MillionsTotal Revenues
$-
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031MillionsDebt Service
Current Future $(3.00)
$(2.00)
$(1.00)
$-
$1.00
$2.00
$3.00
$4.00
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031MillionsNet Revenues Available for Contingency
-
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Debt Coverage (Excise Tax Debt = 1.0x)
Required Debt Coverage
Water Projections
Town of Oro Valley
Ten Year Rate Analysis and Pro Forma
Fiscal Years
Years
2022 -2031
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version City Rate Plan
Effective Effective Effective Effective Effective Effective Effective Effective Effective Effective
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26 Jul-27 Jul-28 Jul-29 Jul-30
Water Summary `
Scen:2022 02 18 -- Equal Percent Adjustments
1 Water Monthly Rates and Charges
CITY Water Rate and Charges
W1 Residential & Irrigation 5/8"
Monthly Minimum Charge
3/4"18.99 18.99 19.94 20.94 21.98 23.08 24.01 24.01 24.49 24.49 24.98
Volume Rate/1,000 Gal
1 7,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16
7,001 16,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23 4.23 4.32 4.32 4.41
16,001 32,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07 6.07 6.19 6.19 6.31
32,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
W2 Residential & Irrigation 3/4"
Monthly Minimum Charge
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00 36.00 36.72 36.72 37.45
Volume Rate/1,000 Gal
1 10,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16
10,001 24,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23 4.23 4.32 4.32 4.41
24,001 48,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07 6.07 6.19 6.19 6.31
48,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission Page: 2
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version City Rate Plan
Effective Effective Effective Effective Effective Effective Effective Effective Effective Effective
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26 Jul-27 Jul-28 Jul-29 Jul-30
Water Summary `
Scen:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
W3 Residential & Irrigation 1"
Monthly Minimum Charge
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99 59.99 61.19 61.19 62.41
Volume Rate/1,000 Gal
1 17,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16
17,001 40,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23 4.23 4.32 4.32 4.41
40,001 80,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07 6.07 6.19 6.19 6.31
80,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
W4 Residential & Irrigation 1.5"
Monthly Minimum Charge
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98 119.98 122.38 122.38 124.83
Volume Rate/1,000 Gal
1 35,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16
35,001 80,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23 4.23 4.32 4.32 4.41
80,001 160,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07 6.07 6.19 6.19 6.31
160,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
W5 Residential & Irrigation 2"
Monthly Minimum Charge
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98 191.98 195.82 195.82 199.74
Volume Rate/1,000 Gal
1 56,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16
56,001 128,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23 4.23 4.32 4.32 4.41
128,001 256,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07 6.07 6.19 6.19 6.31
256,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission Page: 3
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version City Rate Plan
Effective Effective Effective Effective Effective Effective Effective Effective Effective Effective
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26 Jul-27 Jul-28 Jul-29 Jul-30
Water Summary `
Scen:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
W6 Residential & Irrigation 3"
Monthly Minimum Charge
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93 383.93 391.61 391.61 399.44
Volume Rate/1,000 Gal
1 112,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16
112,001 256,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23 4.23 4.32 4.32 4.41
256,001 512,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07 6.07 6.19 6.19 6.31
512,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
W7 Residential & Irrigation 4"
Monthly Minimum Charge
4"474.56 474.56 498.29 523.21 549.37 576.83 599.91 599.91 611.91 611.91 624.14
Volume Rate/1,000 Gal
1 175,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16 175,001 400,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23 4.23 4.32 4.32 4.41
400,001 800,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07 6.07 6.19 6.19 6.31
800,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
W8 Commercial, Turf & Multifamily
Monthly Minimum Charge
5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$ 24.01$ 24.49$ 24.49$ 24.98$
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00 36.00 36.72 36.72 37.45
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99 59.99 61.19 61.19 62.41
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98 119.98 122.38 122.38 124.83
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98 191.98 195.82 195.82 199.74
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93 383.93 391.61 391.61 399.44
4"474.56 474.56 498.29 523.21 549.37 576.83 599.91 599.91 611.91 611.91 624.14
6"949.12 949.12 996.58 1,046.41 1,098.73 1,153.67 1,199.81 1,199.81 1,223.81 1,223.81 1,248.29
8"1,518.60 1,518.60 1,594.53 1,674.25 1,757.97 1,845.86 1,919.70 1,919.70 1,958.09 1,958.09 1,997.26
Volume Rate/1,000 Gal
1 Above 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission Page: 4
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version City Rate Plan
Effective Effective Effective Effective Effective Effective Effective Effective Effective Effective
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26 Jul-27 Jul-28 Jul-29 Jul-30
Water Summary `
Scen:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
W9 Construction
Monthly Minimum Charge
5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$ 24.01$ 24.49$ 24.49$ 24.98$
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00 36.00 36.72 36.72 37.45
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99 59.99 61.19 61.19 62.41
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98 119.98 122.38 122.38 124.83
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98 191.98 195.82 195.82 199.74
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93 383.93 391.61 391.61 399.44
4"474.56 474.56 498.29 523.21 549.37 576.83 599.91 599.91 611.91 611.91 624.14
6"949.12 949.12 996.58 1,046.41 1,098.73 1,153.67 1,199.81 1,199.81 1,223.81 1,223.81 1,248.29
8"1,518.60 1,518.60 1,594.53 1,674.25 1,757.97 1,845.86 1,919.70 1,919.70 1,958.09 1,958.09 1,997.26
Volume Rate/1,000 Gal
1 Above 7.29 7.29 7.65 8.04 8.44 8.86 9.22 9.22 9.40 9.40 9.59
W10 Reclaimed Water
Monthly Minimum Charge
5/8"14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$ 14.62$
3/4"21.93 21.93 21.93 21.93 21.93 21.93 21.93 21.93 21.93 21.93 21.93
1"36.54 36.54 36.54 36.54 36.54 36.54 36.54 36.54 36.54 36.54 36.54
1 1/2"73.08 73.08 73.08 73.08 73.08 73.08 73.08 73.08 73.08 73.08 73.08
2"116.94 116.94 116.94 116.94 116.94 116.94 116.94 116.94 116.94 116.94 116.94
3"233.86 233.86 233.86 233.86 233.86 233.86 233.86 233.86 233.86 233.86 233.86
4"365.41 365.41 365.41 365.41 365.41 365.41 365.41 365.41 365.41 365.41 365.41
6"730.83 730.83 730.83 730.83 730.83 730.83 730.83 730.83 730.83 730.83 730.83
8"1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32 1,169.32
Volume Rate/1,000 Gal
1,001 Above 2.25 2.25 2.25 2.25 2.25 2.25 2.25 2.25 2.25 2.25 2.25
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission Page: 5
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version City Rate Plan
Effective Effective Effective Effective Effective Effective Effective Effective Effective Effective
Current Jul-21 Jul-22 Jul-23 Jul-24 Jul-25 Jul-26 Jul-27 Jul-28 Jul-29 Jul-30
Water Summary `
Scen:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
3 Residential Monthly Charges -- 5/8" Meter
7,000 Gallons
City
Total 35.79$ 35.79$ 37.58$ 39.46$ 41.43$ 43.50$ 45.24$ 45.24$ 46.15$ 46.15$ 47.07$
Dollar Inc - 1.79 1.88 1.97 2.07 1.74 - 0.90 - 0.92
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
10,000 Gallons
City
Total 45.84 45.84 48.13 50.54 53.07 55.72 57.95 57.95 59.11 59.11 60.29
Dollar Inc - 2.29 2.41 2.53 2.65 2.23 - 1.16 - 1.18
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
20,000 Gallons
City
Total 85.14 85.14 89.40 93.87 98.56 103.49 107.63 107.63 109.78 109.78 111.98
Dollar Inc - 4.26 4.47 4.69 4.93 4.14 - 2.15 - 2.20
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
30,000 Gallons
City
Total 133.14 133.14 139.80 146.79 154.13 161.83 168.31 168.31 171.67 171.67 175.11
Dollar Inc - 6.66 6.99 7.34 7.71 6.47 - 3.37 - 3.43
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
4 Commercial Monthly Charges -- WATER
20,000 Gallons
City -- 2" Meter
Total 199.87 199.87 209.86 220.36 231.38 242.94 252.66 252.66 257.72 257.72 262.87
Dollar Inc - 9.99 10.49 11.02 11.57 9.72 - 5.05 - 5.15
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
50,000 Gallons
City -- 2" Meter
Total 271.87 271.87 285.46 299.74 314.72 330.46 343.68 343.68 350.55 350.55 357.56
Dollar Inc - 13.59 14.27 14.99 15.74 13.22 - 6.87 - 7.01
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission Page: 10
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Revenue Expense Summary
Current
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast Summary
Scenario:2022 02 18 -- Equal Percent Adjustments
3 Fund Balance, Revenues and Expenses
Beginning of TY Operating Fund Balance 9,639,036$
Beginning of TY GPF Fund Balance 3,587,830$
Revised Beginning Combined Fund Balance 13,226,866$ 10,572,626$ 9,643,527$ 8,471,244$ 8,565,085$ 9,094,337$ 10,209,788$ 12,715,032$ 15,502,798$ 18,707,290$
Revenues and Expenses
Water Rate Revenues (Includes Reclaimed Water Revenue)14,733,270 15,521,789 16,362,860 17,208,491 18,101,308 18,889,369 19,053,093 19,486,015 19,625,273 20,070,875
Ground Protection Fees 2,394,530 2,421,614 2,440,149 2,452,650 2,465,150 2,477,650 2,490,151 2,502,651 2,515,151 2,527,652
Non-Rate Revenues 975,000 975,000 975,000 975,000 975,000 975,000 975,000 975,000 975,000 975,000
Total Revenues 18,102,800 18,918,403 19,778,009 20,636,141 21,541,457 22,342,019 22,518,244 22,963,666 23,115,425 23,573,527
Operating Expenses
P Personnel 3,662,217 3,726,253 3,791,571 3,858,194 3,926,150 3,995,464 4,066,166 4,138,281 4,211,838 4,286,867
CAP Central Arizona Project 4,062,888 4,354,865 4,619,187 4,097,405 4,193,347 4,317,860 4,501,943 4,693,510 4,892,653 5,104,623
O&M Operations & Maintenance 2,580,788 2,641,478 2,703,964 2,768,320 2,834,625 2,902,961 2,973,414 3,046,077 3,121,045 3,198,423
A Administrative Expense 205,116 209,218 213,403 217,671 222,024 226,465 230,994 235,614 240,326 245,133
U Utilities 850,000 892,500 937,125 983,981 1,033,180 1,084,839 1,139,081 1,196,035 1,255,837 1,318,629
REC Reclaimed Water 949,070 971,870 995,360 1,019,568 1,044,524 1,070,261 1,096,811 1,124,210 1,152,494 1,181,703
NWWRRDS Northwest Recharge, Recovery & Delivery System 0 0 160,000 320,000 480,000 499,200 519,168 539,935 561,532 583,994
0 Total 12,310,079 12,796,184 13,420,608 13,265,139 13,733,851 14,097,050 14,527,577 14,973,661 15,435,727 15,919,371
Net Revenues for Transfers,Capital Outlays and Debt Service 5,792,721 6,122,219 6,357,401 7,371,002 7,807,606 8,244,969 7,990,667 7,990,005 7,679,698 7,654,155
Capital Outlays 3,511,650 1,670,650 3,250,650 3,250,650 3,250,650 3,250,650 3,250,650 3,250,650 3,250,650 3,250,650
Net Revenues Available for Debt Service 2,281,071 4,451,569 3,106,751 4,120,352 4,556,956 4,994,319 4,740,017 4,739,355 4,429,048 4,403,505
Current Debt Service 4,935,311 4,780,241 3,678,607 3,426,083 3,427,277 3,278,441 1,634,346 1,351,161 624,129 513,438
Future Debt Service - 600,427 600,427 600,427 600,427 600,427 600,427 600,427 600,427 600,427
Total Debt Service 4,935,311 5,380,668 4,279,034 4,026,510 4,027,705 3,878,868 2,234,774 1,951,588 1,224,556 1,113,865
Net Revenues for Contingencies and Transfers (2,654,240) (929,099) (1,172,283) 93,841 529,252 1,115,451 2,505,243 2,787,766 3,204,492 3,289,640
Contingency/Reserve - - - - - - - - - -
Other Miscelaneous Transfers - - - - - - - - - -
Total Contingencies & Transfers - - - - - - - - - -
Total Cost of Service 20,757,039 19,847,502 20,950,293 20,542,299 21,012,205 21,226,568 20,013,001 20,175,900 19,910,933 20,283,887
Net Revenues (2,654,240) (929,099) (1,172,283) 93,841 529,252 1,115,451 2,505,243 2,787,766 3,204,492 3,289,640
Percent of COS -12.8%-4.7%-5.6%0.5%2.5%5.3%12.5%13.8%16.1%16.2%
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 12
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Revenue Expense Summary
Current
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast Summary
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Ending Water Combined Fund Balance 10,572,626$ 9,643,527$ 8,471,244$ 8,565,085$ 9,094,337$ 10,209,788$ 12,715,032$ 15,502,798$ 18,707,290$ 21,996,930$
Ending Operating Fund Balance 8,041,966$ 6,426,377$ 5,483,871$ 4,099,453$ 3,125,164$ 2,721,906$ 3,699,812$ 4,776,422$ 6,043,208$ 7,320,199$
Ending GPF Fund Balance 2,530,660$ 3,217,149$ 2,987,372$ 4,465,632$ 5,969,173$ 7,487,883$ 9,015,220$ 10,726,376$ 12,664,082$ 14,676,731$
Revenue Adequacy Tests
Total Exp (Budgetary Basis)20,757,039 19,847,502 20,950,293 20,542,299 21,012,205 21,226,568 20,013,001 20,175,900 19,910,933 20,283,887
Expenses per Day 56,869 54,377 57,398 56,280 57,568 58,155 54,830 55,276 54,551 55,572
Working Capital as % of Tot Exp.51%49%40%42%43%48%64%77%94%108%
Number of Working Capital Days 186 177 148 152 158 176 232 280 343 396
All In Debt Coverage (include Excise Tax Debt)1.17 1.14 1.49 1.83 1.94 2.13 3.58 4.09 6.27 6.87
Goal is 1.30 (excludes Capital Outlays and Transfers)
Debt Coverage Less Excise Tax Debt (Excise Tax debt = 1.0x Coverage)1.27 1.21 1.84 2.50 2.69 2.95 3.58 4.09 6.27 6.87
Goal is 1.30 (excludes Capital Outlays and Transfers)
Fund Balance Reserve Requirement
Minimum Requirement (20% O&M plus Debt Service)987,062$ 1,076,134$ 855,807$ 805,302$ 805,541$ 775,774$ 446,955$ 390,318$ 244,911$ 222,773$
Fund Ratio to Requirement (1.0 Meets Requirement)10.71 8.96 9.90 10.64 11.29 13.16 28.45 39.72 76.38 98.74
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 13
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Water Summary
Current 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Water Summary
Scen:2022 02 18 -- Equal Percent Adjustments
1 Water Monthly Rates and Charges
Residential and Irrigation
Monthly Minimum Charge
5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$ 24.01$ 24.49$ 24.49$ 24.98$
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00 36.00 36.72 36.72 37.45
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99 59.99 61.19 61.19 62.41
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98 119.98 122.38 122.38 124.83
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98 191.98 195.82 195.82 199.74
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93 383.93 391.61 391.61 399.44
Volume Rate/1,000 Gal
1 7,000 2.40 2.40 2.52 2.65 2.78 2.92 3.03 3.03 3.09 3.09 3.16
7,001 16,000 3.35 3.35 3.52 3.69 3.88 4.07 4.23 4.23 4.32 4.32 4.41
16,001 32,000 4.80 4.80 5.04 5.29 5.56 5.83 6.07 6.07 6.19 6.19 6.31
32,001 Above 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
- - 6.70 6.70 7.04 7.39 7.76 8.14 8.47 8.47 8.64 8.64 8.81
Commercial
Monthly Minimum Charge
5/8"18.99$ 18.99$ 19.94$ 20.94$ 21.98$ 23.08$ 24.01$ 24.01$ 24.49$ 24.49$ 24.98$
3/4"28.48 28.48 29.90 31.39 32.96 34.61 36.00 36.00 36.72 36.72 37.45
1"47.46 47.46 49.83 52.32 54.94 57.68 59.99 59.99 61.19 61.19 62.41
1 1/2"94.91 94.91 99.66 104.64 109.87 115.36 119.98 119.98 122.38 122.38 124.83
2"151.87 151.87 159.46 167.44 175.81 184.60 191.98 191.98 195.82 195.82 199.74
3"303.71 303.71 318.90 334.84 351.58 369.16 383.93 383.93 391.61 391.61 399.44
4"474.56 474.56 498.29 523.21 549.37 576.83 599.91 599.91 611.91 611.91 624.14
6"949.12 949.12 996.58 1,046.41 1,098.73 1,153.67 1,199.81 1,199.81 1,223.81 1,223.81 1,248.29
Volume Rate Per 1,000 Gal - Commercial
Volume Charge 2.40$ 2.40$ 2.52$ 2.65$ 2.78$ 2.92$ 3.03$ 3.03$ 3.09$ 3.09$ 3.16$
2.1 Residential Monthly Bill -- 5/8"
5,000 Gallons Total 30.99$ 30.99$ 32.54$ 34.17$ 35.88$ 37.67$ 39.18$ 39.18$ 39.96$ 39.96$ 40.76$
Dollar Inc - 1.55 1.63 1.71 1.79 1.51 - 0.78 - 0.80
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
10,000 Gallons Total 45.84 45.84 48.13 50.54 53.07 55.72 57.95 57.95 59.11 59.11 60.29
Dollar Inc - 2.29 2.41 2.53 2.65 2.23 - 1.16 - 1.18
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
20,000 Gallons Total 85.14 85.14 89.40 93.87 98.56 103.49 107.63 107.63 109.78 109.78 111.98
Dollar Inc - 4.26 4.47 4.69 4.93 4.14 - 2.15 - 2.20
Percent Inc 0.0%5.0%5.0%5.0%5.0%4.0%0.0%2.0%0.0%2.0%
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
14
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Water Summary
Current 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Water Summary
Scen:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
2.2 Commercial Monthly Bill --
20,000 Gallons
3/4"66.99$ 66.99$ 70.34$ 73.86$ 77.55$ 81.43$ 84.68$ 84.68$ 86.38$ 86.38$ 88.11$
1"76.48 76.48 80.30 84.31 88.53 92.96 96.67 96.67 98.61 98.61 100.58
1 1/2"95.46 95.46 100.23 105.24 110.50 116.03 120.67 120.67 123.08 123.08 125.54
2"142.91 142.91 150.06 157.56 165.44 173.71 180.66 180.66 184.27 184.27 187.96
3"199.87 199.87 209.86 220.36 231.38 242.94 252.66 252.66 257.72 257.72 262.87
4"351.71 351.71 369.30 387.76 407.15 427.51 444.61 444.61 453.50 453.50 462.57
6"522.56 522.56 548.69 576.13 604.93 635.18 660.58 660.58 673.80 673.80 687.27
8"997.12 997.12 1,046.98 1,099.33 1,154.30 1,212.01 1,260.49 1,260.49 1,285.70 1,285.70 1,311.42
50,000 Gallons
3/4"138.99$ 138.99$ 145.94$ 153.24$ 160.90$ 168.94$ 175.70$ 175.70$ 179.22$ 179.22$ 182.80$
1"148.48 148.48 155.90 163.69 171.88 180.47 187.69 187.69 191.45 191.45 195.27
1 1/2"167.46 167.46 175.83 184.62 193.85 203.54 211.68 211.68 215.92 215.92 220.24
2"214.91 214.91 225.66 236.94 248.79 261.22 271.67 271.67 277.11 277.11 282.65
3"271.87 271.87 285.46 299.74 314.72 330.46 343.68 343.68 350.55 350.55 357.56
4"423.71 423.71 444.90 467.14 490.50 515.02 535.62 535.62 546.34 546.34 557.26
6"594.56 594.56 624.29 655.51 688.28 722.69 751.60 751.60 766.63 766.63 781.97
8"1,069.12 1,069.12 1,122.58 1,178.71 1,237.65 1,299.53 1,351.51 1,351.51 1,378.54 1,378.54 1,406.11
3 Total Accounts
Total Accounts 21,331 21,625 21,844 21,993 22,142 22,291 22,440 22,589 22,738 22,887
New Accounts 294 219 149 149 149 149 149 149 149
Avg. Annual Growth Rate 1.38%1.01%0.68%0.68%0.67%0.67%0.66%0.66%0.66%
15
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Water Summary
Current 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Water Summary
Scen:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
4 Annual Water Consumption
W.1 Residential & Irrigation 5/8"1,444,476,233 1,464,689,421 1,479,675,060 1,489,781,654 1,499,888,248 1,509,994,842 1,520,101,436 1,530,208,030 1,540,314,624 1,550,421,218
W.2 Residential & Irrigation 3/4"188,922,762 191,566,441 193,526,410 194,848,249 196,170,089 197,491,928 198,813,767 200,135,607 201,457,446 202,779,286
W.3 Residential & Irrigation 1"152,687,088 154,823,705 156,407,749 157,476,057 158,544,366 159,612,675 160,680,983 161,749,292 162,817,600 163,885,909
W.4 Residential & Irrigation 1.5"38,938,765 39,483,652 39,887,620 40,160,064 40,432,507 40,704,951 40,977,395 41,249,838 41,522,282 41,794,725
W.5 Residential & Irrigation 2"93,165,025 94,468,724 95,435,259 96,087,109 96,738,958 97,390,808 98,042,657 98,694,507 99,346,356 99,998,206
W.6 Residential & Irrigation 3"16,881,063 17,117,287 17,292,418 17,410,530 17,528,642 17,646,754 17,764,867 17,882,979 18,001,091 18,119,203
W.7 Residential & Irrigation 4"50,041,170 50,741,418 51,260,567 51,610,691 51,960,815 52,310,939 52,661,063 53,011,187 53,361,311 53,711,435
W.8 Commercial, Turf & Multifamily 327,014,495 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642
W.9 Construction 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280
Sub-Total 2,350,463,880 2,380,557,569 2,401,152,005 2,415,041,276 2,428,930,547 2,442,819,819 2,456,709,090 2,470,598,361 2,484,487,632 2,498,376,903
W.10 Reclaimed Water 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096
Total System 2,944,319,976 2,974,413,665 2,995,008,101 3,008,897,372 3,022,786,643 3,036,675,915 3,050,565,186 3,064,454,457 3,078,343,728 3,092,232,999
5 Revenues and Expenses -- CASH BASIS
Water Revenues
Water Rate Revenue
W.1 Residential & Irrigation 5/8"8,514,696$ 9,029,564$ 9,578,045$ 10,125,639$ 10,704,048$ 11,215,808$ 11,327,182$ 11,611,538$ 11,707,358$ 12,000,218$
W.2 Residential & Irrigation 3/4"1,175,712 1,246,805 1,322,540 1,398,152 1,478,018 1,548,682 1,564,061 1,603,325 1,616,556 1,656,994
W.3 Residential & Irrigation 1"826,340 876,307 929,537 982,680 1,038,814 1,088,480 1,099,288 1,126,885 1,136,184 1,164,606
W.4 Residential & Irrigation 1.5"185,451 196,665 208,611 220,538 233,135 244,282 246,707 252,901 254,988 261,366
W.5 Residential & Irrigation 2"432,142 458,273 486,110 513,902 543,257 569,230 574,883 589,315 594,178 609,041
W.6 Residential & Irrigation 3"66,448 70,466 74,746 79,019 83,533 87,527 88,396 90,615 91,363 93,648
W.7 Residential & Irrigation 4"166,795 176,881 187,625 198,352 209,682 219,707 221,889 227,459 229,336 235,073
W.8 Commercial, Turf & Multifamily 1,565,097 1,648,419 1,736,906 1,830,121 1,928,315 2,013,944 2,027,403 2,071,683 2,082,196 2,127,623
W.9 Construction 388,815 406,635 426,967 448,316 470,731 489,936 491,511 500,522 501,341 510,533
W.10 Reclaimed Water FY22 Budget 1,411,773 1,411,773 1,411,773 1,411,773 1,411,773 1,411,773 1,411,773 1,411,773 1,411,773 1,411,773
13,974,000$ 14,733,270 15,521,789 16,362,860 17,208,491 18,101,308 18,889,369 19,053,093 19,486,015 19,625,273 20,070,875
Ground Protection Fees 2,380,000$ 2,394,530 2,421,614 2,440,149 2,452,650 2,465,150 2,477,650 2,490,151 2,502,651 2,515,151 2,527,652
Non-Rate Revenues 975,000 975,000 975,000 975,000 975,000 975,000 975,000 975,000 975,000 975,000
Total Non-Rate Revenues 3,369,530 3,396,614 3,415,149 3,427,650 3,440,150 3,452,650 3,465,151 3,477,651 3,490,151 3,502,652
Total Revenues 18,102,800 18,918,403 19,778,009 20,636,141 21,541,457 22,342,019 22,518,244 22,963,666 23,115,425 23,573,527
16
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Water Summary
Current 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Water Summary
Scen:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Water Cost of Service
Budget Code
P Personnel 3,662,217$ 3,726,253$ 3,791,571$ 3,858,194$ 3,926,150$ 3,995,464$ 4,066,166$ 4,138,281$ 4,211,838$ 4,286,867$
CAP Central Arizona Project 4,062,888 4,354,865 4,619,187 4,097,405 4,193,347 4,317,860 4,501,943 4,693,510 4,892,653 5,104,623
O&M Operations & Maintenance 2,580,788 2,641,478 2,703,964 2,768,320 2,834,625 2,902,961 2,973,414 3,046,077 3,121,045 3,198,423
A Administrative Expense 205,116 209,218 213,403 217,671 222,024 226,465 230,994 235,614 240,326 245,133
U Utilities 850,000 892,500 937,125 983,981 1,033,180 1,084,839 1,139,081 1,196,035 1,255,837 1,318,629
REC Reclaimed Water 949,070 971,870 995,360 1,019,568 1,044,524 1,070,261 1,096,811 1,124,210 1,152,494 1,181,703
NWWRRDSNorthwest Recharge, Recovery & Delivery System 0 0 160,000 320,000 480,000 499,200 519,168 539,935 561,532 583,994
Total 12,310,079 12,796,184 13,420,608 13,265,139 13,733,851 14,097,050 14,527,577 14,973,661 15,435,727 15,919,371
Department Code
W Water Department 7,298,121$ 7,469,450$ 7,646,062$ 7,828,166$ 8,015,979$ 8,209,729$ 8,409,655$ 8,616,006$ 8,829,047$ 9,049,052$
REC Reclaimed Water 949,070 971,870 995,360 1,019,568 1,044,524 1,070,261 1,096,811 1,124,210 1,152,494 1,181,703
CAP Central Arizona Project 4,062,888 4,354,865 4,619,187 4,097,405 4,193,347 4,317,860 4,501,943 4,693,510 4,892,653 5,104,623
NWWRRDSNorthwest Recharge, Recovery & Delivery System 0 0 160,000 320,000 480,000 499,200 519,168 539,935 561,532 583,994
Total 12,310,079 12,796,184 13,420,608 13,265,139 13,733,851 14,097,050 14,527,577 14,973,661 15,435,727 15,919,371
Total Operating Expenses 12,310,079 12,796,184 13,420,608 13,265,139 13,733,851 14,097,050 14,527,577 14,973,661 15,435,727 15,919,371
Net Revenues for Transfers,Capital Outlays and Debt Service 5,792,721 6,122,219 6,357,401 7,371,002 7,807,606 8,244,969 7,990,667 7,990,005 7,679,698 7,654,155
Capital Outlays 3,511,650 1,670,650 3,250,650 3,250,650 3,250,650 3,250,650 3,250,650 3,250,650 3,250,650 3,250,650
Debt Service
Debt Service -- Current 4,935,311 4,780,241 3,678,607 3,426,083 3,427,277 3,278,441 1,634,346 1,351,161 624,129 513,438
Debt Service -- Future - 600,427 600,427 600,427 600,427 600,427 600,427 600,427 600,427 600,427
Total Debt Service 4,935,311 5,380,668 4,279,034 4,026,510 4,027,705 3,878,868 2,234,774 1,951,588 1,224,556 1,113,865
Net Revenues for Contingencies & Transfers (2,654,240) (929,099) (1,172,283) 93,841 529,252 1,115,451 2,505,243 2,787,766 3,204,492 3,289,640
Contingencies & Transfers
Total Contingencies & Transfers - - - - - - - - - -
Total Cost of Service 20,757,039 19,847,502 20,950,293 20,542,299 21,012,205 21,226,568 20,013,001 20,175,900 19,910,933 20,283,887
Net Revenues (2,654,240) (929,099) (1,172,283) 93,841 529,252 1,115,451 2,505,243 2,787,766 3,204,492 3,289,640
Percent of COS -14.7%-4.9%-5.9%0.5%2.5%5.0%11.1%12.1%13.9%14.0%
All In Debt Coverage (include Excise Tax Debt)1.17 1.14 1.49 1.83 1.94 2.13 3.58 4.09 6.27 6.87
Goal is 1.30 (excludes Capital Outlays and Transfers)
Debt Coverage Less Excise Tax Debt (Excise Tax debt = 1.0x Coverage)1.27 1.21 1.84 2.50 2.69 2.95 3.58 4.09 6.27 6.87
17
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
NON-RATE REVENUES
0 0 0 6000000 WTR-CHARGES FOR SERVICES -$ na na na na na
NR 0 CS 3057 ENGINEER PLAN REV 5,000 na na na na na
NR 0 CS 3058 CONSTRUCT INSPECT 20,000 na na na na na
NR 0 CS 3070 MISC SERVICE REVE 25,000 na na na na na
NR 0 CS 3071 BACKFLOW-INSTALL 4,000 na na na na na
NR 0 MII 3074 SEWER FEES 380,000 na na na na na
NR 0 PI 3075 LATE FEES 90,000 na na na na na
NR 0 PI 3076 NSF FEES 2,000 na na na na na
NR 0 CS 3086 METER INCOME 99,000 na na na na naNR0CS3087NEW SERV ESTABLIS 100,000 na na na na na
NR 0 PI 3088 RECONNECT FEES 32,000 na na na na na
NR 0 MII 3089 RECHARGE-KAI FARM 48,000 na na na na na
NR 0 MII 3094 GROUNDWATER PRESE 2,394,530 na na na na na
NR 0 MII 3098 STORMWATER FEES 70,000 na na na na na
NR 0 II 3099 INTEREST-INVESTME 100,000 na na na na na
0 0 0 3063 RESIDENTIAL WATER - na na na na na
0 0 0 3064 COMMERICAL WATER - na na na na na
0 0 0 3065 IRRIGATION WATER - na na na na na
0 0 0 3066 IRRIGATION-RECLAI - na na na na na
0 0 0 3067 TURF RELATED WATE - na na na na na
0 0 0 3068 TURF-RECLAIMED - na na na na na
0 0 0 3069 CONSTRUCTION WATE - na na na na na
0 0 0 3079 RECLAIMED CONSTRU - na na na na na
0 0 0 0 0 - na na na na na
0 0 0 0 0 - na na na na na
0 0 0 0 0 - na na na na na
0 0 0 0 0 - na na na na na
0 0 0 0 Last - na na na na na
Total Non-Rate Revenues 3,369,530$
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 18
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
OPERATING EXPENSES
Department Code1 Budget Code 2 Expense Net Budget 3 Supply/Treatment Distribution Admin Customer Billing Irrigation 4
0 0 0 6088000 WTR-ADMIN-PERSONNEL - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 305,501 - - 280,198 - 25,303
W 0 P 5006 GROUP INSURANCE 36,139 - - 33,146 - 2,993
W 0 P 5007 SOCIAL SECURITY/M 22,883 - - 20,988 - 1,895
W 0 P 5009 ASRS CONTRIBUTION 37,913 - - 34,773 - 3,140
W 0 P 5011 WORKERS' COMPENSA 588 - - 539 - 49
W 0 P 5012 OTHER EMPLOYEE BE 1,454 - - 1,334 - 120 0 0 0 0 0 - - - - - -
0 0 0 6088010 WTR-ADMIN-O&M - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 94,839 - - 94,839 - -
W 0 O&M 6014 WATER & SEWAGE 436 - - 436 - -
W 0 O&M 6018 VEHICLE REPAIR &36,688 - - 36,688 - -
W 0 O&M 6019 EQUIPMENT REPAIR 5,279 - - 5,279 - -
W 0 O&M 6026 INSURANCE 80,222 - - 80,222 - -
W 0 O&M 6031 PRINTING & BINDING 500 - - 500 - -
W 0 O&M 6034 TRAVEL & TRAINING 4,500 - - 4,500 - -
W 0 O&M 6035 MEMBERSHIPS & SUB 10,950 - - 10,950 - -
W 0 O&M 6037 OFFICE SUPPLIES 13,700 - - 13,700 - -
W 0 O&M 6038 NATURAL GAS & ELE 6,512 - - 6,512 - -
W 0 O&M 6039 GASOLINE 68,790 - - 68,790 - -
W 0 O&M 6046 DEPRECIATION - - - - - -
W 0 O&M 6047 OFFICE LEASE 60,168 - - 60,168 - -
W 0 O&M 6048 AMORTIZATION - - - - - -
W 0 O&M 6051 REGULATORY EXPENS 11,575 - - 11,575 - -
W 0 O&M 6054 WATER UTILITY COM 1,240 - - 1,240 - -
W 0 O&M 6094 ADMIN & FINANCIAL 995,267 - - 995,267 - -
W 0 0 0 0 - - - - - -
0 0 0 6088020 WTR-ADMIN-CAPITAL - - - - - -
W 0 CO 9024 EQUIPMENT - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 6088025 WTR-ADMIN-DEBT SERVICE - - - - - -
T 0 T 9051 PRINCIPAL PAYMENT - - - - - -
T 0 T 9052 INTEREST PAYMENTS - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 6088026 WTR-ADMIN-OTHER FIN USES - - - - - -
T 0 T 9078 TRANSFER TO DEBT - - - - - -
T 0 T 9079 TRANSFER TO CAPIT - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 6088027 WTR-ADMIN-CONTINGENCY - - - - - -
T 0 T 9090 CONTINGENCY/RESER - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 6088030 WTR-CUSTOMER SVC-PERSONNEL - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 254,662 - - - 254,662 -
W 0 P 5002 OVERTIME PAY 100 - - - 100 - W 0 P 5006 GROUP INSURANCE 58,364 - - - 58,364 -
W 0 P 5007 SOCIAL SECURITY/M 18,248 - - - 18,248 -
W 0 P 5009 ASRS CONTRIBUTION 29,488 - - - 29,488 -
W 0 P 5011 WORKERS' COMPENSA 493 - - - 493 -
0 0 0 0 0 - - - - - -
0 0 0 6088040 WTR-CUST SERVICE-O&M - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 154,100 - - - 154,100 -
W 0 O&M 6029 POSTAGE 112,500 - - - 112,500 -
W 0 O&M 6031 PRINTING & BINDIN 9,000 - - - 9,000 -
W 0 O&M 6034 TRAVEL & TRAINING 2,500 - - - 2,500 -
W 0 O&M 6040 NON-CAPITALIZED E 3,000 - - - 3,000 -
W 0 O&M 6043 BAD DEBT EXPENSE 13,000 - - - 13,000 - Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 19
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
0 0 0 0 0 - - - - - -
0 0 0 6088060 WTR-CONSERV-PERSONNEL - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 72,535 36,268 36,268 - - -
W 0 P 5006 GROUP INSURANCE 11,677 5,839 5,839 - - -
W 0 P 5007 SOCIAL SECURITY/M 5,305 2,653 2,653 - - -
W 0 P 5009 ASRS CONTRIBUTION 9,002 4,501 4,501 - - -
W 0 P 5011 WORKERS' COMPENSA 2,017 1,009 1,009 - - -
0 0 0 0 0 - - - - - -
0 0 0 6088070 WTR-CONSERV-O&M - - - - - -
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 20
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
W 0 O&M 6005 OUTSIDE PROFESSIO 45,900 22,950 22,950 - - -
W 0 O&M 6031 PRINTING & BINDIN 11,200 5,600 5,600 - - -
W 0 O&M 6034 TRAVEL & TRAINING 600 300 300 - - -
W 0 O&M 6035 MEMBERSHIPS & SUB 3,045 1,523 1,523 - - -
W 0 O&M 6040 NON-CAPITALIZED E 300 150 150 - - -
W 0 O&M 6041 UNIFORMS 500 250 250 - - -
W 0 O&M 6044 FIELD SUPPLIES 300 150 150 - - -
W 0 O&M 6084 CONSERVATION 500 250 250 - - -
0 0 0 0 0 - - - - - -
0 0 0 6088090 WTR-WTR RES-O&M - - - - - - W 0 O&M 6005 OUTSIDE PROFESSIO 125,000 125,000 - - - -
CAP 0 CAP 6010 CAP WATER CAPITAL 376,208 376,208 - - - -
CAP 0 CAP 6011 CAP WATER DELIVER 1,813,680 1,813,680 - - - -
W 0 O&M 6051 81301 REGULATORY E 50,000 50,000 - - - -
CAP 0 CAP 6082 CAP WATER WHEELIN 1,873,000 1,873,000 - - - -
0 0 0 0 0 - - - - - -
0 0 0 6088100 WTR-ENG ADMIN-PERSONNEL - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 325,934 - - 298,939 - 26,995
W 0 P 5006 GROUP INSURANCE 40,268 - - 36,933 - 3,335
W 0 P 5007 SOCIAL SECURITY/M 24,263 - - 22,253 - 2,010
W 0 P 5009 ASRS CONTRIBUTION 40,448 - - 37,098 - 3,350
W 0 P 5011 WORKERS' COMPENSA 4,476 - - 4,105 - 371
0 0 0 0 0 - - - - - -
0 0 0 6088110 WTR-ENG ADMIN-O&M - - - - - -
W 0 A 6005 OUTSIDE PROFESSIO 102,000 - - 93,552 - 8,448
W 0 A 6031 PRINTING & BINDIN 2,000 - - 1,834 - 166
W 0 A 6034 TRAVEL & TRAINING 4,700 - - 4,311 - 389
W 0 A 6035 MEMBERSHIPS & SUB 717 - - 658 - 59
W 0 A 6051 REGULATORY EXPENS 100 - - 92 - 8
W 0 A 6064 SAFETY COMPLIANCE 300 - - 275 - 25
W 0 A 6094 ADMINISTRATIVE SE 95,299 - - 87,406 - 7,893
0 0 0 0 0 - - - - - -
0 0 0 6088150 WTR-CAPITAL IMPROV-CAPITAL - - - - - -
W 0 CO 9007 82153 WELLS - - - - - -
W 0 CO 9007 82191 WELLS - - - - - -
W 0 CO 9008 82171 BOOSTER STAT - - - - - -
W 0 CO 9008 WT011 BOOSTER STAT - - - - - -
W 0 CO 9008 WT012 BOOSTER STAT - - - - - -
W 0 CO 9009 TRANSMISSION/DIST - - - - - -
W 0 CO 9009 WT003 TRANSMISSION - - - - - -
W 0 CO 9009 WT010 TRANSMISSION - - - - - -
W 0 CO 9010 WT007 RESERVOIRS - - - - - -
W 0 CO 9012 82185 STRUCTURES - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 6088160 WTR-CONST INSP-PERSONNEL - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 129,349 - - 118,636 - 10,713
W 0 P 5002 OVERTIME PAY 500 - - 459 - 41 W 0 P 5006 GROUP INSURANCE 20,788 - - 19,066 - 1,722
W 0 P 5007 SOCIAL SECURITY/M 9,536 - - 8,746 - 790
W 0 P 5009 ASRS CONTRIBUTION 16,114 - - 14,779 - 1,335
W 0 P 5011 WORKERS' COMPENSA 3,610 - - 3,311 - 299
0 0 0 0 0 - - - - - -
0 0 0 6088170 WTR-CONST INSP-O&M - - - - - -
W 0 O&M 6034 TRAVEL & TRAINING 250 125 125 - - -
W 0 O&M 6036 TESTING 1,000 500 500 - - -
W 0 O&M 6040 NON-CAPITALIZED E 775 388 388 - - -
W 0 O&M 6041 UNIFORMS 1,100 550 550 - - -
W 0 O&M 6044 FIELD SUPPLIES 600 300 300 - - -
W 0 O&M 6051 REGULATORY EXPENS 150 75 75 - - - Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 21
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
W 0 O&M 6064 SAFETY COMPLIANCE 460 230 230 - - -
0 0 0 0 0 - - - - - -
0 0 0 6088220 WTR-OPS PRODUCTION-PERSONNEL - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 369,211 338,632 - - - 30,579
W 0 P 5002 OVERTIME PAY 18,000 16,509 - - - 1,491
W 0 P 5006 GROUP INSURANCE 75,688 69,419 - - - 6,269
W 0 P 5007 SOCIAL SECURITY/M 28,725 26,346 - - - 2,379
W 0 P 5009 ASRS CONTRIBUTION 49,046 44,984 - - - 4,062
W 0 P 5011 WORKERS' COMPENSA 10,988 10,078 - - - 910
W 0 P 5018 SPECIAL PAY NON P 8,000 7,337 - - - 663 0 0 0 0 0 - - - - - -
0 0 0 6088230 WTR-OPS PRODUCTION-O&M - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 496 496 - - - -
W 0 U 6012 POWER PURCHASED F 850,000 850,000 - - - -
W 0 O&M 6015 WASTE DISPOSAL FE 1,082 1,082 - - - -
W 0 O&M 6019 EQUIPMENT REPAIR 8,048 8,048 - - - -
W 0 O&M 6020 BUILDING REPAIR &2,596 2,596 - - - -
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 22
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
W 0 O&M 6021 GROUNDS REPAIR &6,317 6,317 - - - -
W 0 O&M 6024 CHEMICALS 60,000 60,000 - - - -
W 0 O&M 6025 RENTALS 500 500 - - - -
W 0 O&M 6034 TRAVEL & TRAINING 3,118 3,118 - - - -
W 0 O&M 6036 TESTING 2,077 2,077 - - - -
W 0 O&M 6040 NON-CAPITALIZED E 2,752 2,752 - - - -
W 0 O&M 6041 UNIFORMS 8,568 8,568 - - - -
W 0 O&M 6044 FIELD SUPPLIES 4,403 4,403 - - - -
W 0 O&M 6051 REGULATORY EXPENS 3,613 3,613 - - - -
W 0 O&M 6055 EQUIP. R&M-WELLS 21,000 21,000 - - - - W 0 O&M 6056 EQUIP. R&M-BOOSTE 18,500 18,500 - - - -
W 0 O&M 6058 EQUIP. R&M-RESERV 23,000 23,000 - - - -
W 0 O&M 6061 EQUIPMENT R&M - M 2,000 2,000 - - - -
W 0 O&M 6064 SAFETY COMPLIANCE 2,110 2,110 - - - -
W 0 O&M 6085 EQUIP. R&M-DISINF 14,000 14,000 - - - -
NWWRRDS 0 NWWRRDS 0 Nortwest Recharge, Recovery & Delivery System (NWRRDS)0 0 - - - -
0 0 0 6088260 WTR-OPS PROD-RECLAIM-O&M - - - - - -
REC 0 REC 6004 EFFLUENT SHORTAGE 30,000 - - - - 30,000
REC 0 REC 6005 OUTSIDE PROFESSIO 7,197 - - - - 7,197
REC 0 REC 6012 POWER PURCHASED F 55,000 - - - - 55,000
REC 0 REC 6014 WATER & SEWAGE 39 - - - - 39
REC 0 REC 6015 WASTE DISPOSAL FE 168 - - - - 168
REC 0 REC 6018 VEHICLE REPAIR &3,312 - - - - 3,312
REC 0 REC 6019 EQUIPMENT REPAIR 2,073 - - - - 2,073
REC 0 REC 6020 BUILDING REPAIR &404 - - - - 404
REC 0 REC 6021 GROUNDS REPAIR &982 - - - - 982
REC 0 REC 6024 CHEMICALS 20,000 - - - - 20,000
REC 0 REC 6026 INSURANCE 16,805 - - - - 16,805
REC 0 REC 6034 TRAVEL & TRAINING 713 - - - - 713
REC 0 REC 6036 TESTING 323 - - - - 323
REC 0 REC 6038 NATURAL GAS & ELE 588 - - - - 588
REC 0 REC 6039 GASOLINE 6,210 - - - - 6,210
REC 0 REC 6040 NON-CAPITALIZED E 414 - - - - 414
REC 0 REC 6041 UNIFORMS 960 - - - - 960
REC 0 REC 6044 FIELD SUPPLIES 496 - - - - 496
REC 0 REC 6046 DEPRECIATION - - - - - -
REC 0 REC 6047 OFFICE LEASE 5,432 - - - - 5,432
REC 0 REC 6051 REGULATORY EXPENS 3,182 - - - - 3,182
REC 0 REC 6054 WATER UTILITY COM 260 - - - - 260
REC 0 REC 6056 EQUIP. R&M-BOOSTE 3,460 - - - - 3,460
REC 0 REC 6057 EQUIP. R&M-MAINS 5,000 - - - - 5,000
REC 0 REC 6058 EQUIP. R&M-RESERV 250 - - - - 250
REC 0 REC 6059 EQUIP. R&M-SERVIC 500 - - - - 500
REC 0 REC 6060 EQUIP. R&M-HYDRAN 500 - - - - 500
REC 0 REC 6061 EQUIPMENT R&M - M 4,000 - - - - 4,000
REC 0 REC 6062 BLUESTAKE 1,153 - - - - 1,153
REC 0 REC 6064 SAFETY COMPLIANCE 314 - - - - 314 REC 0 REC 6085 EQUIP. R&M-DISINF 2,024 - - - - 2,024
REC 0 REC 6094 ADMIN & FINANCIAL 98,451 - - - - 98,451
REC 0 REC 6099 RECLAIMED WATER F 678,860 - - - - 678,860
0 0 0 0 0 - - - - - -
0 0 0 6088280 WTR-OPS DISTRIBUTION-PERSONNEL- - - - - -
W 0 P 5001 REGULAR EMPLOYEES 334,670 - 306,952 - - 27,718
W 0 P 5002 OVERTIME PAY 20,000 - 18,344 - - 1,656
W 0 P 5006 GROUP INSURANCE 78,748 - 72,226 - - 6,522
W 0 P 5007 SOCIAL SECURITY/M 25,933 - 23,785 - - 2,148
W 0 P 5009 ASRS CONTRIBUTION 44,573 - 40,881 - - 3,692
W 0 P 5011 WORKERS' COMPENSA 9,986 - 9,159 - - 827
W 0 P 5018 SPECIAL PAY NON P 4,500 - 4,127 - - 373 Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 23
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
0 0 0 0 0 - - - - - -
0 0 0 6088290 WTR-OPS DISTRIBUTION-O&M - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 750 - 750 - - -
W 0 O&M 6015 WASTE DISPOSAL FE 709 - 709 - - -
W 0 O&M 6019 EQUIPMENT REPAIR 5,360 - 5,360 - - -
W 0 O&M 6034 TRAVEL & TRAINING 5,505 - 5,505 - - -
W 0 O&M 6040 NON-CAPITALIZED E 5,000 - 5,000 - - -
W 0 O&M 6041 UNIFORMS 4,200 - 4,200 - - -
W 0 O&M 6044 FIELD SUPPLIES 4,500 - 4,500 - - -
W 0 O&M 6051 REGULATORY EXPENS 350 - 350 - - -
W 0 O&M 6057 EQUIP. R&M-MAINS 98,000 - 98,000 - - -
W 0 O&M 6059 EQUIP. R&M-SERVIC 10,000 - 10,000 - - -
W 0 O&M 6060 EQUIP. R&M-HYDRAN 30,500 - 30,500 - - -
W 0 O&M 6062 BLUESTAKE 6,091 - 6,091 - - -
W 0 O&M 6064 SAFETY COMPLIANCE 5,850 - 5,850 - - -
0 0 0 0 0 - - - - - -
0 0 0 6088300 WTR-OPS DISTRIBUTION-CAPITAL - - - - - -
W 0 CO 9020 VEHICLES - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 6088310 WTR-OPS WATER QUALITY-PERS - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 172,091 - - 157,838 - 14,253
W 0 P 5002 OVERTIME PAY 300 - - 275 - 25
W 0 P 5006 GROUP INSURANCE 43,771 - - 40,146 - 3,625
W 0 P 5007 SOCIAL SECURITY/M 12,269 - - 11,253 - 1,016
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 24
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
W 0 P 5009 ASRS CONTRIBUTION 21,394 - - 19,622 - 1,772
W 0 P 5011 WORKERS' COMPENSA 4,793 - - 4,396 - 397
0 0 0 0 0 - - - - - -
0 0 0 6088320 WTR-OPS WATER QUALITY-O&M - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 1,250 625 625 - - -
W 0 O&M 6029 POSTAGE 3,800 1,900 1,900 - - -
W 0 O&M 6031 PRINTING & BINDIN 3,150 1,575 1,575 - - -
W 0 O&M 6034 TRAVEL & TRAINING 2,445 1,223 1,223 - - -
W 0 O&M 6035 MEMBERSHIPS & SUB 310 155 155 - - -
W 0 O&M 6036 TESTING 120,000 60,000 60,000 - - -
W 0 O&M 6040 NON-CAPITALIZED E 1,800 900 900 - - -
W 0 O&M 6041 UNIFORMS 2,100 1,050 1,050 - - -
W 0 O&M 6044 FIELD SUPPLIES 5,000 2,500 2,500 - - -
W 0 O&M 6051 REGULATORY EXPENS 1,300 650 650 - - -
W 0 O&M 6064 SAFETY COMPLIANCE 400 200 200 - - -
W 0 O&M 6088 EQUIP. R&M-BACKFL 12,500 6,250 6,250 - - -
0 0 0 0 0 - - - - - -
0 0 0 6088330 WTR-OPS WATER QUALITY-CAPITAL - - - - - -
W 0 CO 9002 MINOR ASSETS - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 6088340 WTR-OPS ADMIN-PERSONNEL - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 277,007 - - 254,064 - 22,943
W 0 P 5006 GROUP INSURANCE 25,850 - - 23,709 - 2,141
W 0 P 5007 SOCIAL SECURITY/M 20,722 - - 19,006 - 1,716
W 0 P 5009 ASRS CONTRIBUTION 34,377 - - 31,530 - 2,847
W 0 P 5011 WORKERS' COMPENSA 7,702 - - 7,064 - 638
0 0 0 0 0 - - - - - -
0 0 0 6088350 WTR-OPS ADMIN-O&M - - - - - -
W 0 O&M 6034 TRAVEL & TRAINING 2,790 - - 2,790 - -
W 0 O&M 6035 MEMBERSHIPS & SUB 1,914 - - 1,914 - -
W 0 O&M 6037 OFFICE SUPPLIES 8,138 - - 8,138 - -
W 0 O&M 6040 NON-CAPITALIZED E 1,000 - - 1,000 - -
W 0 O&M 6041 UNIFORMS 2,100 - - 2,100 - -
W 0 O&M 6051 REGULATORY EXPENS 600 - - 600 - -
W 0 O&M 6064 SAFETY COMPLIANCE 400 - - 400 - -
0 0 0 0 0 - - - - - -
0 0 0 6088370 WTR-OPS METERS-PERSONNEL - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 192,612 - - - 192,612 -
W 0 P 5002 OVERTIME PAY 5,000 - - - 5,000 -
W 0 P 5006 GROUP INSURANCE 49,791 - - - 49,791 -
W 0 P 5007 SOCIAL SECURITY/M 14,316 - - - 14,316 -
W 0 P 5009 ASRS CONTRIBUTION 24,921 - - - 24,921 -
W 0 P 5011 WORKERS' COMPENSA 5,583 - - - 5,583 -
W 0 P 5018 SPECIAL PAY NON P 3,200 - - - 3,200 -
0 0 0 0 0 - - - - - -
0 0 0 6088380 WTR-OPS METERS-O&M - - - - - -
W 0 O&M 6019 EQUIPMENT REPAIR 1,200 - - - 1,200 -
W 0 O&M 6021 GROUNDS REPAIR &1,650 - - - 1,650 -
W 0 O&M 6034 TRAVEL & TRAINING 2,445 - - - 2,445 -
W 0 O&M 6040 NON-CAPITALIZED E 750 - - - 750 -
W 0 O&M 6041 UNIFORMS 3,500 - - - 3,500 -
W 0 O&M 6044 FIELD SUPPLIES 2,000 - - - 2,000 -
W 0 O&M 6051 REGULATORY EXPENS 1,000 - - - 1,000 -
W 0 O&M 6059 EQUIP. R&M-SERVIC 2,500 - - - 2,500 - Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 25
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
W 0 O&M 6061 EQUIPMENT R&M - M 4,000 - - - 4,000 -
W 0 O&M 6064 SAFETY COMPLIANCE 450 - - - 450 -
0 0 0 0 0 - - - - - -
0 0 0 6088390 WTR-OPS METERS-CAPITAL - - - - - -
W 0 CO 9006 METERS - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 60583310 WATER CONTROL SYSTMS PERSONNEL- - - - - -
W 0 P 5001 REGULAR EMPLOYEES 135,533 - - 124,308 - 11,225
W 0 P 5006 GROUP INSURANCE 20,714 - - 18,998 - 1,716
W 0 P 5007 SOCIAL SECURITY/M 9,960 - - 9,135 - 825
W 0 P 5009 ASRS CONTRIBUTION 16,820 - - 15,427 - 1,393
W 0 P 5011 WORKERS' COMPENSA 3,768 - - 3,456 - 312
0 0 0 0 0 - - - - - -
0 0 0 60583320 WATER CONTROL SYSTMS O&M - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 4,134 2,067 2,067 - - -
W 0 O&M 6034 TRAVEL & TRAINING 4,769 2,385 2,385 - - -
W 0 O&M 6040 NON-CAPITALIZED E 1,834 917 917 - - -
W 0 O&M 6041 UNIFORMS 2,064 1,032 1,032 - - -
W 0 O&M 6044 FIELD SUPPLIES 1,101 551 551 - - -
W 0 O&M 6055 EQUIP. R&M-WELLS 35,000 17,500 17,500 - - -
W 0 O&M 6056 EQUIP. R&M-BOOSTE 38,000 19,000 19,000 - - -
W 0 O&M 6058 EQUIP. R&M-RESERV 5,500 2,750 2,750 - - -
W 0 O&M 6064 SAFETY COMPLIANCE 1,376 688 688 - - -
W 0 O&M 6074 EQUIP. R&M-TELEME 9,077 4,539 4,539 - - -
0 0 0 0 0 - - - - - -
0 0 0 60583330 WATER CONTROL SYSTMS CAPITAL - - - - - -
W 0 CO 9024 WT008 EQUIPMENT - - - - - -
0 0 0 0 0 - - - - - -
0 0 0 0 0 - - - - - -
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 26
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
P Personnel 3,662,217$ 563,573$ 525,742$ 1,675,531$ 656,778$ 240,593$
CAP Central Arizona Project 4,062,888 4,062,888 - - - -
O&M Operations & Maintenance 2,580,788 520,975 338,610 1,407,608 313,595 -
A Administrative Expense 205,116 - - 188,128 - 16,988
U Utilities 850,000 850,000 - - - -
REC Reclaimed Water 949,070 - - - - 949,070
NWWRRDS Northwest Recharge, Recovery & Delivery System 0 0 - - - -
#N/A - - - - - - #N/A - - - - - - #N/A - - - - - - #N/A - - - - - - #N/A - - - - - -
- - - - - - - - - - - -
Total 12,310,079 5,997,436 864,352 3,271,266 970,373 1,206,652
TRUE TRUE FALSE TRUE TRUE TRUE
W Water Department 7,298,121$ 1,934,548$ 864,352$ 3,271,266$ 970,373$ 257,582$
26.5%11.8%44.8%13.3%3.5%
REC Reclaimed Water 949,070$ -$ -$ -$ -$ 949,070$
0.0%0.0%0.0%0.0%100.0%
CAP Central Arizona Project 4,062,888$ 4,062,888$ -$ -$ -$ -$
100.0%0.0%0.0%0.0%0.0%NWWRRDS Northwest Recharge, Recovery & Delivery System 0$ 0$ -$ -$ -$ -$
100.0%0.0%0.0%0.0%0.0%
#N/A -$ -$ -$ -$ -$ -$
0.0%0.0%0.0%0.0%0.0%
#N/A -$ -$ -$ -$ -$ -$
0.0%0.0%0.0%0.0%0.0%
#N/A -$ -$ -$ -$ -$ -$
0.0%0.0%0.0%0.0%0.0%
#N/A -$ -$ -$ -$ -$ -$
0.0%0.0%0.0%0.0%0.0%
#N/A -$ -$ -$ -$ -$ -$
0.0%0.0%0.0%0.0%0.0%
#N/A -$ -$ -$ -$ -$ -$
0.0%0.0%0.0%0.0%0.0%
Total Operating Expenses (No Personnel)8,647,862$ 5,433,863$ 338,610$ 1,595,736$ 313,595$ 966,058$
100.0%62.8%3.9%18.5%3.6%11.2%
Total Water Department 12,310,079$ 5,997,436$ 864,352$ 3,271,266$ 970,373$ 1,206,652$
100.0%48.7%7.0%26.6%7.9%9.8%
TOTAL WATER SYSTEM EXPENDITURES 12,310,079$ 5,997,436$ 864,352$ 3,271,266$ 970,373$ 1,206,652$
Percent 100.0%48.7%7.0%26.6%7.9%9.8%
TRUE TRUE TRUE TRUE TRUE TRUE
Budget Code
Department Code
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 28
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W1
Test Year2022 Net Supply/Customer Reclaimed
Budget Treatment Distribution Admin Billing Water
Test Year W 1.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZWATER COST OF SERVICE MODEL
CAPITAL OUTLAYS(Major)
Total Capital Outlays 3,511,650$ 2,500$ 3,351,000$ 150,000$ 8,150$ -$
Percent 100.0%0.1%95.4%4.3%0.2%0.0%
TOTAL OPERATING/CAPITAL OUTLAYS 15,821,729$ 5,999,936$ 4,215,352$ 3,421,266$ 978,523$ 1,206,652$
Percent 100.0%37.9%26.6%21.6%6.2%7.6%
Contingencies & TRANSFERS
T Contingencies & Transfers -$ -$ -$ -$ -$ -$
0.0%0.0%0.0%0.0%0.0%
CURRENT DEBT SERVICE
Water Debt Service
Principal & Interest 4,251,864$ na na na na na
Other 683,447 na na na na na
Reserve - na na na na na
TOTAL CURRENT DEBT SERVICE -- WATER 4,935,311$ 2,230,122$ 2,705,189$ -$ -$ -$
100.0%45.2%54.8%0.0%0.0%0.0%
FUTURE DEBT SERVICE
Water Debt Service
Principal & Interest -$ -$ -$ -$ -$ -$
Other - - - - - -
Reserve - - - - - -
TOTAL FUTURE DEBT SERVICE -- WATER -$ -$ -$ -$ -$ -$
0.0%0.0%0.0%0.0%0.0%0.0%
TOTAL COST OF SERVICE
TOTAL COST OF SERVICE 20,757,039$ 8,230,058$ 6,920,541$ 3,421,266$ 978,523$ 1,206,652$
100.0%39.6%33.3%16.5%4.7%5.8%
NON RATE REVENUES
TOTAL NON-RATE REVENUES 3,369,530$ 1,336,001$ 1,123,425$ 555,381$ 158,846$ 195,878$
100.0%39.6%33.3%16.5%4.7%5.8%
TOTAL REVENUE REQUIREMENT
TOTAL REVENUE REQUIREMENT 17,387,509$ 6,894,057$ 5,797,116$ 2,865,886$ 819,677$ 1,010,774$
0.0%0.0%0.0%0.0%0.0%0.0%
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 29
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W2
Test Year
2022 Test Year Test Year Max Day Test Year Test Year
Annual Daily Capacity Total Extra Water Wastewater
Use Average Factor Capacity Capacity Bills Bills
Test Year W 2.0 -- WATER Cost Allocations to Defined Customer Class Units
Scenario:2022 02 18 -- Equal Percent Adjustments
Customer Class Units -- Test Year Volume
W1 Residential & Irrigation 5/8"1,444,476,233 3,957,469 130 5,126,296 1,168,827 218,657 -
W2 Residential & Irrigation 3/4"188,922,762 517,597 131 677,963 160,366 21,252 -
W3 Residential & Irrigation 1"152,687,088 418,321 138 575,342 157,021 7,157 -
W4 Residential & Irrigation 1.5"38,938,765 106,682 168 179,342 72,661 646 -
W5 Residential & Irrigation 2"93,165,025 255,247 159 405,633 150,386 890 -
W6 Residential & Irrigation 3"16,881,063 46,249 194 89,527 43,277 24 -
W7 Residential & Irrigation 4"50,041,170 137,099 162 222,380 85,281 61 -
W8 Commercial, Turf & Multifamily 327,014,495 895,930 109 980,096 84,165 6,780 -
W9 Construction 38,337,280 105,034 96 101,096 (3,938) 360 -
Total Potable 2,350,463,880 6,439,627 8,357,674 1,918,047 255,828
W10 Reclaimed Water 593,856,096 1,627,003 177 2,880,427 1,253,424 144 -
Total System 2,944,319,976 8,066,630 177 11,238,101 3,171,471 255,972 -
Peaking Factor 1.39
Allocation Factors
Base 100.00%
Maximum Day 66.67%33.33%
Customer Class Units -- Percent of Annual Volumes
W1 Residential & Irrigation 5/8"61.45%60.94%85.42%0.00%
W2 Residential & Irrigation 3/4"8.04%8.36%8.30%0.00%
W3 Residential & Irrigation 1"6.50%8.19%2.80%0.00%
W4 Residential & Irrigation 1.5"1.66%3.79%0.25%0.00%
W5 Residential & Irrigation 2"3.96%7.84%0.35%0.00%
W6 Residential & Irrigation 3"0.72%2.26%0.01%0.00%
W7 Residential & Irrigation 4"2.13%4.45%0.02%0.00%
W8 Commercial, Turf & Multifamily 13.91%4.39%2.65%0.00%
W9 Construction 1.63%-0.21%0.14%0.00%
Total Potable Sytem 100.00%100.00%
W10 Reclaimed Water 0.06%0.00%
Total System 100.00%0.00%
SOURCE: Volume Input spreadsheet
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
30
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Test Year W3
Test Year
2022
Max Cust Total Max Cust
Base Day Billing Water Base Day Billing
Test Year W 3.0 -- Water Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
OPERATING EXPENSES/CAPITAL OUTLAYS
Treatment
Water Department 66.67%33.33%0.00%5,997,436$ 3,998,291$ 1,999,145$ -$
Capital Outlays 66.67%33.33%0.00%2,500 1,667 833 -
Total Treatment 5,999,936$ 3,999,957$ 1,999,979$ -$
Distribution
Water Department 66.67%33.33%0.00%864,352$ 576,234$ 288,117$ -$
Capital Outlays 66.67%33.33%0.00%3,351,000 2,234,000 1,117,000 -
Total Distribution 4,215,352$ 2,810,234$ 1,405,117$ -$
Reclaimed Water
Water Department 66.67%33.33%0.00%1,206,652$ 804,434$ 402,217$ -$
Capital Outlays 66.67%33.33%0.00%- - - -
Total Flood Irrigation 1,206,652$ 804,434$ 402,217$ -$
Customer Billing
Water Department 0.00%0.0%100.0%970,373$ -$ -$ 970,373$
Capital Outlays 0.00%0.0%100.0%8,150 - - 8,150
Total Customer Billing 978,523$ -$ -$ 978,523$
Sub-Total 12,400,462$ 7,614,626$ 3,807,313$ 978,523$
Percentage 100.00%61.41%30.70%7.89%
Administration
Water Department 61.41%30.70%7.89%3,271,266$ 2,008,753 1,004,377 258,136
Capital Outlays 61.41%30.70%7.89%150,000 92,109 46,054 11,837
Total Administration 3,421,266$ 2,100,862$ 1,050,431$ 269,973$
Total Operating/Cap Outlays 15,821,729$ 9,715,489$ 4,857,744$ 1,248,496$
TRANSFERS
Water Department 66.67%33.33%0.00%-$ -$ -$ -$
Total Transfers -$ -$ -$ -$
DEBT SERVICE
Current Debt Service 66.67%33.33%0.00%4,935,311$ 3,290,207$ 1,645,104$ -$
Future Debt Service 66.67%33.33%0.00%- - - -
Total Debt Service 4,935,311$ 3,290,207$ 1,645,104$ -$
Sub-Total 20,757,039$ 13,005,696$ 6,502,848$ 1,248,496$
Sub-Total Percentage 100.00%62.66%31.33%6.01%
NON-RATE REVENUES
Non-Rate Revenues 62.66%31.33%6.01%3,369,530 2,111,239 1,055,620 202,671
TOTAL COST OF SERVICE
Total Water Cost Classification 17,387,509$ 10,894,456$ 5,447,228$ 1,045,825$
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 31
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
NON-RATE REVENUES
0 0 0 6000000 WTR-CHARGES FOR SERVICES -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
NR 0 CS 3057 ENGINEER PLAN REV 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000
NR 0 CS 3058 CONSTRUCT INSPECT 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000
NR 0 CS 3070 MISC SERVICE REVE 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000
NR 0 CS 3071 BACKFLOW-INSTALL 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000
NR 0 MII 3074 SEWER FEES 380,000 380,000 380,000 380,000 380,000 380,000 380,000 380,000 380,000 380,000
NR 0 PI 3075 LATE FEES 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000
NR 0 PI 3076 NSF FEES 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000
NR 0 CS 3086 METER INCOME 99,000 99,000 99,000 99,000 99,000 99,000 99,000 99,000 99,000 99,000
NR 0 CS 3087 NEW SERV ESTABLIS 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000
NR 0 PI 3088 RECONNECT FEES 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000 32,000
NR 0 MII 3089 RECHARGE-KAI FARM 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000 48,000
NR 0 MII 3094 GROUNDWATER PRESE 2,394,530 2,421,614 2,440,149 2,452,650 2,465,150 2,477,650 2,490,151 2,502,651 2,515,151 2,527,652
NR 0 MII 3098 STORMWATER FEES 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000
NR 0 II 3099 INTEREST-INVESTME 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000
0 0 0 3063 RESIDENTIAL WATER - - - - - - - - - -
0 0 0 3064 COMMERICAL WATER - - - - - - - - - -
0 0 0 3065 IRRIGATION WATER - - - - - - - - - -
0 0 0 3066 IRRIGATION-RECLAI - - - - - - - - - -
0 0 0 3067 TURF RELATED WATE - - - - - - - - - -
0 0 0 3068 TURF-RECLAIMED - - - - - - - - - -
0 0 0 3069 CONSTRUCTION WATE - - - - - - - - - -
0 0 0 3079 RECLAIMED CONSTRU - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 0 Last - - - - - - - - - -
Total Non-Rate Revenues 3,369,530$ 3,396,614$ 3,415,149$ 3,427,650$ 3,440,150$ 3,452,650$ 3,465,151$ 3,477,651$ 3,490,151$ 3,502,652$
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 32
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
OPERATING EXPENSES
Department Code 1 Budget Code2 Expense 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025
0 0 0 6088000 WTR-ADMIN-PERSONNEL - - - - - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 305,501 311,611 317,843 324,200 330,684 337,298 344,044 350,925 357,943 365,102
W 0 P 5006 GROUP INSURANCE 36,139 36,141 36,143 36,144 36,146 36,148 36,150 36,152 36,153 36,155
W 0 P 5007 SOCIAL SECURITY/M 22,883 23,341 23,807 24,284 24,769 25,265 25,770 26,285 26,811 27,347
W 0 P 5009 ASRS CONTRIBUTION 37,913 38,671 39,445 40,234 41,038 41,859 42,696 43,550 44,421 45,310
W 0 P 5011 WORKERS' COMPENSA 588 600 612 624 636 649 662 675 689 703
W 0 P 5012 OTHER EMPLOYEE BE 1,454 1,483 1,513 1,543 1,574 1,605 1,637 1,670 1,704 1,738
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088010 WTR-ADMIN-O&M - - - - - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 94,839 96,736 98,670 100,644 102,657 104,710 106,804 108,940 111,119 113,341
W 0 O&M 6014 WATER & SEWAGE 436 445 454 463 472 481 491 501 511 521
W 0 O&M 6018 VEHICLE REPAIR &36,688 37,422 38,170 38,934 39,712 40,507 41,317 42,143 42,986 43,846
W 0 O&M 6019 EQUIPMENT REPAIR 5,279 5,385 5,492 5,602 5,714 5,828 5,945 6,064 6,185 6,309
W 0 O&M 6026 INSURANCE 80,222 84,233 88,445 92,867 97,510 102,386 107,505 112,880 118,524 124,451
W 0 O&M 6031 PRINTING & BINDING 500 510 520 531 541 552 563 574 586 598
W 0 O&M 6034 TRAVEL & TRAINING 4,500 4,590 4,682 4,775 4,871 4,968 5,068 5,169 5,272 5,378
W 0 O&M 6035 MEMBERSHIPS & SUB 10,950 11,169 11,392 11,620 11,853 12,090 12,331 12,578 12,830 13,086
W 0 O&M 6037 OFFICE SUPPLIES 13,700 13,974 14,253 14,539 14,829 15,126 15,428 15,737 16,052 16,373
W 0 O&M 6038 NATURAL GAS & ELE 6,512 6,838 7,179 7,538 7,915 8,311 8,727 9,163 9,621 10,102
W 0 O&M 6039 GASOLINE 68,790 73,605 78,758 84,271 90,170 96,482 103,235 110,462 118,194 126,468
W 0 O&M 6046 DEPRECIATION - - - - - - - - - -
W 0 O&M 6047 OFFICE LEASE 60,168 61,371 62,599 63,851 65,128 66,430 67,759 69,114 70,496 71,906
W 0 O&M 6048 AMORTIZATION - - - - - - - - - -
W 0 O&M 6051 REGULATORY EXPENS 11,575 11,807 12,043 12,283 12,529 12,780 13,035 13,296 13,562 13,833
W 0 O&M 6054 WATER UTILITY COM 1,240 1,265 1,290 1,316 1,342 1,369 1,396 1,424 1,453 1,482
W 0 O&M 6094 ADMIN & FINANCIAL 995,267 1,015,172 1,035,476 1,056,185 1,077,309 1,098,855 1,120,832 1,143,249 1,166,114 1,189,436
W 0 0 0 0 - - - - - - - - - -
0 0 0 6088020 WTR-ADMIN-CAPITAL - - - - - - - - - -
W 0 CO 9024 EQUIPMENT - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088025 WTR-ADMIN-DEBT SERVICE - - - - - - - - - -
T 0 T 9051 PRINCIPAL PAYMENT - - - - - - - - - -
T 0 T 9052 INTEREST PAYMENTS - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088026 WTR-ADMIN-OTHER FIN USES - - - - - - - - - -
T 0 T 9078 TRANSFER TO DEBT - - - - - - - - - -
T 0 T 9079 TRANSFER TO CAPIT - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088027 WTR-ADMIN-CONTINGENCY - - - - - - - - - -
T 0 T 9090 CONTINGENCY/RESER - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088030 WTR-CUSTOMER SVC-PERSONNEL - - - - - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 254,662 259,755 264,950 270,249 275,654 281,167 286,791 292,527 298,377 304,345
W 0 P 5002 OVERTIME PAY 100 107 114 123 131 140 150 161 172 184
W 0 P 5006 GROUP INSURANCE 58,364 58,367 58,370 58,373 58,376 58,379 58,382 58,384 58,387 58,390
W 0 P 5007 SOCIAL SECURITY/M 18,248 18,613 18,985 19,365 19,752 20,147 20,550 20,961 21,380 21,808
W 0 P 5009 ASRS CONTRIBUTION 29,488 30,078 30,679 31,293 31,919 32,557 33,208 33,872 34,550 35,241
W 0 P 5011 WORKERS' COMPENSA 493 503 513 523 534 544 555 566 578 589
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088040 WTR-CUST SERVICE-O&M - - - - - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 154,100 157,182 160,326 163,532 166,803 170,139 173,542 177,012 180,553 184,164
W 0 O&M 6029 POSTAGE 112,500 114,750 117,045 119,386 121,774 124,209 126,693 129,227 131,812 134,448 Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 33
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
W 0 O&M 6031 PRINTING & BINDIN 9,000 9,180 9,364 9,551 9,742 9,937 10,135 10,338 10,545 10,756
W 0 O&M 6034 TRAVEL & TRAINING 2,500 2,550 2,601 2,653 2,706 2,760 2,815 2,872 2,929 2,988
W 0 O&M 6040 NON-CAPITALIZED E 3,000 3,060 3,121 3,184 3,247 3,312 3,378 3,446 3,515 3,585
W 0 O&M 6043 BAD DEBT EXPENSE 13,000 13,260 13,525 13,796 14,072 14,353 14,640 14,933 15,232 15,536
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088060 WTR-CONSERV-PERSONNEL - - - - - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 72,535 73,986 75,465 76,975 78,514 80,085 81,686 83,320 84,986 86,686
W 0 P 5006 GROUP INSURANCE 11,677 11,678 11,678 11,679 11,679 11,680 11,681 11,681 11,682 11,682
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 34
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
W 0 P 5007 SOCIAL SECURITY/M 5,305 5,411 5,519 5,630 5,742 5,857 5,974 6,094 6,216 6,340
W 0 P 5009 ASRS CONTRIBUTION 9,002 9,182 9,366 9,553 9,744 9,939 10,138 10,340 10,547 10,758
W 0 P 5011 WORKERS' COMPENSA 2,017 2,057 2,098 2,140 2,183 2,227 2,271 2,317 2,363 2,411
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088070 WTR-CONSERV-O&M - - - - - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 45,900 46,818 47,754 48,709 49,684 50,677 51,691 52,725 53,779 54,855
W 0 O&M 6031 PRINTING & BINDIN 11,200 11,424 11,652 11,886 12,123 12,366 12,613 12,865 13,123 13,385
W 0 O&M 6034 TRAVEL & TRAINING 600 612 624 637 649 662 676 689 703 717
W 0 O&M 6035 MEMBERSHIPS & SUB 3,045 3,106 3,168 3,231 3,296 3,362 3,429 3,498 3,568 3,639
W 0 O&M 6040 NON-CAPITALIZED E 300 306 312 318 325 331 338 345 351 359
W 0 O&M 6041 UNIFORMS 500 510 520 531 541 552 563 574 586 598
W 0 O&M 6044 FIELD SUPPLIES 300 306 312 318 325 331 338 345 351 359
W 0 O&M 6084 CONSERVATION 500 510 520 531 541 552 563 574 586 598
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088090 WTR-WTR RES-O&M - - - - - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 125,000 127,500 130,050 132,651 135,304 138,010 140,770 143,586 146,457 149,387
CAP 0 CAP 6010 CAP WATER CAPITAL 376,208 387,165 460,215 504,045 489,435 485,783 493,088 500,393 507,698 515,003
CAP 0 CAP 6011 CAP WATER DELIVER 1,813,680 2,019,780 2,133,135 2,246,490 2,303,168 2,375,303 2,493,810 2,617,470 2,746,283 2,885,400
W 0 O&M 6051 81301 REGULATORY E 50,000 51,000 52,020 53,060 54,122 55,204 56,308 57,434 58,583 59,755
CAP 0 CAP 6082 CAP WATER WHEELIN 1,873,000 1,947,920 2,025,837 1,346,870 1,400,745 1,456,775 1,515,046 1,575,647 1,638,673 1,704,220
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088100 WTR-ENG ADMIN-PERSONNEL - - - - - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 325,934 332,453 339,102 345,884 352,801 359,857 367,055 374,396 381,884 389,521
W 0 P 5006 GROUP INSURANCE 40,268 40,270 40,272 40,274 40,276 40,278 40,280 40,282 40,284 40,286
W 0 P 5007 SOCIAL SECURITY/M 24,263 24,748 25,243 25,748 26,263 26,788 27,324 27,871 28,428 28,997
W 0 P 5009 ASRS CONTRIBUTION 40,448 41,257 42,082 42,924 43,782 44,658 45,551 46,462 47,391 48,339
W 0 P 5011 WORKERS' COMPENSA 4,476 4,566 4,657 4,750 4,845 4,942 5,041 5,142 5,244 5,349
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088110 WTR-ENG ADMIN-O&M - - - - - - - - - -
W 0 A 6005 OUTSIDE PROFESSIO 102,000 104,040 106,121 108,243 110,408 112,616 114,869 117,166 119,509 121,899
W 0 A 6031 PRINTING & BINDIN 2,000 2,040 2,081 2,122 2,165 2,208 2,252 2,297 2,343 2,390
W 0 A 6034 TRAVEL & TRAINING 4,700 4,794 4,890 4,988 5,087 5,189 5,293 5,399 5,507 5,617
W 0 A 6035 MEMBERSHIPS & SUB 717 731 746 761 776 792 807 824 840 857
W 0 A 6051 REGULATORY EXPENS 100 102 104 106 108 110 113 115 117 120
W 0 A 6064 SAFETY COMPLIANCE 300 306 312 318 325 331 338 345 351 359
W 0 A 6094 ADMINISTRATIVE SE 95,299 97,205 99,149 101,132 103,155 105,218 107,322 109,469 111,658 113,891
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088150 WTR-CAPITAL IMPROV-CAPITAL - - - - - - - - - -
W 0 CO 9007 82153 WELLS - - - - - - - - - -
W 0 CO 9007 82191 WELLS - - - - - - - - - -
W 0 CO 9008 82171 BOOSTER STAT - - - - - - - - - -
W 0 CO 9008 WT011 BOOSTER STAT - - - - - - - - - -
W 0 CO 9008 WT012 BOOSTER STAT - - - - - - - - - -
W 0 CO 9009 TRANSMISSION/DIST - - - - - - - - - -
W 0 CO 9009 WT003 TRANSMISSION - - - - - - - - - -
W 0 CO 9009 WT010 TRANSMISSION - - - - - - - - - -
W 0 CO 9010 WT007 RESERVOIRS - - - - - - - - - -
W 0 CO 9012 82185 STRUCTURES - - - - - - - - - -
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088160 WTR-CONST INSP-PERSONNEL - - - - - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 129,349 131,936 134,575 137,266 140,012 142,812 145,668 148,581 151,553 154,584
W 0 P 5002 OVERTIME PAY 500 510 520 531 541 552 563 574 586 598
W 0 P 5006 GROUP INSURANCE 20,788 20,789 20,790 20,791 20,792 20,793 20,794 20,795 20,796 20,797
W 0 P 5007 SOCIAL SECURITY/M 9,536 9,727 9,921 10,120 10,322 10,529 10,739 10,954 11,173 11,396 Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 35
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
W 0 P 5009 ASRS CONTRIBUTION 16,114 16,436 16,765 17,100 17,442 17,791 18,147 18,510 18,880 19,258
W 0 P 5011 WORKERS' COMPENSA 3,610 3,682 3,756 3,831 3,908 3,986 4,065 4,147 4,230 4,314
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088170 WTR-CONST INSP-O&M - - - - - - - - - -
W 0 O&M 6034 TRAVEL & TRAINING 250 255 260 265 271 276 282 287 293 299
W 0 O&M 6036 TESTING 1,000 1,020 1,040 1,061 1,082 1,104 1,126 1,149 1,172 1,195
W 0 O&M 6040 NON-CAPITALIZED E 775 791 806 822 839 856 873 890 908 926
W 0 O&M 6041 UNIFORMS 1,100 1,122 1,144 1,167 1,191 1,214 1,239 1,264 1,289 1,315
W 0 O&M 6044 FIELD SUPPLIES 600 612 624 637 649 662 676 689 703 717
W 0 O&M 6051 REGULATORY EXPENS 150 153 156 159 162 166 169 172 176 179
W 0 O&M 6064 SAFETY COMPLIANCE 460 469 479 488 498 508 518 528 539 550
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088220 WTR-OPS PRODUCTION-PERSONNEL - - - - - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 369,211 376,595 384,127 391,810 399,646 407,639 415,792 424,107 432,590 441,241
W 0 P 5002 OVERTIME PAY 18,000 18,360 18,727 19,102 19,484 19,873 20,271 20,676 21,090 21,512
W 0 P 5006 GROUP INSURANCE 75,688 75,692 75,696 75,699 75,703 75,707 75,711 75,714 75,718 75,722
W 0 P 5007 SOCIAL SECURITY/M 28,725 29,300 29,885 30,483 31,093 31,715 32,349 32,996 33,656 34,329
W 0 P 5009 ASRS CONTRIBUTION 49,046 50,027 51,027 52,048 53,089 54,151 55,234 56,338 57,465 58,615
W 0 P 5011 WORKERS' COMPENSA 10,988 11,208 11,432 11,661 11,894 12,132 12,374 12,622 12,874 13,132
W 0 P 5018 SPECIAL PAY NON P 8,000 8,160 8,323 8,490 8,659 8,833 9,009 9,189 9,373 9,561
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088230 WTR-OPS PRODUCTION-O&M - - - - - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 496 506 516 526 537 548 559 570 581 593
W 0 U 6012 POWER PURCHASED F 850,000 892,500 937,125 983,981 1,033,180 1,084,839 1,139,081 1,196,035 1,255,837 1,318,629
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 36
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
W 0 O&M 6015 WASTE DISPOSAL FE 1,082 1,136 1,193 1,253 1,315 1,381 1,450 1,522 1,599 1,679
W 0 O&M 6019 EQUIPMENT REPAIR 8,048 8,209 8,373 8,541 8,711 8,886 9,063 9,245 9,430 9,618
W 0 O&M 6020 BUILDING REPAIR &2,596 2,648 2,701 2,755 2,810 2,866 2,924 2,982 3,042 3,102
W 0 O&M 6021 GROUNDS REPAIR &6,317 6,443 6,572 6,704 6,838 6,974 7,114 7,256 7,401 7,549
W 0 O&M 6024 CHEMICALS 60,000 64,200 68,694 73,503 78,648 84,153 90,044 96,347 103,091 110,308
W 0 O&M 6025 RENTALS 500 510 520 531 541 552 563 574 586 598
W 0 O&M 6034 TRAVEL & TRAINING 3,118 3,180 3,244 3,309 3,375 3,443 3,511 3,582 3,653 3,726
W 0 O&M 6036 TESTING 2,077 2,119 2,161 2,204 2,248 2,293 2,339 2,386 2,434 2,482
W 0 O&M 6040 NON-CAPITALIZED E 2,752 2,807 2,863 2,920 2,979 3,038 3,099 3,161 3,224 3,289
W 0 O&M 6041 UNIFORMS 8,568 8,739 8,914 9,092 9,274 9,460 9,649 9,842 10,039 10,240
W 0 O&M 6044 FIELD SUPPLIES 4,403 4,491 4,581 4,672 4,766 4,861 4,958 5,058 5,159 5,262
W 0 O&M 6051 REGULATORY EXPENS 3,613 3,685 3,759 3,834 3,911 3,989 4,069 4,150 4,233 4,318
W 0 O&M 6055 EQUIP. R&M-WELLS 21,000 21,420 21,848 22,285 22,731 23,186 23,649 24,122 24,605 25,097
W 0 O&M 6056 EQUIP. R&M-BOOSTE 18,500 18,870 19,247 19,632 20,025 20,425 20,834 21,251 21,676 22,109
W 0 O&M 6058 EQUIP. R&M-RESERV 23,000 23,460 23,929 24,408 24,896 25,394 25,902 26,420 26,948 27,487
W 0 O&M 6061 EQUIPMENT R&M - M 2,000 2,040 2,081 2,122 2,165 2,208 2,252 2,297 2,343 2,390
W 0 O&M 6064 SAFETY COMPLIANCE 2,110 2,152 2,195 2,239 2,284 2,330 2,376 2,424 2,472 2,522
W 0 O&M 6085 EQUIP. R&M-DISINF 14,000 14,280 14,566 14,857 15,154 15,457 15,766 16,082 16,403 16,731
NWWRRDS 0 NWWRRDS 0 Nortwest Recharge, Recovery & Delivery System (NWRRDS)0 0 160,000 320,000 480,000 499,200 519,168 539,935 561,532 583,994
0 0 0 6088260 WTR-OPS PROD-RECLAIM-O&M - - - - - - - - - -
REC 0 REC 6004 EFFLUENT SHORTAGE 30,000 30,600 31,212 31,836 32,473 33,122 33,785 34,461 35,150 35,853
REC 0 REC 6005 OUTSIDE PROFESSIO 7,197 7,341 7,488 7,638 7,790 7,946 8,105 8,267 8,432 8,601
REC 0 REC 6012 POWER PURCHASED F 55,000 57,750 60,638 63,669 66,853 70,195 73,705 77,391 81,260 85,323
REC 0 REC 6014 WATER & SEWAGE 39 40 41 41 42 43 44 45 46 47
REC 0 REC 6015 WASTE DISPOSAL FE 168 171 175 178 182 185 189 193 197 201
REC 0 REC 6018 VEHICLE REPAIR &3,312 3,378 3,446 3,515 3,585 3,657 3,730 3,804 3,881 3,958
REC 0 REC 6019 EQUIPMENT REPAIR 2,073 2,114 2,157 2,200 2,244 2,289 2,335 2,381 2,429 2,477
REC 0 REC 6020 BUILDING REPAIR &404 412 420 429 437 446 455 464 473 483
REC 0 REC 6021 GROUNDS REPAIR &982 1,002 1,022 1,042 1,063 1,084 1,106 1,128 1,151 1,174
REC 0 REC 6024 CHEMICALS 20,000 21,400 22,898 24,501 26,216 28,051 30,015 32,116 34,364 36,769
REC 0 REC 6026 INSURANCE 16,805 17,981 19,240 20,587 22,028 23,570 25,220 26,985 28,874 30,895
REC 0 REC 6034 TRAVEL & TRAINING 713 727 742 757 772 787 803 819 835 852
REC 0 REC 6036 TESTING 323 329 336 343 350 357 364 371 378 386
REC 0 REC 6038 NATURAL GAS & ELE 588 617 648 681 715 750 788 827 869 912
REC 0 REC 6039 GASOLINE 6,210 6,645 7,110 7,608 8,140 8,710 9,320 9,972 10,670 11,417
REC 0 REC 6040 NON-CAPITALIZED E 414 422 431 439 448 457 466 476 485 495
REC 0 REC 6041 UNIFORMS 960 979 999 1,019 1,039 1,060 1,081 1,103 1,125 1,147
REC 0 REC 6044 FIELD SUPPLIES 496 506 516 526 537 548 559 570 581 593
REC 0 REC 6046 DEPRECIATION - - - - - - - - - -
REC 0 REC 6047 OFFICE LEASE 5,432 5,541 5,651 5,764 5,880 5,997 6,117 6,240 6,364 6,492
REC 0 REC 6051 REGULATORY EXPENS 3,182 3,246 3,311 3,377 3,444 3,513 3,583 3,655 3,728 3,803
REC 0 REC 6054 WATER UTILITY COM 260 265 271 276 281 287 293 299 305 311
REC 0 REC 6056 EQUIP. R&M-BOOSTE 3,460 3,529 3,600 3,672 3,745 3,820 3,897 3,974 4,054 4,135
REC 0 REC 6057 EQUIP. R&M-MAINS 5,000 5,100 5,202 5,306 5,412 5,520 5,631 5,743 5,858 5,975
REC 0 REC 6058 EQUIP. R&M-RESERV 250 255 260 265 271 276 282 287 293 299
REC 0 REC 6059 EQUIP. R&M-SERVIC 500 510 520 531 541 552 563 574 586 598
REC 0 REC 6060 EQUIP. R&M-HYDRAN 500 510 520 531 541 552 563 574 586 598
REC 0 REC 6061 EQUIPMENT R&M - M 4,000 4,080 4,162 4,245 4,330 4,416 4,505 4,595 4,687 4,780
REC 0 REC 6062 BLUESTAKE 1,153 1,176 1,200 1,224 1,248 1,273 1,298 1,324 1,351 1,378
REC 0 REC 6064 SAFETY COMPLIANCE 314 320 327 333 340 347 354 361 368 375
REC 0 REC 6085 EQUIP. R&M-DISINF 2,024 2,064 2,106 2,148 2,191 2,235 2,279 2,325 2,371 2,419
REC 0 REC 6094 ADMIN & FINANCIAL 98,451 100,420 102,428 104,477 106,567 108,698 110,872 113,089 115,351 117,658
REC 0 REC 6099 RECLAIMED WATER F 678,860 692,437 706,286 720,412 734,820 749,516 764,507 779,797 795,393 811,301
0 0 0 0 0 - - - - - - - - - - Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 37
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
0 0 0 6088280 WTR-OPS DISTRIBUTION-PERSONNEL - - - - - - - - - -
W 0 P 5001 REGULAR EMPLOYEES 334,670 341,363 348,191 355,154 362,258 369,503 376,893 384,431 392,119 399,962
W 0 P 5002 OVERTIME PAY 20,000 20,400 20,808 21,224 21,649 22,082 22,523 22,974 23,433 23,902
W 0 P 5006 GROUP INSURANCE 78,748 78,752 78,756 78,760 78,764 78,768 78,772 78,776 78,780 78,783
W 0 P 5007 SOCIAL SECURITY/M 25,933 26,452 26,981 27,520 28,071 28,632 29,205 29,789 30,385 30,992
W 0 P 5009 ASRS CONTRIBUTION 44,573 45,464 46,374 47,301 48,247 49,212 50,196 51,200 52,224 53,269
W 0 P 5011 WORKERS' COMPENSA 9,986 10,186 10,389 10,597 10,809 11,025 11,246 11,471 11,700 11,934
W 0 P 5018 SPECIAL PAY NON P 4,500 4,590 4,682 4,775 4,871 4,968 5,068 5,169 5,272 5,378
0 0 0 0 0 - - - - - - - - - -
0 0 0 6088290 WTR-OPS DISTRIBUTION-O&M - - - - - - - - - -
W 0 O&M 6005 OUTSIDE PROFESSIO 750 765 780 796 812 828 845 862 879 896
W 0 O&M 6015 WASTE DISPOSAL FE 709 723 738 752 767 783 798 814 831 847
W 0 O&M 6019 EQUIPMENT REPAIR 5,360 5,467 5,577 5,688 5,802 5,918 6,036 6,157 6,280 6,406
W 0 O&M 6034 TRAVEL & TRAINING 5,505 5,615 5,727 5,842 5,959 6,078 6,200 6,324 6,450 6,579
W 0 O&M 6040 NON-CAPITALIZED E 5,000 5,100 5,202 5,306 5,412 5,520 5,631 5,743 5,858 5,975
W 0 O&M 6041 UNIFORMS 4,200 4,284 4,370 4,457 4,546 4,637 4,730 4,824 4,921 5,019
W 0 O&M 6044 FIELD SUPPLIES 4,500 4,590 4,682 4,775 4,871 4,968 5,068 5,169 5,272 5,378
W 0 O&M 6051 REGULATORY EXPENS 350 357 364 371 379 386 394 402 410 418
W 0 O&M 6057 EQUIP. R&M-MAINS 98,000 99,960 101,959 103,998 106,078 108,200 110,364 112,571 114,823 117,119
W 0 O&M 6059 EQUIP. R&M-SERVIC 10,000 10,200 10,404 10,612 10,824 11,041 11,262 11,487 11,717 11,951
W 0 O&M 6060 EQUIP. R&M-HYDRAN 30,500 31,110 31,732 32,367 33,014 33,674 34,348 35,035 35,736 36,450
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 38
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
P Personnel 3,662,217$ 3,726,253$ 3,791,571$ 3,858,194$ 3,926,150$ 3,995,464$ 4,066,166$ 4,138,281$ 4,211,838$ 4,286,867$
CAP Central Arizona Project 4,062,888 4,354,865 4,619,187 4,097,405 4,193,347 4,317,860 4,501,943 4,693,510 4,892,653 5,104,623
O&M Operations & Maintenance 2,580,788 2,641,478 2,703,964 2,768,320 2,834,625 2,902,961 2,973,414 3,046,077 3,121,045 3,198,423
A Administrative Expense 205,116 209,218 213,403 217,671 222,024 226,465 230,994 235,614 240,326 245,133
U Utilities 850,000 892,500 937,125 983,981 1,033,180 1,084,839 1,139,081 1,196,035 1,255,837 1,318,629
REC Reclaimed Water 949,070 971,870 995,360 1,019,568 1,044,524 1,070,261 1,096,811 1,124,210 1,152,494 1,181,703
NWWRRDS Northwest Recharge, Recovery & Delivery System 0 0 160,000 320,000 480,000 499,200 519,168 539,935 561,532 583,994
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
Total 12,310,079 12,796,184 13,420,608 13,265,139 13,733,851 14,097,050 14,527,577 14,973,661 15,435,727 15,919,371
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
W Water Department 7,298,121 7,469,450 7,646,062 7,828,166 8,015,979 8,209,729 8,409,655 8,616,006 8,829,047 9,049,052
REC Reclaimed Water 949,070 971,870 995,360 1,019,568 1,044,524 1,070,261 1,096,811 1,124,210 1,152,494 1,181,703
CAP Central Arizona Project 4,062,888 4,354,865 4,619,187 4,097,405 4,193,347 4,317,860 4,501,943 4,693,510 4,892,653 5,104,623
NWWRRDS Northwest Recharge, Recovery & Delivery System 0 0 160,000 320,000 480,000 499,200 519,168 539,935 561,532 583,994
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
#N/A - - - - - - - - - -
Total Operating Exp & Contingencies 12,310,079$ 12,796,184$ 13,420,608$ 13,265,139$ 13,733,851$ 14,097,050$ 14,527,577$ 14,973,661$ 15,435,727$ 15,919,371$
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
Budget Code
Department Code
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 41
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W4
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 4.0 -- WATER Service Revenue Requirement Raised from Rates
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
CAPITAL OUTLAYS
Treatment 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$
Distribution 3,351,000 1,510,000 3,090,000 3,090,000 3,090,000 3,090,000 3,090,000 3,090,000 3,090,000 3,090,000
Administration 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000
Customer 8,150 8,150 8,150 8,150 8,150 8,150 8,150 8,150 8,150 8,150
Flood Irrigation - - - - - - - - - -
TOTAL WATER CAPITAL OUTLAYS 3,511,650$ 1,670,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$
CONTINGENCIES & TRANSFERS
T Contingencies & Transfers -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
CURRENT DEBT SERVICE - WATER
Water Debt Service
Principal & Interest 4,251,864$ 4,229,100$ 3,300,830$ 3,116,988$ 3,188,042$ 3,109,592$ 1,516,368$ 1,263,409$ 558,245$ 462,000$
Other 683,447 551,141 377,778 309,095 239,236 168,849 117,979 87,752 65,884 51,438
Reserve - - - - - - - - - -
TOTAL CURRENT DEBT SERVICE -- WATER 4,935,311$ 4,780,241$ 3,678,607$ 3,426,083$ 3,427,277$ 3,278,441$ 1,634,346$ 1,351,161$ 624,129$ 513,438$
FUTURE DEBT SERVICE - WATER
Water Debt Service
Principal -$ 274,027$ 284,988$ 296,388$ 308,243$ 320,573$ 333,396$ 346,732$ 360,601$ 375,025$
Interest - 326,400 315,439 304,039 292,184 279,854 267,031 253,695 239,826 225,402
Reserve - - - - - - - - - -
TOTAL FUTURE DEBT SERVICE -- WATER -$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$
TOTAL COST OF SERVICE
TOTAL COST OF SERVICE - WATER 20,757,039$ 19,847,502$ 20,950,293$ 20,542,299$ 21,012,205$ 21,226,568$ 20,013,001$ 20,175,900$ 19,910,933$ 20,283,887$
NON RATE REVENUES
TOTAL WATER NON-RATE REVENUES 3,369,530$ 3,396,614$ 3,415,149$ 3,427,650$ 3,440,150$ 3,452,650$ 3,465,151$ 3,477,651$ 3,490,151$ 3,502,652$
TOTAL REVENUE REQUIREMENT
TOTAL WATER REVENUE REQUIREMENT 17,387,509$ 16,450,888$ 17,535,144$ 17,114,650$ 17,572,056$ 17,773,918$ 16,547,850$ 16,698,249$ 16,420,782$ 16,781,235$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 42
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W5
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 5.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
OPERATING EXPENSES
Water
Personnel Services
Allocation Factor
Treatment 15.4%15.4%15.4%15.4%15.4%15.4%15.4%15.4%15.4%15.4%
Distribution 14.4%14.4%14.4%14.4%14.4%14.4%14.4%14.4%14.4%14.4%
Administration 45.8%45.8%45.8%45.8%45.8%45.8%45.8%45.8%45.8%45.8%
Customer 17.9%17.9%17.9%17.9%17.9%17.9%17.9%17.9%17.9%17.9%
Reclaimed Water 6.6%6.6%6.6%6.6%6.6%6.6%6.6%6.6%6.6%6.6%
Total 100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%
Total Cost
Treatment 563,573$ 573,428$ 583,479$ 593,732$ 604,190$ 614,856$ 625,736$ 636,834$ 648,154$ 659,700$
Distribution 525,742 534,935 544,311 553,876 563,631 573,582 583,732 594,085 604,644 615,415
Administration 1,675,531 1,704,829 1,734,712 1,765,194 1,796,285 1,827,997 1,860,344 1,893,338 1,926,992 1,961,319
Customer 656,778 668,262 679,976 691,924 704,111 716,542 729,222 742,155 755,346 768,802
Reclaimed Water 240,593 244,800 249,091 253,468 257,933 262,486 267,131 271,869 276,701 281,630
Total 3,662,217$ 3,726,253$ 3,791,571$ 3,858,194$ 3,926,150$ 3,995,464$ 4,066,166$ 4,138,281$ 4,211,838$ 4,286,867$
Total Operating/Contingencies
Allocation Factor
Treatment 62.8%62.8%62.8%62.8%62.8%62.8%62.8%62.8%62.8%62.8%
Distribution 3.9%3.9%3.9%3.9%3.9%3.9%3.9%3.9%3.9%3.9%
Administration 18.5%18.5%18.5%18.5%18.5%18.5%18.5%18.5%18.5%18.5%
Customer 3.6%3.6%3.6%3.6%3.6%3.6%3.6%3.6%3.6%3.6%
Reclaimed Water 11.2%11.2%11.2%11.2%11.2%11.2%11.2%11.2%11.2%11.2%
Total 100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%
Total Cost
Treatment 5,433,863$ 5,699,069$ 6050382.294 5,910,831$ 6,162,645$ 6,347,306$ 6,573,402$ 6,808,385$ 7,052,503$ 7,309,256$
Distribution 338,610 355,136 377,028 368,332 384,024 395,531 409,620 424,263 439,475 455,475
Administration 1,595,736 1,673,617 1,776,786 1,735,805 1,809,754 1,863,982 1,930,379 1,999,385 2,071,074 2,146,473
Customer 313,595 328,900 349,175 341,121 355,654 366,311 379,359 392,920 407,009 421,826
Reclaimed Water 966,058 1,013,208 1,075,666 1,050,856 1,095,625 1,128,455 1,168,651 1,210,428 1,253,828 1,299,475
Total 8,647,862$ 9,069,931$ 9,629,038$ 9,406,945$ 9,807,701$ 10,101,585$ 10,461,412$ 10,835,380$ 11,223,889$ 11,632,504$
Total Water Operating Expenses 12,310,079$ 12,796,184$ 13,420,608$ 13,265,139$ 13,733,851$ 14,097,050$ 14,527,577$ 14,973,661$ 15,435,727$ 15,919,371$
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 43
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W5
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 5.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
CAPITAL OUTLAYS
Water Capital Outlays
Treatment 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$ 2,500$
Distribution 3,351,000 1,510,000 3,090,000 3,090,000 3,090,000 3,090,000 3,090,000 3,090,000 3,090,000 3,090,000
Administration 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000
Customer 8,150 8,150 8,150 8,150 8,150 8,150 8,150 8,150 8,150 8,150
Reclaimed Water - - - - - - - - - -
Total Water Capital Outlays 3,511,650$ 1,670,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$ 3,250,650$
TRANSFERS
Water Allocated Transfers
Treatment 0.00%-$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Distribution 0.00%- - - - - - - - - -
Administration 0.00%- - - - - - - - - -
Customer 0.00%- - - - - - - - - -
Reclaimed Water 0.00%- - - - - - - - - -
Total Water Transfers -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
CURRENT DEBT SERVICE
Water Debt Service
Treatment 2,230,122$ 2,168,964$ 1,259,009$ 1,053,340$ 1,055,341$ 1,056,448$ 1,052,036$ 821,132$ 346,938$ 256,719$
Distribution 2,705,189 2,611,277 2,419,599 2,372,743 2,371,936 2,221,993 582,310 530,029 277,191 256,719
Administration - - - - - - - - - -
Customer - - - - - - - - - -
Reclaimed Water - - - - - - - - - -
Total Current Water Debt Service 4,935,311$ 4,780,241$ 3,678,607$ 3,426,083$ 3,427,277$ 3,278,441$ 1,634,346$ 1,351,161$ 624,129$ 513,438$
FUTURE DEBT SERVICE
Water Debt Service
Treatment -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Distribution - 600,427 600,427 600,427 600,427 600,427 600,427 600,427 600,427 600,427
Administration - - - - - - - - - -
Customer - - - - - - - - - -
Reclaimed Water - - - - - - - - - -
Total Future Water Debt Service -$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$ 600,427$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 44
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W5
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 5.0 -- WATER Service Cost Functionalization
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
TOTAL COST OF SERVICE
Total Water COS
Treatment 8,230,058$ 8,443,961$ 7,895,370$ 7,560,403$ 7,824,676$ 8,021,111$ 8,253,675$ 8,268,851$ 8,050,095$ 8,228,174$
Distribution 6,920,541 5,611,775 7,031,366 6,985,378 7,010,019 6,881,533 5,266,089 5,238,804 5,011,737 5,018,036
Administration 3,421,266 3,528,446 3,661,498 3,650,998 3,756,038 3,841,980 3,940,723 4,042,723 4,148,066 4,257,792
Customer 978,523 1,005,313 1,037,301 1,041,196 1,067,915 1,091,003 1,116,731 1,143,225 1,170,505 1,198,778
Reclaimed Water 1,206,652 1,258,008 1,324,758 1,304,324 1,353,558 1,390,941 1,435,782 1,482,296 1,530,529 1,581,105
Total 20,757,039$ 19,847,502$ 20,950,293$ 20,542,299$ 21,012,205$ 21,226,568$ 20,013,001$ 20,175,900$ 19,910,933$ 20,283,887$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 45
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W6
10 Year Forecast
2022 - 2031
Allocation
%2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 6.0 -- Water Cost Classification
Scenario:2022 02 18 -- Equal Percent Adjustments
Total Water Costs
Treatment 8,230,058$ 8,443,961$ 7,895,370$ 7,560,403$ 7,824,676$ 8,021,111$ 8,253,675$ 8,268,851$ 8,050,095$ 8,228,174$
Distribution 6,920,541 5,611,775 7,031,366 6,985,378 7,010,019 6,881,533 5,266,089 5,238,804 5,011,737 5,018,036
Admin 3,421,266 3,528,446 3,661,498 3,650,998 3,756,038 3,841,980 3,940,723 4,042,723 4,148,066 4,257,792
Customer 978,523 1,005,313 1,037,301 1,041,196 1,067,915 1,091,003 1,116,731 1,143,225 1,170,505 1,198,778
Potable Water Costs 19,550,388 18,589,494 19,625,535 19,237,975 19,658,648 19,835,627 18,577,218 18,693,603 18,380,404 18,702,781
Reclaimed Water 1,206,652 1,258,008 1,324,758 1,304,324 1,353,558 1,390,941 1,435,782 1,482,296 1,530,529 1,581,105
Total Water System Costs 20,757,039 19,847,502 20,950,293 20,542,299 21,012,205 21,226,568 20,013,001 20,175,900 19,910,933 20,283,887
Water Cost Classification: POTABLE WATER
Base 62.66%12,249,646 11,647,581 12,296,731 12,053,899 12,317,479 12,428,368 11,639,890 11,712,813 11,516,572 11,718,564
Max Day/Extra Capacity 31.33%6,124,823 5,823,791 6,148,366 6,026,949 6,158,739 6,214,184 5,819,945 5,856,406 5,758,286 5,859,282
Customer Billing 6.01%1,175,918 1,118,122 1,180,438 1,157,127 1,182,430 1,193,075 1,117,384 1,124,384 1,105,546 1,124,936
Sub-Total 100.00%19,550,388 18,589,494 19,625,535 19,237,975 19,658,648 19,835,627 18,577,218 18,693,603 18,380,404 18,702,781
Less Non-Rate Revenues
Base 62.66%2,111,239 2,128,210 2,139,823 2,147,655 2,155,488 2,163,320 2,171,152 2,178,985 2,186,817 2,194,649
Max Day/Extra Capacity 31.33%1,055,620 1,064,105 1,069,912 1,073,828 1,077,744 1,081,660 1,085,576 1,089,492 1,093,408 1,097,325
Customer Billing 6.01%202,671 204,300 205,415 206,166 206,918 207,670 208,422 209,174 209,926 210,678
Sub-Total 100.00%3,369,530 3,396,614 3,415,149 3,427,650 3,440,150 3,452,650 3,465,151 3,477,651 3,490,151 3,502,652
Net Water Cost Classification
Base 10,138,407 9,519,372 10,156,908 9,906,243 10,161,991 10,265,048 9,468,737 9,533,828 9,329,755 9,523,914
Max Day/Extra Capacity 5,069,203 4,759,686 5,078,454 4,953,122 5,080,996 5,132,524 4,734,369 4,766,914 4,664,877 4,761,957
Customer Billing 973,247 913,822 975,023 950,961 975,511 985,404 908,962 915,210 895,620 914,258
Total 16,180,858 15,192,880 16,210,386 15,810,325 16,218,498 16,382,976 15,112,068 15,215,952 14,890,252 15,200,130
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 46
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W7
10 Year Forecast
2022 - 2031 Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 7.0 -- Customer and Volume Totals
Scenario:2022 02 18 -- Equal Percent Adjustments
WATER VOLUMES
Customer Class Units -- Base Annual Usage
W1 Residential & Irrigation 5/8"1,444,476,233 1,464,689,421 1,479,675,060 1,489,781,654 1,499,888,248 1,509,994,842 1,520,101,436 1,530,208,030 1,540,314,624 1,550,421,218
W2 Residential & Irrigation 3/4"188,922,762 191,566,441 193,526,410 194,848,249 196,170,089 197,491,928 198,813,767 200,135,607 201,457,446 202,779,286
W3 Residential & Irrigation 1"152,687,088 154,823,705 156,407,749 157,476,057 158,544,366 159,612,675 160,680,983 161,749,292 162,817,600 163,885,909
W4 Residential & Irrigation 1.5"38,938,765 39,483,652 39,887,620 40,160,064 40,432,507 40,704,951 40,977,395 41,249,838 41,522,282 41,794,725
W5 Residential & Irrigation 2"93,165,025 94,468,724 95,435,259 96,087,109 96,738,958 97,390,808 98,042,657 98,694,507 99,346,356 99,998,206
W6 Residential & Irrigation 3"16,881,063 17,117,287 17,292,418 17,410,530 17,528,642 17,646,754 17,764,867 17,882,979 18,001,091 18,119,203
W7 Residential & Irrigation 4"50,041,170 50,741,418 51,260,567 51,610,691 51,960,815 52,310,939 52,661,063 53,011,187 53,361,311 53,711,435
W8 Commercial, Turf & Multifamily 327,014,495 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642
W9 Construction 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280
Total Potable 2,350,463,880 2,380,557,569 2,401,152,005 2,415,041,276 2,428,930,547 2,442,819,819 2,456,709,090 2,470,598,361 2,484,487,632 2,498,376,903
W10 Reclaimed Water 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096
Total System 2,944,319,976 2,974,413,665 2,995,008,101 3,008,897,372 3,022,786,643 3,036,675,915 3,050,565,186 3,064,454,457 3,078,343,728 3,092,232,999
Percent of Total
W1 Residential & Irrigation 5/8"61.45%61.53%61.62%61.69%61.75%61.81%61.88%61.94%62.00%62.06%
W2 Residential & Irrigation 3/4"8.04%8.05%8.06%8.07%8.08%8.08%8.09%8.10%8.11%8.12%
W3 Residential & Irrigation 1"6.50%6.50%6.51%6.52%6.53%6.53%6.54%6.55%6.55%6.56%
W4 Residential & Irrigation 1.5"1.66%1.66%1.66%1.66%1.66%1.67%1.67%1.67%1.67%1.67%
W5 Residential & Irrigation 2"3.96%3.97%3.97%3.98%3.98%3.99%3.99%3.99%4.00%4.00%
W6 Residential & Irrigation 3"0.72%0.72%0.72%0.72%0.72%0.72%0.72%0.72%0.72%0.73%
W7 Residential & Irrigation 4"2.13%2.13%2.13%2.14%2.14%2.14%2.14%2.15%2.15%2.15%
W8 Commercial, Turf & Multifamily 13.91%13.83%13.72%13.64%13.56%13.48%13.41%13.33%13.26%13.18%
W9 Construction 1.63%1.61%1.60%1.59%1.58%1.57%1.56%1.55%1.54%1.53%
Total Potable Water 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%
W10 Reclaimed Water na na na na na na na na na na
Net Annual Volume after Minimum:
W1 Residential & Irrigation 5/8"1,444,476,233 1,464,689,421 1,479,675,060 1,489,781,654 1,499,888,248 1,509,994,842 1,520,101,436 1,530,208,030 1,540,314,624 1,550,421,218
W2 Residential & Irrigation 3/4"188,922,762 191,566,441 193,526,410 194,848,249 196,170,089 197,491,928 198,813,767 200,135,607 201,457,446 202,779,286
W3 Residential & Irrigation 1"152,687,088 154,823,705 156,407,749 157,476,057 158,544,366 159,612,675 160,680,983 161,749,292 162,817,600 163,885,909
W4 Residential & Irrigation 1.5"38,938,765 39,483,652 39,887,620 40,160,064 40,432,507 40,704,951 40,977,395 41,249,838 41,522,282 41,794,725
W5 Residential & Irrigation 2"93,165,025 94,468,724 95,435,259 96,087,109 96,738,958 97,390,808 98,042,657 98,694,507 99,346,356 99,998,206
W6 Residential & Irrigation 3"16,881,063 17,117,287 17,292,418 17,410,530 17,528,642 17,646,754 17,764,867 17,882,979 18,001,091 18,119,203
W7 Residential & Irrigation 4"50,041,170 50,741,418 51,260,567 51,610,691 51,960,815 52,310,939 52,661,063 53,011,187 53,361,311 53,711,435
W8 Commercial, Turf & Multifamily 327,014,495 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642
W9 Construction 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280
Total Potable Water 2,350,463,880 2,380,557,569 2,401,152,005 2,415,041,276 2,428,930,547 2,442,819,819 2,456,709,090 2,470,598,361 2,484,487,632 2,498,376,903
W10 Reclaimed Water 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096
Total System 2,944,319,976 2,974,413,665 2,995,008,101 3,008,897,372 3,022,786,643 3,036,675,915 3,050,565,186 3,064,454,457 3,078,343,728 3,092,232,999
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 47
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W7
10 Year Forecast
2022 - 2031 Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 7.0 -- Customer and Volume Totals
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Customer Class Units -- Base Daily Average
W1 Residential & Irrigation 5/8"3,957,469 4,012,848 4,053,904 4,081,594 4,109,283 4,136,972 4,164,661 4,192,351 4,220,040 4,247,729
W2 Residential & Irrigation 3/4"517,596.61 524,840 530,209 533,831 537,452 541,074 544,695 548,317 551,938 555,560
W3 Residential & Irrigation 1"418,321 424,175 428,514 431,441 434,368 437,295 440,222 443,149 446,076 449,002
W4 Residential & Irrigation 1.5"106,682 108,174 109,281 110,028 110,774 111,520 112,267 113,013 113,760 114,506
W5 Residential & Irrigation 2"255,247 258,818 261,466 263,252 265,038 266,824 268,610 270,396 272,182 273,968
W6 Residential & Irrigation 3"46,249 46,897 47,376 47,700 48,024 48,347 48,671 48,994 49,318 49,642
W7 Residential & Irrigation 4"137,099 139,018 140,440 141,399 142,358 143,318 144,277 145,236 146,195 147,155
W8 Commercial, Turf & Multifamily 895,930 902,273 902,273 902,273 902,273 902,273 902,273 902,273 902,273 902,273
W9 Construction 105,034 105,034 105,034 105,034 105,034 105,034 105,034 105,034 105,034 105,034
Total Potable Water 6,439,627 6,522,076 6,578,499 6,616,551 6,654,604 6,692,657 6,730,710 6,768,763 6,806,815 6,844,868
W10 Reclaimed Water 1,627,003 1,627,003 1,627,003 1,627,003 1,627,003 1,627,003 1,627,003 1,627,003 1,627,003 1,627,003
Total System 8,066,630 8,149,079 8,205,502 8,243,554 8,281,607 8,319,660 8,357,713 8,395,766 8,433,818 8,471,871
Customer Class Units -- Capacity Factor
W1 Residential & Irrigation 5/8"130 130 130 130 130 130 130 130 130 130
W2 Residential & Irrigation 3/4"131 131 131 131 131 131 131 131 131 131
W3 Residential & Irrigation 1"138 138 138 138 138 138 138 138 138 138
W4 Residential & Irrigation 1.5"168 168 168 168 168 168 168 168 168 168
W5 Residential & Irrigation 2"159 159 159 159 159 159 159 159 159 159
W6 Residential & Irrigation 3"194 194 194 194 194 194 194 194 194 194
W7 Residential & Irrigation 4"162 162 162 162 162 162 162 162 162 162
W8 Commercial, Turf & Multifamily 109 109 109 109 109 109 109 109 109 109
W9 Construction 96 96 96 96 96 96 96 96 96 96
W10 Reclaimed Water 177 177 177 177 177 177 177 177 177 177
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 48
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W7
10 Year Forecast
2022 - 2031 Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 7.0 -- Customer and Volume Totals
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Customer Class Units -- Total Capacity
W1 Residential & Irrigation 5/8"5,126,296 5,198,030 5,251,213 5,287,080 5,322,947 5,358,815 5,394,682 5,430,549 5,466,416 5,502,284
W2 Residential & Irrigation 3/4"677,963 687,450 694,484 699,227 703,971 708,714 713,458 718,201 722,945 727,688
W3 Residential & Irrigation 1"575,342 583,393 589,361 593,387 597,412 601,438 605,463 609,489 613,514 617,540
W4 Residential & Irrigation 1.5"179,342 181,852 183,713 184,967 186,222 187,477 188,732 189,987 191,242 192,496
W5 Residential & Irrigation 2"405,633 411,309 415,517 418,355 421,193 424,032 426,870 429,708 432,546 435,384
W6 Residential & Irrigation 3"89,527 90,779 91,708 92,334 92,961 93,587 94,214 94,840 95,466 96,093
W7 Residential & Irrigation 4"222,380 225,492 227,799 229,355 230,911 232,467 234,023 235,578 237,134 238,690
W8 Commercial, Turf & Multifamily 980,096 987,034 987,034 987,034 987,034 987,034 987,034 987,034 987,034 987,034
W9 Construction 101,096 101,096 101,096 101,096 101,096 101,096 101,096 101,096 101,096 101,096
Total Portable Water 8,357,674 8,466,435 8,541,925 8,592,836 8,643,748 8,694,659 8,745,571 8,796,482 8,847,394 8,898,305
W10 Reclaimed Water 2,880,427 2,880,427 2,880,427 2,880,427 2,880,427 2,880,427 2,880,427 2,880,427 2,880,427 2,880,427
Total System 11,238,101 11,346,863 11,422,352 11,473,264 11,524,175 11,575,087 11,625,998 11,676,910 11,727,821 11,778,733
Customer Class Units -- Extra Capacity
W1 Residential & Irrigation 5/8"1,168,827 1,185,183 1,197,309 1,205,486 1,213,664 1,221,842 1,230,020 1,238,198 1,246,376 1,254,554
W2 Residential & Irrigation 3/4"160,366 162,611 164,274 165,396 166,518 167,640 168,762 169,884 171,006 172,128
W3 Residential & Irrigation 1"157,021 159,218 160,847 161,946 163,044 164,143 165,242 166,340 167,439 168,537
W4 Residential & Irrigation 1.5"72,661 73,678 74,432 74,940 75,448 75,957 76,465 76,973 77,482 77,990
W5 Residential & Irrigation 2"150,386 152,491 154,051 155,103 156,155 157,207 158,260 159,312 160,364 161,416
W6 Residential & Irrigation 3"43,277 43,883 44,332 44,634 44,937 45,240 45,543 45,846 46,148 46,451
W7 Residential & Irrigation 4"85,281 86,474 87,359 87,956 88,552 89,149 89,746 90,342 90,939 91,536
W8 Commercial, Turf & Multifamily 84,165 84,761 84,761 84,761 84,761 84,761 84,761 84,761 84,761 84,761
W9 Construction (3,938) (3,938) (3,938) (3,938) (3,938) (3,938) (3,938) (3,938) (3,938) (3,938)
Total Potable Water 1,918,047 1,944,360 1,963,426 1,976,285 1,989,144 2,002,002 2,014,861 2,027,720 2,040,578 2,053,437
W10 Reclaimed Water 1,253,424 1,253,424 1,253,424 1,253,424 1,253,424 1,253,424 1,253,424 1,253,424 1,253,424 1,253,424
Total System 3,171,471 3,197,784 3,216,851 3,229,709 3,242,568 3,255,427 3,268,285 3,281,144 3,294,003 3,306,862
Percent of Total
W1 Residential & Irrigation 5/8"60.94%60.95%60.98%61.00%61.01%61.03%61.05%61.06%61.08%61.10%
W2 Residential & Irrigation 3/4"8.36%8.36%8.37%8.37%8.37%8.37%8.38%8.38%8.38%8.38%
W3 Residential & Irrigation 1"8.19%8.19%8.19%8.19%8.20%8.20%8.20%8.20%8.21%8.21%
W4 Residential & Irrigation 1.5"3.79%3.79%3.79%3.79%3.79%3.79%3.80%3.80%3.80%3.80%
W5 Residential & Irrigation 2"7.84%7.84%7.85%7.85%7.85%7.85%7.85%7.86%7.86%7.86%
W6 Residential & Irrigation 3"2.26%2.26%2.26%2.26%2.26%2.26%2.26%2.26%2.26%2.26%
W7 Residential & Irrigation 4"4.45%4.45%4.45%4.45%4.45%4.45%4.45%4.46%4.46%4.46%
W8 Commercial, Turf & Multifamily 4.39%4.36%4.32%4.29%4.26%4.23%4.21%4.18%4.15%4.13%
W9 Construction -0.21%-0.20%-0.20%-0.20%-0.20%-0.20%-0.20%-0.19%-0.19%-0.19%
Total Potable Water 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%
W10 Reclaimed Water na na na na na na na na na na
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 49
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W7
10 Year Forecast
2022 - 2031 Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 7.0 -- Customer and Volume Totals
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Customer Class Units -- Annual Bills
Total Bills
W1 Residential & Irrigation 5/8"218,657 221,716 223,985 225,515 227,045 228,575 230,104 231,634 233,164 234,694
W2 Residential & Irrigation 3/4"21,252 21,550 21,770 21,919 22,068 22,216 22,365 22,514 22,662 22,811
W3 Residential & Irrigation 1"7,157 7,257 7,332 7,382 7,432 7,482 7,532 7,582 7,632 7,682
W4 Residential & Irrigation 1.5"646 655 662 666 671 676 680 685 689 694
W5 Residential & Irrigation 2"890 903 912 918 924 930 937 943 949 955
W6 Residential & Irrigation 3"24 25 25 25 25 25 26 26 26 26
W7 Residential & Irrigation 4"61 62 62 63 63 64 64 65 65 65
W8 Commercial, Turf & Multifamily 6,780 6,828 6,876 6,924 6,972 7,020 7,068 7,116 7,164 7,212
W9 Construction 360 360 360 360 360 360 360 360 360 360
W10 Reclaimed Water 144 144 144 144 144 144 144 144 144 144
Total System 255,972 259,500 262,128 263,916 265,704 267,492 269,280 271,068 272,856 274,644
Percentage of Total
W1 Residential & Irrigation 5/8"85.42%85.44%85.45%85.45%85.45%85.45%85.45%85.45%85.45%85.45%
W2 Residential & Irrigation 3/4"8.30%8.30%8.31%8.31%8.31%8.31%8.31%8.31%8.31%8.31%
W3 Residential & Irrigation 1"2.80%2.80%2.80%2.80%2.80%2.80%2.80%2.80%2.80%2.80%
W4 Residential & Irrigation 1.5"0.25%0.25%0.25%0.25%0.25%0.25%0.25%0.25%0.25%0.25%
W5 Residential & Irrigation 2"0.35%0.35%0.35%0.35%0.35%0.35%0.35%0.35%0.35%0.35%
W6 Residential & Irrigation 3"0.01%0.01%0.01%0.01%0.01%0.01%0.01%0.01%0.01%0.01%
W7 Residential & Irrigation 4"0.02%0.02%0.02%0.02%0.02%0.02%0.02%0.02%0.02%0.02%
W8 Commercial, Turf & Multifamily 2.65%2.63%2.62%2.62%2.62%2.62%2.62%2.63%2.63%2.63%
W9 Construction 0.14%0.14%0.14%0.14%0.14%0.13%0.13%0.13%0.13%0.13%
W10 Reclaimed Water 0.06%0.06%0.05%0.05%0.05%0.05%0.05%0.05%0.05%0.05%
Total System 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%
Total Customers
W1 Residential & Irrigation 5/8"18,221 18,476 18,665 18,793 18,920 19,048 19,175 19,303 19,430 19,558
W2 Residential & Irrigation 3/4"1,771 1,796 1,814 1,827 1,839 1,851 1,864 1,876 1,889 1,901
W3 Residential & Irrigation 1"596 605 611 615 619 623 628 632 636 640
W4 Residential & Irrigation 1.5"54 55 55 56 56 56 57 57 57 58
W5 Residential & Irrigation 2"74 75 76 77 77 78 78 79 79 80
W6 Residential & Irrigation 3"2 2 2 2 2 2 2 2 2 2
W7 Residential & Irrigation 4"5 5 5 5 5 5 5 5 5 5
W8 Commercial, Turf & Multifamily 565 569 573 577 581 585 589 593 597 601
W9 Construction 30 30 30 30 30 30 30 30 30 30
W10 Reclaimed Water 12 12 12 12 12 12 12 12 12 12
Total System 21,331 21,625 21,844 21,993 22,142 22,291 22,440 22,589 22,738 22,887
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 50
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W7
10 Year Forecast
2022 - 2031 Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 7.0 -- Customer and Volume Totals
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
NEW Customers
W1 Residential & Irrigation 5/8"255 189 127 127 127 127 127 127 127
W2 Residential & Irrigation 3/4"25 18 12 12 12 12 12 12 12
W3 Residential & Irrigation 1"8 6 4 4 4 4 4 4 4
W4 Residential & Irrigation 1.5"1 1 0 0 0 0 0 0 0
W5 Residential & Irrigation 2"1 1 1 1 1 1 1 1 1
W6 Residential & Irrigation 3"0 0 0 0 0 0 0 0 0
W7 Residential & Irrigation 4"0 0 0 0 0 0 0 0 0
W8 Commercial, Turf & Multifamily 4 4 4 4 4 4 4 4 4
W9 Construction - - - - - - - - -
W10 Reclaimed Water - - - - - - - - -
Total System 294 219 149 149 149 149 149 149 149
Monthly Volume Per Meter
W1 Residential & Irrigation 5/8"6,606 6,606 6,606 6,606 6,606 6,606 6,606 6,606 6,606 6,606
W2 Residential & Irrigation 3/4"8,889 8,889 8,889 8,889 8,889 8,889 8,889 8,889 8,889 8,889
W3 Residential & Irrigation 1"21,333 21,333 21,333 21,333 21,333 21,333 21,333 21,333 21,333 21,333
W4 Residential & Irrigation 1.5"60,255 60,255 60,255 60,255 60,255 60,255 60,255 60,255 60,255 60,255
W5 Residential & Irrigation 2"104,670 104,670 104,670 104,670 104,670 104,670 104,670 104,670 104,670 104,670
W6 Residential & Irrigation 3"692,245 692,245 692,245 692,245 692,245 692,245 692,245 692,245 692,245 692,245
W7 Residential & Irrigation 4"820,819 820,819 820,819 820,819 820,819 820,819 820,819 820,819 820,819 820,819
W8 Commercial, Turf & Multifamily 48,232 48,232 47,896 47,563 47,236 46,913 46,594 46,280 45,970 45,664
W9 Construction 106,492 106,492 106,492 106,492 106,492 106,492 106,492 106,492 106,492 106,492
W10 Reclaimed Water 4,124,001 4,124,001 4,124,001 4,124,001 4,124,001 4,124,001 4,124,001 4,124,001 4,124,001 4,124,001
Total System 11,503 11,462 11,426 11,401 11,377 11,352 11,329 11,305 11,282 11,259
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 51
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
Total Cost of Service
Base 10,138,407$ 9,519,372$ 10,156,908$ 9,906,243$ 10,161,991$ 10,265,048$ 9,468,737$ 9,533,828$ 9,329,755$ 9,523,914$
Max Day/Extra Capacity 5,069,203 4,759,686 5,078,454 4,953,122 5,080,996 5,132,524 4,734,369 4,766,914 4,664,877 4,761,957
Sub-Total Non Customer 15,207,610 14,279,058 15,235,363 14,859,365 15,242,987 15,397,572 14,203,106 14,300,742 13,994,632 14,285,871
Customer 973,247 913,822 975,023 950,961 975,511 985,404 908,962 915,210 895,620 914,258
Total Potable Water Cost of Service 16,180,858 15,192,880 16,210,386 15,810,325 16,218,498 16,382,976 15,112,068 15,215,952 14,890,252 15,200,130
Reclaimed Water Cost of Service 1,206,652 1,258,008 1,324,758 1,304,324 1,353,558 1,390,941 1,435,782 1,482,296 1,530,529 1,581,105
Total Cost of Service/Net Revenue Requirement 17,387,509 16,450,888 17,535,144 17,114,650 17,572,056 17,773,918 16,547,850 16,698,249 16,420,782 16,781,235
TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE
Customer Class Allocation Factors:
Base
Residential & Irrigation 5/8"61.45%61.53%61.62%61.69%61.75%61.81%61.88%61.94%62.00%62.06%
Residential & Irrigation 3/4"8.04%8.05%8.06%8.07%8.08%8.08%8.09%8.10%8.11%8.12%
Residential & Irrigation 1"6.50%6.50%6.51%6.52%6.53%6.53%6.54%6.55%6.55%6.56%
Residential & Irrigation 1.5"1.66%1.66%1.66%1.66%1.66%1.67%1.67%1.67%1.67%1.67%
Residential & Irrigation 2"3.96%3.97%3.97%3.98%3.98%3.99%3.99%3.99%4.00%4.00%
Residential & Irrigation 3"0.72%0.72%0.72%0.72%0.72%0.72%0.72%0.72%0.72%0.73%
Residential & Irrigation 4"2.13%2.13%2.13%2.14%2.14%2.14%2.14%2.15%2.15%2.15%
Commercial, Turf & Multifamily 13.91%13.83%13.72%13.64%13.56%13.48%13.41%13.33%13.26%13.18%
Construction 1.63%1.61%1.60%1.59%1.58%1.57%1.56%1.55%1.54%1.53%
Toal Potable Water 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%
Reclaimed Water na na na na na na na na na na
Max Day/Extra Capacity
Residential & Irrigation 5/8"60.94%60.95%60.98%61.00%61.01%61.03%61.05%61.06%61.08%61.10%
Residential & Irrigation 3/4"8.36%8.36%8.37%8.37%8.37%8.37%8.38%8.38%8.38%8.38%
Residential & Irrigation 1"8.19%8.19%8.19%8.19%8.20%8.20%8.20%8.20%8.21%8.21%
Residential & Irrigation 1.5"3.79%3.79%3.79%3.79%3.79%3.79%3.80%3.80%3.80%3.80%
Residential & Irrigation 2"7.84%7.84%7.85%7.85%7.85%7.85%7.85%7.86%7.86%7.86%
Residential & Irrigation 3"2.26%2.26%2.26%2.26%2.26%2.26%2.26%2.26%2.26%2.26%
Residential & Irrigation 4"4.45%4.45%4.45%4.45%4.45%4.45%4.45%4.46%4.46%4.46%
Commercial, Turf & Multifamily 4.39%4.36%4.32%4.29%4.26%4.23%4.21%4.18%4.15%4.13%
Construction -0.21%-0.20%-0.20%-0.20%-0.20%-0.20%-0.20%-0.19%-0.19%-0.19%
Toal Potable Water 100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%100.00%
Reclaimed Water na na na na na na na na na na
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 52
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Customer
Residential & Irrigation 5/8"85.42%85.44%85.45%85.45%85.45%85.45%85.45%85.45%85.45%85.45%
Residential & Irrigation 3/4"8.30%8.30%8.31%8.31%8.31%8.31%8.31%8.31%8.31%8.31%
Residential & Irrigation 1"2.80%2.80%2.80%2.80%2.80%2.80%2.80%2.80%2.80%2.80%
Residential & Irrigation 1.5"0.25%0.25%0.25%0.25%0.25%0.25%0.25%0.25%0.25%0.25%
Residential & Irrigation 2"0.35%0.35%0.35%0.35%0.35%0.35%0.35%0.35%0.35%0.35%
Residential & Irrigation 3"0.01%0.01%0.01%0.01%0.01%0.01%0.01%0.01%0.01%0.01%
Residential & Irrigation 4"0.02%0.02%0.02%0.02%0.02%0.02%0.02%0.02%0.02%0.02%
Commercial, Turf & Multifamily 2.65%2.63%2.62%2.62%2.62%2.62%2.62%2.63%2.63%2.63%
Construction 0.14%0.14%0.14%0.14%0.14%0.13%0.13%0.13%0.13%0.13%
Reclaimed Water 0.06%0.06%0.05%0.05%0.05%0.05%0.05%0.05%0.05%0.05%
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 53
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Total Cost by Customer Class
Residential & Irrigation 5/8"
Base 6,230,552$ 5,856,999$ 6,259,047$ 6,110,926$ 6,275,128$ 6,345,196$ 5,858,830$ 5,904,942$ 5,784,194$ 5,910,269$
Max Day/Extra Capacity 3,089,091 2,901,262 3,096,870 3,021,286 3,100,140 3,132,432 2,890,209 2,910,848 2,849,286 2,909,333
Customer 831,368 780,769 833,145 812,591 833,577 842,038 776,723 782,070 765,336 781,270
Total Cost of Service 10,151,012$ 9,539,029$ 10,189,062$ 9,944,803$ 10,208,845$ 10,319,665$ 9,525,763$ 9,597,860$ 9,398,816$ 9,600,872$
Calculation of Customer Costs/Bill
Total Customer Costs 831,368$ 780,769$ 833,145$ 812,591$ 833,577$ 842,038$ 776,723$ 782,070$ 765,336$ 781,270$
Total Bills 218,657 221,716 223,985 225,515 227,045 228,575 230,104 231,634 233,164 234,694
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 9,319,643$ 8,758,261$ 9,355,918$ 9,132,212$ 9,375,268$ 9,477,627$ 8,749,039$ 8,815,791$ 8,633,480$ 8,819,602$
Total Volume 1,444,476,233 1,464,689,421 1,479,675,060 1,489,781,654 1,499,888,248 1,509,994,842 1,520,101,436 1,530,208,030 1,540,314,624 1,550,421,218
Total Non-Customer Cost 6.45$ 5.98$ 6.32$ 6.13$ 6.25$ 6.28$ 5.76$ 5.76$ 5.61$ 5.69$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 6.45$ 5.98$ 6.32$ 6.13$ 6.25$ 6.28$ 5.76$ 5.76$ 5.61$ 5.69$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 218,657 221,716 223,985 225,515 227,045 228,575 230,104 231,634 233,164 234,694
Revenue from Minimum Charge 831,368$ 780,769$ 833,145$ 812,591$ 833,577$ 842,038$ 776,723$ 782,070$ 765,336$ 781,270$
Total Cost of Service 10,151,012$ 9,539,029$ 10,189,062$ 9,944,803$ 10,208,845$ 10,319,665$ 9,525,763$ 9,597,860$ 9,398,816$ 9,600,872$
Net Cost of Service 9,319,643$ 8,758,261$ 9,355,918$ 9,132,212$ 9,375,268$ 9,477,627$ 8,749,039$ 8,815,791$ 8,633,480$ 8,819,602$
Test Year Annual Volume after Minimum 1,444,476,233 1,464,689,421 1,479,675,060 1,489,781,654 1,499,888,248 1,509,994,842 1,520,101,436 1,530,208,030 1,540,314,624 1,550,421,218
Net Volumetric Charge 6.45$ 5.98$ 6.32$ 6.13$ 6.25$ 6.28$ 5.76$ 5.76$ 5.61$ 5.69$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 54
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Residential & Irrigation 3/4"
Base 814,893$ 766,036$ 818,620$ 799,247$ 820,723$ 829,887$ 766,275$ 772,306$ 756,514$ 773,003$
Max Day/Extra Capacity 423,832 398,062 424,900 414,529 425,348 429,779 396,545 399,377 390,930 399,169
Customer 80,805 75,887 80,978 78,980 81,020 81,842 75,494 76,013 74,387 75,936
Total Cost of Service 1,319,530$ 1,239,984$ 1,324,497$ 1,292,756$ 1,327,091$ 1,341,508$ 1,238,314$ 1,247,696$ 1,221,831$ 1,248,107$
Calculation of Customer Costs/Bill
Total Customer Costs 80,805$ 75,887$ 80,978$ 78,980$ 81,020$ 81,842$ 75,494$ 76,013$ 74,387$ 75,936$
Total Bills 21,252 21,550 21,770 21,919 22,068 22,216 22,365 22,514 22,662 22,811
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 1,238,725$ 1,164,097$ 1,243,519$ 1,213,776$ 1,246,071$ 1,259,666$ 1,162,820$ 1,171,683$ 1,147,444$ 1,172,172$
Total Volume 188,922,762 191,566,441 193,526,410 194,848,249 196,170,089 197,491,928 198,813,767 200,135,607 201,457,446 202,779,286
Total Non-Customer Cost 6.56$ 6.08$ 6.43$ 6.23$ 6.35$ 6.38$ 5.85$ 5.85$ 5.70$ 5.78$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 6.56$ 6.08$ 6.43$ 6.23$ 6.35$ 6.38$ 5.85$ 5.85$ 5.70$ 5.78$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 21,252 21,550 21,770 21,919 22,068 22,216 22,365 22,514 22,662 22,811
Revenue from Minimum Charge 80,805$ 75,887$ 80,978$ 78,980$ 81,020$ 81,842$ 75,494$ 76,013$ 74,387$ 75,936$
Total Cost of Service 1,319,530$ 1,239,984$ 1,324,497$ 1,292,756$ 1,327,091$ 1,341,508$ 1,238,314$ 1,247,696$ 1,221,831$ 1,248,107$
Net Cost of Service 1,238,725$ 1,164,097$ 1,243,519$ 1,213,776$ 1,246,071$ 1,259,666$ 1,162,820$ 1,171,683$ 1,147,444$ 1,172,172$
Test Year Annual Volume after Minimum 188,922,762 191,566,441 193,526,410 194,848,249 196,170,089 197,491,928 198,813,767 200,135,607 201,457,446 202,779,286
Net Volumetric Charge 6.56$ 6.08$ 6.43$ 6.23$ 6.35$ 6.38$ 5.85$ 5.85$ 5.70$ 5.78$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 55
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Residential & Irrigation 1"
Base 658,595$ 619,109$ 661,607$ 645,950$ 663,307$ 670,713$ 619,302$ 624,177$ 611,413$ 624,740$
Max Day/Extra Capacity 414,990 389,757 416,035 405,881 416,474 420,813 388,272 391,045 382,775 390,841
Customer 27,213 25,557 27,271 26,598 27,285 27,562 25,424 25,599 25,052 25,573
Total Cost of Service 1,100,798$ 1,034,423$ 1,104,914$ 1,078,430$ 1,107,067$ 1,119,088$ 1,032,999$ 1,040,821$ 1,019,239$ 1,041,154$
Calculation of Customer Costs/Bill
Total Customer Costs 27,213$ 25,557$ 27,271$ 26,598$ 27,285$ 27,562$ 25,424$ 25,599$ 25,052$ 25,573$
Total Bills 7,157 7,257 7,332 7,382 7,432 7,482 7,532 7,582 7,632 7,682
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 1,073,585$ 1,008,866$ 1,077,642$ 1,051,831$ 1,079,781$ 1,091,526$ 1,007,575$ 1,015,222$ 994,188$ 1,015,581$
Total Volume 152,687,088 154,823,705 156,407,749 157,476,057 158,544,366 159,612,675 160,680,983 161,749,292 162,817,600 163,885,909
Total Non-Customer Cost 7.03$ 6.52$ 6.89$ 6.68$ 6.81$ 6.84$ 6.27$ 6.28$ 6.11$ 6.20$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 7.03$ 6.52$ 6.89$ 6.68$ 6.81$ 6.84$ 6.27$ 6.28$ 6.11$ 6.20$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 7,157 7,257 7,332 7,382 7,432 7,482 7,532 7,582 7,632 7,682
Revenue from Minimum Charge 27,213$ 25,557$ 27,271$ 26,598$ 27,285$ 27,562$ 25,424$ 25,599$ 25,052$ 25,573$
Total Cost of Service 1,100,798$ 1,034,423$ 1,104,914$ 1,078,430$ 1,107,067$ 1,119,088$ 1,032,999$ 1,040,821$ 1,019,239$ 1,041,154$
Net Cost of Service 1,073,585$ 1,008,866$ 1,077,642$ 1,051,831$ 1,079,781$ 1,091,526$ 1,007,575$ 1,015,222$ 994,188$ 1,015,581$
Test Year Annual Volume after Minimum 152,687,088 154,823,705 156,407,749 157,476,057 158,544,366 159,612,675 160,680,983 161,749,292 162,817,600 163,885,909
Net Volumetric Charge 7.03$ 6.52$ 6.89$ 6.68$ 6.81$ 6.84$ 6.27$ 6.28$ 6.11$ 6.20$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 56
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Residential & Irrigation 1.5"
Base 167,957$ 157,887$ 168,725$ 164,732$ 169,159$ 171,048$ 157,937$ 159,180$ 155,925$ 159,323$
Max Day/Extra Capacity 192,035 180,359 192,519 187,820 192,722 194,730 179,672 180,955 177,128 180,861
Customer 2,457 2,308 2,462 2,402 2,464 2,489 2,296 2,311 2,262 2,309
Total Cost of Service 362,450$ 340,554$ 363,707$ 354,954$ 364,345$ 368,266$ 339,904$ 342,446$ 335,314$ 342,493$
Calculation of Customer Costs/Bill
Total Customer Costs 2,457$ 2,308$ 2,462$ 2,402$ 2,464$ 2,489$ 2,296$ 2,311$ 2,262$ 2,309$
Total Bills 646 655 662 666 671 676 680 685 689 694
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 359,993$ 338,246$ 361,244$ 352,553$ 361,881$ 365,777$ 337,608$ 340,135$ 333,052$ 340,184$
Total Volume 38,938,765 39,483,652 39,887,620 40,160,064 40,432,507 40,704,951 40,977,395 41,249,838 41,522,282 41,794,725
Total Non-Customer Cost 9.25$ 8.57$ 9.06$ 8.78$ 8.95$ 8.99$ 8.24$ 8.25$ 8.02$ 8.14$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 9.25$ 8.57$ 9.06$ 8.78$ 8.95$ 8.99$ 8.24$ 8.25$ 8.02$ 8.14$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 646 655 662 666 671 676 680 685 689 694
Revenue from Minimum Charge 2,457$ 2,308$ 2,462$ 2,402$ 2,464$ 2,489$ 2,296$ 2,311$ 2,262$ 2,309$
Total Cost of Service 362,450$ 340,554$ 363,707$ 354,954$ 364,345$ 368,266$ 339,904$ 342,446$ 335,314$ 342,493$
Net Cost of Service 359,993$ 338,246$ 361,244$ 352,553$ 361,881$ 365,777$ 337,608$ 340,135$ 333,052$ 340,184$
Test Year Annual Volume after Minimum 38,938,765 39,483,652 39,887,620 40,160,064 40,432,507 40,704,951 40,977,395 41,249,838 41,522,282 41,794,725
Net Volumetric Charge 9.25$ 8.57$ 9.06$ 8.78$ 8.95$ 8.99$ 8.24$ 8.25$ 8.02$ 8.14$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 57
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Residential & Irrigation 2"
Base 401,855$ 377,761$ 403,693$ 394,139$ 404,730$ 409,249$ 377,880$ 380,854$ 373,066$ 381,197$
Max Day/Extra Capacity 397,456 373,289 398,457 388,732 398,877 403,032 371,867 374,522 366,601 374,327
Customer 3,384 3,178 3,391 3,308 3,393 3,428 3,162 3,184 3,115 3,180
Total Cost of Service 802,695$ 754,228$ 805,541$ 786,178$ 807,000$ 815,709$ 752,908$ 758,559$ 742,783$ 758,705$
Calculation of Customer Costs/Bill
Total Customer Costs 3,384$ 3,178$ 3,391$ 3,308$ 3,393$ 3,428$ 3,162$ 3,184$ 3,115$ 3,180$
Total Bills 890 903 912 918 924 930 937 943 949 955
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 799,310$ 751,050$ 802,149$ 782,871$ 803,607$ 812,281$ 749,746$ 755,376$ 739,667$ 755,524$
Total Volume 93,165,025 94,468,724 95,435,259 96,087,109 96,738,958 97,390,808 98,042,657 98,694,507 99,346,356 99,998,206
Total Non-Customer Cost 8.58$ 7.95$ 8.41$ 8.15$ 8.31$ 8.34$ 7.65$ 7.65$ 7.45$ 7.56$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 8.58$ 7.95$ 8.41$ 8.15$ 8.31$ 8.34$ 7.65$ 7.65$ 7.45$ 7.56$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 890 903 912 918 924 930 937 943 949 955
Revenue from Minimum Charge 3,384$ 3,178$ 3,391$ 3,308$ 3,393$ 3,428$ 3,162$ 3,184$ 3,115$ 3,180$
Total Cost of Service 802,695$ 754,228$ 805,541$ 786,178$ 807,000$ 815,709$ 752,908$ 758,559$ 742,783$ 758,705$
Net Cost of Service 799,310$ 751,050$ 802,149$ 782,871$ 803,607$ 812,281$ 749,746$ 755,376$ 739,667$ 755,524$
Test Year Annual Volume after Minimum 93,165,025 94,468,724 95,435,259 96,087,109 96,738,958 97,390,808 98,042,657 98,694,507 99,346,356 99,998,206
Net Volumetric Charge 8.58$ 7.95$ 8.41$ 8.15$ 8.31$ 8.34$ 7.65$ 7.65$ 7.45$ 7.56$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 58
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Residential & Irrigation 3"
Base 72,814$ 68,449$ 73,147$ 71,416$ 73,335$ 74,154$ 68,470$ 69,009$ 67,598$ 69,071$
Max Day/Extra Capacity 114,377 107,422 114,665 111,866 114,786 115,982 107,013 107,777 105,498 107,721
Customer 93 87 93 91 93 94 87 87 85 87
Total Cost of Service 187,284$ 175,958$ 187,905$ 183,373$ 188,214$ 190,229$ 175,570$ 176,873$ 173,181$ 176,879$
Calculation of Customer Costs/Bill
Total Customer Costs 93$ 87$ 93$ 91$ 93$ 94$ 87$ 87$ 85$ 87$
Total Bills 24 25 25 25 25 25 26 26 26 26
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 187,191$ 175,871$ 187,812$ 183,282$ 188,121$ 190,136$ 175,483$ 176,786$ 173,096$ 176,792$
Total Volume 16,881,063 17,117,287 17,292,418 17,410,530 17,528,642 17,646,754 17,764,867 17,882,979 18,001,091 18,119,203
Total Non-Customer Cost 11.09$ 10.27$ 10.86$ 10.53$ 10.73$ 10.77$ 9.88$ 9.89$ 9.62$ 9.76$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 11.09$ 10.27$ 10.86$ 10.53$ 10.73$ 10.77$ 9.88$ 9.89$ 9.62$ 9.76$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 24 25 25 25 25 25 26 26 26 26
Revenue from Minimum Charge 93$ 87$ 93$ 91$ 93$ 94$ 87$ 87$ 85$ 87$
Total Cost of Service 187,284$ 175,958$ 187,905$ 183,373$ 188,214$ 190,229$ 175,570$ 176,873$ 173,181$ 176,879$
Net Cost of Service 187,191$ 175,871$ 187,812$ 183,282$ 188,121$ 190,136$ 175,483$ 176,786$ 173,096$ 176,792$
Test Year Annual Volume after Minimum 16,881,063 17,117,287 17,292,418 17,410,530 17,528,642 17,646,754 17,764,867 17,882,979 18,001,091 18,119,203
Net Volumetric Charge 11.09$ 10.27$ 10.86$ 10.53$ 10.73$ 10.77$ 9.88$ 9.89$ 9.62$ 9.76$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 59
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Residential & Irrigation 4"
Base 215,846$ 202,905$ 216,833$ 211,702$ 217,390$ 219,817$ 202,968$ 204,566$ 200,383$ 204,750$
Max Day/Extra Capacity 225,389 211,684 225,956 220,441 226,195 228,551 210,878 212,383 207,892 212,273
Customer 232 218 232 227 232 235 217 218 213 218
Total Cost of Service 441,466$ 414,806$ 443,021$ 432,369$ 443,817$ 448,603$ 414,062$ 417,167$ 408,488$ 417,241$
Calculation of Customer Costs/Bill
Total Customer Costs 232$ 218$ 232$ 227$ 232$ 235$ 217$ 218$ 213$ 218$
Total Bills 61 62 62 63 63 64 64 65 65 65
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 441,234$ 414,589$ 442,789$ 432,143$ 443,585$ 448,368$ 413,846$ 416,949$ 408,274$ 417,023$
Total Volume 50,041,170 50,741,418 51,260,567 51,610,691 51,960,815 52,310,939 52,661,063 53,011,187 53,361,311 53,711,435
Total Non-Customer Cost 8.82$ 8.17$ 8.64$ 8.37$ 8.54$ 8.57$ 7.86$ 7.87$ 7.65$ 7.76$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 8.82$ 8.17$ 8.64$ 8.37$ 8.54$ 8.57$ 7.86$ 7.87$ 7.65$ 7.76$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 61 62 62 63 63 64 64 65 65 65
Revenue from Minimum Charge 232$ 218$ 232$ 227$ 232$ 235$ 217$ 218$ 213$ 218$
Total Cost of Service 441,466$ 414,806$ 443,021$ 432,369$ 443,817$ 448,603$ 414,062$ 417,167$ 408,488$ 417,241$
Net Cost of Service 441,234$ 414,589$ 442,789$ 432,143$ 443,585$ 448,368$ 413,846$ 416,949$ 408,274$ 417,023$
Test Year Annual Volume after Minimum 50,041,170 50,741,418 51,260,567 51,610,691 51,960,815 52,310,939 52,661,063 53,011,187 53,361,311 53,711,435
Net Volumetric Charge 8.82$ 8.17$ 8.64$ 8.37$ 8.54$ 8.57$ 7.86$ 7.87$ 7.65$ 7.76$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 60
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Commercial, Turf & Multifamily
Base 1,410,533$ 1,316,923$ 1,393,069$ 1,350,875$ 1,377,827$ 1,383,886$ 1,269,314$ 1,270,855$ 1,236,700$ 1,255,418$
Max Day/Extra Capacity 222,441 207,491 219,237 212,435 216,511 217,302 199,166 199,263 193,769 196,563
Customer 25,779 24,045 25,576 24,949 25,597 25,861 23,858 24,026 23,515 24,008
Total Cost of Service 1,658,752$ 1,548,459$ 1,637,883$ 1,588,260$ 1,619,935$ 1,627,049$ 1,492,338$ 1,494,144$ 1,453,984$ 1,475,989$
Calculation of Customer Costs/Bill
Total Customer Costs 25,779$ 24,045$ 25,576$ 24,949$ 25,597$ 25,861$ 23,858$ 24,026$ 23,515$ 24,008$
Total Bills 6,780 6,828 6,876 6,924 6,972 7,020 7,068 7,116 7,164 7,212
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 1,632,973$ 1,524,414$ 1,612,307$ 1,563,311$ 1,594,338$ 1,601,188$ 1,468,480$ 1,470,118$ 1,430,469$ 1,451,981$
Total Volume 327,014,495 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642
Total Non-Customer Cost 4.99$ 4.63$ 4.90$ 4.75$ 4.84$ 4.86$ 4.46$ 4.46$ 4.34$ 4.41$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 4.99$ 4.63$ 4.90$ 4.75$ 4.84$ 4.86$ 4.46$ 4.46$ 4.34$ 4.41$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 6,780 6,828 6,876 6,924 6,972 7,020 7,068 7,116 7,164 7,212
Revenue from Minimum Charge 25,779$ 24,045$ 25,576$ 24,949$ 25,597$ 25,861$ 23,858$ 24,026$ 23,515$ 24,008$
Total Cost of Service 1,658,752$ 1,548,459$ 1,637,883$ 1,588,260$ 1,619,935$ 1,627,049$ 1,492,338$ 1,494,144$ 1,453,984$ 1,475,989$
Net Cost of Service 1,632,973$ 1,524,414$ 1,612,307$ 1,563,311$ 1,594,338$ 1,601,188$ 1,468,480$ 1,470,118$ 1,430,469$ 1,451,981$
Test Year Annual Volume after Minimum 327,014,495 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642 329,329,642
Net Volumetric Charge 4.99$ 4.63$ 4.90$ 4.75$ 4.84$ 4.86$ 4.46$ 4.46$ 4.34$ 4.41$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 61
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Construction
Base 165,363$ 153,303$ 162,167$ 157,255$ 160,393$ 161,098$ 147,761$ 147,940$ 143,964$ 146,143$
Max Day/Extra Capacity (10,407) (9,639) (10,185) (9,869) (10,058) (10,095) (9,253) (9,257) (9,002) (9,132)
Customer 1,369 1,268 1,339 1,297 1,322 1,326 1,215 1,215 1,182 1,198
Total Cost of Service 156,324$ 144,931$ 153,321$ 148,684$ 151,656$ 152,329$ 139,723$ 139,899$ 136,144$ 138,210$
Calculation of Customer Costs/Bill
Total Customer Costs 1,369$ 1,268$ 1,339$ 1,297$ 1,322$ 1,326$ 1,215$ 1,215$ 1,182$ 1,198$
Total Bills 360 360 360 360 360 360 360 360 360 360
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 154,956$ 143,664$ 151,982$ 147,386$ 150,334$ 151,003$ 138,508$ 138,683$ 134,962$ 137,012$
Total Volume 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280
Total Non-Customer Cost 4.04$ 3.75$ 3.96$ 3.84$ 3.92$ 3.94$ 3.61$ 3.62$ 3.52$ 3.57$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 4.04$ 3.75$ 3.96$ 3.84$ 3.92$ 3.94$ 3.61$ 3.62$ 3.52$ 3.57$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 360 360 360 360 360 360 360 360 360 360
Revenue from Minimum Charge 1,369$ 1,268$ 1,339$ 1,297$ 1,322$ 1,326$ 1,215$ 1,215$ 1,182$ 1,198$
Total Cost of Service 156,324$ 144,931$ 153,321$ 148,684$ 151,656$ 152,329$ 139,723$ 139,899$ 136,144$ 138,210$
Net Cost of Service 154,956$ 143,664$ 151,982$ 147,386$ 150,334$ 151,003$ 138,508$ 138,683$ 134,962$ 137,012$
Test Year Annual Volume after Minimum 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280 38,337,280
Net Volumetric Charge 4.04$ 3.75$ 3.96$ 3.84$ 3.92$ 3.94$ 3.61$ 3.62$ 3.52$ 3.57$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 62
Date: 2/18/2022 2022 02 18 Oro Valley AZ Rate Model Presentation Version Forecast W8
10 Year Forecast
2022 - 2031
Test Year Forecast
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
Forecast W 8.0 -- WATER Cost of Service by Customer Class
Scenario:2022 02 18 -- Equal Percent Adjustments
TOWN OF ORO VALLEY AZ
WATER COST OF SERVICE MODEL
Reclaimed Water
Revenue Requirement Allocation 1,206,652$ 1,258,008$ 1,324,758$ 1,304,324$ 1,353,558$ 1,390,941$ 1,435,782$ 1,482,296$ 1,530,529$ 1,581,105$
Customer 548 507 536 519 529 530 486 486 473 479
Total Cost of Service 1,207,199$ 1,258,515$ 1,325,293$ 1,304,843$ 1,354,086$ 1,391,472$ 1,436,269$ 1,482,783$ 1,531,002$ 1,581,585$
Calculation of Customer Costs/Bill
Total Customer Costs 548$ 507$ 536$ 519$ 529$ 530$ 486$ 486$ 473$ 479$
Total Bills 144 144 144 144 144 144 144 144 144 144
Customer Cost/Bill 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Non-Customer Charge
Total Non-Customer Costs 1,206,652$ 1,258,008$ 1,324,758$ 1,304,324$ 1,353,558$ 1,390,941$ 1,435,782$ 1,482,296$ 1,530,529$ 1,581,105$
Total Volume 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096
Total Non-Customer Cost 2.03$ 2.12$ 2.23$ 2.20$ 2.28$ 2.34$ 2.42$ 2.50$ 2.58$ 2.66$
Calculation of Minimum Charge
Monthly Minimum Volume - - - - - - - - - -
Non-Customer Charge/1,000 Gallons 2.03$ 2.12$ 2.23$ 2.20$ 2.28$ 2.34$ 2.42$ 2.50$ 2.58$ 2.66$
Monthly Non-Customer Charge -$ -$ -$ -$ -$ -$ -$ -$ -$ -$
Monthly Customer Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Calculation of Volumetric Charge
Monthly Minimum Charge 3.80$ 3.52$ 3.72$ 3.60$ 3.67$ 3.68$ 3.38$ 3.38$ 3.28$ 3.33$
Total Bills 144 144 144 144 144 144 144 144 144 144
Revenue from Minimum Charge 548$ 507$ 536$ 519$ 529$ 530$ 486$ 486$ 473$ 479$
Total Cost of Service 1,207,199$ 1,258,515$ 1,325,293$ 1,304,843$ 1,354,086$ 1,391,472$ 1,436,269$ 1,482,783$ 1,531,002$ 1,581,585$
Net Cost of Service 1,206,652$ 1,258,008$ 1,324,758$ 1,304,324$ 1,353,558$ 1,390,941$ 1,435,782$ 1,482,296$ 1,530,529$ 1,581,105$
Test Year Annual Volume after Minimum 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096 593,856,096
Net Volumetric Charge 2.03$ 2.12$ 2.23$ 2.20$ 2.28$ 2.34$ 2.42$ 2.50$ 2.58$ 2.66$
Intellectual Property of Economists.com, LLC / Willdan Group Inc. - Not
to be used without express written permission 63
5500 Democracy Drive, Suite 130 Plano, TX 75024 972.378.6588
www.willdan.com