Supply Chain and Spend Analysis
November 22, 2010 74 Comments
Hello There,
This time, I thought I should give a bit of my thought about how we can use excel in spend analysis
It might have already discussed in business meetings that sourcing Strategy, Category expertise, negotiation methodology, managing supplier relation and procurement execution are all critical components of a highly effective Supply Chain Management initiative and the beginning of these all process starts with spend analysis, so it is the prime tool.
Spend Analysis should be a hot subject of discussion in any Supply Chain Organization because of the importance it has in a decisionmaking process. Take an example of the hospitality industry; spend analysis plays a prominent role in the procurement function because of the ability a spend analysis report has in helping to understand and to clearly establish expenditure patterns throughout the organization which will eventually enable the Supply Chain practitioners to accurately identify how much ($) is being spent, on what (Goods and Services), with whom (Suppliers), by whom (Business Unit) and how (Method of purchase) on a daily basis.
Also analyzing spends supports the daytoday food and beverage costing, or for a monthly menu engineering and event costing, just few of the benefits…
Defining and understanding scope of spend analysis is really become a mighty task these days because of non availability of cleansed, standardized data.
Besides the above mentioned issue related to quality data there are few more show stoppers the analysts are identified and they are:

Lack of expertise and ability among existing staff to access, organize and analyze spend data for sustainable use.

Lack of consistent approach and source to get the realtime spend information from a procurement system.

Failure of Top Management in linking the information and insight gained from spend analysis with the strategy and objectives of their organization
Faced with above said facts, the learning from industries around the globe concludes that, the most successful spend data analysis can be done in a more effective way considering the following:

Look into indepth version of spend data capabilities not just the spend surface.

Access all spends data within all business units and outside eprocurement group.

Adopt a common scientific classification Scheme of the spend category.

An efficient repeatable data cleansing and classification initiative has to do.

Augment category expertise to data and classification accuracy and validation.

Classify spending at a detailed level, possibly on subcategories and to products

Enhance core spend data with vital business projects.

Increase frequency and coverage of spending analysis.

Install and utilize advanced reporting and decision support tools not just spread sheet matrix techniques.

Continuously expand use and scope of spend data management program.
Despite the critical role spend data plays in supply chain management globally, except for some hospitality giants, most organization doesn’t have no formal procedures for managing and analyzing spend data, worse yet the doubt is few of the business units only examining spend data, sometimes the spend data in a hotels managed by single person has been neglected or totally ignored
Here comes the excel for rescue; I have attached few screen shots of various excel tools which I prepared to get this mighty task done. Please drop me a line so that I would be glad to share these tools.
Enjoyed your article. Please send Excel spreadsheets. Thank you.
Hi, can you please share the excel tools for spend analysis.
and also share documents if any for ‘End to End’ / ‘Step by Step’ spend analysis with an objective to indentify actionable items.
Regards,
Senthil
Enjoyed your article. Please send Excel spreadsheets. Thank you.
Enjoyed your article. Please send Excel spreadsheets. Thank you
Hi again,
Could you email these templetes as well, they seem really interesting.
Thank you
Giovanna
Hi,
Excellent article. Would really love to have a look at the spreadsheets.
Pls share them at lagnajit.patnaik@gmail.com
thanks and regards,
Lagnajit
SCM consultant, India
I am very interested in your excel tools that you are willing to share. I have recently started a new position and am implementing spend management. Your help would be greatly appreciated.
Regards,
Ian
Hi,
Could you email these templetes as well, they seem really interesting.
kkyander@yahoo.com
Regards,
Karen
Great article. Can you also share excel spreadsheets/tools with me. email is nrlew27car@hotmail.com
Hi,
Could you email these templates to me, as well? They look to be well done.
joshweston_02@hotmail.com
Hello Austine, please do forward me your excel spend analysis templates. I appreciate your insight!
bilikjoseph@hotmail.com
Thanks
Joseph
Me too please : tmb2kuk@yahoo.co.uk
Hi, how can i download you example files?
Could you email these templates to me?
can you please please mail these template to rohan.pattnaik@gmail.com
Wishes for a Happy new year. Great article. Can you also share excel spreadsheets/tools with me. email is E.Tzelepis@deddie.gr
Awesome work. Can you also share excel spreadsheets/tools with me. My email is nisargvpatel@gmail.com
Fantastic! please could i also request templates;
I am in the process of doing an evaluation. Can you olease provide me with a copy of your template?
I am very interested in receving any of your excel tools that you are willing to share. I have recently creating a strategic sourcing position that includes implementing spend management. Any help and/or guidance that you can provide would be greatly appreciated.
Email: david.hill@hhsc.state.tx.us
Would love to see your spreadsheet as well. My email address is lensa.h.feyissarozelle@centurylink.com. Thank you!
hi its really great screen shorts.. great effort. and very well written article.. can you please send me the tool at aamirkhalil@gmail.com
Can you please send to admin@stavnem.com
please send excel sheet to : amit_nz@hotmail.com
Sir, Could you send the tool to prafulno1@hotmail.com
Would love to see your spreadsheet. My e
mail id is rahulmmore25@gmail.com
Hi Austine,
Very well article and look forward to more insightful stuff.
Pls do share the spreadsheet used for your analysis.
My email id is lagnajit.patnaik@gmail.com
Look forward to your response.
Thanks and regards,
Lagnajit Patnaik, India, Business Consultant
Dear Austin,
Valuable article and please share me the Tool if you would like to, if yes, much appreciated. My email ID is senthil_j@hotmail.co.uk
Thanks n Regards,
Senthil, Gulf Energy LLC, oman.
Could you please send to: admin@stavnem.com
Hi Could you please forward the excel data to debjeet.swain@sjmsom.in . currently i am studying in IIT Bombay and i need you help to complete this project which is very vital. Thanks in anticipation.
Hi, Excellent article.., Could you please send excel data(tools & File) to yogeshdbhondekar@gmail.com.
Hi,
Could you email these templetes as well, they seem really interesting.
filipepmaio@gmail.com
Regards,
Filipe
Will you please share excell sheets on my e mail address “dilip.kulkarni@mrcindia.com”
Please please could you share the tools with me.
Hi could you please send template to cmbote@carolina.rr.com. Thanks
Enjoyed your article. Can you send me the excel spreadsheet, as it would assist me greatly
Hi ,
Very deep infos . I`m PM for an E&P Oil Co and I need a solution to build an Procurement Overview 2012 vs 2013 , I could not find the proper tool to run this calculation . If you can help me will be great , thank you .
andi.vasile@gmail.com
Sincerely ,
Andy
Just found your article and would be interested in receiving your templates. Please forward to sstephenson@artcobell.com Thank you!
hi, I work as buyer in medium size company and I have been given the task to analyze the data for purchasing, since I am basic user of excel I have no idea how to create any advance analysis. So can you please share your excel workbook kishoreready@gmail.com
Hi Could you please forward the excel data to cronique@msn.com
I have just started up as a buyer and such a tool would really support me in my new function.
Thank you
Please forward to admin@stavnem.com
Thank you for your interesting post. Could you please forward the excel data to vinhthien19292@gmail.com. Many thanks again!
Enjoyed your article..
please send the excel sheet to gejothomas@gmail.com
Hi there (everyone), if these support tools are current with anyone I would appreciate the sharing of this excel datasheet at obsedian_hawk@yahoo.co.uk
Hi, would you pl share the excel file to manoranjithp@gmail.com
Appreciate it
Hi this tool would be very helpful to me. Please send the excel spreadsheets. Thanks!
Thank you , can you share the excel sheet with me tareqmasri@gmail.com
Superb…. If you could pls share the excel sheet to my mail ID. santoshmech@gmail.com
Hi, a very nice tool, please share to kokojerry@hotmail.com
Interesting article.
Kindly forward the excel example to mann192003@gmail.com
Intrestred in the Spreadsheet, mail jgaviria@komprasbpo.com
Hi,
Would like to try out your excel. It will be really great if you can forward it to me at
rajiv.chatterjee@hotmail.com
thank you for sharing this. Very comprehensive. Would it be possible to have copies of the excel spreadsheets including the “Supply Chain and Performance Measurement using Microsoft Excel” please?
Thanks a lot for sharing the article. Pls send the spreadsheet to my email at
Thanks a lot for sharing the article. Pls send the spreadsheet to my email at nasiruddin26@gmail.com
Hi this tool is fantastic. Please send the excel spreadsheets for learning purpose only. Thanks!
Hi, can you please share the Excel Templates. my email is faisaljalal@hotmail.com
Excellent article.., Could you please send excel to imaliuddin@gmail.com
Hey awesome job.
Please I would like to get this as a basis to improve.
Plz forward the .xls @ johansen.peter@mail.ru
Regards
Echoing the above requests for spreadsheets – Thank you for doing this!
gimmealoner@gmail.com
I see this is an old post, but please could I ask for the excel files if this is still available, Thanks.
wouter.krugel@mweb.co.za
I would appreciate if you can share those templates with me.
Many thanks
Looks very interesting, can you please send the templet to neelesh.shanbhag@gmail.com
Hi!
It would be so interesting to look at your spend analysis Excel template. Could you please send it to me? Would be very much appreciated! camanteckningar@icloud.com
thank you for sharing this. Very comprehensive. Would it be possible to have copies of the excel spreadsheets? can you email vijaysewkaransing@hotmail.com
Thanks for sharing this. Would you please send excel spreadsheets? email :prafulno1@hotmail.com
Hi Interesting article
It would really help if you can share the excel spreadsheets and tools if any
email: jyotirmoy.sahoo@gmail.com
the screenshot makes sense for ground level of analysis. Can you send the template
Thanks for sharing this. Would you please send excel spreadsheets? email bharebr@hotmail.com
Hi there,
Really liked your article, could please email the excel template to nahinibrahim@gmail.com
thank you for sharing this. could you please send it to me? very much appreciated! tania.susi@gmail.com
Reblogged this on Lovecchioconsulting's Blog and commented:
Great! is it possible to get a cpy at info@lovecchioconsulting.it ?
Thanks
Giuseppe
Great! Is it possible to get a copy at info@lovecchioconsulting.it ?
Many thanks
Giuseppe
Thanks for the article, please can you email the spreadsheets to alexdavidnorman@googlemail.com? you’re work is much appreciated