课程: Excel Supply Chain Analysis: Solving Procurement Problems

免费学习该课程！

今天就开通帐号，24,600 门业界名师课程任您挑！

Perform a spend analysis

Perform a spend analysis

课程: Excel Supply Chain Analysis: Solving Procurement Problems

开始一个月试用 购买团队方案

Perform a spend analysis

“

- [Instructor] As a procurement professional, your job is to spend money on behalf of the company, but KinetEco needs to constantly evaluate whether its money is being spent well. Spend Analysis is a crucial process for understanding where and how your organization is spending its money. By analyzing our spending patterns, we can identify cost-savings opportunities, improve supplier relationships, and enhance overall financial efficiency. In this video, we'll guide you through the steps to conduct a Spend Analysis using Excel. First, we'll need to gather and organize our spending data. The key components that we'll want to work with include supplier names, categories, amounts, dates, and payment terms. If you have the Exercise Files, look for 03_03 Spend Analysis, otherwise, set up your Excel sheet to look like this. Now, let's use Excel's PivotTable feature to analyze our data. PivotTables are a powerful tool for summarizing and analyzing all kinds of data. Select your data range, A1…

内容