Letter to Operations: no more spreadsheets for Purchasing

March 8, 2012
By guest blogger - Doug Potter

Editor’s Note: This article addresses supply chain issues in the form of a memo written to the operations management department.

Memorandum

To:      Operations Management

From:  Doug Potter

Re:      No more spreadsheets for Purchasing

Supply Chain management would be so much better off without spreadsheets. I see this over and over. Purchasing and operations management has a spreadsheet to tell them what and how much to reorder. And the spreadsheet has grown to a behemoth that takes constant care and feeding.

Don’t bother with cloud based supply chain planning systems, like MRP for manufacturers and DRP for distributors. People often tell me: “Our spreadsheet takes care of everything we need.”

That’s probably a true statement. As long as we can agree:

  1. You don’t need any higher profits
  2. You already programmed the spreadsheet with a complete set of supply chain best practices for purchasing and manufacturing planning.

But seriously, the biggest cost from spreadsheet-based supply chain planning is higher overhead. Related problems include:

  • Order Point versus MRP. A spreadsheet never rarely provides complete time-phased planning, usually it is just a device for enhanced order point, or min/max replenishment.
  • More Overhead. There’s tremendous overhead in the development and maintenance of the spreadsheet. Usually this shows up as time spent using, customizing, debugging, and maintaining it. One sign things are out of hand: someone on the staff decides they have to learn programming using Excel macros to help.
  • Lost Productivity. Inventing your own methods of replenishment and reordering is usually far less effective since you cannot really deliver all the money-saving features of a true MRP system (for example, try implementing “pegging” from a spreadsheet).
  • “Not Invented Here”. We humans have an innate problem. We tend to like things we made ourselves. (Ladies, if you think this is a male problem, I’m interested in your opinion – email me at dpotter (at) newportconsulting.com). So anyone associated with the development and invention of that spreadsheet will typically defend its use and block any attempts at best practices or real supply chain improvement.
  • Involve Everybody. Spreadsheets frequently live on a computer and are passed around via email. When more than one person needs access to the most current information. MRP systems (especially cloud based systems) allow multiple users and your entire organization to get real-time status regarding supply chain activities.
  • Not Scalable. As business volumes increase, the management of Excel as a planning device becomes exponentially more uncontrollable.

I suppose you could consider the Excel Spreadsheet an extension of the enterprise it management system. My counterargument: it’s an improper extension of the company enterprise software. There’s a much better solution, if you follow standard best practices in supply chain planning. These best practices should include Cloud ERP so you entire organization, your business partners, and other stakeholders can participate in supply chain planning.





About Newport Consulting Group
Newport Consulting was incorporated in 1989 as a spin-off of Price Waterhouse. Today the business has a large customer base that covers many industries including deep specialization in distribution, manufacturing, finance and accounting. Newport Consulting is a Microsoft Dynamics partner and software developer. Visit www.newportconsulting.com to learn more.

Tags: , , , ,

2 Responses to “ Letter to Operations: no more spreadsheets for Purchasing ”

  1. Fashion ERP Software Man on March 16, 2012 at 11:40 am

    Well set up ERP really is the way forward, managing spreadsheets only really works at very small scales. I think you’re better off moving to ERP before it’s a requirement. Last thing you need is to learn something new when you’re already bogged down.

  2. Brian on April 18, 2012 at 2:30 pm

    Great insights Doug, I completely agree. My co-workers and I publish discussions/news about Enterprise BPM, ERP’s, cloud computing, etc. that may be of interest as well: http://blog.apptricity.com/

Leave a Reply

*