skip to Main Content

6 Reasons to Avoid Using Spreadsheets for Supply Chain Planning

Supply Chain Planning  
04/03/2019

First introduced to the business world in the late 1970’s as a computerized representation of bookkeeping worksheets, spreadsheet software has become a staple in almost every office. Used in a wide variety of industries from manufacturing to retailing to professional services, from multinationals to the SME, spreadsheet functionality is loaded onto virtually every modern office PC and laptop in the developed world.

Businesses everywhere rely upon the flexibility, speed, and power of spreadsheets to track sales and expenses, help evaluate inventories, forecast demand, and generate decision-support analyses. It is one of information technology’s great success stories. Considered to be indispensable in many businesses, the skills required to manipulate spreadsheets and create the myriad reports that are available through the software are taught in every business school across North America. Spreadsheets have evolved into a highly sophisticated converter of data into information, and in the hands of a knowledgeable user, their output can almost “sing” to business leaders.

As powerful and remarkable as spreadsheets are – they do have limitations. If businesses rely upon spreadsheet software too heavily, their companies can be exposed to serious financial and operational risk.

Having acknowledged that spreadsheets are likely here to stay, and that they can be an amazing asset for any business, managers need to know when to use them and when to employ a more holistic technology that is safer, more consistent, and more robust.

The following is a brief selection of the shortcomings of spreadsheets that management should consider when planning their future technology needs:

1. GIGO

Every IT professional knows about “garbage in, garbage out.” Spreadsheets are particularly vulnerable to this condition.

Entering data into spreadsheets manually is still very common, and with each piece of data entered by hand, there are ample opportunities for errors to occur. Many businesses try to avoid this problem by installing routines that require data to be downloaded from a data warehouse or similar, but even then, the user must query the right data for the analysis, and manipulate it carefully.

The quality of the output, in the form of reports, charts, graphs, or tables, is fully dependent upon the way in which the raw data makes its way into the spreadsheet. If mistakes are made during a download or through manual data entry, results can mislead and significantly distort reality.

2. Inconsistent Knowledge

Some analysts are brilliant spreadsheet super-users who can glide through the software’s functions with ease. These experts possess unique skills that enable them to craft the appropriate formula for almost every business problem and eventuality.

A less experienced analyst might be familiar with fundamental spreadsheet structure but challenged by higher levels of analytical complexity. A lack of advanced mathematical acumen may result in errors in a spreadsheet’s structure. Imagine a novice spreadsheet user who inadvertently inputs the wrong formula to calculate a percentage growth trend, or sorts data incorrectly for a Pareto Analysis; such mistakes could spell disaster.

It is very difficult for businesses to build and maintain a workforce that it highly skilled in spreadsheet development and manipulation. It is a constant challenge to train and retrain users who routinely change job responsibilities or move in and out of the company. When there is significant variation in the skill sets of the analysts, variation in the quality of output will result.

Further, even a team of highly-skilled analysts can have their own methods and preferences when it comes to problem-solving. Ten different analysts might take ten different paths to solving a problem or addressing a business need. Achieving consistency of approach is a chronic challenge.

3. Transfer of Knowledge

A given professional might be able to build a set of spreadsheets that work perfectly well for both the analyst and the business. But problems arise when management tries to “export” that approach to other analysts within the company.

By its nature, the computer spreadsheet is highly customizable. It is possible to “lock down” some cells, formulas, and processing macros, but that comes at a cost to the very quality that makes spreadsheets attractive: flexibility. When a user inherits a standardized spreadsheet from another user, the temptation to tinker, modify, and adjust might be irresistible. Certain valuable nuances considered when building the original spreadsheet can easily be lost as the spreadsheet is transferred from one user to another. It can be very difficult for one user to get into another user’s “headspace” to truly understand why the spreadsheet was constructed in the way that it was.

Transfer of knowledge required to achieve consistency of approach in many offices can be exceedingly challenging when trying to distribute spreadsheet technology broadly throughout the enterprise.

4. A Matter of Interpretation

Many business metrics are open to interpretation. As analysts gather data to populate spreadsheets, they must take great care in gathering the right data. It is important that we avoid comparing apples to oranges.

Consider, for example, the issue of “cost.” An analyst can easily query a data warehouse for cost information, but be unaware of the different types of costs that might exist in the master files. Should they use “ex-factory” cost, “net landed” cost, or “total cost of ownership” for a given analysis? Results will vary dramatically depending upon the level of business knowledge possessed by the user.

5. Potential for Fraud and Misrepresentation

Spreadsheet applications are vulnerable to security breaches, and open the potential for fraudulent activity and malfeasance if not managed very carefully. By nature, spreadsheets have open access by the user or users; manipulation and version control can be difficult to track.

6. Limited Sophistication

While spreadsheet software has evolved tremendously since the 1970’s, the software tends to be limited in its ability to calculate very sophisticated demand forecasts, plan complex materials requirements, and coordinate with other functional areas of the business when used for planning and budgeting purposes.

Today’s supply chain planning (SCP) software can simultaneously calculate forecasts, for example, using a variety of complex algorithms, and chose the forecast that provides the best “fit.” This is very difficult to achieve in spreadsheets even in the hands of super-users. Further, ERP and supply chain planning software will speak a consistent language across an entire business, facilitating the coordination of analyses and results across various functional areas.

Paradoxically, the speedy spreadsheet fails to support agile business strategies particularly well. They can be awkward to update, and require a considerable amount of human intervention to produce suitable reports. For the agile business that requires virtually real-time information, the spreadsheet can be decidedly slow.       

Summary:

Spreadsheets are indispensable in many workplaces, and the technology has been singularly successful over the past 40 years. It has earned its accolades, having saved billions of dollars and countless hours of processing time for financial reports, inventory analyses, sales analyses, budget creation, and many other activities. Being overly-reliant on this technology can, however, introduce significant risk to business.

Office spreadsheet applications are best suited to “ad hoc” analysis and report generation, under special or unique circumstances. Their flexibility and openness to customization allows users a high level of creativity, and fast manipulation of data. To rely on an analytical architecture based on spreadsheets over the long term can, however, lead to a number of problems and inefficiencies.

It is critical that companies achieve high levels of consistency in the generation of information, secure their data very tightly, allow for fast and efficient transfer of knowledge from user to user, and ensure that the right data is being used for the right analyses, thereby avoiding misinterpretation.

Enterprise Resource Planning (ERP) systems and purpose-built supply chain planning software systems, such as DemandCaster, are ideal for addressing many of the vulnerabilities encountered in spreadsheet-centric offices. Reputable ERP and SCP software systems are secure. They use common sets of data to produce consistent reports and outputs on a reliable schedule. They are robust, and use sophisticated algorithms, developed by experts in the field, to process vast amounts of data very quickly.

Know when to use spreadsheets, and when not to use spreadsheets to support your business needs. Your company’s bottom line will be the healthier for it.

Contact us if you are ready to reduce your reliance on risky spreadsheets and gain the agility needed to make supply chain planning a continuous driver of efficiency and profitability at your company.

 

Related Articles

Seven Advantages of Integrated Demand and Supply Planning

A championship football team reaches such heights because of teamwork, practice, and a clear strategy.  Both offensively and defensively, team members are drilled over and over to work together and know the plan so that on game day, everyone is [...]

What you should know about correlation and causation

Just because you see patterns doesn’t mean you should make your business decisions around them. It’s easy to find connections and mix up correlation and causation, so do you research and don’t mix them up. The Institute of Business Forecasting [...]

Demand Planning vs. Supply Planning: Balance is the Key to Success

Organizations that manage a supply chain have a number of priorities that need to be continually balanced: meeting financial goals, completing customer orders on time and in full, and keeping facilities at optimal productivity levels, to name just a few. [...]

What is CPFR in supply chain?

CPFR stands for collaborative planning, forecasting, and replenishment. The Institute of Business Forecasting and Planning said, “CPFR strategies allow aligning of multiple S&OP processes and jointly plan supply chain activities to ensure that the joint business plans between organizations are [...]

The Long and the Short of It: Variables in Managing Long and Short Supply Chain Legs

Supply chain planning can be a daunting task. And, as economies globalize at a faster rate, just keeping pace will become increasingly difficult. Studies have shown that as much as 21% of a company’s performance is impacted by its global [...]

6 Tips for Better Supply Chain Planning: Planning Resolutions for the New Year

Every January, millions of people start the New Year with a list of resolutions.  From weight loss to career to finances, the list of things to change and improve are diverse and aimed at pushing someone to the next level. [...]

Technology Helps Brands Grow Beyond

In the 2018 National Manufacturing Outlook and Insights report, manufacturers expressed remarkable optimism for their industry and businesses in 2018. More than half of those that responded to the survey that generated the report indicated that they expected growth within [...]

Confronting Disaster with Agile Supply Chains

Predictive analytics in the week prior to the arrival of Hurricane Florence onto the shores of North Carolina on September 14, 2018 estimated that at least 10,000 actual or planned truck shipments to and from coastal regions were at risk [...]

5 Ways Spreadsheets Undermine Your Forecasting and Planning Credibility

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 [...]

Automate Processes for More Accurate Forecasting

Accurate forecasting, or at least as near to accurate as you can get, creates efficiency and cost savings. By having accurate demand forecasts, you can plan inventory with a minimum of overstock, production, and shipping with short lead times along [...]
Subscribe to our Blog
Back To Top