Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-29-2015, 02:39 PM
shg shg is offline Solver Transportation solution Windows 7 64bit Solver Transportation solution Office 2010 32bit
Advanced Beginner
 
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver Transportation solution Excel Solver Normie Excel 1 11-19-2015 09:57 AM
Solver Transportation solution How to set this out in Excel or solver 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft