Price Volume Mix Analysis (PVM) excel template with Charts - Sales mix and Gross Profit by Product
**** Warning : Waterfall Charts require at least Excel 2016. ******
This PVM (Price Volume Mix) excel template offers a model which turn simple input into insightful charts to understand your product mix and how it impacted your sales.
By entering your sales by product, Gross profit by product and volumes of products sold, you'll be able to see several different analyses showing which product performed the best and which product may need to be worked on
All the charts titles and tables have been automated. Just input the period you want to see in the input tab and it will flow through the model.
I have taken extra time to make it as easy and flexible as possible for any user to use this model, which is a FULLY UNLOCKED version, meaning you can adjust it the way you want!
Finally, I have also included in the model some links to great articles which explain the why and how of the Price Volume Mix analysis
I like it