Chapter 5 · 7 levels

Profitability

Gross margin, contribution margin, revenue mix versus margin mix, the Pareto check, the real cost of returns and the mix-shift trap, on Harbor & Pine's orders and product costs.

Start

Revenue says how much the store sold. Profitability says how much of it the store kept. The two can move in opposite directions: a category that sells a lot at a thin margin can grow revenue while profit stands still, and a wave of returns can turn a good month into an average one.

In this chapter you work from the order lines up. Gross margin takes the cost of the goods off net sales. Contribution margin also takes off the refunds. Then you compare what each category brings in sales with what it brings in margin, check whether 20% of the products really make 80% of the sales, price the returns, and meet the trap that catches most margin reports: the overall margin moving because the mix moved, not because any category got better or worse.

House rules, as in every chapter of this track: only booked orders count (completed or refunded), lines with a quantity of 0 or less are data errors and are left out, and line net = quantity × unit price × (1 − discount_pct / 100). Costs come from products.unit_cost, which is missing on 9 products: their lines are excluded from every margin, and a good report says so. The boss is the category P&L Laura Bennett takes to the quarterly review.

Levels

  1. Gross margin by category

    from Laura Bennett, Head of Finance

    gross margin, cogs, margin pct, missing costs, groupby

    Code Difficulty 2 of 5 Not started

  2. Contribution margin by channel

    from Robert Kim, Chief Operating Officer

    contribution margin, gross margin, refunds, per order, cte

    Code Difficulty 3 of 5 Not started

  3. Revenue mix vs margin mix

    from Thomas Whitaker, Head of Merchandising

    mix, share of total, gross margin, groupby, transform

    Code Difficulty 2 of 5 Not started

  4. Pareto: do 20% of products make 80% of sales?

    from Thomas Whitaker, Head of Merchandising

    pareto, cumulative share, window functions, ranking, running total

    Code Difficulty 3 of 5 Not started

  5. What returns really cost

    from Angela Rivera, Head of Customer Support

    return rate, refunds, denominators, margin lost, merge

    Code Difficulty 3 of 5 Not started

  6. Metric trap: the margin that rose by itself

    from Catherine Hale, Chief Executive Officer

    mix shift, gross margin, weighted average, simpsons paradox, metric traps

    Quiz Difficulty 3 of 5 Not started

  7. Boss: the category P&L review

    from Laura Bennett, Head of Finance

    gross margin, contribution margin, coverage, refunds, filter, reporting

    Boss · 3 steps Difficulty 4 of 5 Not started

Pick what may run on this site. You can change this any time from "Cookie settings" at the bottom of every page.