Price per Litre by Pack: Index vs the Core Pack and Ladder Checks
This lesson is part of the course
In this lesson
You turn six packs of one drink into total content, price per litre and an index against the core pack, and flag where the price-per-litre ladder breaks.
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
- Price per Litre by Pack: Index vs the Core Pack and Ladder Checks Locked
- Volume Discounts: Discount per Kilogram, the Price of the Extra Grams and the Bigger-Is-Cheaper Rule Locked
- Price Points & Thresholds: Price Endings with CEILING and Crossing Whole-Number Barriers Locked
- Pack-Size Changes: Smaller or Bigger Packs at the Same Price, Price per kg and Margin Effect Locked
- Shelf Price Build-Up: Cost, List Price, Retailer Margin and Tax – Forward and Backward Locked
- Channel & Occasion Packs: Single-Serve, Multipacks and Club Sizes – Margin per Pack and per Litre Locked
- Portfolio Mix: Volume Shares × Margins with SUMPRODUCT and Mix-Shift Scenarios Locked
- Capstone: Range Dashboard with Margins, Ladder Gaps, the Weakest Pack and a Chart Locked