• Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to footer

Before Header

  • Customer Training
  • Customer Support
  • Blog

Search

  • English

    Supply Chain Management Software (SCM Software) by Logility

    • Solutions
      • Advanced Analytics
      • Integrated Business Planning
      • Demand Optimization
      • Inventory Optimization
      • Sourcing Management
      • Supply Optimization
      • Quality & Compliance
      • Retail Optimization
      • Product Life Cycle Management
      • Supply Chain Data Management
      • Cloud Services
    • Industries
      • Consumer Goods
      • Furniture / Durable Goods
      • Electronics
      • Food & Beverage
      • Life Sciences
      • Process / Chemical
      • Retail
      • Service / Aftermarket Parts
      • Apparel / Softgoods
      • Wholesale Distribution
    • Resource Center
    • Company
      • Investor Relations
      • Contact Us
      • Careers
      • Leadership Team
      • Office Locations
      • Our Brands
      • Partners
    • News and Events
      • In The News
      • Events and Conferences
      • Press Releases
      • Press Inquiries
    • Contact Us
    • Solutions
      • Advanced Analytics
      • Integrated Business Planning
      • Demand Optimization
      • Inventory Optimization
      • Sourcing Management
      • Supply Optimization
      • Quality & Compliance
      • Retail Optimization
      • Product Life Cycle Management
      • Supply Chain Data Management
      • Cloud Services
    • Industries
      • Consumer Goods
      • Furniture / Durable Goods
      • Electronics
      • Food & Beverage
      • Life Sciences
      • Process / Chemical
      • Retail
      • Service / Aftermarket Parts
      • Apparel / Softgoods
      • Wholesale Distribution
    • Resource Center
    • Company
      • Investor Relations
      • Contact Us
      • Careers
      • Leadership Team
      • Office Locations
      • Our Brands
      • Partners
    • News and Events
      • In The News
      • Events and Conferences
      • Press Releases
      • Press Inquiries
    • Contact Us
    • Blog
    • Customer Support
    • Customer Training

    The Forecasting Conundrum

    August 23, 2016 //  by Hank Canitz

    The Forecasting Conundrum

    1. Home
    2. Blog
    3. The Forecasting Conundrum

    Supply Chain ForecastingConundrum: 1) a riddle whose answer is or involves a pun; 2) an intricate and difficult problem

    I have heard a number of supply chain professionals proclaim that their companies should stop forecasting product demand due to poor forecast accuracy. If we could only get closer to true end-customer demand the company could ship exactly what is needed, where and when. It’s the old Push — Pull argument.  And I agree that some companies can operate leaner if they move to a pull distribution strategy based on actual customer demand. However, what is often overlooked is that moving to a pull strategy does not eliminate the need for a forecast. Most likely the company will still need to forecast raw materials, purchased components, and/or sub-assemblies to be able to meet customer demand. In most cases the lead time for the materials to build a finished product is longer than the lead time a customer is willing to wait for that finished product. Here in lies the conundrum.

    What’s really driving supply chain professionals to throw up their hands and proclaim the worthlessness of product forecasting is their frustration with low levels of forecast accuracy. Given that most companies will have to forecast customer demand at some point in their supply chain, i.e., finished goods, sub-assemblies, raw materials, etc., it makes sense to put the frustration behind us and focus on improving forecasting capabilities. I have seen companies from a variety of industries struggle to overcome common barriers to improving product forecast accuracy. Let’s explore a few of these barriers below.

    Financial Impact

    First, you have to overcome the barrier of getting approval for forecast improvement projects. C-Level executives show greater interest when a positive relationship is seen between an investment and increasing shareholder value. To gain support for improving forecast capabilities, supply chain managers must show the relationship between forecast accuracy and shareholder value. They must speak in the terms the executive team thinks in (revenue, growth, service, value). One way of doing this is through the use of the DuPont Financial Performance Model which can help you show how improvements in forecast accuracy can increase sales revenue and reduce inventory, both of which lead to higher profits and increased shareholder value.

    Supply Chain Talent

    Another significant challenge is in finding and retaining demand planning expertise. Creating an accurate forecast requires skills in statistics, knowledge of the company’s products, customers and markets, and experience in making sense from lots of conflicting data. This combination of expertise is hard to find on the market and just as difficult to build internally. A company must put a premium on finding qualified forecasting professionals, providing business, system and professional training, and developing clear promotion opportunities to retain these critical resources.

    Executive Leadership

    The forecast process needs an executive champion. Solid leadership from above can prevent the argument of “whose forecast is the best” and “which one should be used.” An executive champion can create a vision and build consensus, advocate for the team, enforce consistent process and metrics, and directly lead improvement efforts that will positively impact both topline growth and bottom line profits. Such a leader sets the stage for dramatic demand planning process improvements to take place.

    Spreadsheet Sabotage

    Demand PlanningContrary to popular belief using Excel as a forecasting “system” is not a best practice. In fact, it is likely holding your company back from improving forecast accuracy. Studies have shown time and again that spreadsheets provide inadequate forecasting functionality and are riddled with errors. However, a recent survey conducted by APICS and Logility found almost one half of respondents still use spreadsheets as their primary tool for demand planning. However, spreadsheets simply cannot consistently generate accurate forecasts or support best-in-class supply chain processes. Spreadsheets lack the advanced capabilities to support multiple forecasting methods, management by exception, dynamic “ABC” segmentation, multiple levels of aggregation, global consensus planning, visual metrics, and “what-if” scenario analysis to name a few. Implementing an advanced statistical forecasting solution is a fundamental step to improving forecast capabilities. Only integrated planning systems provide the level of flexibility, power, and collaboration necessary to meet today’s complicated demand planning needs.

    Dynamic Models

    Companies tend to use an inadequate mix of forecasting techniques. A recent study found that nearly 40% of companies use only one forecasting technique across all their products no matter the life-cycle stage, channels served or market dynamics. Best-in-class companies have the ability to apply a series of forecasting techniques, tuned to perform best at different phases of the product lifecycle. They exploit both available historical data and forward-looking market knowledge at each lifecycle stage. An advanced forecasting solution can automatically change forecast methods during a product’s lifecycle to maintain maximum accuracy from launch to end-of-life.

    Best-in-class forecasting provides tangible business benefits, including lower inventory levels, shorter lead times, fewer out-of-stock events, increased perfect-order performance, and more successful new product launches. A comprehensive demand planning system managed by well-trained personnel and supported by an executive champion can supply a consensus forecast that all departments can use to develop their individual plans, while aggregating and disaggregating demand to create more accurate global forecasts over any demand horizon.

    Related Content:

    Hank Canitz
    Hank Canitz

    Product Marketing Director Hank brings more than 25 years of experience building high performance supply chains. This experience includes evaluating, selecting, implementing, using and marketing supply chain technology. Hank’s graduate degree in SCM from Michigan State, numerous SCM certifications, diverse experience as a supply chain practitioner and experience in senior marketing roles with leading supply chain solution providers helps him to bring a unique perspective on supply chain best practices and supporting technology to the Voyager Blog.

    Recent Posts

    • Import Bans from China Grow in US and UK
    • How Do You Turn Supply Chain Data Into Actionable Information?
    • Lot Traceability in the Fashion Industry
    • How Can Manufacturers Manage Disruption and Improve Productivity?
    • 12 Steps to a Resilient Enterprise: Part 1 of 4

    Related White Papers

    • Five Ways to Build Advanced Supply Chain Planning and Optimization Capabilities in Process Chemical Industries
    • Supply Chain Planning Transformation – A Practitioner’s Roadmap
    • A Digital Transformation Guide for Supply Chain Disruptions

    Success with Logility

    • Red Wing Shoe Company Masters Retail Supply Chain Collaboration
    • Haggar Crafts an Exceptional Supply Chain
    • Bodybuilding.com Uses Alerts to Strengthen Demand Planning Prowess
    Supply Chain Brief

    Category: Demand PlanningAsset Category: Demand Planning/Forecasting

    Previous Post: « Key Ingredients to Formulating a Winning Supply Chain Strategy in the Process Chemical Industry
    Next Post: Four Inventory Optimization Questions Every Life Sciences Supply Chain Team Should Ask Itself »

    Footer

    Solutions

    • Advanced Analytics
    • Integrated Business Planning
    • Demand Optimization
    • Inventory Optimization
    • Sourcing Management
    • Supply Optimization
    • Quality & Compliance
    • Retail Optimization
    • Product Life Cycle Management
    • Supply Chain Data Management
    • Cloud Services

    Industries

    • Consumer Goods
    • Furniture / Durable Goods
    • Electronics
    • Food & Beverage
    • Life Sciences
    • Process / Chemical
    • Retail
    • Service / Aftermarket Parts
    • Apparel / Softgoods
    • Wholesale Distribution

    Other

    • White Papers
    • Press Releases
    • Company
    • Careers
    • Contact Us
    • Investor Relations
    • Privacy Policy
    • Terms of Use
    • Cookie Policy
    • Forward Looking Statement

    Our Brands

    • Logility Solutions
    • Halo Business Intelligence
    • Demand Solutions
    • NGC Software

    Social Media

    © 2021 American Software, Inc. All rights reserved.