Will Solver do the job?
Hi,
Solver is a fairly complex tool, you should take a look at the SOLVSAMP.XLS
file which is probably on your computer.
One point, Solver does not necessarily give you the best solution, it gives
you A solution which meets your criteria. That is, sometimes more than one
solution work but Solver only returns one, not the whole collection.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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?
|