DATA IMPORT & CONNECTIVITY
W2MO offers a variety of configurable interfaces for each use case. Data for planning tasks can be prepared in Excel and uploaded as .csv file. Alternatively data from the WMS, ERP, or TM system can be made available automatically each day.
On the one hand, our customers from the consulting and project environment appreciate the flexibility and speed of the .csv upload. On the other hand, the direct database connector enables real-time processing of large data volumes and therefore allows the operational use of our optimization algorithms for a significant step towards operational excellence!
The manual import allows to collect data from different sources and to integrate them quickly and easily into the current model. Import templates and parameterizations ensure a seamless integration of the .csv data into the simulation.
W2MO always offers a direct .csv template for data upload for product master data, orders, transporters, bin status reports and bills of materials. The following example of order headers and positions shows how easily and comfortably the data preparation and upload can be managed by W2MO.
W2MO offers configurable standard interfaces with standardized data import and export at the push of a button or automatically for the operational use. For example, data from SAP EWM can be imported as a direct copy into the W2MO model and can then be transferred to the model configuration by filters and logic rules. In this way, both data collection and data processing can be directly controlled and validated. An overview report with the results of the data collection will be created and sent per mail automatically each time the connector is importing data. Consequently, the model is being constantly updated with the latest data.
Extrapolation – no glance in the crystal ball!
In many supply chain and logistics projects the available database does not meet the desired optimum in its scale, detail level and quality. However, these data gaps can be easily generated and integrated based on planned figures and assumptions with W2MO. Forecasted developments of business figures and order data provide an essential support for planning, simulation and optimization. With help of the extrapolation functionalities of W2MO, this data can be generated and manipulated in a detailed and structured manner. The expected database is created on a comparable historic time period with growth planning figures, expert knowledge and qualified assumptions.
DATA MAINTENANCE & VALIDATION
Master data quality and data validation become continuously more important due to the growing amount of available data. Being integrated into W2MO, data can be easily checked for consistency, adjusted and corrected using table references, filters and mass updates directly in the database.
All data and results of the models and simulations can be easily downloaded in the .csv format for further processing. Using the database connector, it is also possible to directly return the optimization results back to the WMS or ERP system and thus benefit continuously and operationally from the powerful algorithms.