Find the tariff that belongs to the account
Tiered water tariffs charge different blocks of consumption at different rates. A single average price can hide the effect of crossing a threshold, especially when estimating a small reduction from a high-use period. Begin with the current schedule for the correct customer class and service location.
Confirm meter size, residential category, inside or outside service area and the tariff's effective date where relevant. Snohomish's rate page illustrates account distinctions and included units; Miami-Dade's bill guide shows how units appear on a statement. Neither supplies a universal tariff for another utility.
Write down whether thresholds apply per month, billing period, day, household or another basis. Do not treat a monthly block as a quarterly allowance, and do not prorate it yourself unless the utility's published rules require that method.
Create one row for each block
Record the lower and upper consumption boundaries, the rate unit and the charge rate. Keep fixed fees and sewer components outside the initial water-block calculation. If a base charge includes units, identify those units before adding excess-use blocks.
The main register is marked m³, while smaller pointer scales carry their own multipliers. Identify which reading the utility requires before building the tariff rows. Retain the original billed unit through the block calculation; dial colour or pointer position alone does not establish your account’s charge basis.
Photo & usage
Satirdan kahraman · CC BY-SA 4.0 · Source. Display copies resized and encoded as WebP; no instructional details were fabricated or removed.
Check how boundaries are expressed. “First ten units” and “above ten units” should not both charge the tenth unit. Use the utility's examples or ask for clarification if a schedule is ambiguous.
Keep the original unit through the block calculation. Converting the entire bill to litres first can make a simple tariff harder to trace. Convert only the final scenario volume if needed, showing the factor and avoiding premature rounding near a threshold.
Price a hypothetical three-block bill
This illustrative USD tariff charges the first 10 cubic metres at USD 1.50 each, the next 10 at USD 2.50 and any additional volume at USD 4.00. At 24 cubic metres, the blocks are 10, 10 and 4 cubic metres.
| Block | Volume | Charge |
|---|---|---|
| First | 10 m³ | USD 15.00 |
| Second | 10 m³ | USD 25.00 |
| Third | 4 m³ | USD 16.00 |
The water-only variable total is USD 56.00. This invented example excludes fixed fees, sewer, taxes and local adjustments. It demonstrates the block method rather than current prices.
Apply a reduction from the top block down
In the same illustrative tariff, reducing volume from 24 to 18 cubic metres removes four cubic metres from the highest block and two from the second. The charge reduction is 4 × USD 4.00 + 2 × USD 2.50 = USD 21.00.
The new water-only charge is USD 35.00: USD 15.00 for the first block and USD 20.00 for eight units in the second. USD 56.00 minus USD 35.00 confirms the same USD 21.00 difference.
Using the original average rate, USD 56.00 ÷ 24, would estimate only USD 14.00 for six units. The difference arises because the removed volume came from more expensive blocks. This reasoning depends on the tariff being an increasing block structure with the stated boundaries.
Do not mistake another structure for increasing blocks
A utility may use seasonal pricing, declining blocks, a uniform rate or a charge in which all units change price at a threshold. EPA's water-bill guide describes varied structures. Identify the actual method before applying the worked example.
For seasonal rates, note which dates and uses attract the rate and how a crossing period is allocated. For an allowance based on occupancy or property, confirm the account's recorded details. Do not alter the household count in a spreadsheet and assume the utility has approved a revised allowance.
If the bill presents only a combined amount, request the relevant calculation or account schedule. A plausible block model that fails to match the utility's method is still wrong. Keep the unresolved basis visible until it is confirmed.
Check thresholds when periods differ
Some utilities adjust block allowances for service days, while others use fixed billing periods or another published rule. Record the actual treatment. An unusually long interval may cross a block even without a higher daily use rate.
Compare consumption per day separately from the charge calculation. Normalising volume can explain behaviour, but the tariff must still be applied as the utility defines it. Do not replace billed volume with a standard-month estimate when reconstructing an actual statement.
Where estimated readings are involved, a later actual reading may change the allocation. Ask the utility how corrections affect blocks across periods. Do not assume a catch-up quantity belongs entirely to the latest period's highest rate.
Show the boundary around an uncertain reduction
If a proposed fixture change might reduce consumption by a range, calculate the endpoints under the same tariff. A scenario that crosses a tier can have a different marginal charge from one that remains inside it. State the use-frequency assumptions separately.
Avoid rounding a volume just below a threshold upward merely to simplify a table. Retain sufficient precision for the tariff rule, then apply the utility's actual billing resolution. Ask about rounding if it materially changes the outcome.
Keep sewer effects separate unless the sewer tariff uses the same blocks and volume by explicit rule. A water-tier calculation does not automatically determine wastewater charges. The combined cost scenario needs both components explained.
Verify the block totals before making a decision
Add the block volumes and confirm they recover total consumption. Multiply each block independently and add the charges. Check the difference between original and changed scenarios by calculating both totals, rather than relying only on a shortcut.
Save the schedule and a dated copy of the calculation. When rates change, update the block values and effective dates without overwriting the old scenario. A later review should be able to reproduce the original decision.
The worksheet is complete when units, thresholds and period rules are explicit and the arithmetic matches a known bill or a clearly labelled scenario. It can then support a limited water-cost comparison without promising a future invoice amount.
Test just below and above a boundary
Use a small boundary check to see whether the worksheet charges blocks correctly. Under the article's illustrative tariff, 10 cubic metres cost USD 15.00. Eleven cubic metres cost USD 17.50 because only the eleventh unit enters the second block. Charging all eleven at USD 2.50 would produce USD 27.50 and apply a different tariff structure.
At 20 cubic metres, the correct illustrative total is USD 40.00. At 21, it is USD 44.00 because one unit enters the third block. These checks help expose an off-by-one boundary or a spreadsheet formula that reprices the whole volume when a threshold is crossed.
For the actual account, use the utility's stated units and permitted precision. If thresholds are adjusted for service days, test the adjusted boundary using the approved method. Keep any included base units separate so they are not charged again in the first excess block.
Then reverse the calculation: add all allocated block volumes and recover the original consumption. A worksheet can produce a plausible charge while accidentally omitting a small final block. Both the volume total and charge total need independent checks.
Save those boundary examples with the spreadsheet. When rates change, they provide a quick way to verify that the structure remains correct without claiming that a software check confirms the utility's policy.
THE REFERENCE FILE
Sources & scope
Documentation reviewed 1 Nov 2026. Examples are illustrative; this article does not claim hands-on product testing. Follow the instructions for your actual material, model and location.
