Visit my blog: www.undercontrolling.com You can find the excel file and the post related to this video in the following url: undercontrolling.com/sales-br...
Super helpful. How do you handle when a new SKU is added in a subsequent period? There will be 0 quantity sold at $0 the prior period which creates a formula error. How do you handle when a sales number is negative (e.g., a return)?
Hey this is a great video. How would this work if you had different size shirts under the colors that also has different prices so that it is a another level of mix
Question: how can I incorporate discount impact into this model.. for example make turnover "net", add a discount column and spit the impact into price change and discount change..
Hello Amir. You can check the post here: undercontrolling.com/sales-bridge-volume-price-mix-analysis/ Moreover, in the post you can find the excel I use in the video: undercontrolling.com/wp-content/uploads/2019/11/Sales-bridge.xlsx Hope it helps.
This analysis is not correct, formulas are wrong for volume. For example, if you’re bridging to actuals for “T Red”, your units went from 30->40, the “volume” piece of the delta should thus be positive, as should the mix piece bc the price/unit is unchanged and higher than the W.A. Price of 110/unit…
Thank you so much and appreciate for being so generous for sharing !
Great video...simple, clear and focused. Keep doing this kind of content, we are pleased to watch it.
Simple but powerful! Thanks
Buen vídeo!
Super helpful. How do you handle when a new SKU is added in a subsequent period? There will be 0 quantity sold at $0 the prior period which creates a formula error. How do you handle when a sales number is negative (e.g., a return)?
Hey this is a great video. How would this work if you had different size shirts under the colors that also has different prices so that it is a another level of mix
Question: how can I incorporate discount impact into this model.. for example make turnover "net", add a discount column and spit the impact into price change and discount change..
Great video and blog post. I tried to make this myself a few weeks ago and failed to get the variance numbers to balance!
Thank you for your comment. I am glad the video helped you to carry out the correct analysis.
how to make that chart?
Can we have the excel please
Hi ,Thank you for video , any chance to get formula
Hello Amir. You can check the post here: undercontrolling.com/sales-bridge-volume-price-mix-analysis/
Moreover, in the post you can find the excel I use in the video: undercontrolling.com/wp-content/uploads/2019/11/Sales-bridge.xlsx
Hope it helps.
Can you please share the excel
So wrong . How can you use mix to calculate volume impact ? 😮
This analysis is not correct, formulas are wrong for volume. For example, if you’re bridging to actuals for “T Red”, your units went from 30->40, the “volume” piece of the delta should thus be positive, as should the mix piece bc the price/unit is unchanged and higher than the W.A. Price of 110/unit…