If you are among the vast majority of purchasing pros, your enterprise wide software is notoriously weak in spend analytics and reporting capability. Unless you enjoy the horsepower of the giants in the enterprise software industry, or have one of the “Cadillac” purchasing software products, you are, like most of the rest of us, at the mercy of the enterprise software product.
Well, we resourceful purchasing pros are never without alternatives. While we cannot solve the software problem, we can solve the spend analytics and reporting by resort to an Excel spreadsheet.
Help is on the way in the form of a new online training course called Spend Analytics and Excel. This course is being developed jointly iwth the American Purchasing Society. It will not delve deeply into mathematics but will demonstrate in step by step fashion, including short tutorials for those “Excel averse” types, the purchasing analytics that will optimize your effectiveness.
We will show how to use Excel to analyze supplier responses to RFQs, to evaluate supplier performance, to project demand forecasting and replenishment models, even to analyze supplier financial health. You’ll learn shortcuts on sorting, presenting, and analyzing data so you can make sound decisions based upon user friendly dollars and numbers that you have created out of raw data.
We have researched the market demands and are customizing the content to meet these demands. The course will be available toward year end. in the meantime, contact me with any suggestions at RobertMenard@RobertMenard.com