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 units | Current units | Base unit price | Current unit price |
|---|---|---|---|
| 10 | 5 | 10 | 11 |
| 10 | 15 | 20 | 21 |
| Result | Value |
|---|---|
| Total spending change | 70 |
| Volume effect | 0 |
| Mix effect | 50 |
| Price effect | 20 |
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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Base units (row 1) | 10 | 11 | Total spending change | 70 | 60 |
| Current units (row 1) | 5 | 6 | Total spending change | 70 | 81 |
| Base unit price (row 1) | 10 | 11 | Total spending change | 70 | 60 |
| Current unit price (row 1) | 11 | 12 | Total spending change | 70 | 75 |
