Enterprise System Spectator blog: ERP and enterprise system vendor evaluation, selection, and implementation.

The Enterprise System Spectator

Monday, November 15, 2004

Is Excel the poor man's i2?

Enrico Camerinelli from Meta Group wrote me this week with a hypothesis that's not going to sit well with the supply chain planning (SCP) vendors.

In the market for SCP software, it could be argued that the market leader is not i2, Manugistics, or SAP, but Microsoft Excel. Many companies never look at the leading SCP vendors, finding that it's much simpler, easier, and certainly less expensive to simply create an Excel model to plan short term production around one or two key constraints.

Enrico says that the advantages of using Excel are many:
  • Overall ease of use.

  • Allows the planner to use his knowledge and experience to create a model that is highly relevant and specific to the problem.

  • Allows the planner to quickly generate multiple scenarios.

  • Allows the planner to tweak the results if needed.

  • Allows the plan to be annotated to explain the results or provide clarification.

The downside, of course, is that an Excel model for supply chain planning is likely to be disconnected from backoffice systems, creating extra work to download or rekey data to the model and to import the results of the approved plan back into the production system.

So, what do you think? Do you think that using Excel is a viable alternative to buying a costly SCP system? Click on the comments link below and give your view. Or send me an e-mail.

Update, Nov. 19: Karthik Mani, a VP at i2, saw this post and wrote his own post regarding the advantages and disadvantages of Excel for supply chain planning. He writes,
Excel has its advantages. Some of them are
  1. Familiar interface. Planners use it every day.

  2. Desktop availability very similar to web, but planners can display a lot more data than can be provided in a standard web based tool.

  3. Very easy configurability for the end user - layout, pivots, filtering, graphs, logical functions, math functions.

  4. Very easy availability of skilled resources to help end users with more sophisticated changes to the engine.
But Excel based planning also has its big disadvantages
  1. In even medium sized enterprises, multiple people are responsible for coming up with the operational plans (demand plan, staffing plans, production plans, logistics plans etc.) and Excel based planning is very poor at synchronizing those plans.

  2. Excel models will be disconnected from the back office systems leading to painful keying in of master data.

  3. Enterprise has no control over assumptions and logic used in the planning process.

  4. Communication of metrics (this quarter we need to focus on revenues rather than market share and profitability, next quarter we need to focus on market share rather than profitability and revenue) is very tough.
Karthik thinks that the ideal approach is to marry the use of Excel with a best-in-class SCP solution. As an executive at i2, it's not surprising that this would be his view. But I think it does make a lot of sense. He continues,
The best in class SCM solutions have now moved to marry the advantages of both of these approaches. Here you have a central data and plan synchronization infrastructure. The front end exposed to the users is Microsoft Excel. Some of the light planning logic can be directly incorporated into the Excel sheet; all of the reasonably sophisticated calculations will reside in engines that will be available to the spreadsheets as web services.
Read Karthik's post on his weblog.

by Frank Scavo, 11/15/2004 07:02:00 AM | permalink | e-mail this!

 Reader Comments:

Dwight Shih e-mailed me with similar observations regarding financial analysis applications:

If you spend some time with Financial Analysis Software vendors, then I think that you'll find their toughest competition is existing excel spreadsheets in the hands of financial analysts. The counter argument is often not the accuracy of the spreadsheet, but rather the transparency, consistency and provenance of the spreadsheet:

1. Who developed the spreadsheet?
2. What assumptions are built into the spreadsheet?
3. Are the formulae used to evaluate B the same as those used by a colleague to evalulate A last week?
4. Did the analyst [intentionally or otherwise] tweak one of the underlying assumptions for this analysis?

I suspect that there is a market for an excel specific version control system. One that could open up the spreadsheet and highlight both formulaic and data differences. Then analysis could be tied to a specific version of a specific spreadsheet variant.

Posted at http://www.ideoplex.com/blog/2004/11/17.html#a1034
Here are some further thoughts on this topic in my blog.


Other areas beyond SCM seem to be thinking the same way. Dwight had alluded to this one in his comment.

Karthik Mani
Post a Comment

Links to this post:


Powered by Blogger

(c) 2002-2018, Frank Scavo.

Independent analysis of issues and trends in enterprise applications software and the strengths, weaknesses, advantages, and disadvantages of the vendors that provide them.

About the Enterprise System Spectator.

Frank Scavo Send tips, rumors, gossip, and feedback to Frank Scavo, at .

I'm interested in hearing about best practices, lessons learned, horror stories, and case studies of success or failure.

Selecting a new enterprise system can be a difficult decision. My consulting firm, Strativa, offers assistance that is independent and unbiased. For information on how we can help your organization make and carry out these decisions, write to me.

My IT research firm, Computer Economics provides metrics for IT management, such as IT spending and staffing benchmarks, technology adoption and investment trends, IT management best practices, IT salaries, outsourcing statistics, and more.

Go to latest postings

Search the Spectator!
Join over 1,700 subscribers on the Spectator email list!
Max. 1-2 times/month.
Easy one-click to unsubscribe anytime.

Follow me on Twitter
My RSS feed RSS News Feed

Computer Economics
Outsourcing Statistics
IT Spending and Staffing Benchmarks
IT Staffing Ratios
IT Management Best Practices
Worldwide Technology Trends
IT Salary Report


2014 Best Independent ERP Blog - Winner 2013 Best ERP Writer - Winner Constant Contact 2010 All Star Technobabble Top 100 Analyst Blogs

Key References
Strativa: Business strategy consulting, strategic planning
Strativa: IT strategy consulting
Strativa: Business process improvement, process mapping, consultants
Strativa: IT due diligence
Strativa: ERP software selection consulting and vendor evaluation
Strativa: CRM software selection consulting and vendor evaluation
Strativa: Project management consulting, change management
StreetWolf: Digital creative studio specializing in web, mobile and social applications
Enterprise IT News: diginomica

Spectator Archives
May 2002
June 2002
July 2002
August 2002
September 2002
October 2002
November 2002
December 2002
January 2003
February 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
July 2008
August 2008
September 2008
October 2008
November 2008
December 2008
January 2009
February 2009
March 2009
April 2009
May 2009
June 2009
July 2009
August 2009
September 2009
October 2009
November 2009
December 2009
January 2010
February 2010
March 2010
April 2010
June 2010
July 2010
August 2010
September 2010
October 2010
November 2010
December 2010
January 2011
February 2011
March 2011
April 2011
May 2011
July 2011
August 2011
September 2011
October 2011
November 2011
December 2011
January 2012
February 2012
March 2012
April 2012
May 2012
June 2012
July 2012
September 2012
October 2012
December 2012
January 2013
February 2013
March 2013
May 2013
June 2013
July 2013
September 2013
October 2013
December 2013
January 2014
February 2014
March 2014
April 2014
May 2014
June 2014
July 2014
August 2014
September 2014
October 2014
November 2014
December 2014
February 2015
March 2015
April 2015
May 2015
June 2015
July 2015
September 2015
October 2015
November 2015
February 2016
May 2016
June 2016
July 2016
August 2016
September 2016
October 2016
January 2017
February 2017
May 2017
June 2017
October 2017
January 2018
April 2018
May 2018
Latest postings