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

Sign in

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

3AI Digital Library

Terminal Volume Forecasting

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

  • IoT devices at risk from Amnesia:33

    A new series of vulnerabilities dubbed Amnesia:33 puts millions of IoT devices at risk of being compromised. Security researchers from Forescout disclosed the 33 vulnerabilities today. The flaws are found in four open-source TCP/IP libraries used in the firmware of products from over 150 vendors. According to the researchers’ estimates, millions of consumer and enterprise […]

  • Improving Customer Experience – AI/ML Driven Issue Resolution

    Author: Ashish Vashishta, VP – Technology, eClerx Customers across industries typically face issues with their purchased products/services. A troubleshooting system which can use latest AIML technologies to resolve these issues faster and more effectively can lead to a much better customer experience. As an example, a customer may have purchased a bundled product offering – […]

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

  • Cloud4C and Google Cloud to build CoE for SAP and Anthos

    The partnership aims to enable enterprises to accelerate their digital transformation journey on the cloud. Cloud4C, a cloud managed services provider, is collaborating with Google Cloud to build a Centre of Excellence (CoE) for SAP and Anthos by Google Cloud. The center of excellence (CoE) will equip businesses with capabilities to modernize mission critical IT infrastructure and applications, while […]