Fwd: Looking for Software companies
Arun Basil Lal
Arun Basil Lal
From: Vidyadhar Prabhudesai <vidya...@gmail.com>
1-To manage the Sample and Product definitions.
2- To facilitate the Field data collection and recording, from paper questionnaires.
3- To cross reference and validate the collected data via statistical algorithms.
4- To perform the necessary computations and aggregations to produce predefined measures in a hierarchical structure on the dimensions of the Product, Store and Time governed by Client specific instruction sets.
5- To produce management and product performance reports
6- To facilitate the export of reports in predefined file or report formats
More details on systems functions by sequence :
A. Sample Management
- Set up the panel based on the universe
- Continuous checks of the panel for new and/or existing outlets
- Calculating extrapolation factors used in extrapolate the panel so that it will represent the universe.
- Outlet Types: (All outlet types used by the system to distinguish each outlet e.g. supermarkets, kiosks, bakeries)
- Regions: All the areas (urban, rural) for all districts.
B. Product Management
1- Entering new products in the system
2- Products: All products with definitions for each one (segments and information such as brand, size, manufacturer, distributor, flavor, pack type etc
C. Data Capture Management
Paper Questionnaire Processing
-Collect/enter the information (purchases, stocks and prices) for all outlets, either from manual questionnaires or from electronic files.
-Create new questionnaires for new outlets (filling all information such as address, telephones, contact person, owner, outlet type etc).
- Print questionnaires for auditors’ next visit to the outlets with all relevant products for each outlet.
D. Data Validation Management
- Several automated validations must be implemented such as
- Price checks,
- Purchases and Stock checks
- Missing categories or even categories that auditors forgot to enter either purchases or stocks.
- These validations must be take place before the data goes to processing .
E. Data Processing Management
- Using extrapolation factors the system generates several measures for each product within the relevant category. Each store within a sample cell has a projection factor representing the whole region in that cell (i.e. each Grocery in Central region is representative for total Groceries in Total Central).
- Establish an audit database across all the field locations (Outlets) to enable historical analytics and trend-analysis through any category/ies.
- Fixed Report and Market Instructions (Dynamic and custom instructions will be implemented in later phase)
Measures that must be implemented:
-Sales Quantity (Vol/Value)
-Sales Share (Vol/Val)
- Purchases Quantity
- Numeric Distribution
- Numeric out of stock
- Weighted Distribution
- Weighted out of stock
- Stock Cover
- Distribution Turnover
- Average Price
- Sales percentage change
F. Data Delivery/Reporting Management
-The final output of the results must be in a form which can be processed for example, the client must be provided with any reports that will be useful for further analysis by his/her company
Above described is the functions of the system needed at the initial phase .System should have the capability for ongoing development across functions.