Supply Chain News

Isn’t It Time to Finally Retire Your Supply Chain Spreadsheets?

According to a recent survey, 65% of companies are still using spreadsheets in planning their supply chain process, and while they are familiar, inexpensive, and convenient relying on spreadsheets pose serious setbacks for organizations.

A recent Wall Street Journal article details how finance chiefs are cutting back on Microsoft Excel because it hasn’t “kept up with the demands of contemporary corporate finance units.”

“I don’t want financial planning people spending their time importing and exporting and manipulating data, I want them to focus on what is the data telling us” – Adobe Inc.’s finance chief Mark Garrett tells WSJ journalist Tatyana Shumsky.

This mood prevails among supply chain executives as well.

Spreadsheets still dominate planning in the supply chain.

We recently commissioned Supply Chain Insights to conduct independent research on supply chain network design, and 65% of the companies surveyed are reportedly using spreadsheets to support this process.

Spreadsheets are familiar, inexpensive and convenient. But they pose serious setbacks for organizations:

  • They are practically never integrated with other systems
  • They are not updated automatically
  • The logic behind them is often only clear to those who create them and often dies when somebody leaves, making collaboration difficult
  • Analyses are often slow given that you can only work with a certain amount of data
  • Version control is hard

What Supply Chain Chiefs Say

Several of our customers have decided to retire their spreadsheets in exchange for more robust and collaboration-friendly solutions. BP, for instance, used to run its business mainly on spreadsheets. But this limited transparency and visibility, as Norm Jerome, the company’s former advisor for Economic Modeling and Supply Chain Optimization recounts:

"Using a collection of spreadsheets (each owned by different people or teams) tends to be rather manual and disconnected so typically it’s quite difficult to figure out the true state of business on any given day because you have to look in so many different places. Replacing those spreadsheets with a central tool allows people to learn a huge amount about what is going on that they never knew.

Centralizing this data and providing wide access has been one of the biggest benefits of the system we have built in AIMMS. And building this system in AIMMS was easier than in any other environment we have. Then, once you have good quality data regularly flowing in, you can build up a history. This then provides a basis from which you can actually start doing modeling and optimization.”

BP is not alone. Nampak, a leading packaging company based in South Africa, traded spreadsheets for a customized production scheduling and optimization tool built in AIMMS. The team was using Excel, which allowed them to manage their schedule at a basic level but didn’t provide the ability to make fast, complex, optimized calculations or quantify the financial impact of their planning decisions.

Using the AIMMS-based solution allowed them to quantify planning changes and respond more quickly as planning challenges unfolded. You can learn more about their optimization journey in the video below.

Boon Edam is yet another industry leader that is moving away from using spreadsheets. They have also adopted an AIMMS-based solution. This time for S&OP. The company was transitioning to a new business model and needed to optimize the workload between factories to increase efficiency.

But the tools that they were using could not keep up with their business reality. This compelled them to develop a solution in AIMMS. This has greatly contributed to improving their forecast accuracy and forecast horizon.

Supply Chain Analytics for Everyone

Are you struggling with spreadsheets? Do these challenges sound familiar? We want to make it easier for organizations to liberate insights with a technology that is robust and powerful, but easy to use and easy to collaborate on.

That’s why we launched AIMMS SC Navigator, a suite of Apps that helps you democratize supply chain analytics. We’d love to tell you more about it and see how it can work for your business.

Related Article: Why You Don’t Need Perfect Data to Begin Implementing Sales & Operations Planning

Why You Don’t Need Perfect Data to Begin Implementing Sales & Operations Planning

What Are Companies Looking For In Network Design Technologies?

Nearly three-quarters have a supply chain network design process, with 35% using in-house technologies

Network design as a discipline is complex.

You need technology to crunch the numbers, manage the data and run optimization models for decision support.

 

The majority of survey respondents (72%) have a network design process in place.

Half of them are already using technologies, 35% of which are deployed in-house.

Traditionally, network design technologies have been used on a project basis.

Recently though, we have seen a move from strategic to tactical use, with companies running models on a quarterly, monthly or even weekly basis.

This has resulted in a need to build up internal skills in the form of a dedicated team or center of excellence.

Supply Chain Network Design is the practice of locating and rationalizing the facilities within the supply chain, determining the capacity of these facilities, determining how to source demand through the network and selecting modes of transportation in a manner that provides the required level of customer service at the lowest cost.


Download the Research: What Are Companies Looking For In Network Design Technologies?


Article Topics
Best Practices   Supply Chain   Supply Chain Optimization   Analytics   Supply Chain Optimization   All topics


Comments
Be the first to post a comment.
You must be logged in to post a comment. Login.

 
Latest Supply Chain News
Amazon Selects New York City and Northern Virginia For Its New HQ2 Locations
Amazon to invest $5 billion and create more than 50,000 jobs across the two new headquarters and announces Nashville as new Operations Center of Excellence with more than 5,000 jobs.

It’s Time to Review and Minimize the Ever Increasing Threat of Cargo Theft
Although many businesses prefer not to report incidences of theft, the Federal Bureau of Investigation (FBI) estimates that North American cargo losses amount to roughly $40 billion annually...and the…

SAP SE to Acquire Qualtrics International for $8 Billion
Under the terms of the agreement, SAP will acquire all outstanding shares of Qualtrics for US$8 billion in cash, SAP has secured financing in the amount of €7 billion to cover the purchase price and…

Control Towers for CFOs: Aligning Finance and the Supply Chain in the Extended Enterprise
CFOs must balance conflicting demands as they make reinvestment decisions that facilitate ethical, sustainable growth while maintaining a disciplined drive for operational efficiency and short-term shareholder…


 

24|7 Pro Team

The 24|7 Team is your direct pipeline to solutions for your business challenges. It's your opportunity to have supply chain and logistics experts look at your specific challenges and needs, and give you free, no-obligation advice, solutions, and information.

The 24|7 Team will simplify the task of creating a database of likely partners, building your knowledge base, and preparing your Request for Proposal list.

1
  Choose a topic for your RFP

Transportation RFP/RFI

The Transportation RFP is your direct pipeline to solutions for your transportation challenges. It's your opportunity to have logistics experts look at your specific transportation challenges and needs, and give you free, no-obligation advice, solutions, and information specific to your request.

Choosing the perfect software or system can be an indomitable challenge. Using this transportation/TMS RFP will simplify the task of creating a database of likely partners, building your knowledge base, and preparing your Request for Proposal list.

Warehouse/DC Management RFP/RFI

The Warehouse Management Systems (WMS) RFP is your direct pipeline to solutions for your WMS challenges. It's your opportunity to have logistics experts look at your specific WMS challenges and needs, and give you free, no-obligation advice, solutions, and information specific to your request.

Choosing the perfect WMS solution can be an indomitable challenge. Using this WMS RFP will simplify the task of creating a database of likely partners, building your knowledge base, and preparing your WMS Request for Proposal list.

Supply Chain RFP/RFI

The Supply Chain RFP is your opportunity to have logistics experts look at your specific challenges and needs, and receive free, no-obligation advice, solutions, and information. It simplifies finding a pool of likely partners, building your knowledge base, and preparing your Request for Proposal list. The companies in the Logistics Planner have agreed to respond to your request for in-depth information and follow-up, and your request is totally confidential.

Software/Technology RFP/RFI

The Software/Technology is your direct pipeline to solutions for your logistics information technology challenges. It's your opportunity to have logistics experts look at your specific technology challenges and needs, and give you free, no-obligation advice, solutions, and information specific to your request. Whether it's WMS, TMS, Mobile or Cloud, our pros can help.

The companies listed below have agreed to respond to your request for in-depth information and follow-up. Your request is totally confidential.

Executive Education RFI

The Logistics and Supply Chain Education RFI can help you identify the schools, coursework, continuing education, distance learning and certification opportunities available from leading logistics educational institutions.

Upgrade and improve your logistics and supply chain skillsets. Whatever route you choose—advanced degree, executive education, certification or distance learning—the time and money you invest in your education today can pay off in continued career success tomorrow. Contact leading universities and professional institutions for the information you need to prepare for the future.

Third Party Logistics RFP/RFI

This 3PL Request for Proposal (RFP)/Request for Information (RFI) can help you find the 3PL and 4PL providers that can meet your specific 3PL service challenges and needs. The 3PL companies below will provide free, no-obligation third-party logistics advice, solutions, and information.

Ask your 3PL questions, you'll get answers. Simply complete the information, and detail your 3PL challenges. Then, check off the third-party logistics companies that you want to review your request.

1. Choose an RFI topic.
2. Enter your contact information and challenge.
3. Select companies and optional categories.
4. Submit.


2

Your Information



Your Challenge, Problem or Request *

3

Select Transportation Companies

  • Select All

  • 3Gtms
  • BluJay Solutions
  • CSX Trans. Intermodal
  • Kuebix
  • Landstar
  • Legacy Supply Chain Svs.
  • One Network
  • Pitt Ohio
  • Purolator
  • Quintiq
  • SEKO Logistics
  • SMC3


Select Relevent Categories

  • Air Freight
  • Intermodal
  • Motor Freight
  • Ocean Freight
  • Rail Freight
  • TMS

Select Warehouse/DC Management Companies

  • Select All

  • 3PL Central
  • Apex Supply Chain Tech.
  • Honeywell Intelligrated
  • Kuebix
  • Legacy Supply Chain Svs.
  • Swisslog
  • Westfalia Technologies
  • Zebra Technologies


Select Relevent Categories

  • Auto ID & Data Capture
  • Automation
  • Conveyors & Sortation
  • Lift Trucks
  • Packaging & Labeling
  • Pallets & Containers
  • Shelving & Racking
  • WMS

Select Supply Chain Companies

  • Select All

  • 3Gtms
  • 3PL Central
  • Amber Road
  • Apex Supply Chain Tech.
  • APICS
  • BluJay Solutions
  • CSX Trans. Intermodal
  • Frontier Business
  • Kuebix
  • Landstar
  • Legacy Supply Chain Svs.
  • Logility
  • One Network
  • Purolator
  • Quintiq
  • SMC3
  • Synchrono
  • TAKE Supply Chain
  • Westfalia Technologies
  • Zebra Technologies


Select Relevent Categories

  • Global Trade
  • Inventory Management
  • Risk Management
  • Sustainability

Select Software/Technology Companies

  • Select All

  • 3GTMS
  • 3PL Central
  • Apex Supply Chain Tech.
  • BluJay Solutions
  • Honeywell Intelligrated
  • Frontier Business
  • Kuebix
  • Logility
  • One Network
  • Quintiq
  • SMC3
  • Swisslog Logistics
  • Synchrono
  • TAKE Supply Chain
  • Zebra Technologies


Select Relevent Categories

  • ERP
  • Sales & Operations
  • Sourcing/Procurement
  • Optimization
  • Transportation Mgmt
  • Warehouse Mgmt

Select Executive Education Choices

  • Select All

  • Graduate Courses
  • Online/Distance
  • Executive Education
  • Certifications
  • Undergraduate
  • Seminars
  • Associations
  • Conferences
  • Tradeshows


Select Third Party Logistics Companies

  • Select All

  • 3PL Central
  • Landstar
  • Legacy Supply Chain Svs.
  • Purolator
  • SEKO Logistics
  • Westfalia Technologies


4
 

24|7 Company Profiles