hi ll,

Thanks ... do you have any ideas how does a solver works on my scenarios ...
Will highly appreciate if you could give me an example ... that will be
great...

--
jl


" wrote:

Dear jl,

Since you have many constraints, it's better use "solver" than "goal
seek" to your satisfaction.

Regards,
ll
jl wrote:
Example : week 5, customer ABC's requirement is 100,000 pcs of 1U, 30,000
pcs of 1T, 60,000 pcs of PP, 1,000 pcs of 2T and 1,000 pcs of 1C.

Under such scenarios, my company have 5 production lines as follows :-
Line 1 : only can run 1U and PP (total added up to 100%)
Line 2 : only can run 1U and PP (total added up to 100%)
Line 3 : only can run 1C, 1T and 2T (total added up to 100%)
Line 4 : only can run 1U and PP (total added up to 100%)
Line 5 : can run 1C, 1T, 2T, 1U and PP (total added up to 100%)

i tried Goal Seek in MS. Excel but it doesn't work with some many scenarios
at the same time ... so can anyone help to advice me a shortest way to get
this done ?

currently, i m manualling joggaling using excel spreadsheet ... it is very
time consuming ...

--
jl