need scenarios function to running MPS for production planning
 

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

need scenarios function to running MPS for production planning
 

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

need scenarios function to running MPS for production planning
 

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

need scenarios function to running MPS for production planning
 

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

"jl" wrote in message
...
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

need scenarios function to running MPS for production planning
 

Dear jl,

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

ll
jl wrote:
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