Deliver2You: Product Logistics And Distribution Using Excel
A work-along version of the spreadsheet can be found here:
In this video I walk you though how to set up and solve a logistics problem in Microsoft Excel using the Solver Add-In. The goal is to utilize the firm’s shipping lanes in a manner that minimizes shipping costs while meeting warehouse demand. However, the shipping arcs in this problem carry capacity constraints. Some product ships direct and some product passes through a distribution center. It will be out job to meet those constraints at the lowest possible cost.
This problem comes from the book “Introduction to Management Science 3/e” by Hiller and Hiller. For my complete video library organized by playlist, please go to my video page here: