I'd like to optimize the loading problem in first-mile delivery that maximize the occupancy of the truck. The main question to be answered is this: with the given truck, would this list of items fit or not fit? If fit, can we know the visualization of the items in the trucks? If not, can we know the items that are not carried?
My early research is that this problem is like the container loading problem (clp). The items are in cartoon, and I just want to know for each truck. The items are weakly heterogeneous but they tend to have a lot in number of quantity (since it is first mile delivery). Any advice about how to solve this? I would want to stay as close as possible with Excel and Python.