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, but in order to node works all ports must be connected.

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.
The ninth table is used to define maximum distance within which a given percentage of total demand must be met. The rules create a constraint that a certain % of weight, volume or both have to come from a warehouse whithin the specified distance. Multiple consecutive rules can be defined, along with the respective limits and percentages. They can also be set as either a hard, or a soft constraint, by defining the appropriate penalty parameters.

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. Required data type: Integer, Double

Truck Capacity Volume* (Warehouses)

Please select the truck capacity volume column. Required data type: Integer, Double

Minimum FTL Costs (Warehouses)

Please select the minimum FTL costs column. Required data type: Integer, Double

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

Please select the truck costs per km/mi [first km/mi] column. Required data type: Integer, Double

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

Please select the truck costs per km/mi [1000 km/mi] column. Required data type: Integer, Double

Minimum LTL Costs (Warehouses)

Please select the minimum LTL costs column. Required data type: Integer, Double

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

Please select the costs 1/2 truck [%] column. Required data type: Integer, Double

Minimum Inbound Replenishment Frequency (Warehouses)

Please select the minimum inbound replenishment frequency column. Required data type: Integer, Double

Minimum Outbound Replenishment Frequency (Warehouses)

Please select the minimum outbound replenishment frequency column. Required data type: Integer, Double

Stepwise Cost Function Weight (Warehouses)

Please select the stepwise cost function weight column. Required data type: String

Stepwise Cost Function Volume (Warehouses)

Please select the stepwise cost function volume column. Required data type: String

Name* (Customers)

Please select the name column. Required data type: String

Latitude* (Customers)

Please select the latitude column. Required data type: Integer, Double

Longitude* (Customers)

Please select the longitude column. Required data type: Integer, Double

Weight* (Customers)

Please select the weight column. Required data type: Integer, Double

Volume* (Customers)

Please select the volume column. Required data type: Integer, Double

Number of Shipments* Customers)

Please select the number of shipments column. Required data type: Integer

Product Segments (Customers)

Please select the product segments column. Required data type: String

Factory (Customers)

Please select the factory column. Required data type: String

Warehouse (Customers)

Please select the warehouse column. Required data type: String

Maximum Warehouse Distance (Customers)

Please select the maximum warehouse distance column. Required data type: Integer, Double

Penalty Costs Warehouse Distance (Customers)

Please select the penalty costs warehouse distance column. Required data type: Integer, Double

Segment Name (Product Segments)

Please select the segment name column. Required data type: String

Available Warehouses (Product Segments)

Please select the available warehouses column. Required data type: String

Departure Location Name* (Transport Costs)

Please select the departure location name column. Required data type: String

To Location Name* (Transport Costs)

Please select the to location name column. Required data type: String

Weight Capacity per Unit (Transport Costs)

Please select the weight capacity per unit column. Required data type: Integer, Double

Volume Capacity per Unit (Transport Costs)

Please select the volume capacity per unit column. Required data type: Integer, Double

Costs per Unit (Transport Costs)

Please select the costs per unit column. Required data type: Integer, Double

From Country ISO2 (Transport Costs Rules)

Please select the from country ISO2 column. Required data type: String

From Zip (Transport Costs Rules)

Please select the from zip column. Required data type: String

From Name (Transport Costs Rules)

Please select the from name column. Required data type: String

To Country ISO2 (Transport Costs Rules)

Please select the to country ISO2 column. Required data type: String

To Zip (Transport Costs Rules)

Please select the to zip column. Required data type: String

To Name (Transport Costs Rules)

Please select the to name column. Required data type: String

Layer (Transport Costs Rules)

Please select the layer column. Required data type: String

Distance (Transport Costs Rules)

Please select the distance column. Required data type: Integer, Double

Weight Capacity per Unit (Transport Costs Rules)

Please select the weight capacity per unit column. Required data type: Integer, Double

Volume Capacity per Unit (Transport Costs Rules)

Please select the volume capacity per unit column. Required data type: Integer, Double

Costs per Unit (Transport Costs Rules)

Please select the costs per unit column. Required data type: Integer, Double

Stepwise Cost Function Id (Stepwise Cost Function Weight)

Please select the from stepwise cost function id column. Required data type: String

Step End (Stepwise Cost Function Weight)

Please select the step end column. Required data type: Integer

Fixed Cost (Stepwise Cost Function Weight)

Please select the fixed cost column. Required data type: Integer, Double

Cost Per Weight Unit (Stepwise Cost Function Weight)

Please select the cost Per Weight Unit column. Required data type: Integer, Double

Stepwise Cost Function Id (Stepwise Cost Function Volume)

Please select the from stepwise cost function id column. Required data type: String

Step End (Stepwise Cost Function Volume)

Please select the step end column. Required data type: Integer

Fixed Cost (Stepwise Cost Function Volume)

Please select the fixed cost column. Required data type: Integer, Double

Cost Per Volume Unit (Stepwise Cost Function Volume)

Please select the cost per volume unit column. Required data type: Integer, Double

Distance Limit (Distance Limits)

Please select the distance limit column. Required data type: Integer, Double

Minimum Weight to Cover [%] (Distance Limits)

Please select the minimum weight to cover [%] column. Required data type: Integer, Double

Minimum Volume to Cover [%] (Distance Limits)

Please select the minimum volume to cover [%] column. Required data type: Integer, Double

Penalty Cost Distance Limit (Distance Limits)

Please select the penalty cost distance limit column. Required data type: Integer, Double

Name* (Factories)

Please select the name column. Required data type: String

Latitude* (Factories)

Please select the latitude column. Required data type: Integer, Double

Longitude* (Factories)

Please select the longitude column. Required data type: Integer, Double

Truck Capacity Weight* (Factories)

Please select the truck capacity weight column. Required data type: Integer, Double

Truck Capacity Volume* (Factories)

Please select the truck capacity volume column. Required data type: Integer, Double

Minimum FTL Costs (Factories)

Please select the minimum FTL costs column. Required data type: Integer, Double

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

Please select the truck costs per km/mi [first km/mi] column. Required data type: Integer, Double

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

Please select the truck costs per km/mi [1000 km/mi] column. Required data type: Integer, Double

Minimum LTL Costs (Factories)

Please select the minimum LTL costs column. Required data type: Integer, Double

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

Please select the costs 1/2 truck [%] column. Required data type: Integer, Double

Name* (Warehouses)

Please select the name column. Required data type: String

Latitude* (Warehouses)

Please select the latitude column. Required data type: Integer, Double

Longitude* (Warehouses)

Please select the longitude column. Required data type: Integer, Double

Fixed* (Warehouses)

Please select fixed column. Required data type: Integer

Minimum Weight* (Warehouses)

Please select the minimum weight column. Required data type: Integer, Double

Maximum Weight* (Warehouses)

Please select the maximum weight column. Required data type: Integer, Double

Penalty Costs Weight (Warehouses)

Please select the penalty costs weight column. Required data type: Integer, Double

Minimum Volume* (Warehouses)

Please select the minimum Volume column. Required data type: Integer, Double

Maximum Volume* (Warehouses)

Please select the maximum volume column. Required data type: Integer, Double

Penalty Costs Volume (Warehouses)

Please select the penalty costs volume column. Required data type: Integer, Double

Fixed Costs* (Warehouses)

Please select the fixed costs column. Required data type: Integer, Double

Costs per Weight Unit* (Warehouses)

Please select the costs per weight unit column. Required data type: Integer, Double

Costs per Volume Unit* (Warehouses)

Please select the costs per volume unit column. Required data type: Integer, Double

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 Engine82 ×
• String Manipulation (Variable)76 ×
• Column Selection Configuration75 ×
• Column Filter20 ×
• Constant Value Column15 ×
• Show all 47 nodes

Extensions

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

Links

• No links available