need scenarios function to running MPS for production planning

[jl]

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 ...

 

[joytickle]

Dear jl,

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

Regards,

 

[jl]

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...

 

[Mike Middleton]

jl -

Excel models for Machine Allocation problems are available at
http://www.solver.com/proframe.htm

Your problem statement is not complete. You need details of unit capacity
for each line, details of cost, etc.

- Mike
http://mikemiddleton.com

 

[joytickle]

Dear jl,

The office suite has a sample demonstrating how to use solver function.
Use the search "solvsamp.xls" in your computer.