Excess Usage Calculator 2
Sample Calculation 2 - Excess Water Usage
Excess usage experienced in June and July due to irrigation . A failed irrigation line break caused 23,880 gallons excess usage in August. An irrigation report was submitted in May. The broken irrigation line was repaired and Augusts excess usage 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 | 10,530 | 5,000 | 5,530 | |||||
| Tier1 | 3,000 | x | 0.25 | = | $7.50 | 2,530 | ||
| Tier2 | 2,530 | x | 0.75 | = | $18.98 | |||
| Tier3 | x | 5.00 | = | |||||
| Tier4 | x | 9.00 | = | |||||
| Tier5 | x | 15.00 | = | |||||
| 5,530 | $26.48 | |||||||
| July | 14,550 | 5,000 | 9,550 | |||||
| Tier1 | 3,000 | x | 0.25 | = | $7.50 | 6,550 | ||
| Tier2 | 4,000 | x | 0.75 | = | $30.00 | 2,550 | ||
| Tier3 | 2,550 | x | 5.00 | = | $127.50 | |||
| Tier4 | x | 9.00 | = | |||||
| Tier5 | x | 15.00 | = | |||||
| 9,550 | $165.00 | |||||||
| August | 28,880 | 5,000 | 23,880 | |||||
| Tier1 | 3,000 | x | 0.25 | = | $7.50 | 20,880 | ||
| Tier2 | 4,000 | x | 0.75 | = | $30.00 | 16,880 | ||
| Tier3 | 4,000 | x | 5.00 | = | $200.00 | 12,880 | ||
| Tier4 | 9,000 | x | 9.00 | = | $810.00 | 3,880 | ||
| Tier5 | 3,880 | x | 15.00 | = | $582.00 | |||
| 23,880 | $1,629.50 |
| Totals from above Excess Water Usage Table | ||
|---|---|---|
| Total Excess Water | $1,820.98 | |
| Quarterly Water Bill | $166.00 | |
| Total Water Billing | $1,986.98 | |
| Excess Usage - Tiers 1-2 | $101.48 | $50.74 |
| Excess Usage - Tiers 3-5 | $1,719.50 | $1,719.50 |
| Quarterly Sanitary Bill | $234.00 | |
| Total Sanitary Bill | $2,004.24 |
| Excess Usage by Tier | Incremental Additional Gal | Act Excess Gal Used | Water District Excess Billed | Sanitary District Excess Billed |
|---|---|---|---|---|
| Tier 1 | 3,000 | 9,000 | $22.50 | $11.25 |
| Tier 2 | 4,000 | 10,530 | $78.98 | $39.49 |
| Tier 3 | 4,000 | 6,550 | $327.50 | $327.50 |
| Tier 4 | 9,000 | 9,000 | $810.00 | $810.00 |
| Tier 5 | above 25K | 3,880 | $582.00 | $582.00 |
| 38,960 | $1,820.98 | $1,770.24 | ||
| Base Gal in QTR | 15,000 | |||
| Total Gal Used | 53,960 |