Hi All,
I have a list of item(with info on the qty and their size) which I need select suitable box base on size and qty to fit it in.
Example cases:
Standard Box list(all item ignore their height):
Use box ABC(1): If the qty equal or less than 10, and the item size smaller than 10cmx10cm
Use box ABC(10): If the qty more than 10, and the item size smaller than 10cmx10cm
Use box DEF(1): If the qty equal or less than 10, and the item size smaller than 30cmx25cm
Use box DEF(10): If the qty more than 10, and the item size smaller than 30cmx25cm
Use box XYZ(1): If the qty equal or less than 10, and the item size smaller than 50cmx50cm
Use box XYZ(10): If the qty more than 10, and the item size smaller than 50cmx50cm
If I have an item name Z22(with qty 2 and size of 5cmx5cm): the suitable box for this item will be ABC(1)
as the qty less than 10 and the size less than 10cmx10cm
If I have an item name alpha01(with qty 20 and size of 24cmx33cm): the suitable box for this item will be XYZ(10)
as the qty more than 10 and the size larger than 30cmx25cm
Any coding that you guys can advice? as I really run out of idea to create the coding.
I have a list of item(with info on the qty and their size) which I need select suitable box base on size and qty to fit it in.
Example cases:
Standard Box list(all item ignore their height):
Use box ABC(1): If the qty equal or less than 10, and the item size smaller than 10cmx10cm
Use box ABC(10): If the qty more than 10, and the item size smaller than 10cmx10cm
Use box DEF(1): If the qty equal or less than 10, and the item size smaller than 30cmx25cm
Use box DEF(10): If the qty more than 10, and the item size smaller than 30cmx25cm
Use box XYZ(1): If the qty equal or less than 10, and the item size smaller than 50cmx50cm
Use box XYZ(10): If the qty more than 10, and the item size smaller than 50cmx50cm
If I have an item name Z22(with qty 2 and size of 5cmx5cm): the suitable box for this item will be ABC(1)
as the qty less than 10 and the size less than 10cmx10cm
If I have an item name alpha01(with qty 20 and size of 24cmx33cm): the suitable box for this item will be XYZ(10)
as the qty more than 10 and the size larger than 30cmx25cm
Any coding that you guys can advice? as I really run out of idea to create the coding.