课程: Excel Supply Chain Analysis: Solving Transportation Problems

今天就学习课程吧！

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

Create and run the Solver model

Create and run the Solver model - Microsoft Excel教程

课程: Excel Supply Chain Analysis: Solving Transportation Problems

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

Create and run the Solver model

“

- In the previous movie, we created summary formulas that Solver can use as part of its process to find the lowest cost solution for a transportation problem. In this movie, we will create and run the solver model based on current values. My sample file's 01_04_Solved, and you can find it in the chapter one folder of the exercise files collection. We're continuing the work that we did earlier in the chapter, but just as a quick review, we have demand information for eight wind farms and items are coming from a series of three distribution centers, which have the capacity listed there. I copied the capacity for the distribution centers from columns to rows to make it easier to work with it in combination with the outbound transport matrix that I have below. To calculate total cost, we are multiplying the distance of each route, so in this case Amarillo to Abilene is 270 miles, by the number of items moving on that route.…

内容