From the course: Excel Supply Chain Analysis: Solving Transportation Problems
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Evaluate a Solver solution - Microsoft Excel Tutorial
From the course: Excel Supply Chain Analysis: Solving Transportation Problems
Evaluate a Solver solution
- [Instructor] In the previous movie, we completed a solver model for a transshipment problem, which was an extension of the transportation problem that we solved in chapter one. It's tempting to look at the numbers in the spreadsheet and accept them as the truth, but you must also use your judgment to determine whether the solution makes business sense. We'll take a look at such a scenario in this movie. The first sample file that I'll open is 02 05 transshipment, and you can find it in the chapter two folder of the exercise files collection. This is the result of our work from earlier in the chapter, and if I scroll down, we can see that the total cost here in cell C 37 is $162,413. The outbound cost from our distribution centers in Amarillo, Kansas City, and Tulsa is 85,445. And if you recall, that's exactly the outbound cost from our transportation problem in chapter one. So all we've done is add cost by moving our…
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.