Been trying to create a PVM-analysis without success.
Price Volume Mix effect
Anyone got samples on how to do it? Please help me....
Someone must ahve done this 🙂
There are probably some other names for it also. But the general idea is to compare sales in two time periods and see how much of the difference that comes from Price effect (same customers/products but sold at higher/lower price), Volume effect (same customers/products but different volume) and Mix effect.
My company is an OEM partner of Qlik, and our software's front-end uses QlikView to deliver the analytical output. We specialize in providing bottom-up price/volume/mix analysis. It sounds like we may be able to help you. Please feel free to write me at email@example.com.
The Kini Group
The attached spreadsheet can serve as a template for solving any PVM situation that you encounter. The spreadsheet also includes "Proof" calculations which show that the sum of the micro variances equal the correct macro totals. Just put the spreadsheet on "Show Formulas" and follow the calculation logic. The main point in the analysis is the correct extraction of Mix Variance from Volume Variance. Try looking at the link for an in-depth exposition of the analysis details.
The Mix Variance amount for each individual product is determined by 3 amounts:
. The difference between the price of the individual product and the Actual Group Budget Price.
. The difference between the product's Actual Product Mix and its' Budget Product Mix.
. The actual Group Total amount.
In the case of, for example, Product 1:
. $210 - $162 = $48
. 0.173913 - 0.300000 = -0.126087
. Product 1 Mix Variance = $48 x -0.126087 x 1150 = $-6960
Intuitive results . . . no anomalies . . . no "gotchas"
Are you attempting to do you PVM for two different time periods or Actual vs Budget? I have recently finished a model that does two different time periods with waterfalls, we included Currency effect within the pricing model also. Just wanted to clarify. I don't currently have an example that doesn't house actual data, but I might could mock up something if needed. But each model is usually very specific for business models also.
- restrict the data (File -> Reduce Data -> Remove all values)
- or copy only the datamodel into an empty application
and send it only to me by mail - will keep it confidential, whatever is in
Edith removed a signature.