Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, I am new to this group and hope you can help me. I have a
problem that I am trying to solve. I am trying to use solver but not sure if I am setting up the model correctly. I have 4 workers Sam, Avery, Ben, and Steve and 4 different duties (Engine, Trans, Alignment, & Brakes) that the can be performed. Each person has a different average time(mins) to complete each task. I am trying to develop the formula to optimize who should do what to get the lowest amount of time. Engine Transmission Alignment Brakes Sam 45 34 23 45 Avery 48 30 36 37 Ben 30 48 40 41 Steve 38 34 30 31 Thoughts on the formula and contraints? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linear Programming via Excel Solver | Excel Discussion (Misc queries) | |||
Binary integer non-linear programming excel solver premium | Excel Worksheet Functions | |||
Binary integer non-linear programming excel solver | Excel Discussion (Misc queries) | |||
Binary integer non-linear programming excel solver | Excel Worksheet Functions | |||
Binary integer non-linear programming excel solver premium | Excel Worksheet Functions |