You can most likely buy that from one of many bigger Transport companies around what world. Very little chance that someone would give you a entire FileMaker Solution for free, but have a look at
Any solution that you might try to use will need to consider the dimensions of the shipped objects and the dimensions of the truck's load space--not just its "capacity"
To simplify this problem is why many industries have standardized the pallets or other containers that they use. Without such a standard, this becomes a very complex problem.
Dimensions is a good start, but the total weight is also a factor, you can fill a truck with gold bars but it won't move.
Hello siplus and morgeboso.
There are many parameters to take into account.
- Unit dimensions of objects,
- Weight of objects,
- Possibility of palette,
- The contents of a palette for the objects selected for the palette,
- The possibility of putting pallets one on top of the other, one does not put a pallet of beer cans on packages of pasta or eggs,
- Number of pallets possible in the truck,
- Maximum weight transportable by the truck,
- Refrigerated or not.
And some more....
I forget the order for delivery if multiple points of delivery.
There is already enough fun but it is doable with several passes and recursive programs.
Yeah, of course you're right, there is a palette (no pun intended) of factors to be examined before even trying to minmax such a thing.
Probably a way to do it is to generate a lot of records representing possible shipments, have a efficiency and plausibility factor associated to each, sorting them by that factor and picking the first one. Might take a lot of time to develop, surely not something a developer would fork out for free.
Yes siplus, this is a way to do and leave the final choice to the driver.
It takes a lot of time to write such routines and I'm not candidate now. Perhaps when I'll be retired for fun whitout any pressure