This tool allows utilities to quickly determine the proportion of residential revenues from water sales at risk of loss when demand patterns change, based on the utility's own rate structure, customer demand profile, and weather conditions. The tool requires only minimal data and uses simplifying assumptions based on actual customer behavior. It focuses exclusively on revenue projections and assessments and allows the user to compare two different rate structures and assess which one offers greater revenue resiliency. A
tutorial video and
example spreadsheet are also included to guide the user.