All the FMCG manufactures can benefit from understanding business status and progress in use of SOI data by category, channel, and territory. KASP Turbo, as a SOI analyzer reinforces ERP, is the best cost effective solution.

Frequently Asked Questions:
•  We don't know accurate volume index of selected product, channel and marketing.
•  We don't know which are the top 10 % distributors within passed quarter when we plan a promotion?
•  We don't know whether we should add distributors or not?
•  We don't know which product should be involved into promotion?
•  We don't know overdue account receivable accuracy of selected product, channel and marketing.
•  We don't know inventory control objective is increasing or decreasing.
•  We don't know order fulfillment is increasing or decreasing.
•  We don't know which distributors should be promoted.
•  We don't know which are the top 10% SKUs during the promotion period?
•  ……

ETL solution
•  Efficiency
With multi-platform, server-based engine processes large volumes of data with minimal hardware investment.
•  Flexibility
Dimensional framework adapts to different data system and can handle various business changes. Also it can be absorbed into the enterprise platform as a department solution to.
•  Scheduling
Automation task can be triggered according to predefined condition or some certain time.

Reporting Solution
•  Flexible Reporting format and access model.
Multiple formats: Excel, PDF, XML, HTML, and CSV.
Multiple deploying methods: centralized access, email, application integration, MS Office.
•  Predefined sales performance KPI
Coverage
Inventory (turn over, safety stock)
Logistic (order fulfillment, on-time deliverability)
Credit (overdue account receivable, over limit of credit)
Gross profit

Business benefits:
•  Coverage analysis will help us to find opportunities to increase weighted distribution.
•  Inventory analysis will help us to find opportunities to improve return of inventory investment.
•  Logistic analysis will help us to find opportunities to improve order fulfillment, and on-time deliverability.
•  Credit analysis will help us to find opportunities to improve management of overdue account and credit.
•  Gross analysis profit will help us to find opportunities to improve margin.
•  ……

Architecture:
•  Front-end: web browser
•  Middle-end: J2SE
•  Back-end: Microsoft SQL Server

Development Platform:
•  Java
•  Java scripts
•  Microsoft SQL Server & Analysis Services

Target Customer:
•  FMCG and other manufacturers use ERP

Implementation:
•  About 1 week