Network Design Plus (Lat, Lon)

This node can be used to finds the optimal number and location of warehouses based on transport, handling and fixed warehouse costs. It can model your flows starting from the factories via the warehouses up to your customers. It is also possible to regard capcity restrictions (weight, volume) in warehouses. If you have an existing network structure, it is also possible to fix your existing warehouses and search for additional ones. Define detailed transportation costs for all factory-warehouse and warehouse-customer relations.

For this node eight input tables are needed. Three input tables are mandatory - factories, warehouses and customers, and the rest are optional.

The first one contains the information of the factories.
The second table contains all the information concerning the warehouses.
The third table contains the information of the customers.
The fourth table is used to define product segments and the available warehouses for each of segment.
The fifth table is used to define transport costs for all factory-warehouses and warehouse-customer relations. Please make sure to specify transport costs for all possible relations. If one relation is missing, the transport costs will be zero for this relation.
The sixth table is used to define general rules and the corresponding vehicle capacities transport costs. The rules are then applied to the relations and the appropriate capacity and cost values are assigned to each relation. The relations that don't match any rules will not be considered, and the transport cost for them will be set to 0.
The seventh and eighth table are used to define stepwise cost function weight and volume respectfully. This is relevant when the variable costs are not linear, rather decreasing/increasing based on the total weight/volume going through a warehouse. Each function is defined by a unique ID, and the costs are defined per different steps (weight/volume ranges). The upper limit for each step is defined, and the costs from a specific step are considered (active) whenever the total weight/volume assigned to a warehouse falls within the step range.

Please specify the distance unit, vehicle type, street level, inbound consolidation, outbound consolidation, allow multisourcing, min and max warehouses parameters in the configuration dialogue.

In case input and output data need to be saved on the Log-hub Platform, please set save scenario flag to true, fill the workspace id for the workspace in which the scenario should be saved, and give name to the scenario. In case existing scenario should be overwritten, set the overwrite scenario flag also to true, otherwise leave to false.

To use this node you need an API Key from Log-hub Supply Chain Apps. This key you can generate with an Supply Chain Apps Pro Account. More information you can find on www.log-hub.com.

Log-hub video for API key generation: https://www.youtube.com/watch?v=FZgOn1IZ1Bk&t=255s

Options

Truck Capacity Weight* (Warehouses)

Please select the truck capacity weight column

Truck Capacity Volume* (Warehouses)

Please select the truck capacity volume column

Minimum FTL Costs (Warehouses)

Please select the minimum FTL costs column

Truck Costs per km/mi [first km/mi]* (Warehouses)

Please select the truck costs per km/mi [first km/mi] column

Truck Costs per km/mi [1000 km/mi]* (Warehouses)

Please select the truck costs per km/mi [1000 km/mi] column

Minimum LTL Costs (Warehouses)

Please select the minimum LTL costs column

Costs 1/2 Truck [%]* (Warehouses)

Please select the costs 1/2 truck [%] column

Minimum Inbound Replenishment Frequency (Warehouses)

Please select the minimum inbound replenishment frequency column

Minimum Outbound Replenishment Frequency (Warehouses)

Please select the minimum outbound replenishment frequency column

Stepwise Cost Function Weight (Warehouses)

Please select the stepwise cost function weight column

Stepwise Cost Function Volume (Warehouses)

Please select the stepwise cost function volume column

Name* (Customers)

Please select the name column

Latitude* (Customers)

Please select the latitude column

Longitude* (Customers)

Please select the longitude column

Weight* (Customers)

Please select the weight column

Volume* (Customers)

Please select the volume column

Number of Shipments* Customers)

Please select the number of shipments column

Product Segments (Customers)

Please select the product segments column

Factory (Customers)

Please select the factory column

Warehouse (Customers)

Please select the warehouse column

Maximum Warehouse Distance (Customers)

Please select the maximum warehouse distance column

Penalty Costs Warehouse Distance (Customers)

Please select the penalty costs warehouse distance column

Segment Name (Product Segments)

Please select the segment name column

Available Warehouses (Product Segments)

Please select the available warehouses column

Departure Location Name* (Transport Costs)

Please select the departure location name column

To Location Name* (Transport Costs)

Please select the to location name column

Weight Capacity per Unit (Transport Costs)

Please select the weight capacity per unit column

Volume Capacity per Unit (Transport Costs)

Please select the volume capacity per unit column

Costs per Unit (Transport Costs)

Please select the costs per unit column

From Country ISO2 (Transport Costs Rules)

Please select the from country ISO2 column

From Zip (Transport Costs Rules)

Please select the from zip column

From Name (Transport Costs Rules)

Please select the from name column

To Country ISO2 (Transport Costs Rules)

Please select the to country ISO2 column

To Zip (Transport Costs Rules)

Please select the to zip column

To Name (Transport Costs Rules)

Please select the to name column

Layer (Transport Costs Rules)

Please select the layer column

Distance (Transport Costs Rules)

Please select the distance column

Weight Capacity per Unit (Transport Costs Rules)

Please select the weight capacity per unit column

Volume Capacity per Unit (Transport Costs Rules)

Please select the volume capacity per unit column

Costs per Unit (Transport Costs Rules)

Please select the costs per unit column

Stepwise Cost Function Id (Stepwise Cost Function Weight)

Please select the from stepwise cost function id column

Step End (Stepwise Cost Function Weight)

Please select the step end column

Fixed Cost (Stepwise Cost Function Weight)

Please select the fixed cost column

Cost Per Weight Unit (Stepwise Cost Function Weight)

Please select the cost Per Weight Unit column

Stepwise Cost Function Id (Stepwise Cost Function Volume)

Please select the from stepwise cost function id column

Step End (Stepwise Cost Function Volume)

Please select the step end column

Fixed Cost (Stepwise Cost Function Volume)

Please select the fixed cost column

Cost Per Volume Unit (Stepwise Cost Function Volume)

Please select the cost per volume unit column

Name* (Factories)

Please select the name column

Latitude* (Factories)

Please select the latitude column

Longitude* (Factories)

Please select the longitude column

Truck Capacity Weight* (Factories)

Please select the truck capacity weight column

Truck Capacity Volume* (Factories)

Please select the truck capacity volume column

Minimum FTL Costs (Factories)

Please select the minimum FTL costs column

Truck Costs per km/mi [first km/mi]* (Factories)

Please select the truck costs per km/mi [first km/mi] column

Truck Costs per km/mi [1000 km/mi]* (Factories)

Please select the truck costs per km/mi [1000 km/mi] column

Minimum LTL Costs (Factories)

Please select the minimum LTL costs column

Costs 1/2 Truck [%]* (Factories)

Please select the costs 1/2 truck [%] column

Name* (Warehouses)

Please select the name column

Latitude* (Warehouses)

Please select the latitude column

Longitude* (Warehouses)

Please select the longitude column

Fixed* (Warehouses)

Please select fixed column

Minimum Weight* (Warehouses)

Please select the minimum weight column

Maximum Weight* (Warehouses)

Please select the maximum weight column

Penalty Costs Weight (Warehouses)

Please select the penalty costs weight column

Minimum Volume* (Warehouses)

Please select the minimum Volume column

Maximum Volume* (Warehouses)

Please select the maximum volume column

Penalty Costs Volume (Warehouses)

Please select the penalty costs volume column

Fixed Costs* (Warehouses)

Please select the fixed costs column

Costs per Weight Unit* (Warehouses)

Please select the costs per weight unit column

Costs per Volume Unit* (Warehouses)

Please select the costs per volume unit column

Min Warehouses (Parameters)

Please specify the min warehouses

Max Warehouses (Parameters)

Please specify the max warehouses

Save Scenario (Save Scenario on Platform)

In order to save scenario on the Log-hub Platform, set the parameter to true

Overwrite Scenario (Save Scenario on Platform)

In order to overwrite existing scenario on Log-hub Platform, set the parameter to true

Distance Unit (Parameters)

Please select the distance unit

Vehicle Type (Parameters)

Please select the vehicle type

Street Level (Parameters)

Please select the street level

Inbound Consolidation (Parameters)

Please select the inbound consolidation

Outbound Consolidation (Parameters)

Please select the outbound consolidation

Allow Multisourcing (Parameters)

Please select the allow multisourcing

Workspace Id - workspace where Scenario should be saved (Save Scenario on Platform)

Please enter here the workspace id in which you want to save scenario

Scenario Name (Save Scenario on Platform)

Please enter scenario name

Log-hub API Key

Please enter here the API Key from Log-hub.

Nodes

• Rule Engine77 ×
• String Manipulation (Variable)72 ×
• Column Selection Configuration71 ×
• String To Number15 ×
• Constant Value Column14 ×
• Show all 32 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Data Generation
• FeatureKNIME Javasnippet
• FeatureKNIME JSON-Processing
• FeatureKNIME Quick Forms
• Show all 6 modules

Links

• No links available