Please login in order to report media.
Download the spreadsheet at the link above
Demonstration of model development and the optimal solution of a network transportation model, or transportation problem, with Excel Solver.
In this example, you would like to minimize the cost of shipping products to distribution points.
You are given the cost to ship products along each path in a network of origins to destinations.
You are also given forecast demand and production capacities.
Learn how to build the model in Excel and then set up and use solver to minimize the cost associated with meeting product demand.