Incremental Tiers: Units per Band, One SUMPRODUCT & the Effective Rate
This lesson is part of the course
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 Pro
- All-Units Tiers: One Rate for the Whole Quantity, Cliffs & Buying Up to the Next Band Pro
- Incremental Tiers: Units per Band, One SUMPRODUCT & the Effective Rate Pro
- Block Tariffs: Fixed Charge, Rising Blocks, Bills for Many Sites & the Marginal Price Pro
- Volume Rebates: Retroactive vs Prospective Scales & Accruing from a Year-End Forecast Pro
- Tiered Commissions & Fee Tables: Accelerators, Fixed + Percent Fees & the Effective % Pro
- Stepped Fixed Costs: Staff Added Every N Units, Cost per Unit & the Best Operating Points Pro
- A Tier Engine: One Band Table, One Formula for Every Customer & Two Price Lists Compared Pro