Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Supply Chain Network Design with Excel
Course Overview
Course Overview
SCA101: Fundamentals of Supply Chain Network Design
Introduction to Supply Chain Network Design (9:14)
Understanding Trade-offs in Supply Chain Network Design (7:21)
Factors affecting Supply Chain Network Design (2:49)
Understanding and Evaluating Supply Chain Design Options (8:46)
Case Study: The Evolution of Amazon's Distribution Network (7:15)
Fundamentals of Supply Chain Network Design Quiz
SCA102: Fundamentals of Supply Chain Modeling
Section Overview
Introduction to Supply Chain Modeling (4:50)
Introduction to Optimization Modeling (7:50)
Loading Excel Solver
Building and Solving a Basic Supply Chain Model in Excel (7:02)
Calculating Distance between Two Locations (3:19)
Fundamentals of Supply Chain Modeling Quiz
SCA103: Designing Optimal Supply Chain Network - I
Section Overview
Understanding Facility Location Decisions (8:43)
Greenfield Analysis - Locating a Single Facility in Supply Chain (8:29)
Greenfield Analysis - Locating Multiple Facilities in Supply Chain (6:25)
Choosing Facilities from a Set of Potential Locations (7:45)
Understanding Capacity Allocation in Network Design (6:57)
Capacity Allocation: Determining Size of Facilities (5:52)
Understanding Demand and Supply Allocation in Network Design (3:05)
Allocating Demand and Supply in Network Design (7:49)
Modeling Assignment I
SCA104: Designing Optimal Supply Chain Network - II
Section Overview
Determining Optimal Number of Facilities (3:19)
Introducing Service Component in Network Design (4:08)
Introducing Green Component in Network Design (5:36)
Transportation Decisions in Network Design (6:32)
Modeling Assignment II
SCA105: Advanced Supply Chain Modeling Strategies
Section Overview
Introduction (2:43)
Applying 80-20 Rule in Modeling (4:22)
Aggregation in Modeling (4:13)
Baselines and Scenarios (4:41)
Infeasibility Analysis (7:35)
Advanced Supply Chain Modeling Strategies Quiz
SCA106: Real Life Supply Chain Network Design Project
Section Overview
Project Background (2:49)
Initial Project Discussion (5:07)
Understanding the Data (5:11)
Planning the Model (4:35)
Preparing the Data (11:30)
Downloading and Loading Open Solver (3:04)
Building the Baseline (14:11)
Running Scenarios (11:18)
Analyzing the Results (10:38)
Wrap Up
Challenges associated with Network Design Projects (6:09)
Supply Chain Network Optimization Tools (2:56)
Wrap Up (2:09)
Supply Chain Network Design Terminologies CheatSheet
Greenfield Analysis - Locating Multiple Facilities in Supply Chain
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock