Product mix problem using excel .xls - Can anybody throw in some light?

[jlohit]

This is in regard to a Product Mix problem where i have 10 products with different profit margins . And these products go through a process of operations in a specific routing.

Processing : Line 1 - Line 3 belongs to plant A
Packaging : Packline7- Packline10 belongs to plant A

Processing : Line 4 - Line 6 Belongs to Plant B
Packaging : Packlline11- Packline14 belongs to Plant B

Constraints :
* If Pack7 is running , Pack10 cannot be used.
* If Pack11 is running - Packline13 cannot be used

*Each Product if started processing in PLant A should end in plant A ( the same plant)


HOw to formulate this kind of problems ?

[Craig H.]

I am afraid we need LOTS more information here. What is the processing sequence, for instance? How many units/hour are made/packed on each line?

Is this a school project?

[Jim Wynne]

Originally Posted by jlohit

This is in regard to a Product Mix problem where i have 10 products with different profit margins . And these products go through a process of operations in a specific routing.

Processing : Line 1 - Line 3 belongs to plant A
Packaging : Packline7- Packline10 belongs to plant A

Processing : Line 4 - Line 6 Belongs to Plant B
Packaging : Packlline11- Packline14 belongs to Plant B

Constraints :
* If Pack7 is running , Pack10 cannot be used.
* If Pack11 is running - Packline13 cannot be used

*Each Product if started processing in PLant A should end in plant A ( the same plant)


HOw to formulate this kind of problems ?

Craig is right, there doesn't appear to be enough information, unless the solution is just to run everything in Plant A, and sell Plant B.

[jlohit]

Thanks for the reply Marc. Ya..this is a school project. Will get you the sample excel file....soon.. Actually i have formed a mathametical model for this problem.....but dont know how far it will give me a proper solution.

Thanks Again Marc. i will mail you the excel sheet which i have formulted..your help is really helpful for me...

[Steve Prevette]

This sounds like it is likely a Linear Program. You can formulate Linear Programs in excel and solve them using the "solver" under the "tools" menu.

[Craig H.]

Originally Posted by Steve Prevette

This sounds like it is likely a Linear Program. You can formulate Linear Programs in excel and solve them using the "solver" under the "tools" menu.

It sure does, Steve. I like working with them but rarely get the chance. Hopefully we will get the file soon.