Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
    pexels pavel danilyuk 8112119
    Data Analytics Is Revolutionizing Medical Credentialing
    8 Min Read
    data and seo
    Maximize SEO Success with Powerful Data Analytics Insights
    8 Min Read
    data analytics for trademark registration
    Optimizing Trademark Registration with Data Analytics
    6 Min Read
    data analytics for finding zip codes
    Unlocking Zip Code Insights with Data Analytics
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Letter to Operations: no more spreadsheets for Purchasing
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Business Intelligence > Business Rules > Letter to Operations: no more spreadsheets for Purchasing
Business RulesData Visualization

Letter to Operations: no more spreadsheets for Purchasing

EphraimCohen
EphraimCohen
4 Min Read
SHARE

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

Doug Potter - Newport Consulting GroupMemorandum

To:      Operations Management

From:  Doug Potter

More Read

Online Business Model Innovation
Lookalike Audiences: How to Find and Engage Them Using Big Data
Dave Wells’ prescription for the incurious
Telling Your Story: How Data Visualization Can Propel Your Business
Dashboard Design and Delivery Worst Practices

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

Doug Potter - Newport Consulting GroupMemorandum

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.

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

accountant using ai
AI Improves Integrity in Corporate Accounting
Exclusive
ai and law enforcement
Forensic AI Technology is Doing Wonders for Law Enforcement
Artificial Intelligence Exclusive
langgraph and genai
LangGraph Orchestrator Agents: Streamlining AI Workflow Automation
Artificial Intelligence Exclusive
ai fitness app
Will AI Replace Personal Trainers? A Data-Driven Look at the Future of Fitness Careers
Artificial Intelligence Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Data Storytelling: More Immersive and Easier on the Brain

3 Min Read

Birthday Probabilities: Heat Map vs. R

2 Min Read
legal repercussion with big data
Big DataBusiness RulesData ManagementPolicy and Governance

New Legal And Ethical Challenges Of Big Data

7 Min Read

Challenges and Opportunities in Big Data From Industry and Academia Panel

5 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence
ai chatbot
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?