This water and energy management company located in the north of Portugal is responsible for the integration of the urban water cycle in one of the largest cities of the country with around 160,000 customers and 50,000 m3 of water supplied to customers daily.
A significant effort based on the continuous improvement of the company has been focused on upgrading the water meter grid, aiming at reducing measurement errors on the equipment and their reliability.
The daily operation manages around 400 interventions and operations. 250 of them are related to the management of the network of water meters. Most of the interventions consist of water meter replacements and contractual modifications (changes to the placement, connection, disconnection and removal of meters). These services are scheduled in a time window agreed with the client and should be performed as quickly as possible. Carrying out this service means organising and distributing the 250 interventions through eight operational teams.
The main challenges are:
The goals of the project are:
To achieve efficient and strategic management of people and resources, the need for an optimised and automatic itinerary assignment to the different operational teams was identified. This can be achieved by using optimisation algorithms to achieve efficiency to perform all daily services.
Firstly, a detailed study was carried out to fully characterise the entire operation of the team planning process, the information flows, and the existing information systems in place.
After this study, a software platform was designed and implemented. The plat form integrates with the existing management software of the company and uses heuristic and meta-heuristic algorithms to solve the optimisation process, taking into account the execution times of each type of service, the meter types and the availability of teams. Through a simple and user-friendly interface, users have the possibility to quickly and efficiently carry out the optimised planning of teams and carry out real-time monitoring of operations.
The main modules of the platform are described below.