Optimization using Excel – 21.Job sequencing model using Evolutionary solver

Optimization using Excel
Lecture 21
Soumitra Chakraborty
Play Video

In this video, I have solved a non-smooth job sequencing non-linear problem using the Evolutionary solver in Excel. I have also explained the GRG solver is not very helpful in this context. Before solving the problem, I have explained the INDEX function operation and the all DIFFERENT constraint in Excel. The objective was to minimize the average tardiness for the jobs. The concepts of tardiness and lateness were also explained in this video.