Recent Posts
- Train the Trainer: A Review of the CPSM Instructor Program
- Health Care in Your Work Space
- Companies cope with the high cost of gas
- Body Language: A Dialect All Its Own?
- Is 5S Implementation Truly Worth the Effort?
- SWOT or SWOTT Analysis
- Every Team Needs a Leader
- Service and Leadership
- Home Again!
- Book Learning
Recent Comments
- Mary on Train the Trainer: A Review of the CPSM Instructor Program
- Eric on Train the Trainer: A Review of the CPSM Instructor Program
- mew on Every Team Needs a Leader
- Erik O'Grady on Every Team Needs a Leader
- AZReam on Health Care in Your Work Space
Most Commented On
- Certificate or Certification? (16)
- Who does what? A Look at Procurement's Role in the Supply Chain (9)
- Generation Gap: Go Easy on the Millennial Group (4)
- The Bored Employee (4)
- Who Am I? Read my card! (4)
Archives
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
Blog
Review: The ABCs of Spend Analysis Bring the data together
May 21, 2007
Let's now look at the B section of Purchasing's ABCs of Spend Analysis report.‘A’ section told us how important it is to have the skills to get to B, bringing it together.It is kinda like the monopoly game, you must pass A to get to B.
Charles Dominick with Next Level Purchasing has a great definition of Spend Analysis.“Spend Analysis is the systematic review of historical purchase data.The output of a spend analysis is a summary of purchases by various variables, such as category, supplier, and/or business units.”
In the ABCs article it states in implementing a spend analysis, the very first steps are getting support, deciding what data you need, then finding it.The process known as ETL – extract, transform, and load – pulling data together and cleaning it up.
High level support is a must on a spend analysis program.Without support you may run in to resistance from system administrators, financial staff or even other buyers. Due to cut backs in the last few years, overload of work on the remaining staff, employees lack the time to assist unless it is spelled out that they are to work on a program.It is not always because they do not want to help; it is a time and demand problem.Most supply management jobs require prioritizing duties.
Chris Haydon states in the article “you should start with the end in mind, map that territory and think of how the data needs to mesh together.Determine how often you want to pull the data.”
You need to know your purpose in order to determine your needs.
Posted by Mary Walker on May 21, 2007 | Comments (0)