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		x	$5.00	=		(1,350)
		Tier4		x	$9.00	=		(1,350)
		Tier5		x	$15.00	=		(1,350)

July	4,500	5,000
		Tier1		x	$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


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

Sample Calculation 1 - Excess Water Usage

Website Accessibility Statement