View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GD GD is offline
external usenet poster
 
Posts: 83
Default Will Solver do the job?

Not sure about solver as i've never used it but i use Whats Best! 9.0 for a
similar routing optimisation

"Mark" wrote:

Just a question.......Work related.

Basically my job involves scheduling deliveries to customers at various
sites from various distribution points. The drivers work for a set number of
hours on their shift.

Will Solver be the tool to build myself a spreadsheet where I can enter into
it delivery points, distribution points, time each delivery takes. And get
solver to provide me with the best distribution point for each customer and
also which deliveries a particular driver can make within his 12 hour day?