Syntha Lab RU

Revenue analysis: price, volume and mix

Splits the deviation of revenue from plan into three causes: price change, volume change and change in the product mix. Answers why revenue did not match.

Revenue, profit and costs For whom: Finance directors, sales directors and category managers.

Calculate on your data →

At a glance

What question does it answer?
Why revenue did not match plan: prices, volume or sales structure.
What data is needed?
For each category or item: units and average price excl. VAT, plan and actual for the same period.
How to read the result?
The three effects add up to the revenue variance. The price effect is discounts and price rises; the volume effect the total units sold; the mix effect whether more expensive or cheaper items sold than planned. The main factor is named in the conclusion. Example on the default values: Plan RUB 51.5m, actual RUB 49.625m: a variance of −RUB 1.875m. The price effect is −RUB 2.435m, volume +RUB 0.28m and mix +RUB 0.28m. The main factor is price: check discount depth. If the main factor is price, look at discount depth and share; if volume, traffic and conversion; if mix, the buying structure. Next: “Income and expense budget: plan versus actual” and “Gross-margin bridge by cause”.

Why and how to reason

If revenue did not match plan, the question “why” splits into three: prices changed, more or fewer units were sold, the structure changed (more cheap or more expensive items sold). The calculation separates these causes so that their sum agrees with the total deviation.

Price effect = actual units x (actual price - plan price): what you would have received selling the actual quantity at a different price. Volume effect: the total number of units changed while the structure stayed as planned. Mix effect: the remainder from shifting toward more expensive or cheaper items.

Example. Plan RUB 51.5 m, actual RUB 49.625 m, deviation -RUB 1.875 m. Price: 1,650 x (-500) + 2,700 x (-400) + 3,100 x (-200) + 1,800 x 50 = -RUB 2.435 m. Volume +0.28 m, mix +0.28 m. Total -2.435 + 0.28 + 0.28 = -RUB 1.875 m. So volume and structure pulled revenue up, but price cuts pulled it down hard.

When to use it

It comes in handy to review revenue plan fulfillment by category: a season, quarter, promotion. It helps determine where to look for the cause: prices, traffic or assortment. Assumption: items are comparable between plan and actual. New and dropped items are shown separately. It does not answer why prices or volume changed: that is the next stage of review.

How to read the result

Find the largest effect in absolute terms. Price is negative (-RUB 2.4 m): discounts and price cuts took away more than volume gave. Then you need to examine whether the discount paid back in profit, in “Promo discount” and “Elasticity”. Volume and mix are positive: there is enough traffic and structure. If volume is negative, the problem is traffic and conversion. Decision: focus on the cause with the biggest effect and check it with a separate calculation. For the largest effect open the next calculation: price, “Promo discount”; volume, forecast; mix, ABC. It is worth writing the cause next to the number so you do not search for it again in the next report.

Common mistakes

The usual mistakes: comparing revenue with and without VAT; using different item lists in plan and actual; computing the price effect from an average price. Also: forgetting that a price cut can be a deliberate part of the plan. Also: confusing the price effect with platform discounts. Also: ignoring new items.

What data is needed?

  • For each category or item: units and average price excl. VAT, plan and actual for the same period.
  • Where to take it: units and price excl. VAT for plan from the approved sales plan; for actual from the sales report in 1C or the ERP for the same period; rows are categories or product groups, identical in plan and actual. Merge only similar items.

How it is calculated

StepFormula
Price effectΣ actual units × (actual price − plan price)
Volume effect(Σ actual units ÷ Σ plan units − 1) × plan revenue
Mix effectΣ actual units × plan price − (Σ actual units ÷ Σ plan units) × plan revenue
New and droppedRevenue of new items (plan 0) − planned revenue of dropped items (actual 0)
CheckPrice + volume + mix + new and dropped = actual revenue − plan revenue

Worked numbers

Default values from the app; in the interactive version you enter your own.

Revenue: plan
51.5 m ₽
Revenue: actual
49.6 m ₽
Variance
−1.88 m ₽Equals the sum of the four effects below.
Price effect
−2.44 m ₽Actual units × (actual price − plan price): discounts and price rises.
Volume effect
279,891 ₽How the total units sold changed at the planned mix.
Mix effect
280,109 ₽A gain if more expensive items sell than planned, a loss if cheaper ones.
New and dropped items
0 ₽Revenue of items missing from the plan minus the planned revenue of items that did not sell. The price effect does not apply to them.
What the revenue deviation is made of
Waterfall: Price −2.44m, Volume +280k, Mix +280k, New and dropped 0, Total deviation −1.87m−3m−2m−2m−1m−500k0PricePricePrice: −2.44m−2.44mVolumeVolumeVolume: +280k+280kMixMixMix: +280k+280kNew and droppedNew and droppedNew and dropped: 00Total deviationTotal deviationTotal deviation: −1.87m−1.87m₽
  • positive
  • negative
  • total
Data as a table
StepChangeLevel
Price−2.44m−2.44m
Volume+280k−2.16m
Mix+280k−1.87m
New and dropped0−1.87m
Total deviation—−1.87m

By category

CategoryRevenue varianceOf which price
Outerwear−2.3 m ₽−825,000 ₽
Dresses840,000 ₽−1.08 m ₽
Knitwear−130,000 ₽−620,000 ₽
Accessories−290,000 ₽90,000 ₽

Revenue is below plan by 1.88 m ₽. The main factor: price (2.44 m ₽). If it is price check discount depth; if volume, traffic and conversion; if mix, the buying structure.

Nuances and limits

  • The mix effect depends on how detailed the rows are: combine only similar items.
  • New and discontinued items are counted separately: enter them in the table, do not set them to zero.
  • Take price excl. VAT and before discounts if you analyze the effect of discounts separately.

Terms used

Calculate on your data →