Cost-Benefit Analysis for Upgrading Regina’s AMR System to Fixed-Network AMI

Overview

Client: City of Regina

Location: Regina, Saskatchewan, Canada

Project: Preliminary Cost-Benefit Analysis for Upgrading City of Regina’s Automated Meter Reading (AMR) System to Fixed-Network Advanced Meter Infrastructure (AMI)

IDS was commissioned by the City of Regina to investigate and compare the costs and benefits of possible options to maintain the City’s current AMR system or to upgrade it to fixed-network advanced metering infrastructure (AMI). IDS has developed a rigorous cost-benefit analysis procedure and software tool to evaluate a range of possible scenarios, and furnished recommendations based on the economic merits of various scenarios.

Challenge

The City of Regina’s water system provides water for residential, commercial, and industrial customers as well as water for irrigation and summer service. The City’s water system serves nearly 70,000 utility accounts for a population of approximately 207,000. In 2002, the City of Regina has initiated a utility-wide program to install a drive-by Automated Meter Reading (AMR) system and replace almost its entire water meter inventory. As this system is approaching the end of its design life of 20 years, the City needs to evaluate and compare the costs and benefits of possible options to maintain current AMR or upgrade to fixed-network advanced metering infrastructure (AMI).

Solution

IDS has developed a rigorous cost-benefit analysis procedure and software tool to evaluate a range of possible options and deployment scenarios for maintaining the City’s current AMR system or upgrading to AMI. The analysis was applied to assess economic merits of alternative scenarios and provide a quantitative evaluation of various scenarios in terms of their associated costs and quantifiable benefits. The defined scenarios considered a number of deployment decisions including: deployment period, possibility to coordinate meter replacement with AMI deployment, and use of vendor’s hosted software services (SaaS) versus in-house management of IT systems.

Working closely with City staff and a number of AMI vendors, information on various cost elements associated with current AMR system and possible AMI implementation scenarios have been collected and used to analyze whole life costs and economic merits of each scenario over 20-year planning horizon. In each scenario analysis, all yearly capital and operating cost and saving over the 20 year period were estimated and converted to present value using an appropriate discount rate. The analysis considered quantifiable economic benefits of AMI systems, namely, operating costs savings and the revenue recovery due to meter replacement associated with AMI deployment. Key economic measures, including net present value (NPV) and benefit cost ratio (BCR), of possible AMI deployment scenarios were assessed and compared. Analysis results and recommendations on a preferred option and deployment considerations will assist in preparing a business case using a rigorous economic analysis and objective evaluation of possible scenarios.

Advanced Analytics and Trend Analysis of Water Consumption and Supply in the City of Regina

Overview

Client: City of Regina

Location: Regina, Saskatchewan, Canada

Project: Assessment of Historical Water Use Trends and Long-Term Forecast of Water Demand in Regina (Based on Nine Years of Automated Meter Reading and Water Supply Data)

IDS was commissioned by the City of Regina to analyze water trends in the City over the past nine years using meter reading data collected by the City’s drive-by automated meter reading (AMR) system as well as storage, pumping, and treatment data collected by the City’s SCADA system. This historical information is invaluable in understanding the impact of such parameters as seasonality, population growth, conservation measures, and water rates on the patterns of water consumption and non-revenue water.

Challenge

The City of Regina’s water system provides water for residential, commercial, and industrial customers as well as water for irrigation, summer service, and fire protection. The system serves a population of approximately 207,000. Over the past decade, the City of Regina has invested heavily to implement state-of-the-art automated meter reading (AMR) and SCADA technologies, which enabled the collection of massive amounts of water consumption and supply data. Processing and analyzing this data could provide wealth of information on the intrinsic behavior of the system and to reliably forecast future water demand. This information will be invaluable to support decisions on system operations, capacity planning, and demand management. However, this analysis would require the use of specialized analytics algorithms and software tools that are not readily available in the market.

Solution

To undertake this project, IDS has developed a unique data analytics solution to implement specialized algorithms to process and analyze the massive amount of Regina’s water data over nine years study period (2005-2013). The solution was designed to provide detailed analysis of water consumption data across various service sectors based on AMR data, as well as water storage, supply, and treatment data. The solution also supported analysis of trends and relationships between water use, population change, non-revenue water, system capacity, per capita use, and climate conditions.

The solution was used to analyze daily, weekly, monthly, annual, and multi-year water consumption based on AMR data and to assess historical trends of water consumption for various service classes (residential, multi-residential, commercial, irrigation, and summer services). The solution was also used to analyze water production and storage data and trends of reservoirs volume change and supply from the treatment plant. Trends of average and peak daily demand, and average per capita demand were also analyzed. Weather data during the study period were also analyzed to examine possible correlation with water consumption trends. The solution was also used to analyze trends in non-revenue water over the study period and evaluate correlation with demand levels and time of the year. The analysis results will provide valuable insights into the intrinsic behavior of the system and forecasting of future water demand. The results will also help define feasible service level targets and support decisions on system operations, capacity planning, and demand management.

Long-Term Forecast of Water Demand in the City of Regina

Project Description

Client:   City of Regina
Location:   Regina, Saskatchewan

Assessment of Historical Water Use Trends and Long-Term Forecast of Water Demand in Regina (Based on Nine Years of Automated Meter Reading and Water Supply Data)

IDS was commissioned by the City of Regina to develop reliable models and innovative solutions to forecast water demand over the next 20 years using detailed data on City population, water consumption, and water supply over the past nine years. This project also involved assessing the adequacy of current system capacity for meeting future demand.

Challenge

The City of Regina is experiencing significant economic and population growth, which is projected to continue into the future. As competing priorities and limited financial resources continue to constrain the ability to make costly new investments to significantly expand the water system capacity, effective management of water use and loss levels is recognized to be the most cost-effective strategy to meet increasing demands.

Solution

An innovative solution to forecast water demand over the next 20 years was developed. Future water demand was forecasted based on historical demand time series, estimated population growth and per capita demand pattern over the next 20 years, while assuming the continuity of water use and supply trends and operational practices. Population was forecasted using an exponential smoothening space state model based on historical population data. The time series of per capita demand over the next 20 years was forecasted using an innovative autoregressive integrated moving average model. The total water demand over the next 20 years was then obtained by multiplying the forecasted time series of per capita demand and projected population. Other forecasting models were also developed to estimate the seasonality of total consumption for both residential and commercial service classes. The demand forecast also considered fire protection and regulatory requirements. The adequacy of the City of Regina’s storage and treatment capacity were assessed and compared to the forecasted demand over the next 20 years.

The resulting water demand forecast model will enable the development of defensible evidence-based plans to meet forecasted water demand and to gain deeper understanding of water consumption and supply trends in the City. The model will also help to justify planning decisions with regard to the system capacity and requirements for meeting future demand.