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,