课程: Excel Supply Chain Analysis: Solving Transportation Problems

今天就学习课程吧！

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

Solution: Analyze a transportation problem

Solution: Analyze a transportation problem - Microsoft Excel教程

课程: Excel Supply Chain Analysis: Solving Transportation Problems

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

Solution: Analyze a transportation problem

“

(upbeat music) - [Instructor] In the previous movie, I described a transportation problem and invited you to solve it. In this movie, I will show you how I would create a solver model to minimize transportation costs in the scenario I provided. My sample file is 05_02_transportation, and you can find it in the chapter five folder of the exercise files collection. As a reminder, we are looking at a transportation problem for Jenny's Biscuits, and Jenny needs to deliver her biscuits to various towns around Mount Crawford, Virginia. First, I know that I will need to have a grid that will indicate the number of units going from each bakery to each customer. So I will scroll down, and I will copy the grid that I have here for distances between locations and B16 to E26, having selected them, press control + C to copy. Then I'll go over to G16 and control + V to paste. I will change the values in the array to the right to one.…

内容