Volume Price Mix Calculation

[Drewftaylor]

HI,

not neccesarily an Excel issue specifically, but i'm trying to work out the impact a change in sales has on a ratio.

the table below shows a loose illustration comparing the year on year movement of Cost vs Sales. I want to show how the impact of price movements for each line contributes to the total.

As the variable in this instance is a denominator, its not a simple to calculate. (Cost of goods is easier, as you can do (change in cost) / sales to work out the impact)

Any help would be marvelous, as i've trawled the internet with no solution.