Overview
-
Learn how to use Microsoft Excel to conceptualize, set up, and solve transportation problems in order to minimize costs in a supply chain.
Syllabus
-
Introduction
- Solve supply chain transportation problems with Excel
- What you should know
- Describe the transportation problem
- Outline a transportation model in Excel
- Define decision variables, constraints, and total cost
- Create and run the Solver model
- Describe the transshipment problem
- Outline a transshipment problem in Excel
- Define decision variables, constraints, and total cost
- Create and run the Solver model
- Evaluate a Solver solution
- Describe fixed cost and facility opening problems
- Outline a linking constraint problem in Excel
- Implement linking constraints in Excel
- Create and run the Solver model
- Describe level of service constraints
- Outline level of service constraint analysis in Excel
- Calculate level of service metrics
- Create and run the Solver model
- Challenge: Analyze a transportation problem
- Solution: Analyze a transportation problem
- Challenge: Analyze a transshipment problem
- Solution: Analyze a transshipment problem
- Challenge: Which distribution centers to open
- Solution: Which distribution centers to open
- Challenge: Level of service constraints problem
- Solution: Level of service constraints problem
- Next steps
