Price-volume-mix decomposition of spending · Calculation guide

Use comparable quantity units across products.

Calculation guide

First scale base-period quantities to the current total, change their mix at base prices, then reprice actual current quantities. Both periods must have positive total units.

volume = (Q₁/Q₀−1) × spend₀. mix = Σp₀q₁ − spend₀−volume. price = Σ(p₁−p₀)q₁.

Inputs

Base units

Example entry 10.

Current units

Example entry 5.

Base unit price

Example entry 10 (in the selected currency).

Current unit price

Example entry 11 (in the selected currency).

Worked example

Product volumes and prices

Base unitsCurrent unitsBase unit priceCurrent unit price
1051011
10152021
ResultValue
Total spending change70
Volume effect0
Mix effect50
Price effect20

Interpreting the result

The three effects add to the spending change. A positive mix effect means the new quantity mix puts more weight on products with higher base-period prices.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Base units (row 1)1011Total spending change7060
Current units (row 1)56Total spending change7081
Base unit price (row 1)1011Total spending change7060
Current unit price (row 1)1112Total spending change7075
Price-volume-mix decomposition of spending →

Sources