Skip to main content

Excess Usage Calculator 1

Sample Calculation 1 - Excess Water Usage

Average usage experienced in June and July.  A failed toilet caused 12,300 gallons excess usage in August.  The toilet was repaired and qualifies for water and sanitary district credit memos with the September 10th billing under the districts leak credit policy.

Excess Water UsageMeteredBaseExcessper hundredExcess $Remaining Gal Over/(Under) 
June3,6505,000 
Tier1 x$0.25= (1,350)
Tier2x$0.75=(1,350)
Tier3x $5.00=(1,350)
Tier4x$9.00=(1,350)
Tier5x$15.00=(1,350)
July4,5005,000 
Tier1 x $0.25=(500)
Tier2x$0.75=(500)
Tier3x$5.00=(500)
Tier4x$9.00=(500)
Tier5x$15.00=(500)
 August17,3005,00012,300
Tier13,000x$0.25=$7.50
Tier24,000x$0.75=$30.00
Tier34,000x$5.00=$200.00
Tier41,300x$9.00=$117.00 
 Tier5x$15.00=
12,300$354.50 
Totals from above Excess Water Usage Table   
Total Excess Water$354.50
 Quarterly Water Bill $166.00
 Total Water Billing $520.50
 Excess UsageTiers 1-2$37.50$18.75
 Excess UsageTiers 3-5$317.00$317.00
 Quarterly Sanitary Bill $234.00
 Total Sanitary Bill $569.75
Excess Usage by TierIncremental Additional GalAct Excess Gal Used Water District Excess BilledSanitary District Excess Billed
Tier 13,0003,000 $7.50$3.75
Tier 24,0004,000$30.00$15.00
Tier 34,0004,000$200.00$200.00
Tier 49,0001,300$117.00$117.00
Tier 5Above 25K---
 12,300$354.50$335.75
 Total Excess Water Qtr15,000  
 Total Gal Used27,300