Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Shipment rating based on Factor based Rates. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Shipment rating based on Factor based Rates.

Received Response
11
Views
1
Comments
edited Jul 6, 2018 3:59PM in Transportation Management 1 comment

Content

We have a below scenario for Freight Calculation:

Shipment Freight Calculation

         

 

Stop Sequence

Location

Stop Type

Product

Factor (M)

Qty (N)

Base Rate / Unit (O)

Factor Based Freight (P = M * N * O)

 

1

S1

Pick Up

 

 

 

 

 

Order 1

2

D1

Drop 1

A

1.0

1

10000

10000

Order 2

B

0.8

1

10000

8000

Order 3

3

D2

Drop 2 (Farthest Delivery Location)

B

0.8

1

15000

12000

Order 4

C

1.2

1

15000

18000

Order 5

C

1.2

1

15000

18000

Order 6

C

1.2

1

15000

18000

         

Factor Based Freight

 

 

84000

Additional Information

           

1

Base Rates are as Below:

         
 

Lane

Rate/Unit

           
 

S1-D1

10000

           
 

S1-D2

15000

           
                 

2

Product Factors

           
 

Product

Factor

           
 

A

1

           
 

B

0.8

           
 

C

1.2

           

 

Can we use Order flex field to store Product Factor for each order? We can then arrive at Freight as a multiplication of Base Per unit Freight for a lane multiplied by the Factor stored on the Order as depicted above.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!