...

Summary of Required Data

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)
  • Hourly rate