• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find price based on given price by volume

trprasad78

Member
Hi Experts need help.

I have attached sample file for reference.

I will copy past in put price with volume (qty) based on "IN PUT" price need to calculate output price.

Frankly speak i have no idea what bases will find the out put price.

in put price volume will not be same as expected order volume.

if volume increase discount also increase.

Need to find out price if we order more volume
 

Attachments

p45cal

Well-Known Member
You're wanting prices for 5k to 100k when you're only given prices below 1k.
If you assume a linear relation, the price will go below 0 aroiund the 10k mark. So it's not linear.

Most vendors give discounts for volume stepwise; eg. up to 1k 1$, >1k to $0.90, >5k to 10k $0.80 and change the price for the whole order, others say eg. for the first 1000 $1 each, for those from 2k to 5k $0.80 each, those from 5k to 10k $0.70 each and so on.

Without knowing the thresholds and a wider range of prices (greater volume) you're not going to be able to make a good guess. If you only have a wider range of prices you might be able to come up with a poor guess.
 

trprasad78

Member
You're wanting prices for 5k to 100k when you're only given prices below 1k.
If you assume a linear relation, the price will go below 0 aroiund the 10k mark. So it's not linear.

Most vendors give discounts for volume stepwise; eg. up to 1k 1$, >1k to $0.90, >5k to 10k $0.80 and change the price for the whole order, others say eg. for the first 1000 $1 each, for those from 2k to 5k $0.80 each, those from 5k to 10k $0.70 each and so on.

Without knowing the thresholds and a wider range of prices (greater volume) you're not going to be able to make a good guess. If you only have a wider range of prices you might be able to come up with a poor guess.
Thank you, yes true... understood, for poor guess what method we can use.

Any method is their for this kind of incomplete data?
 

p45cal

Well-Known Member
Even for a poor guess you still need a wider range of prices.
At the moment you have the same as: the price for 500 is $1 each, what's the price of 100,000?
Impossible.
FYI linear relationship:
76671
and zoomed in to when it hits 0:
76672
 
Last edited:
Top