Price Mix Volume analysis


Any chance of developing a comprehensive scenario were sales increase/decrease is shown by - Price Mix & Volume contribution of this year vs last year (or this year vs. budget).
ideally it would also factor in “New Products” (products not sold in last year) & discontinued products (products not sold in this year).

below is a sample in Excel from Dr. Julie Bonner (
this sample does not have the “New Products” or “Discontiuned Products”


Yes, this is possible to accomplish. Will need more details in order to answer your question. I would suggest trying to start this on your own, then if you run into an issue provide us with the PBIX file and a detailed question of what you need answered. Sam has done many video’s on budgeting, comparing actuals to budget, etc…