Price Mix Volume analysis


#1

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).

Thanks,
Enayat.
below is a sample in Excel from Dr. Julie Bonner (coeurbridge.com)
this sample does not have the “New Products” or “Discontiuned Products”


#2

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…

Thanks
Jarrett

Enterprise%20DNA%20Expert%20-%20Small