+ Reply to Thread
Results 1 to 2 of 2

Transportation Time Problem for Solver Add-In

  1. #1
    Registered User
    Join Date
    09-26-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    17

    Transportation Time Problem for Solver Add-In

    I have a fairly straightforward problem but have limited experience with Solver and not enough time to research and learn myself. Hoping someone can help. This is the problem: I have 700 patients that need to be evacuated from a city. I need to calculate how many ambulances it will take to evacuate all 700 within 96 hours. Here is the problem, 420 of them are going to one city and 280 are going to another city. I have the total, round trip transportation time for each destination. A simple solution is to simply calculate how many ambulances it would take to do the job to each destination within the 96 hours however there would be overlap and so I know that there is probably a more efficient solution. Any help would be greatly appreciated.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Transportation Time Problem for Solver Add-In

    Interesting homework. Had a go at it testing the Simplex-LP but had to do two runs to get the most optimal solution.

    First run I minimized number of ambulances
    LP_1.jpg

    then I changed the model a bit to minimize number of runs
    LP_2.jpg

    As solver complained and not finding a solution if I tried to change both parameters in one go I also tested the evolutionary solver but solution was not as good even if it was close.
    evo_sol.jpg

    Well it could be I did not find the right setup for this model. Perhaps another forum member may do better?

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Transportation problem using Excel Solver
    By ahmedtaher900 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2017, 02:32 AM
  2. Replies: 7
    Last Post: 12-31-2016, 12:29 PM
  3. Solver, Transportation problem with empty runs
    By bl4cki in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2016, 07:05 PM
  4. Solver, Transportation problem with empty runs
    By bl4cki in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2016, 03:18 PM
  5. Best solution for transportation problem
    By Marco André in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-23-2015, 01:31 PM
  6. Help with solver - reverse combinatorial problem / transportation optimization scenario
    By jon_nxt2000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-30-2014, 07:25 PM
  7. Transportation model, linear programming and Solver
    By GregDP in forum Excel General
    Replies: 6
    Last Post: 12-07-2013, 04:56 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1