Price, Volume and Mix Analysis in FMCG

Price-volume-mix analysis (PVM) shows how much of a rise or fall in FMCG sales value came from realized prices, total units sold or a shift in the mix of products sold. The three effects add up to the change for comparable products. If the assortment also changed, add separate lines for new and discontinued products.

What do price, volume and mix measure?

  • Price effect measures the change in realized price per SKU, applied to the units it sold in the current period. A higher shelf price or a smaller average discount can both increase realized price.
  • Volume effect measures the change in total units sold while holding each SKU’s price and its share of units at the base-period level.
  • Mix effect measures the change in the share of units sold by each SKU, valued at base-period prices. Selling a larger proportion of higher-priced packs can raise sales value even when total units stay flat.

How to calculate price, volume and mix

Suppose a snack brand compares two four-week periods across the same stores. Both SKUs are 100 g packs, so volume is measured in packs sold. Each price is the SKU’s retail sales value after discounts divided by its packs sold in that period. The figures are illustrative and use US dollars.

SKU Base units Base price Current units Current price
Original 100 g 600 $2.00 550 $2.10
Premium 100 g 400 $3.00 550 $3.20
Total packs 1,000 — 1,100 —

Base-period sales were $2,400 (600 × $2.00 + 400 × $3.00). Current-period sales were $2,915 (550 × $2.10 + 550 × $3.20). The bridge needs to explain a $515 increase, or 21.5%.

1. Calculate the volume effect

Start with the base period’s weighted average price of $2.40 per pack ($2,400 ÷ 1,000 packs). Apply it to the change in the total number of packs sold. This keeps the base mix of 60% Original and 40% Premium in place.

Volume effect = (1,100 − 1,000) × $2.40 = +$240

2. Calculate the mix effect

At the base mix, 1,100 packs would split into 660 Original and 440 Premium. Actual sales were 550 packs of each SKU, a difference of 110 fewer Original packs and 110 more Premium packs. Value those differences at each SKU’s base price.

Mix effect = (550 − 660) × $2.00 + (550 − 440) × $3.00 = +$110

3. Calculate the price effect

Multiply each SKU’s change in realized price by its actual current-period volume. Original contributes $55 and Premium contributes $110.

Price effect = ($2.10 − $2.00) × 550 + ($3.20 − $3.00) × 550 = +$165

4. Reconcile the bridge to current sales

The bridge applies the changes in order, starting with total volume, then product mix, then price.

Bridge step Effect Sales after step
Base-period sales — $2,400
Volume +$240 $2,640
Mix +$110 $2,750
Price +$165 $2,915

The effects add up to $515 ($240 + $110 + $165), which matches the recorded sales increase. Applying price changes to current units puts the overlap between price and quantity changes in the price effect. Use the same calculation order across reports so the lines stay comparable.

How to handle new and discontinued products

Build the price, volume and mix bridge for SKUs with comparable data. Add current-period sales from confirmed launches under new products. Deduct base-period sales from confirmed exits under discontinued products.

Suppose a launch adds $180 in current sales and a discontinued SKU had $90 in base-period sales. Portfolio sales rise from $2,490 to $3,095. The full bridge is $240 + $110 + $165 + $180 − $90 = $605.

If an existing SKU shows zero sales or disappears from a file, check distribution, stock availability and data coverage before assigning it to a launch or exit. When an outlet stops reporting, keep the comparable-store result separate and account for the coverage change when reconciling full totals.

How FMCG teams use a PVM bridge

  • Investigate price changes. Compare realized prices by retailer with shelf prices and promotion dates. This helps identify which accounts or sales weeks contributed most to the price line.
  • Investigate volume changes. Compare distribution, availability and units sold per selling store. A drop concentrated in outlets with stock gaps calls for a different action from a drop in stores with steady availability.
  • Investigate a shift in product mix. Check where Premium gained share and whether the pattern persists across retailers or depends on a promotion. In the example, Premium rises from 40% to 50% of packs sold, making it the first SKU to review.

Keep the time windows, channel coverage and volume units comparable. Use a consistent sales-value definition across periods, including how you handle discounts, returns and taxes. To see whether the brand kept pace with its category, pair the bridge with FMCG market share analysis.

Frequently asked questions

Can revenue rise when total units sold stay flat?

Yes. At 1,000 packs and unchanged prices of $2.00 and $3.00, a shift from 60% Original and 40% Premium to an even split adds $100. The whole increase is a mix effect.

Can I use average selling price for a PVM analysis?

Use realized average selling price for each SKU in each period. In the example, average revenue per pack rises from $2.40 to $2.65. Of that $0.25 increase, $0.15 comes from price changes within the two SKUs and $0.10 from more of the higher-priced SKU selling.

How do promotions affect price and mix?

A discount lowers the price realized on promoted units. A promotion can also change the share of units sold by each SKU and move the mix effect. To estimate incremental demand from the promotion, compare it with a sales baseline and account for timing and availability.

Can I calculate price-volume-mix in Excel?

Yes. Put each SKU on one row with units and sales value for both periods. Calculate base and current realized price, base share of units and expected current units at that base share. Add columns for each SKU’s mix and price effects, then sum them and add the portfolio volume effect. Use a final check cell to confirm that the bridge equals current sales minus base sales.

Put your sales bridge in market context

TrendBox tracks observed retail prices, distribution and sales velocity in traditional retail. Explore TrendBox’s measurement and pricing services.

If you’re investigating a revenue change across categories, retailers or regions, talk to TrendBox.