![]() |
#2
|
|||
|
|||
![]()
Wow -- that seems like a hard problem to set up for Solver, or to model in code.
Start at whatever location the trailer camped for the night. Pick up some fraction of the deliverables for other locations, up to the available limit. Drive to the next location; drop off its deliverables and fill the truck. Rinse & repeat. In each step, you need to optimize both the pickups and the order of locations visited. Ignoring that you have a second trailer, it takes several circuits to complete the deliverables. You might take this the the operations research department of a good college. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Normie | Excel | 1 | 11-19-2015 09:57 AM |
![]() |
brisbaneguy4109 | Excel | 3 | 10-18-2015 11:12 PM |
Help with Solver Problem | myusername343 | Excel | 0 | 04-10-2014 10:09 AM |
Question on using solver | jcg | Excel | 0 | 12-13-2011 05:54 PM |
Ms word solver | DAREGOT | Word | 1 | 03-11-2010 11:52 PM |