freight costs and graduated interval scales

[Former Member]

hello, friends.

we have a requirement for calculating shipment costs. there is a pricing scenario wherein there is a fixed rate for a trip up to, say, USD 500.00 for the first 20 cubic meters. any volume above this, and the shipping charges will be USD 30.00 per cubic meter. so, if the shipment totals 22.5 cubic meters, the shipping charges should be USD 575.00, (USD 500.00 for the first 20 and USD 75.00 for 2.5 cubic meters times USD 30.00).

graduated interval scales should have been perfect for this, but grad int scales are not supported in SAP Transportation.

would anyone suggest an alternative?

many thanks!

jonathan

[reazuddin_md · Accepted solution]

Yeah, Graduated scales doesnt support , instead SAP has provided to calculate shipment costs based on different parameters hence given as "Multi Dimensional " freight condition types.

find the below eg: & apply it to your requirement.

eg: If you want to capture frieght costs depends on parameters such as duration & distance.

X - D u r a t i o n

-

---

Min-----10hr -

---

15hrs-----20hrs

D - Min---rs 5/--- 7/

---

9/

---

15/

i

s-- 500KM -20/km----22/km25/km--

---

30/km

ta

n1000Km25/km---28/km-30/km----35/km

c

e1500km-30/km---33/km35/km----40/km.

(Note: X - axis = Duration & Y-axis = Distance)

Now as shown in example, you can appy it to your requirement as well

hope it helps you

[Former Member]

hello, friends. this was how we finally did it, and it works for certain situations (depending on the rate differences).

first we defined 3 condition types -

Z001 for the fixed rate of USD 500.00

Z002 for the per cubic meter rate of USD 30.00

Z003 a fixed rate condition type for the correction between the fixed rate of USD 500.00 and the per cubic meter rate, for the first 20 cubic meters.

logic:

1. since graduated interval scales are not supported, Z002 will calculate from 0 cubic meters, meaning USD 30.00 X 22.5 cubic meters = USD 675.00.

2. Z003 will then be fixed used to "correct" the discrepancy for the first 20 cubic meter, calculated as (excess rate - fixed rate) x 20, or [USD 30.00 - (USD 500.00/20 cubic meters)] x 20 = USD 100.00.

we then assign Z001 to exclusion group Z01, and Z002 & Z003 to group Z02. the exclusion rule F was used.

the system will now compare the fixed rate and the calculated excess rate as:

USD 500.00 compared to USD 675.00 - USD 100.00 = USD 575.00.

the system chooses the latter rate.

alternatively, exclusion group Z02 could include 3 condition types instead of just 2. these condition types could be -

Z002 - the rate of USD 30.00 per cubic meter

Z004 - a fixed rate of USD 500.00 (with reference to Z001)

Z005 - a fixed rate of USD 600.00 (USD 30.00 x 20 cubic meters), which will be a corrective entry.

*the formula may not work for all situations, but the idea is that if the actual volume falls below 20 cubic meters, the results of the calculations forces the system to choose condition type Z001.

thanks.

regards.

Edited by: jonathan y on Mar 4, 2010 6:54 AM

[Former Member]

This message was moderated.