Hi Members,
Have gone through the Model 1 and Model 2 for fuel surcharge calculation given by SAP. As per my understanding these scenarios do not fit my current requirement. Hence require expert guidance on below Shipper scenario in SAP TM.
a. Fuel Base Surcharge is fixed with carrier as per the agreement. It shall be different for each carrier.Example- $10 is fixed in the agreement. This can be maintained at agreement level.
b. Current Fuel Index is updated every month. This can be maintained with a rate table with "CAL_DATE"(Calculation Date) as a Calculation Base. Example as per today's date it is $15.
c. Surcharge will be calculated as below
%increase ($15-$10)/$10= 50%. 50% will be multiplied by a factor which is agreed with carrier example, factor is 60% (60% can also be maintained in agreement). So 60% of 50%= 30%.
d. Base rate per kg is $6. So 30% of $6 is $1.8 which is the surcharge.
In step C- how can the divide operation be performed in calculation sheet to calculate percentage increase?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.