From the course: Excel Supply Chain Analysis: Solving Transportation Problems

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Analyze a transshipment problem

Solution: Analyze a transshipment problem - Microsoft Excel Tutorial

From the course: Excel Supply Chain Analysis: Solving Transportation Problems

Start my 1-month free trial

Solution: Analyze a transshipment problem

“

(upbeat music) - [Instructor] In the previous movie, I described a transshipment problem and invited you to solve it. In this movie, I will show you how I would build a worksheet and solver model to minimize transportation costs in the transshipment scenario that I provided. my sample file is 05_04_Transshipment, and you can find it in the chapter five folder of the exercise files collection. I've already described transshipment problems in general in chapter two. So I'll go ahead and start solving here. In a transshipment problem where there are three layers with an origination and then something in the middle, like a distribution center, which then sends items on to customers, we will have inbound transport and outbound transport. So I'll scroll down. And I see that I have my inbound distance matrix, which I can use as the base for inbound transport. So I'll select cells B16 through E19, press Control C to copy,…

Contents