| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver Help I think
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 Thanks! Allan . |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Solver Help I think
allanj1161 At hotmail dot com
"Tony" wrote: 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 Thanks! Allan . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using solver | Excel Worksheet Functions | |||
| Solver or Other? | Excel Worksheet Functions | |||
| I need to know how to use the solver | Excel Worksheet Functions | |||
| Solver Help | Excel Worksheet Functions | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Linear Mode
