Incremental Tiers: Units per Band, One SUMPRODUCT & the Effective Rate
This lesson is part of the course
In this lesson
You split Halden Legal's 2,750 archive boxes into Larkspur's four incremental tiers, calculate the whole charge in one SUMPRODUCT, return the effective rate per box and compare it with an all-units charge at the same rates.
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