Excel Supply Chain Analysis: Solving Procurement Problems

This course provides procurement specialists with the advanced Excel techniques needed to solve common procurement problems, such as cost analysis, inventory management, and supplier risk management. Through hands-on exercises and real-world examples, instructor Daniel Stanton shows you how to master Excel tools to make data-driven decisions, optimize procurement processes, and enhance supplier relationships. The course is ideal for professionals seeking to improve cost management, streamline operations, and add strategic value to their organizations.

Learning objectives
Calculate total landed cost and total cost of ownership to make informed purchasing decisions.
Perform inventory management calculations such as economic order quantity, safety stock, and reorder points to optimize stock levels.
Use Excel to conduct demand forecasting, improving procurement accuracy.
Conduct a spend analysis and manage procurement budgets to identify cost-saving opportunities and ensure financial control.
Create and maintain a supplier risk register to proactively manage procurement-related risks.
Use Excel to compare supplier prices and make data-driven decisions to select the most cost-effective suppliers.
Implement contract management techniques using Excel to ensure compliance and optimize supplier relationships.
Utilize Excel tools to perform cost reduction analyses, supporting strategic procurement decisions.
Develop and manage a procurement budget in Excel to track performance and make adjustments as necessary.
Visualize procurement data through Excel charts and dashboards to enhance decision-making and communication with stakeholders.