Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Back round:
I have to come up with a liners optimization model for ten factories that can each produce one of three products. The stipulation is that only one product can be made at each factory and we need to reach minimum production units for all three products acroos all ten factories. Also there are a maximum number of a product units that can be produced at each factory. Each of the ten factories has differeing operation costs and profit margins so I am looking to maximize profits across the board. Problem. I have come up with all the formulas for all the constraints, but I cant seem to come up with at formula that says that at Factory 1 which can only produce a total of 100 units of either product A, B, and C. So that when you produce 100 units of A then your produce 0 of B and 0 of C. Or any combination Solver comes out with as being the one that maximizes profit across all ten factories. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to add-in solver without cd | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Solver | Excel Discussion (Misc queries) | |||
Solver help | Excel Worksheet Functions | |||
solver | Excel Discussion (Misc queries) |