课程: Excel Supply Chain Analysis: Solving Transportation Problems

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Solution: Analyze a transshipment problem

Solution: Analyze a transshipment problem - Microsoft Excel教程

课程: Excel Supply Chain Analysis: Solving Transportation Problems

开始一个月试用 购买团队方案

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,…

内容