From the course: Excel Supply Chain Analysis: Solving Transportation Problems
Join today to access over 23,200 courses taught by industry experts.
Define decision variables, constraints, and total cost - Microsoft Excel Tutorial
From the course: Excel Supply Chain Analysis: Solving Transportation Problems
Define decision variables, constraints, and total cost
- [Instructor] In the previous movie, we outlined a transshipment problem in Excel. Now we can add our decision variables, constraints, and total cost equation. There's a lot to do. So let's get going. My sample file is 02_03_Summary, and you can find it in the Chapter02 folder, the Exercise Files collection. In this workbook, we have our Demand data, and also Capacity for our Distribution Centers and Factories and the distances between factories and distribution centers and Distribution Centers and wind farms at the cities listed under Outbound Distance. We also have arrays that we can use to change the number of units that are going to each individual distribution center for factories and then from distribution centers to customers. We need to calculate totals. So I will start by calculating the number of units that are going from Albuquerque out to other cities and the same for Fort Worth and Springfield. So I'll…
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.