Excel Supply Chain Analysis: Solving Procurement Problems’ cover photo
Excel Supply Chain Analysis: Solving Procurement Problems

Excel Supply Chain Analysis: Solving Procurement Problems

Transportation, Logistics, Supply Chain and Storage

Master advanced Excel skills to solve procurement challenges, optimize processes, and enhance supplier relationships.

About us

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.

Industry
Transportation, Logistics, Supply Chain and Storage
Company size
2-10 employees
Specialties
Supply Chain, Procurement, Excel, and Business Analysis

Updates

Affiliated pages

Similar pages