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.
Posted on Format Video