Simple Contribution Margin Variance Calculator

Description
Basic calculator that breaks down contribution margin chance into its component. It calculates the contribution of the change in price, cost, quantity and its combination to the overall change in contribution margin.

These calculation can be used to multiple comparisons such as:

* Actual vs budgets or forecast
* period over period change

This calculations can be easily replicated to for comparing multiple businesses or product lines vertically or horizontally.

To use the template you just have to hard code the values in the quantity, price and cost lines that are highlighted with blue font. Bellow those cells you would find the calculation for each component.