Data Processing — Retail Tracking


Exhibit 28.9   Derivation of sales: Consumer offtake is retailer purchases plus the difference between opening and closing stock.


Exhibit 28.10   Example — Computing Sales for March (25th Feb to 25th Mar).

Manual Audit — Sales Derivation

In the case of manual audits, sales is derived from stocks and purchases. As portrayed in Exhibit 28.9, retailer purchases move stock into the store, increasing the in-store stock; and consumer purchases move stock out, depleting the in-store stock. Consumer purchases are therefore equal to retailer purchases plus the difference between opening and closing stock (see example in Exhibit 28.10).

 

Previous     Next

Note: To find content on MarketingMind type the acronym ‘MM’ followed by your query into the search bar. For example, if you enter ‘mm consumer analytics’ into Chrome’s search bar, relevant pages from MarketingMind will appear in Google’s result pages.







Business Intelligence - Market and Trade

Business Intelligence - Market and Trade

Suite of interactive, online dashboards that seamlessly integrate retail and consumer data sources in a manner that makes it easier to glean insights.


Scan Track

Scan Track

Suite of dashboards to visualize/analyse retail scan data.


Online Apps to train Category Managers

Online Apps to train Category Managers


The Plannogrammer is an experiential learning facility for category managers, trade marketers, and retailers in consumer markets. Ideally suited for hybrid learning programmes, Plannogrammer imparts hands-on training in the planning and evaluation of promotions and merchandising.

It supports a collection of simulation and analysis platforms such as Promotions and Space Planner for optimizing space and promotions, Plannogram for populating shelves and merchandising, a Due To Analysis dashboard that decomposes brand sales into the factors driving sales, and a Promotion Evaluator to evaluate the volume, value and profit impact of promotion plans.