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.
Implement linking constraints in Excel - Microsoft Excel Tutorial
From the course: Excel Supply Chain Analysis: Solving Transportation Problems
Implement linking constraints in Excel
- [Instructor] Linking constraints let you require a solver model to pay the cost of opening a facility if any products flow through it. If a facility has been open, it can't be part of the solution. In this movie, I will show you how to add linking constraints to your transportation model. My sample file is 03 03 linking, and you can find it in the chapter three folder of the exercise files collection. In this workbook, I have a worksheet model or at least the start of one, where I have demand information and then also distribution center capacities. I have rearrange the distribution center capacity data and you can see here that I have their capacities, and any two of the distribution centers, each of which has a capacity of 1700 could fulfill the demand of 3325, which is the total demand for all of our wind firms. If we decide to use the distribution center, we must pay the associated fixed cost. Below that I have…
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.