Excess Usage Calculator 3
Sample Calculation 3 - Excess Water Usage
Excess usage experienced in June and July due to irrigation . A failed irrigation line break caused 33.550 gallons excess usage in August. No irrigation report was received in May. The broken irrigation line was repaired. Augusts excess usage did not qualify 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 | 8,080 | 5,000 | 3,080 | |||||
| Tier1 | 3,000 | x | 0.25 | = | $7.50 | 80 | ||
| Tier2 | 80 | x | 0.75 | = | $0.60 | - | ||
| Tier3 | x | 5.00 | = | - | ||||
| Tier4 | x | 9.00 | = | - | ||||
| Tier5 | x | 15.00 | = | |||||
| 3,080 | $8.10 | |||||||
| July | 7,850 | 5,000 | 2,850 | |||||
| Tier1 | 2,850 | x | 0.25 | = | $7.13 | - | ||
| Tier2 | x | 0.75 | = | - | ||||
| Tier3 | x | 5.00 | = | - | ||||
| Tier4 | x | 9.00 | = | - | ||||
| Tier5 | x | 15.00 | = | |||||
| 2,850 | $7.13 | |||||||
| August | 38,550 | 5,000 | 33,550 | |||||
| Tier1 | 3,000 | x | 0.25 | = | $7.50 | 30,550 | ||
| Tier2 | 4,000 | x | 0.75 | = | $30.00 | 26,550 | ||
| Tier3 | 4,000 | x | 5.00 | = | $200.00 | 22,550 | ||
| Tier4 | 9,000 | x | 9.00 | = | $810.00 | 13,550 | ||
| Tier5 | 13,550 | x | 15.00 | = | $2,032.50 | |||
| 33,550 | $3,080.00 |
| Totals from above Excess Water Usage Table | ||
|---|---|---|
| Total Excess Water | $3,095.23 | |
| Quarterly Water Bill | $166.00 | |
| Total Water Billing | $3,261.23 | |
| Excess Usage - Tier 1-2 | $52.73 | $26.36 |
| Excess Usage - Tier 3-5 | $3,042.50 | $3,042.50 |
| Quarterly Sanitary Bill | $234.00 | |
| Total Sanitary Billing | $3,302.86 |
| Excess Usage by Tier | Incremental Additional Gal | Act Excess Gal Used | Water District Excess Billed | Sanitary District Excess Billed |
|---|---|---|---|---|
| Tier 1 | 3,000 | 8,850 | $22.13 | $11.06 |
| Tier 2 | 4,000 | 4,080 | $30.60 | $15.30 |
| Tier 3 | 4,000 | 4,000 | $200.00 | $200.00 |
| Tier 4 | 9,000 | 9,000 | $810.00 | $810.00 |
| Tier 5 | above 25K | 13,550 | $2,032.50 | $2,032.50 |
| 39,480 | $3,095.23 | $3,068.86 | ||
| Base Gal in Qtr | 15,000 | |||
| Total Gal Used | 54,480 |