Pricing & Margin Analytics

What is Price-Volume-Mix Analysis?
A Manufacturer's Guide

PVM analysis takes any change in revenue or gross margin and attributes it to exactly three forces: price, volume, and product mix. It is how manufacturers move from "revenue is up 8%" to knowing precisely what caused it.

8 min read Pricing analytics ERP-native analysis

The short version

Price-volume-mix analysis (referred to as PVM analysis or simply PVM) is a method for attributing changes in revenue or gross margin to three sources. When your Q1 revenue is up $2.1M over the prior year, PVM analysis tells you how much of that came from higher prices, how much from more units sold, and how much from a shift in what you sold. Each source is isolated and quantified.

For manufacturers, this matters because the three effects can run in opposite directions at the same time. Revenue can grow while margin erodes if the mix has shifted toward lower-value products. Volume can decline while margin improves if the shift is toward higher-value parts. Without attribution, the income statement only shows the net result, which can be misleading in either direction.

The key insight: revenue can grow while margin erodes. PVM analysis is the tool that separates these movements so pricing teams can respond to the right problem.

The three components of PVM analysis

Every change in revenue or gross margin between two periods decomposes into three and only three forces. Once you have the attribution, the three values sum to the total change.

Price
Price Effect

The revenue impact of selling at a different price per unit than the prior period, holding volume and mix constant. This isolates whether your pricing decisions held in the market. A 5% list price increase that resulted in a 3.8% realized increase produces a measurable price effect and a measurable gap between plan and outcome.

Volume
Volume Effect

The revenue impact of selling more or fewer units, holding price and mix constant. This separates market demand from pricing decisions. When revenue is down, the volume effect tells you whether the shortfall is a demand problem, a lost-customer problem, or something else entirely, rather than a pricing problem that a compliance review would catch.

Mix
Mix Effect

The revenue impact of selling a different composition of products, holding both price and volume constant. If your revenue is flat but average margin improved, the mix effect explains why: you shifted toward higher-margin products even without raising prices or selling more units. The mix effect is the one that most often surprises manufacturers, and it can move significantly without anyone noticing until PVM is run.

Price-Volume-Mix Bridge
Q1 FY2025 vs Q1 FY2024 · Specialty Parts Manufacturer
$0 $5M $10M $15M $20M $21.4M Prior Period +$1.8M Price −$0.9M Volume +$1.2M Mix $23.5M Current Period +$2.1M · +9.8% YoY
Baseline period
Positive contribution
Negative contribution
Current period

Why the mix effect matters most for manufacturers

Manufacturing businesses tend to run wide product catalogs: thousands of SKUs across product lines, some with high margin entitlement and others that are commodity items with full price transparency. The mix effect captures what happens when the composition of what gets sold shifts across those product lines.

Consider a manufacturer that runs a blanket 5% price increase. The high-value specialty parts absorb the increase and margins hold. The commodity parts often don't, because customers can source alternatives. The net revenue number looks like the pricing initiative worked, but the mix has shifted: volume is now concentrated in lower-margin items because the high-value parts saw some demand compression.

PVM attribution catches this. The price effect shows the increase holding partially. The volume effect shows some demand compression. The mix effect shows the shift toward lower-margin items. The combination tells the real story. Without PVM, "the pricing initiative was broadly successful" becomes the default read when it shouldn't be.

Watch for this pattern: revenue growing while gross margin percentage falls. That combination almost always indicates a mix shift, not a pricing problem. PVM analysis confirms which it is before the team debates the wrong question.

A manufacturing PVM example

Here is a worked example from a specialty parts manufacturer comparing Q1 FY2025 to Q1 FY2024. Total revenue moved from $21.4M to $23.5M, a $2.1M increase. The table shows where it came from.

PVM Attribution: Q1 FY2025 vs Q1 FY2024
Specialty Parts Manufacturer · Three-plant operation
Effect Amount What it tells you
Price +$1.8M Price increases partially held. Realized price up 2.4% on average against a 3.0% planned increase.
Volume −$0.9M Unit volume declined slightly in Q1. Demand softness concentrated in the standard catalog tier.
Mix +$1.2M Mix shifted toward high-value specialty parts. Complex assemblies grew as a share of total orders.
Net revenue change +$2.1M +9.8% YoY. Revenue growth is real but driven more by mix than price.

Without PVM analysis, the read is: "revenue is up nearly 10%, pricing is working." With PVM, the read is more specific: volume is actually declining, pricing held but came in 0.6 points below plan, and the revenue gain is largely driven by mix, specifically a shift toward the specialty segment. That is a different conversation with a different set of follow-on questions.

The follow-on questions for the VP of Pricing look different depending on the answer. A volume problem calls for a commercial response. A pricing compliance gap calls for an exception review. A mix shift calls for examining whether it's structural (the market is changing) or a one-quarter anomaly.

What data PVM analysis requires

PVM analysis runs entirely on transaction-level data from your ERP. The inputs needed are:

Units sold per item, per period
Realized selling price per unit, per period
Item classification: product line, pricing cohort, or taxonomy tier
Customer assignment, for customer-level PVM attribution
Plant or location identifier, for multi-site manufacturers

This data lives in your ERP's order and invoice tables. No external benchmarks are required. No surveys. No manual data collection. The entire analysis runs on what your ERP already recorded when orders were entered and invoices were posted.

The challenge is not collecting the data. It is getting it out in a format that allows period-over-period comparison by item, by cohort, by customer, and by plant, without spending hours in Excel each reporting cycle.

Running PVM in spreadsheets vs. ERP-native tools

Most manufacturers attempt PVM analysis in Excel first. The process typically involves pulling invoice exports from the ERP, cleaning and normalizing the data, building a pivot model, and manually constructing the waterfall bridge. For a business with 2,000 active SKUs and multiple plants, this takes a full day of analyst time per reporting period.

Spreadsheet PVM
· Manual export from ERP each period
· Cleaning and normalization before analysis
· Model breaks when export format changes
· Cannot consolidate multiple ERP sources
· No connection to pricing plan or targets
· Exceptions require manual hunting
ERP-native PVM
· Transaction data flows directly from ERP
· Normalization happens in the data layer
· Periods refresh automatically as transactions post
· Multi-ERP consolidation built in
· Tracks actual vs. pricing plan targets
· Exceptions surface automatically

The fragility of the spreadsheet approach compounds at scale. If your plants run different ERP systems, each system needs a separate export process, and the resulting data structures often don't align without significant manual reconciliation. Multi-ERP PVM in Excel is technically possible but practically unsustainable for a team without dedicated data engineering support.

How Marquis Pricing IQ runs PVM attribution

Pricing IQ · ERP-native module
PVM attribution that runs directly from your ERP, period by period.

Pricing IQ connects to your ERP and runs price-volume-mix attribution from transaction data. The bridge updates each period as invoices post. No exports, no manual bridging, no reconciliation between systems.

PVM attribution by cohort, by customer, and by plant
Actual vs. plan tracking against pricing targets set at budget time
Exceptions flagged automatically, linked to specific transactions
Works across multiple ERPs for multi-site PE-owned manufacturers

FAQ

Common questions about PVM analysis

Questions about price-volume-mix methodology, data requirements, and how manufacturers put it into practice.

What does price-volume-mix analysis mean?

Price-volume-mix analysis is a method for attributing changes in revenue or gross margin to three sources: how much came from selling at different prices (price effect), how much from selling different quantities (volume effect), and how much from selling a different composition of products (mix effect). Together, the three components account for 100% of the change between two periods.

How is PVM analysis different from a variance analysis?

A variance analysis compares actual results to a budget or plan. PVM analysis compares one period's actual results to another period's actual results and attributes the change to specific drivers. The two are complementary. You might run variance analysis to confirm whether you hit plan, then PVM analysis to understand why actual results moved the way they did between periods regardless of what the plan said.

What data is needed to run PVM analysis?

The core inputs are units sold per item, realized selling price per unit, and product classification for each transaction, compared across two periods. This data lives in the invoice and order tables of any ERP system. No external data, benchmarks, or surveys are required. The inputs are already in your ERP; the challenge is getting them out in a format suitable for period-over-period attribution.

How often should manufacturers run PVM analysis?

Most manufacturers run PVM analysis quarterly, aligned to financial reporting periods. Monthly is better for businesses with fast-moving pricing, commodity-linked inputs, or high SKU velocity. Annual-only is generally too infrequent to catch mix drift before it compounds into a year-end margin shortfall. The right cadence is the one that lets your pricing team act before the problem shows up in the income statement.

Can you run PVM analysis across multiple ERP systems?

Yes, but it requires a data layer that normalizes transaction records from different ERP schemas before the attribution runs. Manufacturing businesses operating multiple ERPs across plants need a consolidated item master and a unified transaction structure before cross-company PVM attribution produces meaningful results. Without that consolidation layer, the comparison is apples to oranges and the attribution is unreliable.

Is PVM analysis the same as price-mix-volume analysis?

Yes. Price-volume-mix, price-mix-volume, and PVM all refer to the same analytical framework. The order of the terms varies by industry convention but the underlying method is the same: decomposing a revenue or margin change into its price, volume, and mix components.

Ready to run PVM from your ERP data?

Schedule a demo and we'll walk through Pricing IQ running on real manufacturing data. Bring your pricing team and your most recent period results. We'll run the PVM bridge live.