skip to Main Content

5 Ways Spreadsheets Undermine Your Forecasting and Planning Credibility

Supply Chain Planning
09/26/2018

It's a scenario many a supply chain planner has faced. And it’s one everyone dreads. You’re in a meeting when a key stakeholder asks, “Where did you get those numbers? They don’t match my calculations?” Your stomach flips. Your chest tightens. Your mouth goes dry. You stumble through an awkward explanation, the upshot of which is that you’ll have to go back through your work to answer that question. Your inability to answer prompts others in the room to start asking their own questions. You can’t answer those either. You’ve lost credibility. And spreadsheets are to blame.

If you’ve ever encountered any part of that scenario, you know the feeling it creates. Of being at sea, feeling unmoored because you don’t have the information at hand to share your forecasts with confidence.

But you’re hardly alone. Spreadsheets are a top go-to productivity tool for anyone managing a supply chain, especially forecasters and planners. And for good reason. If your organization is a small business or in start-up mode, spreadsheets can be an effective, low-cost tool for the job. But once your number of SKUs start heading north of 100 or 150, spreadsheet limitations become problematic—and compounding.

Spreadsheets can’t provide holistic views. Or handle scale. They lack ERP integration and security controls. These are all serious impediments to efficient supply chain planning.

But the shortcomings that really hit you in the gut are about credibility. And it’s not just your credibility as a planner that’s on the line. With spreadsheets, the credibility of your company’s entire planning effort is at stake.

Here are 5 ways spreadsheets erode planning credibility:

1. Inevitable Errors

The manual data entry in spreadsheets creates errors. Period. In fact, by some estimates, more than 90% of spreadsheets contain errors of one kind or another. It’s highly likely that your current forecasting spreadsheets contain multiple errors.

There are many ways to make mistakes in spreadsheets. Mistyped numbers, numbers entered or pasted in wrong cells or columns, corrupted or accidentally altered formulas, flawed logic, and missing cells are some.

Unfortunately, unlike a spelling error that a spellchecker can flag in real time, errors in spreadsheets go unnoticed until they cause problems. And those problems have a nasty tendency to cascade. The results? Miscalculated inventory levels, false demand assumptions, production delays, missed deliveries, and lost customers. The list of potential pains is truly endless.

2. Data Limitations

To be credible, an inventory forecast, demand plan, or supply plan must take into account a host of variables that spreadsheets can’t easily accommodate. For example, your planning might require the aggregation of large data sets that span multiple hierarchy levels and extended time horizons. Your plans might need to reflect demand volatility, fluctuating lead-times, or the implications of coordinating supply chains across multiple locations. This degree of data agility is not something you can wring from Excel.

And then there’s the whole issue of timeliness. Spreadsheets are so labor intensive that data becomes outdated as soon as you hit save. Do you have the latest numbers? From everyone? That’s nearly impossible to pull off with spreadsheets.

3. Dueling Spreadsheets—and No Single Version of the Truth

In business, spreadsheets are everywhere—as common as email and slide decks. When it comes to credibility, the very popularity of spreadsheets can work against you. Why? Because every stakeholder in the business likely has their own spreadsheets. Marketing, finance, sales, operations, etc. Multitudes of them. Each one highly customized for very specific purposes.

You know how extraordinarily difficult it is to merge data from different spreadsheet silos. You live that grind every day. Consolidating spreadsheets and reconciling conflicts from different internal departments and external suppliers is like herding cats in a hailstorm.

With no single version of the truth, reaching consensus is a major challenge. A lack of consensus leads to loss of trust and poor decision making. That’s the opposite of what you want from supply chain planning.

4. Lack of Analysis and Insight

Another way that spreadsheets can undermine credibility is by leaving you with no clear answers to business-critical “what if” questions. What if a news event creates an unexpected surge in orders? What if a key supplier suddenly runs into unexpected problems hitting delivery dates? What if a vital production line experiences prolonged unplanned downtime? An agile supply chain plan enables you to plan for the unexpected. But that’s simply not possible when you rely solely on spreadsheets as your primary planning tool.

Excel can perform only limited analysis and relying on it for scenario planning and “what if” analysis requires a high degree of sophistication. Any significant change to the model will likely require substantial adjustments—modifications that are time-consuming and error-prone.

In addition, analyzing data across multiple hierarchies, facilities, customers, and all supply chain nodes is not feasible with spreadsheets.

Without analytical insight, you’re forced to find your way in the dark.

5. Risky Single Point of Failure

In most organizations, one person is responsible for building out the spreadsheets that drive supply chain planning. Credibility issues arise when others in your organization need to work with the spreadsheets the planner created. Because supply chain planning spreadsheets are heavily customized, the only person who can effectively update and modify them is the planner who created them. That’s a very risky single point of failure to have in your planning process.

When it comes to planning, “many heads are better than one.” Individual spreadsheets hinder the comparison, collaboration, and consensus required to ensure that all stakeholders can trust your supply chain plans and make decisions with confidence.

There’s a Better Way—in the Cloud

Comprehensive cloud-based supply chain planning software can help ensure the credibility of your numbers and forecasts. Capabilities like those found in DemandCaster provide substantial advantages over spreadsheet-based planning. Automation, ERP integration, powerful forecasting algorithms and “what if” analysis, fluid collaboration across departments and disciplines, the end of spreadsheet silos, a single version of the truth, and no more single points of failure. And those are just for starters. Explore how DemandCaster empowers you to create supply chain plans everyone can trust.

Related Articles

Supply Chain Planning to the Rescue – Cash Flow Management During COVID-19

During the best of times, managing cash flow can be challenging. But during long-term disruptions such as COVID-19, cash flow management can become an existential exercise. As companies look to assess the damage from the pandemic, in order to define [...]

5 Keys to Managing Supply Chain Planning in Uncertain Times

With the world having been plunged into uncertainty during the COVID-19 pandemic, a critical issue for business managers is stabilizing their supply chain to a consistent flow of components and materials. One July report by the Institute for Supply Management [...]

Beating Disruption with Digital Supply Chains

In the past, companies relied on the shared knowledge of a handful of people within an organization - and sometimes just one person - to plan and manage supply chain requirements. Supply Chain Management (SCM) consisted of phone calls, desk [...]

A Comprehensive Guide to Predictive Inventory Planning and Management

Inventory management remains an important operational feature that determines the successes and failures of enterprises especially in the manufacturing and retail industries. For inventory management, the challenges for most enterprises are similar at a basic level. The mom and pop [...]

Advanced Planning Challenges in Brownfield Facilities

The manufacturing industry relies on its legacy systems and equipment to get work done. This has been the way for decades. A report on the state of the manufacturing industry states that only 26% of manufacturing plants believe implementing new [...]

Best Practices for Resource Capacity Planning for Small and Medium Businesses

Manufacturing can be challenging in the best of conditions.  But for small and medium-sized businesses (SMBs) striving to remain competitive with large companies, their smaller size and reach mean that planning is even more crucial.   Small and medium-sized businesses often [...]

6 Questions that will Improve Your Capacity Planning Strategy

Capacity planning has always been a core strategic process in the manufacturing industries' quest to meet the demand of customers in a timely and efficient manner. Having accurate insight into your plant’s production capacity within specific durations of time while [...]

6 Tips to Improve Inventory Management through Automation

For companies with outdated or manual inventory management systems, lack of certainty about the accuracy of inventory levels can make managers and decision-makers apprehensive during busy times.  If calculations and inventory management practices are off, companies may find themselves with [...]

Strategies for Optimizing Customer Service Levels

  While every business works diligently to improve efficiency and operational excellence, at the end of the day it’s the customer who determines a company’s success.  And companies are looking for new ways to optimize customer service levels to improve [...]

The Method in the Madness – Choosing the Best Demand Planning Method

Aligning demand with supply is a critical function for any company.  And it’s one with a lot of moving parts.  The right demand plan must have a balance of inputs from all areas of the company to create forecasts that [...]
Subscribe to our Blog
Back To Top