Say you have period 1 in which you sell to articles
A1 Qty = 5 - Price = 10
A2 Qty = 5 - Price = 5
Total value = 75 - Avg price = 75 / 10 = 7,5
In periode 2, you sell both articles again but in different volumes and at different prices:
A1 Qty = 10 - Price = 8
A2 Qty = 5 - Price = 10
Total value = 130 - Avg price = 130 / 15 = 8,66
The average price has increased with 1,16. Now we are looking for a formula to explain this increase. Two factors have influenced this increase: the change in price and volume. Does anyone know a formula to calculate the differences. What made the price go up: change in volume or price or both and what's their individual part in the general increase? We are looking in a way to say that by example 0,85 of 1,16 is due to price increase and 0,31 is due to change in volume which has effect on average price?
Does anyone can help me out with this??
Thx,
Rudi
A1 Qty = 5 - Price = 10
A2 Qty = 5 - Price = 5
Total value = 75 - Avg price = 75 / 10 = 7,5
In periode 2, you sell both articles again but in different volumes and at different prices:
A1 Qty = 10 - Price = 8
A2 Qty = 5 - Price = 10
Total value = 130 - Avg price = 130 / 15 = 8,66
The average price has increased with 1,16. Now we are looking for a formula to explain this increase. Two factors have influenced this increase: the change in price and volume. Does anyone know a formula to calculate the differences. What made the price go up: change in volume or price or both and what's their individual part in the general increase? We are looking in a way to say that by example 0,85 of 1,16 is due to price increase and 0,31 is due to change in volume which has effect on average price?
Does anyone can help me out with this??
Thx,
Rudi