Price Points & Thresholds: Price Endings with CEILING and Crossing Whole-Number Barriers
This lesson is part of the course
In this lesson
You apply a planned increase, round each new price up to a price ending in 9 with CEILING, flag prices that cross a whole-number threshold and calculate the alternative price that stays just below it.
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