Skip to Content
0
Former Member
May 12, 2008 at 06:36 PM

Pricing Scaling Problem

21 Views

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,