6 Replies Latest reply on May 29, 2017 1:41 PM by bertrand

# Number of trucks required for a given load?

Hello everyone:

Am I looking for a solution to calculate the number of trucks required for a given load?

The cargo can be boxes, pallets, cylinders or anything that can be transported in a truck.

Transport units can be trucks of different capacities.

regards

Mauricio

• ###### 1. Re: Number of trucks required for a given load?

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

• ###### 2. Re: Number of trucks required for a given load?

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.

• ###### 3. Re: Number of trucks required for a given load?

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.

• ###### 4. Re: Number of trucks required for a given load?

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.

• ###### 5. Re: Number of trucks required for a given load?

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.

• ###### 6. Re: Number of trucks required for a given load?

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