Solver Help I think

[Tony]

Allan,

I have prepared a working example for you. Although it is
basic it covers your needs and it will provide a useful
starter for you.
Can you provide your email address and I will send it
along later today.

Regards

Tony

-----Original Message-----
Hi
I have a list of 10 plants. Each plant has a different

incremental cost of production. In B1:B10 I have a
production rate, in C1:C10 I have the production cost per
unit (vlookup based on value in Col B) in D1:10 is the
production cost per plant. B11 is the Total production
rate and D11 is the total production cost. If I need to
increase production, how can I detemine the most
economical production rate for each plant while also
keeping the total production cost at a minimum. Can this
process be automated and assigned a button to calculate
production rates

 

[Guest]

allanj1161 At hotmail dot com

Allan,

I have prepared a working example for you. Although it is
basic it covers your needs and it will provide a useful
starter for you.
Can you provide your email address and I will send it
along later today.

Regards

Tony


incremental cost of production. In B1:B10 I have a
production rate, in C1:C10 I have the production cost per
unit (vlookup based on value in Col B) in D1:10 is the
production cost per plant. B11 is the Total production
rate and D11 is the total production cost. If I need to
increase production, how can I detemine the most
economical production rate for each plant while also
keeping the total production cost at a minimum. Can this
process be automated and assigned a button to calculate
production rates