help in modelling transport
Posted: Sat Jul 22, 2017 11:10 am
Hello,
My aim is to reduce the freight cost of shipping parcels(cartons) having a certain volume either by using means of pallet or parcel shipping.This is decided on SAP by the parameter Volume(volume per order).I am aiming to alter this volume parameter in my model.
Every order has a certain number of parcels(cartons) to be shipped with a certain volume.Also,the pallet capacity is not an important factor and generally 1 pallet is used for shipping these parcels(cartons).
Here are the challenges I am facing during modelling:
1.If then else("Volume per order<=0.9,Parcel shipping method,Pallet shipping method)
I want input the same relation to the model.
2.The freight cost for parcels are calculated by multiplying the number of parcels(cartons) with a constant price for a parcel(carton).But,I have a lookup table of volume per order shipped and freight cost incurred for the pallet shipping method(using historical data).I need to input this lookup table into the model to calculate the cost incurred by shipping pallets.
Then,my final idea is to find the min of the two freight costs associated with Parcel/pallet shipping ways.
Please help on the above two points
My aim is to reduce the freight cost of shipping parcels(cartons) having a certain volume either by using means of pallet or parcel shipping.This is decided on SAP by the parameter Volume(volume per order).I am aiming to alter this volume parameter in my model.
Every order has a certain number of parcels(cartons) to be shipped with a certain volume.Also,the pallet capacity is not an important factor and generally 1 pallet is used for shipping these parcels(cartons).
Here are the challenges I am facing during modelling:
1.If then else("Volume per order<=0.9,Parcel shipping method,Pallet shipping method)
I want input the same relation to the model.
2.The freight cost for parcels are calculated by multiplying the number of parcels(cartons) with a constant price for a parcel(carton).But,I have a lookup table of volume per order shipped and freight cost incurred for the pallet shipping method(using historical data).I need to input this lookup table into the model to calculate the cost incurred by shipping pallets.
Then,my final idea is to find the min of the two freight costs associated with Parcel/pallet shipping ways.
Please help on the above two points