• 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

    Ann Grackin: Is the Crisis in Demand Management Being Exacerbated by Spreadsheet Dependency?

    January 22, 2014 //  by Logility Staff

    Ann Grackin: Is the Crisis in Demand Management Being Exacerbated by Spreadsheet Dependency?

    1. Home
    2. Blog
    3. Ann Grackin: Is the Crisis in Demand Management Being Exacerbated by Spreadsheet Dependency?

    This blog post is in response to recent results from the APICS/Logility Survey, Consumer Goods S&OP research, and ChainLink’s end-user research.

    Spreadsheet Error Demand management has always been at the top of supply chain professionals’ list of challenges. Of late, many companies have also indicated that having grappled with cost cutting a few years back, now they are more focused on growth. Predictably, 62% of the respondents sought growth through channels, 46% through more direct customers, and approximately 20% by creating new products. These goals have been supported by more channel-specific offerings and packaging and by increasing product options and selections. This year companies also increased their use of new services, trade promotions and the promotional door busters, many of which were less than stellarly executed. All these moves have added complexity to the demand planning challenge.

    Companies have made their chains more complex in other ways, with supply-side changes such as outsourcing and by varying logistics methods leading to constant complaints of poor visibility. We were making progress. But surely as the problems get bigger or more complex, they do call for bigger, more scalable solutions.

    Against this backdrop, it is interesting that many companies still depend on spreadsheets for demand planning and S&OP, as noted in the recent survey by APICS (see Are Spreadsheets the Answer, SC Digest, September 2013). Could there be a connection between the use of spreadsheets and the lack of visibility, poor promotional performance, and growing inventory levels for some companies? I think so. I am going to give a brief picture of recent data and draw what I think are some conclusions about the impact (or lack thereof) of spreadsheets. I am not alone in the opinion (see Red Wing Shoe Company webcast, Are Spreadsheets Sabotaging Your Forecast) that spreadsheets may not be the path to supply chain success.

    Firstly, some ChainLink research data. Each year we ask our audience to tell us about their challenges and what processes and solutions they are going to invest in. We also ask them what they have installed. In comparing our research data over the years we found that those who had already bought and implemented demand planning solutions were seeing improvements in critical measures of their supply chain. Those who did not and had no plans to scored lower on critical measures. These low scorers report forecast inaccuracy, and demand planning as their biggest headaches.  Issues such as: poor ability to analyze customer demand data, such as POS; poor linkage between market demand and procurement; and poor mix, inability to spot underperforming products, and poor execution in promotions were reported.

    Those interviewees who automate forecasting (see Caribou Coffee’s Supply Chain Story, ChainLink, January 2013) , S&OP, and or inventory management systems had significant critical metric improvements and  benefits from these solutions, especially in their ability to change and scale: add more products, respond to changing customer requirements, and fine tune their processes. They had faster turns, lower inventory, and better customer service. They were also more productive. This is an interesting result, since the so-called benefit of spreadsheets is their ability to allow users to be flexible to do it themselves (without IT intervention).

    I recently read a very good survey by Consumer Goods Technology, focused on S&OP. And although it noted that S&OP as a process was becoming more widely adopted with benefits to the organization, many organizations (53%) were using spreadsheets to do the job. Below are several of the points that stood out as I went through the results:

    Logility Staff
    Logility Staff

    Recent Posts

    • 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
    • Supply Chain Manager – A “Green” Superhero

    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
    • AI and Analytics: The Importance of Visualization and Data

    Success with Logility

    • Tillamook Improves Dairy Supply Chain Performance
    • Service Foods Ready for Global Expansion with Scalable Analytics Now in Place
    • CooperVision Clearly Sees Visibility Improvements
    Supply Chain Brief

    Category: CollaborationAsset Category: Analytics, S&OP/IBP

    Previous Post: « Lora Cecere Asks: Why Do People Question the Value of S&OP?
    Next Post: Corralling New Product Innovation and S&OP »

    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.