Forum Discussion

James Walter Pflughaupt's avatar
James Walter Pflughaupt
Copper Contributor
Jun 18, 2018

Time Optimization

Hi all,

 

I am trying to optimize some data to find a minimum amount for downtime using the excel solver function.  I am creating a rotational program where 4 teams have to complete a series of tasks which have separate times required to complete.  There are also mandatory breaks so a minimum of total time cannot be found.  Is there some way to utilize the solver function to piece together the optimal schedule given the time constraints.

 

Thanks!

No RepliesBe the first to reply

Resources