Supply Chain and Spend Analysis


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 decision-making 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 day-to-day 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:

  1. Lack of expertise and ability among existing staff to access, organize and analyze spend data for sustainable use.
  2. Lack of consistent approach and source to get the real-time spend information from a procurement system.
  3. 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 in-depth version of spend data capabilities not just the spend surface.
  • Access all spends data within all business units and outside e-procurement 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.

About Austine Jarome
A highly experienced and ethical procurement / purchasing Executive with extensive team leadership skills and ability to manage procurement within multi million dollar organisations. Providing high-level and innovative procurement / purchasing development strategies and cost saving improvement initiatives to build consistently improved business performances.

74 Responses to Supply Chain and Spend Analysis

  1. Alice Doyle says:

    Enjoyed your article. Please send Excel spreadsheets. Thank you.

  2. Senthil says:

    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

  3. Enjoyed your article. Please send Excel spreadsheets. Thank you.

  4. Ian Goldberg says:

    Enjoyed your article. Please send Excel spreadsheets. Thank you

  5. Giovanna says:

    Hi again,

    Could you e-mail these templetes as well, they seem really interesting.

    Thank you
    Giovanna

  6. Lagnajit Patnaik says:

    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

  7. Ian Goldberg says:

    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

  8. Karen Pearson says:

    Hi,

    Could you e-mail these templetes as well, they seem really interesting.
    kkyander@yahoo.com

    Regards,
    Karen

  9. Nick L says:

    Great article. Can you also share excel spreadsheets/tools with me. email is nrlew27car@hotmail.com

  10. Josh Weston says:

    Hi,

    Could you e-mail these templates to me, as well? They look to be well done.

    joshweston_02@hotmail.com

  11. Joseph Bilik says:

    Hello Austine, please do forward me your excel spend analysis templates. I appreciate your insight!
    bilikjoseph@hotmail.com
    Thanks
    Joseph

  12. Lucy Jenkins says:

    Me too please : tmb2kuk@yahoo.co.uk

  13. GG says:

    Hi, how can i download you example files?

  14. admin says:

    Could you e-mail these templates to me?

  15. Rohan says:

    can you please please mail these template to rohan.pattnaik@gmail.com

  16. Wishes for a Happy new year. Great article. Can you also share excel spreadsheets/tools with me. email is E.Tzelepis@deddie.gr

  17. Sam says:

    Awesome work. Can you also share excel spreadsheets/tools with me. My email is nisargvpatel@gmail.com

  18. T Bates says:

    Fantastic! please could i also request templates;

  19. David Hill says:

    I am in the process of doing an evaluation. Can you olease provide me with a copy of your template?

  20. David Hill says:

    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

  21. Lensa says:

    Would love to see your spreadsheet as well. My e-mail address is lensa.h.feyissa-rozelle@centurylink.com. Thank you!

  22. aamir says:

    hi its really great screen shorts.. great effort. and very well written article.. can you please send me the tool at aamirkhalil@gmail.com

  23. admin says:

    Can you please send to admin@stavnem.com

  24. Amit says:

    please send excel sheet to : amit_nz@hotmail.com

  25. Prafulla Ranjan says:

    Sir, Could you send the tool to prafulno1@hotmail.com

  26. rahul says:

    Would love to see your spreadsheet. My e-
    mail id is rahulmmore25@gmail.com

  27. Lagnajit Patnaik says:

    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

  28. J. Senthil says:

    Dear Austin,
    Valuable article and please share me the Tool if you would like to, if yes, much appreciated. My e-mail ID is senthil_j@hotmail.co.uk
    Thanks n Regards,
    Senthil, Gulf Energy LLC, oman.

  29. admin says:

    Could you please send to: admin@stavnem.com

  30. 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.

  31. yogesh says:

    Hi, Excellent article.., Could you please send excel data(tools & File) to yogeshdbhondekar@gmail.com.

  32. Filipe Maio says:

    Hi,

    Could you e-mail these templetes as well, they seem really interesting.
    filipepmaio@gmail.com

    Regards,
    Filipe

  33. Will you please share excell sheets on my e mail address “dilip.kulkarni@mrcindia.com”

  34. Vince says:

    Please please could you share the tools with me.

  35. cmbote says:

    Hi could you please send template to cmbote@carolina.rr.com. Thanks

  36. Jono says:

    Enjoyed your article. Can you send me the excel spreadsheet, as it would assist me greatly

  37. andivasile says:

    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

  38. Susan Stephenson says:

    Just found your article and would be interested in receiving your templates. Please forward to sstephenson@artcobell.com Thank you!

  39. Kishor says:

    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

  40. RF says:

    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

  41. admin says:

    Please forward to admin@stavnem.com

  42. Thank you for your interesting post. Could you please forward the excel data to vinhthien19292@gmail.com. Many thanks again!

  43. Gejo Thomas says:

    Enjoyed your article..

    please send the excel sheet to gejothomas@gmail.com

  44. Anthony says:

    Hi there (everyone), if these support tools are current with anyone I would appreciate the sharing of this excel data-sheet at obsedian_hawk@yahoo.co.uk

  45. Mano says:

    Hi, would you pl share the excel file to manoranjithp@gmail.com
    Appreciate it

  46. sigrid joseph says:

    Hi this tool would be very helpful to me. Please send the excel spreadsheets. Thanks!

  47. Tareq says:

    Thank you , can you share the excel sheet with me tareqmasri@gmail.com

  48. Santosh says:

    Superb…. If you could pls share the excel sheet to my mail ID. santoshmech@gmail.com

  49. Jerry says:

    Hi, a very nice tool, please share to kokojerry@hotmail.com

  50. Interesting article.
    Kindly forward the excel example to mann192003@gmail.com

  51. Rajiv Chatterjee says:

    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

  52. Esther says:

    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?

  53. Nasir says:

    Thanks a lot for sharing the article. Pls send the spreadsheet to my email at

  54. Nasir says:

    Thanks a lot for sharing the article. Pls send the spreadsheet to my email at nasiruddin26@gmail.com

  55. Durlabh Johri says:

    Hi this tool is fantastic. Please send the excel spreadsheets for learning purpose only. Thanks!

  56. Faisal Jalal says:

    Hi, can you please share the Excel Templates. my email is faisaljalal@hotmail.com

  57. Ali says:

    Excellent article.., Could you please send excel to imaliuddin@gmail.com

  58. Peter says:

    Hey awesome job.

    Please I would like to get this as a basis to improve.

    Plz forward the .xls @ johansen.peter@mail.ru

    Regards

  59. Tim says:

    Echoing the above requests for spreadsheets – Thank you for doing this!

    gimmealoner@gmail.com

  60. Wouter says:

    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

  61. A. Samy says:

    I would appreciate if you can share those templates with me.

    Many thanks

  62. Neelesh says:

    Looks very interesting, can you please send the templet to neelesh.shanbhag@gmail.com

  63. Vik says:

    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

  64. Vijay says:

    thank you for sharing this. Very comprehensive. Would it be possible to have copies of the excel spreadsheets? can you email vijaysewkaransing@hotmail.com

  65. Prafulla Ranjan says:

    Thanks for sharing this. Would you please send excel spreadsheets? e-mail :prafulno1@hotmail.com

  66. Jyotirmoy Sahoo says:

    Hi- Interesting article
    It would really help if you can share the excel spreadsheets and tools if any
    email: jyotirmoy.sahoo@gmail.com

  67. MAtt says:

    the screenshot makes sense for ground level of analysis. Can you send the template

  68. Ebie says:

    Thanks for sharing this. Would you please send excel spreadsheets? e-mail bharebr@hotmail.com

  69. Nathan says:

    Hi there,

    Really liked your article, could please email the excel template to nahinibrahim@gmail.com

  70. susi says:

    thank you for sharing this. could you please send it to me? very much appreciated! tania.susi@gmail.com

  71. Reblogged this on Lovecchioconsulting's Blog and commented:
    Great! is it possible to get a cpy at info@lovecchioconsulting.it ?

    Thanks
    Giuseppe

  72. Great! Is it possible to get a copy at info@lovecchioconsulting.it ?
    Many thanks
    Giuseppe

  73. Alex Norman says:

    Thanks for the article, please can you email the spreadsheets to alexdavidnorman@googlemail.com? you’re work is much appreciated

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: