• Advertise
  • Contact Us
  • About Us
  • Supplier Directory
  • SCB YouTube
  • Login
  • Subscribe
  • Logout
  • My Profile
  • LOGISTICS
    • Air Cargo
    • All Logistics
    • Express/Small Shipments
    • Facility Location Planning
    • Freight Forwarding/Customs Brokerage
    • Global Gateways
    • Global Logistics
    • Last Mile Delivery
    • Logistics Outsourcing
    • LTL/Truckload Services
    • Ocean Transportation
    • Rail & Intermodal
    • Reverse Logistics
    • Service Parts Management
    • Transportation & Distribution
  • TECHNOLOGY
    • All Technology
    • Artificial Intelligence
    • Cloud & On-Demand Systems
    • Data Management (Big Data/IoT/Blockchain)
    • ERP & Enterprise Systems
    • Forecasting & Demand Planning
    • Global Trade Management
    • Inventory Planning/ Optimization
    • Product Lifecycle Management
    • Sales & Operations Planning
    • SC Finance & Revenue Management
    • SC Planning & Optimization
    • Sourcing/Procurement/SRM
    • Supply Chain Visibility
    • Transportation Management
  • GENERAL SCM
    • Business Strategy Alignment
    • Education & Professional Development
    • Global Supply Chain Management
    • Global Trade & Economics
    • HR & Labor Management
    • Quality & Metrics
    • Regulation & Compliance
    • SC Security & Risk Mgmt
    • Supply Chains in Crisis
    • Sustainability & Corporate Social Responsibility
  • WAREHOUSING
    • All Warehouse Services
    • Conveyors & Sortation
    • Lift Trucks & AGVs
    • Order Fulfillment
    • Packaging
    • RFID, Barcode, Mobility & Voice
    • Robotics
    • Warehouse Management Systems
  • INDUSTRIES
    • Aerospace & Defense
    • Apparel
    • Automotive
    • Chemicals & Energy
    • Consumer Packaged Goods
    • E-Commerce/Omni-Channel
    • Food & Beverage
    • Healthcare
    • High-Tech/Electronics
    • Industrial Manufacturing
    • Pharmaceutical/Biotech
    • Retail
  • THINK TANK
  • WEBINARS
    • On-Demand Webinars
    • Upcoming Webinars
    • Webinar Library
  • PODCASTS
  • VIDEOS
  • WHITEPAPERS
Home » Elevating Supply Chain Planning IQ with Data Analytics

Elevating Supply Chain Planning IQ with Data Analytics

April 29, 2013
Romi Malik, Manager, Data & Analytics Solutions Practice, Mindtree

Supply chain planning analytics is a strategic and critical component of supply chain management. It drives aspects like raw material sourcing, manufacturing, goods delivery and return.

Need to Go 'Beyond Reporting'

Traditional supply chain planning is supported by reports generated by an enterprise resource planning system. The best result an ERP system can offer is historical transactional data and standard algorithms. ERP systems lack the ability to provide insights that optimize supply chain planning decisions and stretched lead times to understand interdependency among key performance indicators, which results in experience and gut-feel based optimized decision-making. Standard algorithms like demand forecasting techniques, do not accommodate the ever-changing product behavior during its product lifecycle (sudden growth, seasonality, demand stability, etc.) and the result can be an absence of future outlook and prediction features.

Supply chain planners are keen to link planning-related metrics to business critical KPIs such as On-Time In-Full (OTIF), sales target achievement, excess/low inventories, and actual raw material and logistics cost. Analytics can address these traditional supply chain planning challenges by providing solutions for future outlook generation, optimization, inter-KPI dynamics, quantification of impact of supply chain management metrics, and accurate forecasting. This leads to more informed decisions.

SCM (Planning) Analytics as a Concept

The supply chain management (SCM) planning department primarily targets accurate forecasts regarding product demands for the near future. Demand forecast figures further drive production, distribution, freight cost, and budgeting. Like any other business activity, inefficient SCM planning stumbles upon varied issues.

Sometimes, demand volatility manifests continuous over- or under-forecasting trends. A constantly biased forecast is detrimental for the supply chain.

Sometimes, there is low market serviceability. For example, a particular market demand for 1000 tons within a week was not met because only 750 tons could be dispatched on time, and the remaining only after 2 weeks. In other words, On-Time-In-Full (OTIF) is approximately 75 percent below the market threshold of 90 percent.

Sometimes, there is insufficient or excess inventory.  For example, a new medicinal soap was developed and launched via an intensive advertising campaign. The development and advertisement cost millions. Even though customers are excited about the new product, demand planning was under-forecasted. So, the estimated demand was less than the actual orders, causing insufficient inventory at distribution centers.  On the other hand, when demand is over-forecasted and there are actually fewer sales, the enterprise could end up with non-moving inventory, resulting in a sudden decrease in profits because of the expense of carrying this excess inventory.

Sometimes there is a misguided future outlook on the supply chain efficiency. For example, 100-percent order fulfillment is expected in the coming month, but the production plan shows insufficient planned production to meet the forecasted demand.

Finally, there are often inefficiencies in an organized and unorganized offline trade environment with multi-layered sales and interdependencies: Multi-layered sales implies a combination of primary sales, to private distributors, and secondary sales, to retail outlets.

Data analytics is a combination of business analysis supported by analytics techniques, such as exploratory data analysis, forecasting, regression, correlation and software tools. Dependency on different components of analytics varies from case to case.

Analytical capability can help to mitigate supply chain planning issues by way of analyzing sales data vis-à-vis supply chain planning KPIs and interpretation of trends and patterns. Few of the notable examples are analyzing different aspects of supply chain production efficiency, analysis of stocking norms and distribution efficiency, reviewing variations and inefficiencies in logistics costs incurred at various legs of stock movement until they reach the end consumer, utilizing statistical techniques to identify controlling parameters towards supply chain planning efficiency KPIs and quantifying the impact of individual parameters. For example, quantifying impact of demand drivers & adjustments on forecast bias using a regression model like forecast bias (positive / negative) is a function of base demand, demand drivers, adjustments, etc. Statistics-based customized forecasting approach for individual products, categorized into different scenarios like strong or weak seasonality, stability, and small packs also work.

SCM (Planning) Analytical Construct

The SCM planning analytical construct is comprised of hindsight, insight and foresight. It can be better understood through a consumer promotion scenario; thus the analyzing impact of supply chain planning numbers on a particular promotional event (such as the Temporary Price Reduction (TPR) on the promotion calendar that is typically scheduled during January and February). A 200-percent uplift is expected. For the desired outcome, supply chain planning should be aligned to promotion-related operations.

The following scenarios can be envisioned with some hindsight, insight and foresight. Hindsight, comprised of first-level analysis based on SCM cube slice-n-dice, e.g., visualization of supply chain KPIs during past instances of TPR. Insight, i.e., hypothesis testing of causal factors, e.g., does market serviceability support a positive uplift during TPR promotion type?  Finally, foresight, which involves developing an advance analytics model, e.g., what-if scenario to arrive at an approximate uplift based on SCM variables such as forecast bias, OTIF, and delivery compliance (%).

Best Practices for Supply Chain Planning Analytics Capability

The best practices for such capability include conceptualization of a SCM analytics cell for smooth churn-out of analysis requests via faster data extraction and cleaning methodology, documented analytics frameworks and analysis reports, and project governance.

Regular interactions between analysts and supply chain planners, in terms of the existing SCM process, SCM reports and KPIs, and business logic are important, as well as SLA-driven processing of analytics requests.

It is mandatory to measure performance of analytics capability investment in terms of incremental order fulfillment - volume and value sales. For this purpose, a business value logic standard needs to be developed jointly by planning and analytics team.  Business value logic will translate recommendations and insights into incremental sales/order fulfillment.

Conclusion

Analytics plays the role of support system for a supply chain planner by providing business specific insights in identifying and mitigating issues. It not only provides a means to act in the present based on the past but also provides a future outlook. Supported by data-driven insights, a supply chain planner will be able to improve forecasting accuracy, understand patterns, trim inventory fat, reduce stock-outs, and optimize raw material and logistics costs.

Source: Mindtree


Keywords: supply chain management, supply chain planning, supply chain solutions, supply chain management IT, forecasting accuracy, demand variability

RELATED CONTENT

RELATED VIDEOS

ERP & Enterprise Systems Forecasting & Demand Planning Supply Chain Planning & Optimization Technology Business Strategy Alignment Global Supply Chain Management Quality & Metrics Industrial Manufacturing
KEYWORDS Business Strategy Alignment Demand Variability ERP & Enterprise Systems Forecasting & Demand Planning forecasting accuracy Global Supply Chain Management Industrial Manufacturing Mindtree Quality & Metrics Romi Malik SC Planning & Optimization Supply Chain Analysis & Consulting Supply Chain Management supply chain management IT Supply Chain Management: SC Planning & Optimization Supply Chain Planning supply chain solutions Technology
  • Related Articles

    IBM – Maximize Your Supply Chain Effectiveness With Superior Planning and Analytics Webinar

    IBM – Maximize Your Supply Chain Effectiveness With Superior Planning and Analytics

    Creating Supply Chain Value with Big Data Analytics

Romi Malik, Manager, Data & Analytics Solutions Practice, Mindtree

More from this author

Subscribe to our Daily Newsletter!

Timely, incisive articles delivered directly to your inbox.

Popular Stories

  • DOCUMENTS BEARING THE INSIGNIA OF US CUSTOMS AND BORDER PROTECTION LIE ON A TABLE

    New CBP Regs Call for Greater Diligence by Brokers in Reporting Security Breaches

    Freight Forwarding/Customs Brokerage
  • A WORKER IN A WAREHOUSE, SUPERIMPOSED WITH GRAPHICS SHOWING SUPPLY NETWORK

    Enabling Intelligent Visibility With Supply Chain Analytics

    Data Management (Big Data/IoT/Blockchain)
  • GSCMS-Promo.png

    Watch: Introducing the Global Supply Chain Marketing Summit

    Education & Professional Development
  • A HAND TURNS A LARGE, LIGHTED DIAL WITH THE WORD RISK ON IT iStock-NicoElNino-1364371014.jpg

    Measuring KPIs and KRIs for Comprehensive Supplier Performance Management

    Technology
  • DEEPLY CRACKED EARTH UNDER A BLUE CLOUDY SKY

    Why Maritime Supply Chains Must Adapt to Sustainability Regulations

    Ocean Transportation

Digital Edition

Scb nov 2022 sm

2022 Supply Chain Innovator of the Year

VIEW THE LATEST ISSUE

Case Studies

  • New Revenue for Cloud-Based TMS that Embeds Orderful’s Modern EDI Platform

  • Convenience Store Client Maximizes Profit and Improves Customer Service

  • A Digitally Native Footwear Brand Finds Rapid Fulfillment

  • Expanding Apparel Brand Scales Seamlessly with E-Commerce Technology

  • How a Global LSP Scaled its Security Program and Won More Business

Visit Our Sponsors

Orderful Yang Ming Alithya
Barcoding Blue Yonder BNSF Logistics
CoEnterprise Data Capture Deposco
E2open GAINSystems Generix
Geodis GEP GreyOrange
Here Honeywell Intelligrated IFM
Infor Inmar Keelvar
Kinaxis Korber Lean Solutions Group 2H
Liberty SBF Locus Robotics Logility
LogistiVIEW Lucas Systems MCA Connect
MPO Nvidia Old Dominion
OpenText ORTEC Overhaul
Parsyl PMMI QIMA
Redwood Logistics Ryder E-commerce by Whiplash Saddle Creek Logistics
Schneider Dedicated Setlog Holding AG Ship4WD
Shipwell Tecsys TGW Systems
Thomson Reuters Tive Trailer Bridge
Vecna Robotics Verity
Verusen
  • More From SCB
    • Featured Content
    • Video Library
    • Think Tank Blog
    • SupplyChainBrain Podcast
    • Whitepapers
    • On-Demand Webinars
    • Upcoming Webinars
  • Digital Offerings
    • Digital Issue
    • Subscribe
    • Manage Your Subscription
    • Newsletters
  • Resources
    • Events Calendar
    • SCB's Great Supply Chain Partners
    • Supplier Directory
    • Case Study Showcase
    • Supply Chain Innovation Awards
    • 100 Great Partners Form
  • SCB Corporate
    • Advertise on SCB.COM
    • About Us
    • Privacy Policy
    • Contact Us
    • Data Sharing Opt-Out

All content copyright ©2023 Keller International Publishing Corp All rights reserved. No reproduction, transmission or display is permitted without the written permissions of Keller International Publishing Corp

Design, CMS, Hosting & Web Development :: ePublishing