Abstract:A key component of water supply infrastructure asset management is the establishment of investment priorities: how to decide among investments of different types, values, functions, and physical conditions? The decision may be straightforward in some cases, but in most situations managers find themselves in the situation of having to adopt subjective criteria. Nowadays, decision making needs a comprehensive approach that takes into consideration cost of building, operating, maintaining and disposing of capital assets over their life cycles. Conversely, factors such as improvement of customer level of service, improvement of system reliability, or minimization of negative impacts of the infrastructures on the society and on the environment should be incorporated into the investment prioritization process. This was the motivation for a project promoted by the water utility EPAL, S.A. and jointly developed with a research team. The objective was to define a conceptual model and develop an operational tool able to assist decision-makers in the prioritization of water distribution system investments. In this context, an integrated decision support tool was developed taking into account direct, indirect and external costs during the life cycle of the assets. The model includes different points of view and service goals important for water infrastructure asset management (e.g., quantity and pressure, water quality, reliability, water losses, energy, operation and maintenance, and environment) and was developed for different infrastructure components (water mains and service connections, treatment facilities, pumping stations and service reservoirs). The model was implemented into an MS Excel-based application that allows for input data and report production. Detailed tests were made for the three most common types of investments identified by the involved water utility. Sensitive analyses were carried out and conclusions drawn about the most important and critical points of view for each case. Based on the results of the model applied to this set of investments, three different alternative approaches for investment prioritization are analyzed and discussed. The paper describes the principles of the conceptual model, summarizes the main features of the computer application, discusses its applicability, strengths and weaknesses and presents some recommendations for further development. This paper was presented at the 8th Annual Water Distribution Systems Analysis Symposium which was held with the generous support of Awwa Research Foundation (AwwaRF).

A Water Utility Industry Conceptual Asset Management Data Warehouse Model

A Conceptual Data Modelling Methodology for Asset Management Data Warehousing

Data-driven asset management in urban water pipe networks: a proposed conceptual framework

Demand-Driven Spatiotemporal Variations of Flow Hydraulics and Water Age by Comparative Modeling Analysis of Distribution Network

Multidimensional Schemas for Engineering Asset Management

Research on Electric Power Marketing Decision Support System. Based on Data Warehousing

Water Infrastructure Asset Management: A Methodology to Define Investment Prioritization

A semantic common model for product data in the water industry

Key Technology of Data Warehouse Design in Water and Electricity Engineering Industry

Application of Data Warehouse to Water Quality Assessment System:Existing Status and Future

Information Management for the Water Distribution Systems Analysis

Application of Data Warehouse to Power System

Application of data warehouse and Decision Support System in construction management

An Automatic Method of Data Warehouses Multi-Dimension Modeling for Distributed Information Systems

An Application Study of Data Warehouse and Data Mining in Water Supply

Asset management analytics for urban water mains: a literature review

Asset Management Decisions—Based on System Thinking and Data Analysis

Analytics-driven Asset Management.

An Ontology Approach for Manufacturing Enterprise Data Warehouses Development

A digital water strategy based on the digital water service concept to support asset management in a real system

Establishment Of Water Environmental Data Mart