Tabellab
Business & Operations Intermediate

Subscription Box Economics: Box COGS, Churn by Cohort, CAC Payback & Skip Rates

Build the cost stack of one box, value the plan mix, read cohort churn and the first-box cliff, price skips and pauses, pay back CAC, value subscribers by plan, forecast next month's inventory and test first-box discounts, with every cell checked as you go.

8 lessons 8 labs 2 h Certificate

The first lesson is free โ€” no account needed.

About this course

A subscription box economics course that runs one fictional monthly tea, coffee and snack box, Kettlecrate, in a spreadsheet, for subscription box founders, e-commerce managers, growth marketers and business students. You build the cost stack of one box from COGS, packaging, pick and pack, shipping and payment fees and find the boxes that cover fixed costs, value a mix of monthly and 3-, 6- and 12-month prepaid plans, turn six sign-up cohorts into a retention triangle and see the first-box cliff, measure the revenue lost to skips and pauses, calculate CAC by channel and the payback with and without churn, value a subscriber on each plan as a discounted, churn-adjusted lifetime value, forecast next month's boxes and purchase orders in full cases, and test which first-box discount leaves the most profit. Fictional company and illustrative numbers. Not financial advice. The first lab is free.

Lessons

  1. Box Contribution: COGS, Packaging, Pick & Pack, Shipping and Payment FeesLab14 minFree
  2. Plan Mix: Monthly vs 3-, 6- and 12-Month Prepaid and the Average Revenue per BoxLab13 min Pro
  3. Cohort Retention and Churn by Month: The First-Box CliffLab16 min Pro
  4. Skip and Pause Rates: The Revenue You Do Not BillLab14 min Pro
  5. CAC by Channel and Payback Months, With and Without ChurnLab15 min Pro
  6. Lifetime Value by Plan: Discounted, Churn-Adjusted and CappedLab16 min Pro
  7. Inventory Forecast: Next Month's Boxes from Active Subscribers and Expected ChurnLab15 min Pro
  8. First-Box Discounts: More Sign-ups, Weaker Retention, Which Offer Wins?Lab16 min Pro