A Tier Engine: One Band Table, One Formula for Every Customer & Two Price Lists Compared
This lesson is part of the course
In this lesson
You build one copyable tier formula on a horizontal band table, cost six customers on two fictional envelope price lists, label the cheaper list per customer and chart both costs to see where the lists cross.
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