Pricing for ranges

Hi Friends,

Requirment:

I have a requirment. Please suggest how to map in sap

we need to configure pricing for courier services as vendor

The conditions should as below

if it is 1-250 grams - Rs.10

if it is 251-500 grams - Rs.12

if it is 501-1000 grams - Rs.15

Analysis:

I tried to use the standard scale and graduated scale but it is not working. Because the scale calculation is done based on per unit price.

Example :

My requirment is suppose the weight is 300 gram the price should be Rs.12 only.

But if I use standard scale it is calculated as 300gram*Rs.12 = Rs.3600.

Hence using scales will not be helpful.

If you have any solution for this reqirment please share with me................

Thanks

Vibin