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

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solution: Analyze a transportation problem

Solution: Analyze a transportation problem - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

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

Contents