Water Rate Worksheet
The Water Rate Worksheet is a calculation tool designed to help water system operators and administrators work through rate structures and billing scenarios. Use it to organize rate components, apply…
The Water Rate Worksheet is a calculation tool designed to help water system operators and administrators work through rate structures and billing scenarios. Use it to organize rate components, apply tariffs to consumption volumes, and see how different rate designs affect revenue and customer bills.
Operators can input consumption data, rate tiers, and fixed charges to model billing outcomes or compare rate scenarios. This supports rate analysis, forecasting, and decision-making when evaluating current or proposed rate structures. The worksheet format makes it easy to document assumptions and adjust inputs to test different rate configurations.
Source document
WOH_Water_Rate_Worksheet.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet · 15.4 KB
Become a member to view the full 1 min readRelated articles
Well Disinfection (Shock Chlorination) Guide
Shock chlorination disinfects new, repaired, or contaminated wells by introducing high-concentration chlorine to kill bacteria and viruses. This guide covers when to disinfect, chlorine product selection, dose calculation, step-by-step procedure, and post-treatment sampling for drinking water operators.
18 min read
Water Rate Setting Guide for Small Systems
This guide helps water system operators and boards calculate full costs of service, structure rates to cover operating expenses, debt service, and capital replacement, and plan regular rate adjustments. It covers cost identification, revenue calculations, rate design options, and customer communication.
23 min read
Water Main Leak Repair Guide
Covers identifying and repairing water main leaks, including detection methods, safe excavation and isolation, repair techniques for common pipe materials, post-repair disinfection, and return-to-service procedures. Essential for operators managing distribution system integrity and compliance.
21 min readNeed expert help with your water system?
Water Operator Hotline connects small public water systems with experienced water utility professionals who can help you stay compliant, maintain your equipment, and solve problems fast.