Linear Programming(solver ?)
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?
|