A little while ago I asked this question on SuperUser:


I wanted to find a formula for pricing my products in spreadsheets, so that I could price them fairly such that the more usage would have more discount.

However, based on the answers, I found out that the resulting chart would be something like this:

enter image description here

Which is absolutely wrong. Because it financially means that "if you buy 4000 units you should pay more than when you purchase 8000 units". Of course it doesn't make sense. Now I'm trying to find the data series that can create an increasing amount of payment which results to a linear pattern. But I can't figure it out, and my mathematical knowledge is not helpful here.

Where can I ask questions of this kind?

  • economics.stackexchange? Although this is not macroeconomic, it's more business related. – JTP - Apologise to Monica Jul 14 '15 at 14:12
  • By the way, the cost curve is too steep. When you double the volume, you should drop unit price by perhaps 10%, not much more. – JTP - Apologise to Monica Jul 14 '15 at 14:26
  • @JoeTaxpayer, can you guide me in the right direction. What I want is to encourage customers to buy more. I don't know how to get to that aim though. I'd really appreciate it if you can give me a clue. – Saeed Neamati Jul 14 '15 at 14:41
  • 1
    Possibly on-topic at startups.stackexchange.com Not sure though. – JohnFx Jul 14 '15 at 18:28

You must log in to answer this question.

Browse other questions tagged .