# Find price based on given price by volume

##### 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

• 240 KB Views: 3

#### Belleke

##### Well-Known Member
Do You mean this?

#### Attachments

• 241.1 KB Views: 5

##### Member
Do You mean this?
No I am looking for this.
Even if give more volume formula has to generate discounted price based on input price pattern

#### 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.

##### 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:

and zoomed in to when it hits 0:

Last edited:

#### Belleke

##### Well-Known Member
Any method is their for this kind of incomplete data?
That is asking how to drive a car without engine.