next fit algorithm bin packing in QV?

[shahafei2]

Hi all,

I'm wondering if there is a way to run a "next fit algorithm" in QV in order to calculate the minimum amount of cartons and movements

in my scenario i have 3 zones at the WH(A, B, C)

In each zone there are unique products and the amount of available inventory per product is known 

the carton volume and dimensions are fixed $(v_Car_vol),$(v_Car_length),$(v_Car_width),$(v_Car_width)

The DB is based on the following data 

Product:

ProductID,

Unit_length,

Unit_width

Unit_height

Unit_vol,

Zone,

Units_In_Inventory

Orders:

OrderID,

Delivery_Date,

Delivery_Time,

ProductID,

Qty

What will be the best way to calculate the amount of cartons  per order 

and to present the required daily movements of cartons between the different zones?