Spot2D

Spot2D is a product for operational data exchange between producers and distributors.

A system controls the movement of goods to each outlet on each product online.

Scheme of the movement of data, 2014

Properties

• Developers are sure in sales growth from 20% by means of
  • optimization of a remaining balance of distributors;
  • detailed operational analysis of sales.

• Increase in financial results is provided
  • decrease in quantity and optimization of trade inventories at all levels of distribution;
  • increase in accuracy of sales planning up to 85-90% for 1 year ahead.

• The relations with distributors will improve by means of
  • emergence of a common information space and use of uniform data;
  • settings of real tasks and adequate assessment of their accomplishment;
  • joint achievement of higher business objectives.

Decrease in internal costs on data collection and processing up to 100% at global change of its quality.

• Statistics on the basis of results of the clients using SPOT2D of 1 year.

Technology and security

• Spot2D – SaaS product developing since 2005.
• Spot2D is created on the basis of the software package LAMP
• Open-source (open code system);
• The operating system of the server – Linux;
• The Web server is Apache;
• Programming language of web applications – PHP 5;
• The database is MySQL 5.0 (with replications).

Spot2D is based on own methodology of collecting, processing and data analysis.

The company organized technical and business processes, ensuring reliability and data security:

• Continuous access:
  • servers are placed on a hosting platforms of Germany;
  • each website spot2d.com has a mirror for uninterrupted access;
  • regular service and updating of servers.

Copyright/IP Policy

• backup of all data on a formula of 10 days / 5 weeks / 5 months;
• communications on the protected HTTPS protocol.

Safety of access access for users is limited on:

• to roles (Administrator, client's Manager, distributor's Manager);
• to the amount of data (set of available distributors and products).
• passwords are stored in md5 format;
• fixing of actions of users in a system;
• fixing and time supervision and IP addresses of each fact of access to the website.

Analytical system

• Simple intuitive interface
• Fast reports with small consumption of traffic
• Different methods of obtaining reports – on the website, Excel, e-mail, unloading of base
• static, dynamic, comparative and special reports
• The designer of reports with criteria and filters
  • retail sales in pieces, boxes, units of measure and money (2 versions);
  • quantity of points where the goods are delivered;
  • retail covering, distribution, existence of the obligatory range.

Expanded analysis of a remaining balance of distributors

• the volume of a remaining balance on products and distributors;
• the report on the level of a remaining balance (it is exclusive in SPOT2D);
• losses because of deficit of goods;
• daily monitoring of a remaining balance.

• Simple intuitive interface
• Fast reports with small consumption of traffic
• Different methods of obtaining reports – on the website, Excel, e-mail, unloading of base
• static, dynamic, comparative and special reports
• The designer of reports with criteria and filters
  • retail sales in pieces, boxes, units of measure and money (2 versions);
  • quantity of points where the goods are delivered;
  • retail covering, distribution, existence of the obligatory range.

• Expanded analysis of a remaining balance of distributors
  • the volume of a remaining balance on products and distributors;
  • the report on the level of a remaining balance (it is exclusive in SPOT2D);
  • losses because of deficit of goods;
  • daily monitoring of a remaining balance.

• The list of not shipped clients
• Control of price policy of distributors
• The report on returns from retail
• Distribution of sets of products (obligatory range)
• Monitoring of activity of users on the website

Base of outlets

• Daily replenishment of base of outlets
• Addition of data of outlet:
  • Geographical data (the locality, the area) – Pradata forces;
  • Types and categories of points – the client's forces;
  • Binding to retail chain stores;
  • Other business parameters.

• An opportunity to automatically close inactive points
• Possibility of deduplication, consolidation of outlets
• Possibility of a binding to outlets of other information:
  • data on placement POS материалов/холодильников;
  • integration into the SPOT2R system and reports of sales agents / merchandisers;
  • external data on a situation in outlets.

Orders of distributors

• Creation of the order of the distributor on the basis of recommended (taking into account the current remaining balance and the sales forecast) – increase in accuracy of the order
• The system of electronic signatures at all stages of passing of the order (the distributor – the area manager – the director of sales – the financial controller) – systemacity of business process of orders
• Accounting of the diagram of orders and deliveries, logistic restrictions
• Automatic unloading of the order in the accounting system of the producer (1C, Navision, JD Edwards, Axapta, SAP R3 and others)
• Return on the website of information on shipments to the distributor
• Confirmation by the distributor of receiving shipment
• Difference assessment between the order and its receiving at all stages of passing of the order
• Calculation of sales of distributors on the basis of last/current remaining balance and shipments