Excel Supply Chain Analysis: Solving Transportation Problems

Focused View

Curt Frye

1:55:34

262 View

01 - Introduction

01 - Solve supply chain transportation problems with Excel.mp4

00:30

02 - What you should know.mp4

01:39

02 - Solving a Transportation Problem

01 - Describe the transportation problem.mp4

02:04

02 - Outline a transportation model in Excel.mp4

03:29

03 - Define decision variables, constraints, and total cost.mp4

03:19

04 - Create and run the Solver model.mp4

04:09

03 - Solving a Transshipment Problem

01 - Describe the transshipment problem.mp4

02:01

02 - Outline a transshipment problem in Excel.mp4

04:47

03 - Define decision variables, constraints, and total cost.mp4

07:37

04 - Create and run the Solver model.mp4

05:56

05 - Evaluate a Solver solution.mp4

04:03

04 - Analyzing Fixed Costs and Facility Opening Decisions

01 - Describe fixed cost and facility opening problems.mp4

02:21

02 - Outline a linking constraint problem in Excel.mp4

07:17

03 - Implement linking constraints in Excel.mp4

03:30

04 - Create and run the Solver model.mp4

05:26

05 - Enforcing Level of Service Constraints

01 - Describe level of service constraints.mp4

01:52

02 - Outline level of service constraint analysis in Excel.mp4

05:19

03 - Calculate level of service metrics.mp4

05:25

04 - Create and run the Solver model.mp4

05:31

06 - Practicing Transportation Problem Analysis

01 - Challenge Analyze a transportation problem.mp4

01:06

02 - Solution Analyze a transportation problem.mp4

06:11

03 - Challenge Analyze a transshipment problem.mp4

01:41

04 - Solution Analyze a transshipment problem.mp4

08:21

05 - Challenge Which distribution centers to open.mp4

01:44

06 - Solution Which distribution centers to open.mp4

08:54

07 - Challenge Level of service constraints problem.mp4

01:40

08 - Solution Level of service constraints problem.mp4

08:39

07 - Conclusion

01 - Next steps.mp4

01:03

Exercise Files

Ex_Files_Excel_Supply_Chain.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Problem Solving

Supply Chain

Excel

Curt Frye

Instructor's Courses

I'm president and founder of Technology and Society, Incorporated, an Oregon "C" Corporation that encompasses my work as a course developer, writer, and speaker. I offer programs on effective teamwork, personal development, and business storytelling. BA (political science) and MBA.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.