课程: Excel Supply Chain Analysis: Solving Transportation Problems

今天就学习课程吧！

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

Evaluate a Solver solution

Evaluate a Solver solution - Microsoft Excel教程

课程: Excel Supply Chain Analysis: Solving Transportation Problems

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

Evaluate a Solver solution

“

- [Instructor] In the previous movie, we completed a solver model for a transshipment problem, which was an extension of the transportation problem that we solved in chapter one. It's tempting to look at the numbers in the spreadsheet and accept them as the truth, but you must also use your judgment to determine whether the solution makes business sense. We'll take a look at such a scenario in this movie. The first sample file that I'll open is 02 05 transshipment, and you can find it in the chapter two folder of the exercise files collection. This is the result of our work from earlier in the chapter, and if I scroll down, we can see that the total cost here in cell C 37 is $162,413. The outbound cost from our distribution centers in Amarillo, Kansas City, and Tulsa is 85,445. And if you recall, that's exactly the outbound cost from our transportation problem in chapter one. So all we've done is add cost by moving our…

内容