Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

# Excel Supply Chain Analysis: Solving Transportation Problems

## Overview

Learn how to use Microsoft Excel to conceptualize, set up, and solve transportation problems in order to minimize costs in a supply chain.

Microsoft Excel can be a secret advantage when it comes to solving complex supply chain challenges. Follow along with instructor Curt Frye as he shows how to use the Excel Solver add-in to minimize transportation and transshipment costs within a supply chain. Curt covers a range of topics, including how to analyze fixed costs and facility opening decisions, enforce level of service constraints, and perform scenario analysis. He also provides problem scenarios for you to solve, then goes through the solutions for each. After watching this course and working through the examples, you'll be able to describe the techniques specialized supply chain programs use to arrive at their results.

## Syllabus

Introduction
• Solve supply chain transportation problems with Excel
• What you should know
1. Solving a Transportation Problem
• Describe the transportation problem
• Outline a transportation model in Excel
• Define decision variables, constraints, and total cost
• Create and run the Solver model
2. Solving a Transshipment Problem
• 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
3. Analyzing Fixed Costs and Facility Opening Decisions
• 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
4. Enforcing Level of Service Constraints
• Describe level of service constraints
• Outline level of service constraint analysis in Excel
• Calculate level of service metrics
• Create and run the Solver model
5. Practicing Transportation Problem Analysis
• 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
Conclusion
• Next steps

Curt Frye

## Reviews

Start your review of Excel Supply Chain Analysis: Solving Transportation Problems

### Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.