Choose the Best Supplier in Excel | Step-by-Step Case Study скачать в хорошем качестве

Choose the Best Supplier in Excel | Step-by-Step Case Study

Learn how to choose the best supplier using Excel, AHP, and TOPSIS in this complete step-by-step tutorial. This mini project shows how to build a real decision-making model in Excel to rank suppliers using practical Multi-Criteria Decision Making (MCDM) techniques. ☕ Welcome to MAX Optimization Lab! In this case study, we walk through a real-world supplier selection problem and apply structured methods — AHP for weighting criteria and TOPSIS for ranking suppliers — all inside Excel. You’ll learn how to: Build and normalize a decision matrix in Excel Use AHP to calculate weights for each criterion Apply TOPSIS to compute ideal solutions and distances Rank suppliers to find the best-performing vendor Understand why structured decision models outperform intuition Whether you’re in supply chain, procurement, industrial engineering, or business analytics, this tutorial gives you a practical, easy-to-follow method to make smarter purchasing decisions. 🔧 Key Skills Covered: AHP (Analytic Hierarchy Process) TOPSIS (Similarity to Ideal Solution) Decision matrix normalization Excel modeling and business analytics 🎓 Use Case: Logistics & Supplier Selection (AHP + TOPSIS) 📂 Download the materials: (Link added in comments) ⚙️ Subscribe to MAX Optimization Lab → Where we engineer smarter business decisions using AI, data, and optimization. ⏱ Chapters 00:00 Intro 01:24 The problem 03:30 Methodology 04:40 Excel Demo 05:47 AHP Matrix 09:45 TOPSIS Method 13:28 Final scores & discussion