What price volume mix analysis shows
Price volume mix analysis, often shortened to PVM, splits the change in revenue or gross margin between two periods into its causes. Prices changed. You sold more or fewer units. The mix moved toward products that sell for more or less. Some products were new and some stopped selling. Each cause gets a dollar amount, and the amounts add up to the change.
A manufacturer uses it to answer the question every owner asks after a year-end close: did margin grow because prices went up, because volume grew, or because the product mix shifted? The calculator above answers it from a table you paste from Excel.
The formulas this calculator uses
For each product sold in both periods, unit price P is revenue divided by quantity Q, and unit cost C is cost of goods divided by quantity. Period 0 is the base and period 1 is the current period.
- Price effect: the sum of (P1 − P0) × Q1. It is what this period's units earned from the price change.
- Unit cost effect, for gross margin: the sum of (C1 − C0) × Q1, with the sign reversed, because a higher cost lowers margin.
- Volume effect: the change in total units times the base period's average price, or its average unit margin for the margin bridge.
- Mix effect: what remains of the change for continuing products. It is positive when the units moved toward products with a higher base price or margin.
- New and discontinued products: a product sold only in the current period adds its revenue or margin. One sold only in the base period takes its base amount away.
Methods differ between finance teams. Zebra BI's guide to PVM in Excel describes two common ways to calculate the mix effect, and separates new and discontinued products in one of them. Whichever method you use, use the same one every period, so this month's bridge compares with last month's.
A worked example
A conveyor manufacturer compares 2025 with 2026. It launched a spiral conveyor in 2026 and stopped selling gravity roller sections. These figures are an example, not data from a real company.
| Product | 2025 qty | 2025 revenue | 2025 cost | 2026 qty | 2026 revenue | 2026 cost |
|---|---|---|---|---|---|---|
| Belt conveyor 600 mm | 120 | $1,140,000 | $798,000 | 110 | $1,078,000 | $748,000 |
| Belt conveyor 900 mm | 60 | $720,000 | $486,000 | 85 | $1,062,500 | $714,000 |
| Roller conveyor 600 mm | 200 | $960,000 | $720,000 | 180 | $846,000 | $666,000 |
| Spiral conveyor | 0 | $0 | $0 | 12 | $540,000 | $378,000 |
| Gravity roller section | 40 | $96,000 | $76,000 | 0 | $0 | $0 |
The calculator returns this bridge. Revenue rose by $610,500 and gross margin by $184,500.
| Step | Revenue | Gross margin |
|---|---|---|
| Base, 2025 | $2,916,000 | $836,000 |
| Price | +$57,500 | +$57,500 |
| Unit cost | -$60,000 | |
| Volume | -$37,105 | -$10,737 |
| Mix | +$146,105 | +$55,737 |
| New products | +$540,000 | +$162,000 |
| Discontinued products | -$96,000 | -$20,000 |
| Current, 2026 | $3,526,500 | $1,020,500 |
How to read the result
- Price added $57,500: the 600 mm and 900 mm belt conveyors sold for more per unit, while the roller conveyor sold for less.
- Unit cost took $60,000 off margin, more than the price increases added. Costs rose faster than prices on the products sold in both years.
- Volume was negative because the continuing products sold fewer units in total.
- Mix was strongly positive: sales moved toward the 900 mm belt conveyor, which sells for the most per unit of the three.
- The new spiral conveyor brought most of the growth, $540,000 of revenue and $162,000 of margin.
Mistakes that distort the bridge
- Units that do not compare. The volume effect adds units across products, so count every product in the same kind of unit, such as each, metre or tonne.
- Renamed products. A product code that changed between periods shows up as one discontinued product and one new one. Map old codes to new ones before you paste.
- Returns and credit notes. Use net quantity and net revenue for each period, or a large credit makes the price effect look like a price cut.
- Periods of different length. Compare a year with a year, or a month with the same month a year earlier.
- Currency. If you sell in US and Canadian dollars, convert both periods at one rate, or the price effect carries the exchange rate with it.
Where AI helps
The slow part of PVM is the data: pulling invoice lines from the ERP, matching credit notes to the sales they reverse, and mapping renamed products. An AI system can do that every month from your own records and write a short explanation of each bar, such as which customers drove the price effect. A person on your team checks the numbers and approves any price change. See margin and pricing intelligence for how ThriveAI sets this up.