India's largest platform for AI & Analytics leaders & professionals

Sign in

India's largest platform for AI & Analytics leaders & professionals
Become a Thought Leader
Become a 3AI Member

Sign in

3AI Digital Library

< Go Back

Promotion Analysis and Prediction from TPM data

3AI September 10, 2020

US subsidiary of one of the world’s largest food company

Problem Statement

  • Company had promotion data for a specific retailer in TPM system and wished to leverage it for advanced analytics and forecasting
  • Frequency of promotions were extremely high for the specific retailer, resulting in frequent dips of sales below the baseline
  • The effect of frequent discounting required a new approach to sales response modeling and forecasting

Analytics Led Approach

  • Conducted historical data review and provided insights, trends on promotion performance and sales/revenue distribution by chain and geography
  • A unique methodology to model the effect of continuous discounting on future sales was developed. This resulted in very reliable models to explain promotion responses and volume dips below the baseline
  • Incorporating this new approach provided insights into actual promotion tactic performances by retailer and geography

Business Impact

  • Volume forecasts were generated using the customized model and benchmarked against actual values
  • Analysis and model fitment provided insights into actual (decomposed) effectiveness of individual promotion tactics employed
  • Generated sales forecasts to aid demand planning using customer’s promotion plan for the next year

Critical Success Factors

  • Recommended a more optimal promotion strategy, based on variation in tactic (discounts, features and displays) effectiveness by retailer and geography

    3AI Trending Articles

  • P&L Forecasting Enabled by Analytics

    Author: Rajagopal Rangarajan, Senior Manager – Analytics, AB InBev Accurate P&L forecasts help companies build a good financial plan for the year. It enables the financial planning team in allocating resources more meaningfully across the company. For large and highly leveraged companies like AB-InBev with annual Revenues more than $50 Bn and with a debt […]

  • Process Mining and Task Mining fuels Automation across the Enterprise

    Featured Article: Author: Prakash Narayanan, Head of RPA & Intelligent Automation, Cyient Every business is a collection of core processes. Processes are the foundational infrastructure and form the basic element of business operations. In 1911, Frederick Winslow Taylor became the first person to study and optimize workplace productivity. His monograph ‘The Principles of Scientific Management’ […]

  • Revenue Growth Management in the New E-Commerce-led Phygital World

    Author: Imran Saeed, Vice President and Global Head CPG, Course5 Intelligence (LinkedIn – linkedin.com/in/imran-saeed-608a3b1) ‘Phygital’ is a portmanteau of ‘physical’ and ‘digital’ and symbolizes the seamless relationship between the two channels. It takes the best elements from both and merges them to create an entirely new customer retail experience. Though this does bring in a […]

  • Application of Reinforcement Learning in Supply Chain

    Author: Anindya Bera, Senior Manager – Anaytics, Genpact A supply chain is a complex network of individuals and agents who exchange materials or information in a business ecosystem. The items which are used on day-to-day basis are created by a global collaboration between suppliers, manufacturers, and logistics carriers. What makes this complex? It is the […]