Forum Discussion
fresen
Feb 23, 2019Copper Contributor
Formula average
Hi, I want to find the average price of a product, but the product has 3 different prices - and I want the average based on which one sells most (if that's possible to understand)... ...
fresen
Feb 28, 2019Copper Contributor
1 product
3 Prices for the same product (ordinary/student/member)
Ordinary Student Member
Prices 82 54 44
% of sale. 33%. 53%. 14%
So it's one product, but with three different prices. I want to find the average outgoing price for that product, when i sell the product for different prices...
F.ex.:
Ordinary Student
Prices 100 50
% of sale 50% 50%
This would mean that the average outgoing price for the product - depending on how much the different prices sells - is 75.
Twifoo
Feb 28, 2019Silver Contributor
Given that you have only one product with 3 different prices at a specified percentage of sales mix, the weighted average sales price of your single product is calculated using the Sergei’s formula.