Templates / Price, volume and mix bridge
Price, volume and mix bridge
Split the change in your sales into price, volume and mix — with new and lost products handled, and a line that shows anything the bridge cannot split.
Why this exists
The question behind every revenue review: did we sell more, charge more, or just sell different things? A hand-built PVM bridge can stop reconciling without anyone noticing. This one shows anything it cannot split on its own line.
What is inside
- One row per product: prior-year and current-year volume and net sales in; volume, mix, price, new and lost out
- New and lost products flagged and handled, because they are the usual reason a bridge stops adding up
- A bridge sheet: PY sales + volume + mix + price + new + lost = CY sales, with a "Not split" line that reads zero unless a row has sales without volume
- The method stated in the read-me (volume at the prior-year average price, mix at prior-year prices, price on current-year volume), so the convention is on the table when you present
Two correct methods can put the mix number in different places. The note Why the mix number depends on the method works both through on one small book.
The same analysis, built on your data
We build this bridge into the copy of the system we set up for you, on your own sales data, by category, brand, customer, market, channel or product. It adds up to the total change, with new and lost products handled, and a named line for whatever the bridge cannot split.
Or email support@orkestar.eu