Flat Rates in Rate Tables

[Former Member]

Hi All,

How to implement the following scenarios in Rate Table / Calculation Sheets.

Case1:

Upto 15kg - USD 100 (Fixed)

15-30kg    - USD 10 per KG

31-50kg    - USD 12 per KG

51+ kg      - USD 13 per KG.

Case2:

1 Quantity - 100 USD

Every addnl Quantity - 80 USD

Please help on how to create Rate Table / Calculation rule for the above cases.

Thanks,

Michael M

[tarunkumar · Accepted solution]

Hi Michael,

you can setup a rate table with BASE scale and starting your scale item from ZERO.

ZERO scale item shall be marked as 'absolute' and rest all should be modeled as 'relative'.

[Former Member · Accepted solution]

Thanks Tarun...

It Helped..

[Former Member]

Any Help?

Thanks,

Michael.

[rohit3611]

Hi Michael,

Case 1 : We have created the rate table like with to scale

It worked.

Case 2: - You have to use clipping rate, for that in calculation sheet use method as clipping and in rate table check the rel cal method check box.

Best regards,

Rohit