Tutorvo

Tiered Volume Pricing and Bundles with XLOOKUP

Lesson 8 of 815 minLab

This lesson is part of the course

In this lesson

You price dealer orders from a volume tier table with an approximate-match XLOOKUP, then work out the discount and margin of a bundle.

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

  1. Price, Volume and Margin Trade-offsLab14 min Locked
  2. The Price Waterfall: From List Price to Pocket PriceLab14 min Locked
  3. Cost-Plus vs Value-Based PricingLab14 min Locked
  4. Price Elasticity and the Profit-Maximising PriceLab16 min Locked
  5. Product Profitability: Contribution vs Fully Loaded (ABC)Lab16 min Locked
  6. Customer Profitability, Cost-to-Serve and the Whale CurveLab16 min Locked
  7. Discounts and Promotions: Break-Even Volume LiftLab15 min Locked
  8. Tiered Volume Pricing and Bundles with XLOOKUPLab15 min Locked