What is the "right" S&OP tool?

addtoany linkedin

I came across an interesting post today at SearchManufacturingERP that talked about how to pick a tool to support your S&OP processes.  They raised a number of good points that I thought were worth going a bit deeper on. The first point they make is that for most companies, Excel is not a viable S&OP tool.

  • Anyone who has done extensive work in Excel knows that it is a very powerful tool that works best with smaller data sets.  Companies managing a complex supply chain soon find that they are stretching Excel’s boundaries to the breaking point.
  • Modern S&OP process have a significant “what-if” component to them.  While it is easy to make high level changes to Excel, understanding what the real impact of these changes are, is simply not possible.  Consider a typical S&OP decision…what-if we were to add a promotion for this product line? A simple question, but a complex answer.  Sure, you can change the forecast quantities in Excel, and that can show change to revenue.  But what-if the product line is constrained?  What is the purchasing spend going to be to support this?  A simple Excel model simply cannot support this level of granularity.
  • Excel doesn’t support alerts or lend itself to managing by exception.  Once your S&OP plan is set, you need to monitor performance against it.  Sure, you can see how you’ve performed at the next S&OP meeting, but isn’t that too late?

I’ve gone into some details about how Excel is not the right tool for S&OP (and other things) in other posts, if you are interested, you can find them here; Is Excel the right tool for S&OP How are spreadsheets like cockroaches The endless debate: Is S&OP about technology When spreadsheets go bad So, if Excel is not the right tool for S&OP, what is?  Rather than call out a specific tool, let’s look at some criteria that you need to consider when looking for an S&OP application:

  • I mentioned that Excel is not a good tool for S&OP is because it doesn’t support “what-if” analysis.  This is obviously something you need to look for in any tool for long range planning.  But simply allowing you to hive off a version of the plan and make a change is not enough.  The “what-if” analysis must provide detailed analysis as to what the impact of a given change will be throughout the supply chain.  A key supplier of low level components was just hit by a flood and won’t be shipping parts for six months – what impact will this have on my production?  What-if demand increases on one of my product lines?  What impact does this have on a constrained resource?... on my contract manufacturers?... on my suppliers?  Only a system with full supply chain analytics can address these questions.
  • A related requirement is integration.  If you are going to provide answers to the “what-if” questions above, you will likely need to have detailed information from multiple manufacturing centers around the world. These centers in all likelihood are running a variety of disparate ERP systems, so your tool will need to integrate across all these systems and bring the data in to a single environment.
  • As mentioned earlier, the ability to monitor performance against the plan and report on exceptions is key.  A S&OP plan is good.  A S&OP plan that you monitor and react to when underperforming is truly powerful.

There are several other factors that can play into your selection of a system for S&OP, but I think these are key ones.   What tools are you using for S&OP planning?  Are you evaluating new tools?  What factors are you considering?  Comment back and let us know!

Enhanced by Zemanta

Leave a Reply