Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JL JL is offline
external usenet poster
 
Posts: 24
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JL JL is offline
external usenet poster
 
Posts: 24
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 762
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill Function to next Column shital shah Excel Worksheet Functions 0 August 16th 06 02:53 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
Need a ISWorkday Function -- Any Ideas Mark Excel Worksheet Functions 5 March 29th 05 01:58 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 03:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"