Shipment rating based on Factor based Rates.

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.