Pricing Scaling Problem

[Former Member]

I have a situation where I have to do the pricing on the below basis.

For 100 qty the baseline charge is fixed 10000/-.

Base Line Rate is fixed 10000 per 100 qty

Now if I order 120 qty

then

for first 100 qty Rate is 10,000.00

for the next 5 qty 500.00

for next 5 the rate should be 98/per piece total 490.00

for next 10 the rate should be 97/per piece Total 970.00

So the Total 11,960.00

Now if I order 80 qty then

for first 100 qty Rate is 10,000.00

for the next 5 qty -500.00

for next 5 the rate should be 98/per piece total -490.00

for next 10 the rate should be 97/per piece Total -970.00

So

Total 8,040.00

Could u plz help me on this. I need this urgent,

[Former Member]

Hi,

What is the problem?

Looks like you have posted the requirement here and looking for a solution.

Please read the rules of engagement before you post.

Step 1: Finding An Answer

Rule number one: Try to find the answer first. There are tons of resources out there, show that you have tried to find the answer. A question that shows that the person is willing to try and help themselves is more likely to be answered than one which simply demands information. Tell us what you have done to try and solve the problem yourself - often we can learn from that too!

Search the forums, the articles, the blog posts and the Frequently Asked Questions (FAQ) in the Wiki for your topic.