Sales Fundamentals Tracking System collects and analyzes KPI of ISP based on POS data, shelf, merchandising, pricing and promotion etc. It is a fundamental tool to identify potential business issues and opportunities, to build negotiation advantage and optimize in-store resources.

Frequently Asked Questions:
•  I don't know whether consumers (shoppers) touch our product or not in hypermarkets and large super markets.
•  Whether shoppers pay any attention to our promotion POP in store or not?
•  If our products have competitive price in the store?
•  I don't know the distribution situation of our products by regions or by channel.
•  ……

Data collection solution:
•  Flexible
Input data on-line in various forms like text, excel file, PDA, SMS, etc.
•  Efficiency
The next day will get result of intraday data.

Reporting solution:
•  Flexible Reporting format and access model.
Multiple formats: Excel, PDF, XML, HTML, and CSV.
Multiple deploy methods: centralized access, email, application integration, MS Office.
•  Predefined sales fundamental KPI
Distribution
Shelf
Price
POP

Business benefits:
•  Distribution analysis will help us to fine out opportunities and approach to improve SKU sales.
•  Price analysis will help us to fine out opportunities to improve price strategy.
•  Merchandising analysis will help us to fine out opportunities to improve merchandising strategy and in-store effect.
•  Shelf analysis will help us to fine out opportunities to improve in-store display.
•  ……

Architecture:
•  Front-end: web browser
•  Middle-end: Microsoft .net framework
•  Back-end: Microsoft SQL Server

Development Platform:
•  Microsoft Asp.net
•  Microsoft C#.net
•  Microsoft SQL Server & Analysis Services

Target Customer:
•  FMCG and other manufacturers sell product in store.

Implementation:
•  About 4 weeks