- #1

- 4

- 0

I am trying to come up with a formula that will generate a price based on its cost. The only trick is that it cant be something constant like 20% or 30% more than the cost. It has to be a formula that adds a bigger profit on smaller numbers and lower profit on bigger numbers.

So on a straight forward 20% on top cost would be:

Cost*1.2=Price ---- so $1.00 cost would result $1.20 and $10.00 would result $12.00 and $100 cost would result $120.00

What i would like is smaller number costs from $0.50-$1.00 to be 150% profit, and 1.00 to 2.00 to be something like 100% profit, and 2.00-3.00 to be 75% profit and 5.00-10.00 to be 50% and 10.00-20.00 to be 25% and 20.00-50.00 to be 18% ---- except the curve the % change should be smooth in correlation to the increasing or decreasing of the cost price. So as the numbers are smaller (ex. $0.50 or $1.00) the percentage starts very high and decreases dramatically and levels out around $20.00-$80.00 and higher to 17-18%.

Any ideas on how to do this with a 1 line formula? Any help would be much appreciated.

-Raf