W2MO allows an easy and intuitive data import from all available data sources offering a wide range of interfaces, Excel-/CSV-Integration, RESTful APIs and a general database connector.
These flexible interfaces as well as a standardized data import from operative systems (e.g. SAP) provide a simple and holistic integration into the existing system landscape.
Based on our experience with more than 500 successful customer projects over many years, we can advise you, which data (sources) are actually required and support you in gathering the data as well as in the process of data evaluation and data import.
If required, we can also (in coordination with your IT) extract the necessary data from your systems.
The simple tool integration allows a quick realization of first optimization potentials and ensures a short-term pay-off for your investment.
Moreover, the integration of W2MO enables holistic logistics planning without tool breaks and also supports you in creating extrapolated data for future developments (e.g. increase of order volume, change in order structure, etc.).
Warehouse Modeling
Summary of required data
In general, information regarding layout, products, order data, storage locations, packaging, positioning, material flow will be necessary. The following list is just a guideline and will be finalized during the kick-off meeting. Further additions/changes might be necessary.
Ideally, the observation period (e. g. week, month) includes data of a typical situation based on expected orders volume, as well as situations with high and low system utilization (strong week, low week, average week). All data should preferably be provided in CSV-file format.
Product Master Data
product number (eventually more characteristics for a precise identification)
product description
classification properties
storage place restrictions (e.g. certain products may be stored only in certain picking areas/ tray types / bins)
current storage place in existing warehouse and number of storage compartments / bins
size of case and geometric data (length, width, height, volume, weight, compressible)
number of products per case, cases per pallet
special characteristics that are important for handling and storage, e.g. fragility, campaign, etc.
sales data: business line, promotion product, temporary product, ….
Order Data or picking list data (best per box)
order number / box number
product number (eventually more characteristics for a precise identification)
quantity
final destination (branch office, etc.) if important
time of incoming order, picking time and other available timestamps
assignment to picking list
used shipping unit (box, pallet, …) – if there are other alternatives
time you required executing the orders (if available, e.g. pick start date and time)
Please provide both the raw orders and the boxes (picking list per box) created out of this orders.
Layout, storage of existing warehouses
storage / warehouse: current positioning of products and actual stock
design, layout or draft of the considered area (e.g. DXF – format )
some photographs of the respective warehouse areas (handed over ppts are already sufficient)
storage areas and conveyor or material handling technology
staff costs (in total, number of working hours in the respective area to fulfill the order sets)
data of returns logistics – if necessary (product, timestamp, quantity)
Data of automated systems (if used)
Zone to Zone
diverts
circulation features
buffer places in each zone
conveyor speeds
max. number of persons in each zone
detailed plans of conveyor systems
Shuttle systems
buffer capacities all over the system
circulation features
conveyor speeds
diverts
box sizes, weight limits, max. number of products per box
detailed plans of conveyor systems and workplaces (combination with flow racks etc.)
max. number of persons per workplace
Period
week, month; average, strong and low (for additional business: the expected numbers)
Workforce
Working hours, shift models
Required working hours to fulfill the order sets (if possible per area / zone)