I am trying to use excel solver Simplex LP to find the maximum value of 3 cells. It is an assignment problem where I will have 3 results, which is the time each machine spends to produce the goods. I will need to minimize the makespan, thus i will have to minimize the largest value of the 3. I used the MAX function but it is not linear and continuous. Is there any way i can represent that info such that I can use Simplex LP?
Screenshot_1.png
Screenshot_2.png
Bookmarks