Capstone: Range Dashboard with Margins, Ladder Gaps, the Weakest Pack and a Chart
This lesson is part of the course
In this lesson
You review the whole range in one table: margin % per pack, gaps where the next pack size jumps too far, the pack with the weakest margin and a chart of how many packs of each size sell.
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