Analytics for Consumer Goods and Retail Industry

Consumer Goods and Retail Organizations globally face some of the following challenges on a day-to-day basis.

• How to quantify category attractiveness of a sales territory?
• Which trade-price points indicate change in the buying behavior of outlets?
• Which product categories/base packs are sensitive towards trade promotion investment?
• At which point in the loyalty membership lifecycle, promotions should be targeted?
• How can the count/variety of products be increased in the shopping basket?
• How to quantify sensitivity of order booking towards changes in the credit offered?
• How to detect fraud stockists?
• How to ensure optimal inventory level?

And so on.. MindTree helps Consumer Goods and Retail companies use data to manage their Sales, Marketing, Customers, Supply Chain, and Operations better by determining Key Performance Indicators (KPI’s) for Advanced Analytics in areas such as:

Snapshot of our Experience

Identified potential market opportunities for India's Largest FMCG Firm and a fully owned subsidiary of a Fortune 500 Company

Business Challenge:

• Market width: Identification of untapped markets & market potential estimation
• Market Depth: Increasing product category width in the existing markets
• Need for demand forecasting with minimal forecasting variance

 Solution Offered:

• Performed market potential estimation, demand forecasting, sales uplift modeling, promotions effectiveness analysis, and segmentation analysis
• Helped prioritize new markets based on sales potential & accessibility rating
• Reduced demand forecast variance resulting in savings worth “Rs. Crores” due to drop in days-in-inventory

Improved competitive positioning for a Tobacco Products Company

Business Challenge:

• Collection and analysis of competitor data vis-à-vis client data at world, region, market, company all the way down to brand level.
• Need to develop online data collection and analysis system that could collect data from 70 markets to start with around the globe and analyze them centrally.

 Solution Delivered:

• Performed market development analysis, trade region analysis, and what-if analysis
• Collection of 3rd Party and competitor published data from different Markets & analyze the data centrally at Head office.

Improved market share forecasting for a Global CPG Giant

Business Challenge:

• Archaic forecasting methods and clouded insights into trends

 Solution Offered:

• Performed trend & seasonality analysis, auto-correlation plots, Partial-Correlation Plots, forecast analysis
• Used Oracle Data Miner, Spotfire (S Plus), Arima and R Tool
• Identified new product trends, captured seasonality shifts and improved market share forecasting to within 5% of actual