How can I calculate this. I have several products sold at 1 kilogram, a box can weight 4kg maximum. Products cannot be mixed in 1 box. I have a lot of orders of 1 or 2 or 3 kg, these oriders cannot be splinted over several boxes. How can I define per product how many boxes I will need? Eg 2 orders from 3 kg each is 2 boxes, 2 orders from 2 kg is 1 box, 3 orders from 3 kg and 1 order of 2 kg is 3 boxen, and so on. The formula must detect per product how many times a combination of maximum 4 can be created in order to ship the orders in a minimum number of boxen, respectievelijk the non splitten requirement. It seems difficult.

Wouldn't that be 4 boxes?

I think such optimization would require code. I don't think a simple formula would be able to capture the complexity necessary.

True, in factuur I want ed to write "2 orders from 3 kg and 1 order of 2 kg is 3 boxes" that makes 3 boxes since the order of 2kg cannot be splitted. Do you happen to know the name of the formula? Is it with solver or so?