All-Units Tiers: One Rate for the Whole Quantity, Cliffs & Buying Up to the Next Band
This lesson is part of the course
In this lesson
You price six orders on the all-units list, measure the saving at each threshold, find the break-even quantity from which ordering the band start is cheaper, and return the cheapest cost for at least each quantity.
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