Templates / Price / Volume / Mix Bridge
Price / Volume / Mix Bridge
Split the change in your sales into price, volume and mix — with new and lost products handled, and a check row that proves it adds up.
Download the template (.xlsx) Free · live formulas · no macros · no email required
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 is easy to get wrong in exactly one way — it stops reconciling and nobody notices. This one carries its own check row.
What's inside
- One row per product: prior-year and current-year volume and net sales in, prices and all three effects out
- New and lost products flagged and handled — the usual reason a bridge stops adding up
- A reconciliation block: PY sales + volume + price + mix = CY sales, with a check cell that must read zero
- The method stated in the read-me (volume at old price, price at new volume), so the convention is on the table when you present
The same analysis, computed live
Orkestar computes this bridge from your raw sales file at any level — total, brand, customer, product — and it reconciles to the total change by construction.
