How to Setup & Solve Linear Programming Transportation Problems with Excel Solver

Please login in order to report media.

  • Uploaded 9 months ago in the category How to programming

    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.

  • howsetup&solvelinearprogrammingtransportationproblemsexcelsolver