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

Sign in

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

Sign in

3AI Digital Library

< Go Back

Terminal Volume Forecasting

3AI August 12, 2020

Leading Player in Oil Processing Industry

Problem Statement

  • In-house forecasting of products was not giving accurate information; client wanted an accurate forecasting model.
  • Organization wanted assistance in understanding the appropriate KPI’s / metrics that have a direct influencing impact on the petroleum sales
  • Organization also wanted an forecasting model which will forecast at a Customer / Channel / Terminal level; to plan the inventory.

Analytics Led Approach

  • Selection of Response variables based on Statistical Tests.
  • Understand and identify the key KPI’s for each segment
  • SPSS to analyze data using Statistical techniques, user friendly (Multiple Regression Analysis)
  • Correlation Analysis to identify the relationship.
  • Regression Analysis to predict / forecast.
  •  

Business Impact

  • Pricing – Based on the existing / recent demand, pricing can be done without any intuition (By an Account Manager)
  • Trend Analysis. And structured steps to understand the relationships between multiple fields in the datasets.

Critical Success Factors

  • Channel Behavior – Depicts the prevailing fluctuation and also helps us in tracking the product at a channel level.
  • Pantry Loading – Over loading of products can be avoided and Inventory can be planned accurately to meet demand.

    3AI Trending Articles

  • Blockchain and IoT gives end-to-end visibility to Stakeholders in a Supply Chain

    While IoT sensors help track the movement and quality of products, blockchain’s distributed ledger gives multiple entities joint control over shared information . Covid concentrated attention on supply chains like never before as the pandemic caused massive disruptions. Companies started looking deeper into the roots of their supplies, going further back than their immediate vendors. […]

  • Which Startup Ecosystem Attracted Higher Investments in 2020? – Bangalore or Delhi NCR

    Bengaluru continues to be ahead of Delhi NCR in terms of total funding raised by startups located in these cities The pandemic saw funding across the top startup hubs like Delhi NCR and Bengaluru drying up But both cities gave the country a steady influx of unicorns in 2020, keeping the interest of investors alive […]

  • AI readiness – CEO’s most strategic agenda

    For the larger mass of professionals, the words “artificial intelligence,” or AI, often conjure up images of robots, the sorts of robots that might someday take their jobs. But at the enterprise level, AI means something different. It has enormous power and potential: it can disrupt, innovate, enhance, and in many cases totally transform a business. […]

  • 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 […]