Originally Posted by
p45cal
Realise, that I know less about the problem than you do; What needs to be taken into account when optimising? Which sheet(s) should I be looking at?
I don't know how to do that. You'd better tell.
I've used Solver only a couple of times; I'm not overly familiar with it - however, it shouldn't be too difficult to get my head round.
Will it be allowed to reject orders altogether? Can a job be split among several plants? Or is it just a question of re-assigning plants to jobs?
…nor am I!
Your userform did all 4 mileage calculations, couldn't it be made to transfer them all to the sheet?
I see some rows in the sheet Week2Optimizied have 'Not Optimal' even though some values show a profit (rows 9 and 33)??
All in all I need a lot more info. My time is going to be more limited this coming week.