When calculating the freight cost of a job, conversion ratios can be used. Ratios are available to convert Weight to Cube or Cube to Weight depending on freight calculation requirements.
These business rules are setup as Attributes for each customer:
WGT_2_CUB (Weight to Cube)
CUB_2_WGT(Cube to Weight)
A conversion value is used to determine ratio required. Eg 333.33
Here is a step by step example of how the calculation process works with conversion ratio’s and finding the highest value to invoice.
Example Job: ABC-262222
Load: 5043.9 KG, 35.640 M3
Find relevant business rate cards within eCargo:
Rates: KG Rate $213.86 per 1000 KG
Cube(M3) Rate $71.29
Conversion Ratio: 333.33
Calculate all of the below to find the highest value to invoice:
1. Search for KG rate if available:
Calculate the KG weight by the rate per KG Eg. (5043.9KG/1000) = 5.044 * $213.86 = $1078.69
2. Search for M3 rate if available:
Calculate the M3 by the rate Eg. 35.64 * $71.20 = $2537.57
3. If an attribute found WGT_2_CUB (Weight to Cube) ie. Weight / Factor = M3 and a M3 rate exists:
Calculate (5043.9 KG / 333.33) = 51.13 M3 * $71.29 = $1078.75
4. If an attribute found CUB_2_WGT(Cube to Weight) ie Cube(M3) * Factor = KG and a KG rate exists:
Calculate (35.60 M3 * 333.33) = 11,866.55KG / 1000 * $213.86 = $2537.78
If your business holds a Weight to Cube attribute = 333.33 but does not have any M3 rates in the system then only point 1 can be calculated. $1078.69
If M3 rates were available then it would also access points 1,2, and 3 to get the highest invoice value. $2537.57
If your business holds a Cube to Weight attribute instead of a Weight to Cube, it would not require a M3 rate in the system and then it will take points 1 and 4 and find the highest invoice value.
User can define the ratio value to use. 333.33 is the commonly used value.