I have a problem with a theme of scales, as they talked on this subject.
I have clients to whom they sell "level of volume," but as we know it is not so standard, for example:
I have a negotiation with 5 clients (who do not have any relation to one another, are not customer groups) and between 5 will carry 1 000 000 pieces of the same material. Each of them have price scale differently:
500,000 - $ 100.00 Material A
1,000,000 - $ 95.00
500,000 - $ 200.00 Material A
1,000,000 - $ 170.00
500,000 - $ 90.00 Material A
1,000,000 - $ 80.00
and so on with each client, the issue here is that each one of them I can ask for less than a million, but by having prior negotiation should I give the price of the scale of the million pieces (for example if A customer buys 50,000 I have to give the price of 95 rather than 100) have already identified a field in order to put the price range to be taken, but at the time of the calculation of prices, not taking that value, and even included a formula within the framework of prices for base camp to read this scale, but still does not take courage.
Have any of you know any exit, subroutine or formula that can take to make this calculation?
I thank you in advance for your time and attention