...

Summary of required data

W2MO allows to use all available data sources offering more than 200 customizable Interfaces, Excel-/CSV-Integration, direct SAP Integration, a general SQL-database connector and RESTful APIs.

This enormous range of integration possibilities is one of the reasons that enables W2MO to be the unique #1 solution on the market.

1. 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

  • 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
  • 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

2. Optimization of logistics networks

In general, information regarding item, material flow, locations and order data 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.

Product Master Data:

  • product description (mostly the name)
  • products and their features (e.g. weight, volume, price, transportation restrictions)

Material Flow Data:

  • account (address/zip code or geocodes)
  • orders/transportation (inbound/outbound), order number/order description
  • orderlines (which product will be assigned to which order and to what extend)
  • time windows

Period:

  • campaign, i.e. longer period

Location candidate:

  • address or name with geocodes
  • determine location type (e.g.hub, warehouse, production plant)

Transportation containers:

  • determine transportation containers (e.g. pallet, carton, truck)
  • classification of containers
  • enter costs per kilometer
  • enter potential fixed costs
  • as transportation containers for the route to customers there can be used shipping containers and such containers as as swap bodies or semi-trailers are for transportation between hub and central warehouse.

3. Production logistics:

In general, information regarding product parts, site locations, buffer allocations, product data, order data and 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.

Product parts master data

  • Part number (eventually more characteristics for precise identification)
  • Component description
  • Classification properties
  • Storage place restrictions (certain parts may be stored only in certain storage places or picking areas/ rack types / bins)
  • Current assembly sites, storage locations and bins
  • Package size and geometric data (length, width, height, volume, weight), loading equipment
  • Possible packaging equipment
  • Number of cases per pallet or loading equipment
  • Special characteristics that are important for handling and storage, e.g. fragility etc.
  • Required additional handling cost or special operations needed for a part (collect serial number)
  • Time periods for the value-added processes (e.g. assemblies), which are connected with this part

Dynamic data with the following information on each order item

  • Order number/box number
  • Part number (eventually more characteristics for precise identification)
  • Quantity
  • Time of incoming order, picking time and other available timestamps
  • Handling of orders (assignment to picking list), replenishment or stock transfer
  • Used shipping unit (box, pallet…)
  • Assembly, picking and replenishment areas

Period

  • A week to several months

Workforce

  • Shift models and working hours of staff or teams
  • Approach and logic of current shift and work scheduling
  • Min. and max. working hours
  • Rates
  • Cost per shift operation

Data for production or assembly

Process flows (e.g. Flow-Charts) and restrictions (if appropriate documentation is available). This enormous range of integration possibilities is one of the reasons that enables W2MO to be the unique #1 solution on the market.

Design of material handling

  • Assembly points or assembly stations
  • Access routes
  • Replenishment or transportation to assembly stations (single transports, tugger train etc.)
  • Way of transportation (automatic vs. on demand)
  • Relevant work processes
  • Layout or draft of considered area (e.g. AutoCAD- or DWG files)