From the course: Excel Supply Chain Analysis: Solving Transportation Problems
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Outline a transportation model in Excel - Microsoft Excel Tutorial
From the course: Excel Supply Chain Analysis: Solving Transportation Problems
Outline a transportation model in Excel
- [Instructor] When you analyze a transportation problem, you must take the data and information you're given and set it up in an Excel worksheet. In this movie, I will show you one way to outline a transportation problem. My sample files, 01 02 outline, and you can find it in the chapter one folder of the exercise files collection. In this problem, we have items moving from a series of distribution centers to wind firms in various cities. At the left, in columns B, C and D. We have information about our wind firms, the destination for our wind firm replacement parts, and you also see the demand in addition to the city and state. To the right, we have our distribution centers and their associated capacities. Also note that we have total capacity and total demand. So total capacity for the distribution centers is at least as big as, that is greater than or equal to, the demand. If we had less capacity than demand,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.