SPOT2D Idea
- 1. Every producer must know everything about the product movement to retail outlets.
- 2. Every distributor collects data about secondary sales in ERP daily.
- 3. We collect data about product movement throughout all distribution chains and integrate it in a central database – we open the black box!
SPOT2D Data Flow
Implementation Results
Sales increase from 20% a.o.:
- distributors stocks optimization;
- attention to and focus on “weak points”;
- detailed daily sales analysis.
Improvement of financial results a.o.:
- optimization and decrease of product inventory at all distribution levels;
- increasing of sales planning accuracy up to 85-90%.
Improvement of relations with distributors a.o.:
- common information space and usage of same data;
- setting realistic goals and adequate assessment of their execution;
- united achievement of higher business goals.
Reduction of internal costs for collecting and processing of information up to 100% with global improvement of its quality.
* Based on clients performance after 1 year of SPOT2D usage.
Analytics
- Easy-to-use, intuitive interface
- High-speed reports with low traffic
- Different ways to get report – web-page, Excel, e-mail, database download
- Static, dynamic, comparison and special reports
- Reports constructor with criteria and filters:
- Sales-out in pcs, cases, units, money (2 versions);
- Number of delivered outlets;
- Retail universe coverage, distribution, TOP-products distribution.
- Extended distributors stock analysis:
- Stock volume by SKU and distributor;
- Stock levels report (exclusive to SPOT2D);
- Losses due to out-of-stock;
- Daily stock monitoring.
- Non-delivered outlets list
- Distributors pricing policy control
- Returns from retail report
- Distribution of top-assortment
- Users on-site and analytical activity monitoring
Retail Database
- Daily update of retail database
- Extension of retail outlet info with:
- Geo data (city, area) – by Pradata;
- Outlets types and categories – by client;
- Chains information;
- Other business data.
- Possibility to automatically close inactive outlets
- Possibility of deduplication and merging of retail outlets
- Possibility to connect additional data sources to retail database:
- POS/coolers placement information;
- Integration with SPOT2R system and sales team reports;
- External data about retail outlets.
Distributors Orders
- Distributors order creation based on recommended order (based on actual stocks and sales forecast) – increasing of order’s quality
- System of electronic signatures for ordering process (distributor – regional manager – sales director – logistic) – system ordering business-process
- Order and delivery schedule, logistic control
- Automatic order export to any ERP-system (1С, Navision, JD Edwards, SAP R3 and others)
- Import back from ERP delivery to distributor information
- Distributors confirmation of order delivery
- Valuation of difference between order and delivery at all stages (service level)
- Calculation of distributors sale-out based on previous/actual stock and delivery
Technology and Security
SPOT2D is a SaaS servise that has been constantly evolving since 2009.
SPOT2D is developed based on the Open source stack (Linux + Symfony framework + PostgreSQL), which allows you to scale the project without additional costs for purchasing licenses from the client.
We have organized our infrastructure and business processes to ensure maximum reliability and security of our clients’ data:
- We use only modern servers based on the Intel® Xeon® processor;
- All data integrity is ensured using Adaptec hardware RAID controllers;
- for high availability of all services 24/7, we maintain hot copies of all servers in two different data centers, located in EU;
- we regularly conduct security audits;
Data Privacy:
- Our client is the sole owner of all its information (de jure and de facto);
- We back up all data using the formula 10 days/5 weeks/5 months;
- All communications take place over a secure HTTPS protocol.
Users are restricted by:
- Roles (Administrator, Client Manager, Distributor Manager);
- Outlets, according to sets
- Specific products (groups of products);
