Volume Mix margin analysis

Heres one for all you accounting types.

I am trying to find a spreadsheet that does volume, mix and margin analysis. I have got most of the way but I am a bit stumped, so if anyone has one I would be very very grateful.

Thanks

Simon

Volume and mix analysis can be a difficult challenge. The best course of action is to "Google" search "Volume and Mix Analysis". There are a couple of sites that might well be worth investigating:

http://towsonhigh55.com/links/MixVariance.htm
http://towsonhigh55.com/links/MixVariance.htm

These 2 sites provide complete, concise, practical, easy to comprehend "Micro to Macro" level solutions to this complex problem; complete .pdfs and downloadable explanatory .xlsx spreadsheets are provided. These solution(s) will give you the exact mix variance for a particular product within any product grouping and then show you how it "rolls up" the various levels of the product's budget/actual hierarchy. I sincerely hope that this helps and ends your mind bending headaches!

Simple Example.xlsx

The attached spreadsheet is an example that can be used as a template for Volume, Mix and Margin Analysis.

Intuitive results . . . no anomalies . . . no "gotchas" . . .

Correction . . .
The current link to the Volume and Mix Analysis site is http://www.volume-and-mix-analysis.com/