Example: Client succeeds in understanding product availability across multiple distributor supplied retail outlets…achieves an 88% boost in product availability.

Situation:

• A leading manufacturer-marketer of confections & snack foods had reason to believe that a number of their brands were underdeveloped in independently owned and operated convenience, drug & grocery stores. These are stores supplied by leading distributors for the category. Several distributors had multiple DC’s supplying an identified base of stores across major metro markets.
• The challenge was to work with each distributor to secure monthly data feeds identifying for all of the manufacturers products delivered and sold to the respective store base. Then to organize, scrub and assemble all of the data by distributor into one database for data mining, analytics and opportunity-issue insights.
• Insights would then be identified as action items for manufacturer’s sales organization and the distributor to focus on to close the distribution voids.

Action:

• The Client Sales Leadership & Account Teams worked with RNI to open the conversation with each distributor and the data feed that was needed.
• RNI Data Management Operations worked directly with each Distributor’s IT department to secure the monthly data feeds.
• RNI created a baseline of identified available distribution for all of the manufacturer’s products by distributor supplied store.
• Highly granular distributor and store specific data was scrubbed and organized to Client specific standards.
• RNI created and maintained a high utility database for Manufacturer data mining, analytics and insights for action.

Results:

• The RNI Sales Accelerator Platform™ and a specific set of dashboards were created for the Client team to analyze the data and visualize opportunities. 
• All datasets were assembled and fed into the RNI data store.
• Highly granular product non-availability & availability data was analyzed by specific store and store trading areas.
• Insights from the highly differentiated RNI data clearly showed specific actionable areas for improvement including underdeveloped product mix, pack-size voids and other counter-market standards & trends.
• Reporting by individual store location with all data & opportunities identified areas for immediate actionable correction by specific distributor.
• Client put into place a focused business initiative to address each improvement area over a 16-week period.
• Throughout the tenure of the 16 week period, monthly data feeds were tracked, measured and analyzed versus identified targets.
• The client achieved significant results with 88% of the identified product voids closed.
• The client has retained RNI for its distributor based route to market data assembly, management and visualization needs.