Introduction | Supply Chain Modeler

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

Introduction

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock