Hi,
I am trying to use Solver to get the minimum number of tables to be used while you have to distribute certain number of agents with 2 shifts and different starting and ending times into these tables. The desired system (Solver + VBA) should be able to distribute a given number of agents that can vary from test to test. I have made several trials with Solver with an example of 5 agents (file attached) but it seems not to be giving the minimum number and the distribution.
Thanks in advance.
Bookmarks