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 Usage Metered Base Excess per hundred Excess $ Remaining Gal Over/(Under) 
June 3,650 5,000  
Tier1   x $0.25 =   (1,350)
Tier2 x $0.75 = (1,350)
Tier3 $5.00 = (1,350)
Tier4 x $9.00 = (1,350)
Tier5 x $15.00 = (1,350)
July 4,500 5,000  
Tier1   $0.25 = (500)
Tier2 x $0.75 = (500)
Tier3 x $5.00 = (500)
Tier4 x $9.00 = (500)
Tier5 x $15.00 = (500)
 August 17,300 5,000 12,300
Tier1 3,000 x $0.25 = $7.50
Tier2 4,000 x $0.75 = $30.00
Tier3 4,000 x $5.00 = $200.00
Tier4 1,300 x $9.00 = $117.00  
  Tier5 x $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 Usage Tiers 1-2 $37.50 $18.75
  Excess Usage Tiers 3-5 $317.00 $317.00
  Quarterly Sanitary Bill   $234.00
  Total Sanitary Bill   $569.75
Excess Usage by Tier Incremental Additional Gal Act Excess Gal Used  Water District Excess Billed Sanitary District Excess Billed
Tier 1 3,000 3,000  $7.50 $3.75
Tier 2 4,000 4,000 $30.00 $15.00
Tier 3 4,000 4,000 $200.00 $200.00
Tier 4 9,000 1,300 $117.00 $117.00
Tier 5 Above 25K - - -
  12,300 $354.50 $335.75
  Total Excess Water Qtr 15,000    
  Total Gal Used 27,300