Icon

Truck Load Optimization

<p><strong>Truck Load Optimization</strong></p><p>This workflow uses linear programming to optimize item allocation into the fewest number of trucks while respecting constraints on item count, weight, and volume per truck.</p><p>After uploading an item list and setting the constraints, the data is reshaped for optimization, and a mathematical solver selects the best set of items for the current truck. The chosen items are grouped and labeled with a truck ID, while any leftover items are passed to the next loop iteration. This process continues until all items are allocated, resulting in a complete, constraint-respecting truck loading plan that can be reviewed in an interactive dashboard and downloaded.</p>
Collect items grouped into this iteration's truck load
Repeat the loop with pool of items leftover from previous trucks

Truck Load Optimization


This workflow uses linear programming to optimize item allocation into the fewest number of trucks while respecting constraints on item count, weight, and volume per truck. After uploading an item list and setting the constraints, the data is reshaped for optimization, and a mathematical solver selects the best set of items for the current truck. The chosen items are grouped and labeled with a truck ID, while any leftover items are passed to the next loop iteration. This process continues until all items are allocated, resulting in a complete, constraint-respecting truck loading plan that can be reviewed in an interactive dashboard and downloaded.

Data Ingestion and Constraint Selection
Data Reshaping and Optimization
View Track List and Allocation
Open view toupload item list andinput constraint foroptimization
File Upload & Select Constraints
Reference Row Filter
Top: items for truckallocationBottom: constrains
Optimization
Recursive Loop End
Aggregate item count, weightand volume for each truck
GroupBy
Open viewand downloadtruck list
View and Download Truck List
Reference Row Filter
Row Filter
leftover items for next truck
Row Filter
Create truck ID
Expression
Reformat Item List to Variable Table
Recursive Loop Start
Reformat Attribute Lists to Constraints Table

Nodes

Extensions

Links