Looking for some assistance...

I am trying to determine how to create a summary that will analyse the
differnce between Revenue from one quarter to another...

For Example

In Quarter 1

Part Unts Price Revenue
A 10 5 50
B 5 3 15

Total revenue for quarter is 65

In Q2
Part Unts Price Revenue
A 20 4 80
B 6 3 18

Total revenue for quarter is 98

So we had a 33 change in revenue from Q1 to Q2...so how much was related to
volume, how much to Price erosion and how much to Mix?

I know how to isolate the ASP impact and can get to a combined Mix/Volume
dirrerence....but I will be damed if I can remember how to split out voiume
from mix.....any help would be greatly apprecaited.