Block Tariffs: Fixed Charge, Rising Blocks, Bills for Many Sites & the Marginal Price
This lesson is part of the course
In this lesson
You split the water usage of Larkspur's six sites into the tariff's three blocks with one copyable formula, calculate each monthly bill, return the marginal price of the next m³ and find the site that pays the highest average price.
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
- Band Lookups: Approximate Match on Lower Bounds, Open Top Bands, Gaps & Overlaps Locked
- All-Units Tiers: One Rate for the Whole Quantity, Cliffs & Buying Up to the Next Band Locked
- Incremental Tiers: Units per Band, One SUMPRODUCT & the Effective Rate Locked
- Block Tariffs: Fixed Charge, Rising Blocks, Bills for Many Sites & the Marginal Price Locked
- Volume Rebates: Retroactive vs Prospective Scales & Accruing from a Year-End Forecast Locked
- Tiered Commissions & Fee Tables: Accelerators, Fixed + Percent Fees & the Effective % Locked
- Stepped Fixed Costs: Staff Added Every N Units, Cost per Unit & the Best Operating Points Locked
- A Tier Engine: One Band Table, One Formula for Every Customer & Two Price Lists Compared Locked