Tariff Modelling Tool OCL

Tariff Modelling Tool

A data-driven tariff tool to help eThekwini deliver fairer, more sustainable water services

About this project

To address revenue losses and improve access to water and sanitation, we worked with eThekwini’s Water and Sanitation Department to develop a decision-support tool that models the impact of different tariff schemes. Built in Excel, the tool allows officials to compare and fine-tune water tariffs using real data, helping them balance affordability with cost recovery. By giving officials a clearer picture of how tariff changes affect both revenue and residents, the tool is helping eThekwini build a more transparent, equitable, and financially resilient water system.

Let's chat about building a product like this for you