Customer Bill Impacts: Typical Bills Before & After (with a Chart)
This lesson is part of the course
In this lesson
You calculate five typical monthly bills at current and proposed rates with SUMPRODUCT, the percentage change for each profile, and chart the bills side by side.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Revenue Requirement: O&M, Debt Service & Capital (Cash-Needs Approach) Locked
- Demand Forecast & Non-Revenue Water: the Water Balance Locked
- Fixed vs Volumetric Split & Meter-Size Equivalents Locked
- Increasing Block Tariff: Bills by Usage with MIN & MAX Locked
- Revenue Check & the Rate Needed to Recover Cost Locked
- Customer Bill Impacts: Typical Bills Before & After (with a Chart) Locked
- Affordability: Bill as % of Household Income & a Lifeline Credit Locked
- Drought Surcharge & Revenue Stability Scenarios Locked