Results 1 to 3 of 3

Thread: Transportation problem, linear programming and Solver

  1. #1

    Transportation problem, linear programming and Solver

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am working on a transportation model in which I have to choose the best location for a new factory that minimizes transportation costs with 3 warehouses. I currently have 2 factories, and I want to choose the location for a third factory between 3 alternatives.

    I have been able to solve this problem by analyzing each of the 3 possible locations separately (therefore, creating linear programming models with the 2 old factories + a new one), and then comparing the minimum costs that I would incur in each of these three cases.

    I've been trying to integrate these three steps into one, so that I would have to run Solver only one time and it would give me the best possible location among the 3 choices, but so far I've been unsuccessful. Would it be possible to achieve this in one step?

    And more specifically, could I achieve it while still keeping it as a linear programming problem?

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Crossposted. Please provide links to all other sites you have posted the question in.

    Why you are being asked:

  3. #3
    Sorry about that. Here are the links.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts