By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data science anayst
    Growing Demand for Data Science & Data Analyst Roles
    6 Min Read
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Letter to Operations: no more spreadsheets for Purchasing
Share
Notification Show More
Latest News
ai in automotive industry
AI Is Changing the Automotive Industry Forever
Artificial Intelligence
SMEs Use AI-Driven Financial Software for Greater Efficiency
Artificial Intelligence
data security in big data age
6 Reasons to Boost Data Security Plan in the Age of Big Data
Big Data
data science anayst
Growing Demand for Data Science & Data Analyst Roles
Data Science
ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
Aa
SmartData Collective
Aa
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
Last updated: 2012/03/09 at 9:10 PM
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

data visualization for small business

Data Visualization Boosts Business Scalability with Sales Mapping

5 Best Practices for Extracting, Analyzing, and Visualizing Data
Strategies to Make Better Profits for CPAs During Tax Season
10 Important Ways Data Visualization Can Benefit Your Content Strategy
How to Bring Presentation Data to Life with Powered Template

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.

EphraimCohen March 9, 2012
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai in automotive industry
AI Is Changing the Automotive Industry Forever
Artificial Intelligence
SMEs Use AI-Driven Financial Software for Greater Efficiency
Artificial Intelligence
data security in big data age
6 Reasons to Boost Data Security Plan in the Age of Big Data
Big Data
data science anayst
Growing Demand for Data Science & Data Analyst Roles
Data Science

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

data visualization for small business
Data Visualization

Data Visualization Boosts Business Scalability with Sales Mapping

7 Min Read
big data visualization
Data Visualization

5 Best Practices for Extracting, Analyzing, and Visualizing Data

6 Min Read
big data and accounting
Business RulesData ManagementITSoftware

Strategies to Make Better Profits for CPAs During Tax Season

10 Min Read
Data Visualization
Data Visualization

10 Important Ways Data Visualization Can Benefit Your Content Strategy

13 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
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?