Average price per kg hid the effect of mix.
The company sells a core and a premium category through a distributor in three markets. Its average price per kg report blended pricing decisions with changes in what was sold. That report left open whether the increase was being captured.
There was a single list price adjustment in 17 months, of +2.9%. Afterwards, price at constant mix moved within ±0.4% each month. The largest-volume account in the modern channel kept its price and gained 2.1 pp of kg sold.
Mix gave back almost all of the price increase.
Without mix, price per kg would have grown close to 2 points. The increase was captured, and the shift of volume to large sizes left price per kg at +0.08%.
We broke down the change in price per kg from the invoice line up.
We corrected the sales base at invoice-line level: weights, codes and channels, reconciled against the source.
We split the change in net price per kg into volume, price at constant mix, mix and discounts.
We opened mix into four levels: category, size, SKU and channel. Each level adds up to the total with no residual.
We left a tool that reports price and mix separately every month.
The client's team runs the six deliverables on its own.
Corrected sales base
Clean sell-in, with quality control and reconciled to the cent against the source.
Price waterfall
Bridges by market, channel, account and category. Over the last 6 months price per kg fell 2.0%, and price at constant mix explains 18%.
Price trends
Month-by-month bridges and price and mix indices. The increase ranged from 0% to +5.3% by account; the 0% is the largest-volume account.
Price ladder by size
Price per kg and share of each size, by channel. Sizes up to 400 g lost 2.4 pp of kg sold.
RGM recommendations
Four prioritized levers: list price adjustment, size ladder, a weight plan for small formats and price corridors by account.
Self-contained tool
A file that works offline and is updated every month in four steps, with automated tests.
Consumer goods manufacturers with multi-size portfolios, selling through distributors or retail chains, who need to explain the gap between the list price increase and the realized price.
Anonymized case. We omit the client's name and any detail that could identify it. Figures come from the actual project; the comparison of price per kg across sizes is calculated on an index (over 1,200 g = 100).