Calculating units to corresponding boxes

[Early Bright]

Good afternoon!

I am currently looking for a way to automatically split orders in different size boxes. But I can't find a way to make this work, I hope someone can help me with this!

To explain further:

I have 5 differtent boxes:

Box A: 21-40 units
Box B: 16-20 units
Box C: 6-15 units
Box D: 3-5 units
Box E: 1-2 units

Customer A orders 177 units, which results in 4 boxes A, 1 box E and 1 box C.

How can I make it work so it gives me this result, basically skipping Box B and D?

If more information is required, I am happy to oblige. Hope someone can help me out with this!

 

[Toadstool]

Hi Early Bright,

I can see no reason you wouldn't use 4 box A and 1 box B, unless there's some kind of box/shipping costs you're not supplying?