Stock Warehouse - Stock Analyst
The choice of a specific mix of stock and its precise allocation is one of the fundamental aspects to ensure the company is functional and profit-making. A critical factor in formulating a correct management policy is identifying the objectives of customer service, formulating a suitable forecast and checking stock features, as well as the criteria of stock allocation in the network. It is necessary to be able to view individual warehouses according to many specific points of view and objectively and systematically measure the copious effort (cost of stocks, purchasing costs) and the effective result in terms of level of service.
STOCK ANALYST helps those in charge of logistics to set an appropriate stock policy, keeping the level of tied-up stock, rotations, level of service and lead time of delivery to customer systematically under control; this tool, based on the techniques of Business Intelligence, uses a suitably structured Data Warehouse, fed primarily by the data provided by the Management Software (orders/supplier bills, stock and orders/customers’ bills).
STOCK ANALYST monitors key operational factors on a daily basis and highlights, giving suitable notification, situations that are not in the norm; it develops different reports, including by way of example:
- Detection of the level of service (by supplier, product and customer)
- Detection of Lead Time and delay time (by supplier, product, and customer)
- Clusterisation of customer orders according to “Classes of Lead Time” and “Classes of delay”
- ABC crossed matrix (to check consistency of product management)
- Detection of stock trend (in pieces, value etc.), rotations and coverage by products
STOCK ANALYST avails of over 30 reports to monitor performances in terms of tied-up stock, lead time and level of service, to record them over time and make comparisons, to relate the phenomena. The installation is fast and Simco specialists help to identify how best to perform data migration and interpret the results that emerge offering an approach which, combining expertise in logistics and information technology, maximizes the use of the monitor and analysis tool.
|
the method
Macroanalysis
Macroanalysis consists of two phases: confrontation with the I.T. area to verify congruence of the data acquisition graph (ETL Extraction, Transformation and Loading) of Stock Analyst; confrontation with the Logistics area to verify that the reports (and the methods of calculation of the single metrics) included in Stock Analyst satisfy needs. Macroanalysis will be the reference point for subsequent phases and illustrate the final structure of Stock Analyst (procedures and methods of ETL, metrics and constructible reports) and the assessment of any customisations that may be necessary/required.
Start-up
The procedures to load the data (ETL) that power Stock Analyst will be realized in close collaboration with the customer, having the knowledge of the structure of the source sw and more generally of the hardware infrastructure. In particular, the data extraction phase will be handled by the customer (data collection format will be provided by Simco), while the operations of any transformation and loading into the Data Warehouse will be the task of Simco. In this phase, tests will be carried out on the strength of the importation procedures.
Release
Once Stock Analyst has been installed and configured, a series of tests will be performed to verify the correct operation of the system. In particular, the following must be verified: efficiency of the production of information, correctness of the data provided, correct application of the security policies on the data. Once the implementation phase of the project has been completed, Stock Analyst will be made available to the entire group of users to verify its functionality. During this phase a short technical training course will take place for users of the System.
Improvement and training assistance
Following thirty years of experience in logistics consulting Simco can work side-by-side with the company in interpreting the “logistics instrument panel” and suggesting the optimisation and improvements in the processes to increase competitiveness. Training courses can also be organised and held during this phase to analyse and interpret the data.
|
