You could try using the IO add on program to do the optimization. It can accept almost any imaginable formula to establish the criteria. ( see the files section for IO)
Sid
Can anyone think of a way to optimise results for maximal cash-flow
each month rather than Gross Profit Made in a year? Is there a
mathematical formula I can use?