Supply Chain Management, Analytics, and Optimization Blog

Optimization Intelligence for Supply Chain
Logistics and Planning Professionals

What are supply chain professionals using to make network decisions? 

Part I in our series on assessing your network design’s maturity 

How does your network design compare to othersWe recently created a quiz to help supply chain professionals answer this question.  Our goal was to help you identify potential improvement opportunities by answering a few questions and get a temperature check on the current landscape of network design solutions. We had quiz takers from 23 countries and across industries – from chemicals to manufacturing, metals, telecom, cosmetics, consumer goods, transportation and food. It’s great to see the enthusiasm for this interactive tool. 

Our findings show that most respondents rely on a combination of spreadsheets (nearly 60%), gut feel (15%) and previous experience (46%) to make supply chain network decisions.  Only about 22% use network design software and 18% use network design software with embedded analytics among this group. 

what do you currently use to make supply chain decisions?

More than half of the professionals assessed indicated that they didn’t use some form of advanced analytics to support their network design process. None of the respondents share data across multiple applications to manage inventory, network design and S&OP in an integrated way.

"Do you currently use advanced analytics to optimize your network?"

“Do you currently use advanced analytics to optimize your network?”


When asked to assess their maturity level in using network design technologies, most professionals stated that they considered themselves “advanced beginners” (nearly 40%), followed by “competent” (32%), “novice” (12%), and “proficient” at 8%.  

How experienced is your company in terms of using supply chain network technologies?


It’s time to kick the spreadsheet habit 

These quiz responses are fairly consistent with a 2017 survey by Lora Cecere’s Supply Chain Insights, which revealed that 65% of companies use spreadsheets for network design. Spreadsheets are inexpensive and familiar. People often stick to using them because they think they can’t afford a more advanced solution. Some also think the solutions available in the market are too difficult to use or too expensive.  

The truth is, companies that use spreadsheets for network design are leaving major opportunities on the table. The more complex the network, the harder it is to make spreadsheets work. Spreadsheets are also known for being error-prone. In fact, as Market Watch reports, close to 90% of spreadsheet documents contain errors.  They don’t support robust optimization and they are unsustainable. Managing data across multiple spreadsheets quickly becomes unmanageable. If the person who initially created the spreadsheet leaves the company, it’s often harder for other users to understand the built-in logic as well.

It’s time for companies to kick their spreadsheet habit. Lower infrastructure costs and advances in cloud computing have made supply chain optimization technology a lot more accessible. Care should be exercised though, because the same reasons that have made the technology more accessible should’ve made it more affordable. But unfortunately, that’s not always the caseFind the right partner to work with that can help your team make a big step forward and build this competency.  The benefits can be considerable. Your team can reduce time spent on low value work and spend more time driving impact.

Take our quiz to see where you are compared to others and speak to one of our experts to see how AIMMS can help you transform network design within your organization.

This entry was posted in Digital transformation, Spreadsheets, supply chain design, Supply chain optimization on by .
Gloria Quintanilla

About Gloria Quintanilla

Gloria Quintanilla is a Marketing and Communications Specialist at AIMMS.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • Sign up

  • Banner 200x200
  • Banner 200x200
  • Customer Reviews

  • Review AIMMS on G2 Crowd
  • Recent Posts

  • Supply Chain Brief
  • Categories