Excel Model

  • Thread starter Thread starter David324
  • Start date Start date
D

David324

I want to build a model to optimize production scheduling in a manufacturing
plant. I have two production lines that can run several products with varying
production rates, and profit/hour. These two lines pull raw material from the
same two sources that are limited in capacity so the combined production
rates must be optimized to avoid running out of raw material. There are 3-6
different products/production line that run for periods of a few hours to a
few days before changing products and the change is instantaneous. How can I
build an interactive model to allow me to schedule these two production lines
to maximize profit and manage the inventory of raw material?
 
David324 -

Maybe some of the Solver production management examples would be useful.

To see, browse to http://www.solver.com/procenter.htm and examine the
machine allocation examples.

- Mike
http://www.MikeMiddleton.com



I want to build a model to optimize production scheduling in a manufacturing
plant. I have two production lines that can run several products with
varying
production rates, and profit/hour. These two lines pull raw material from
the
same two sources that are limited in capacity so the combined production
rates must be optimized to avoid running out of raw material. There are 3-6
different products/production line that run for periods of a few hours to a
few days before changing products and the change is instantaneous. How can I
build an interactive model to allow me to schedule these two production
lines
to maximize profit and manage the inventory of raw material?
 
Back
Top