Genetic algorithm for solving total weighted tardiness and sum of earliness and tardiness penalties of job-shop scheduling problem

This paper addresses a scheduling problem known in the job-shop industrial environment and recommends solving the problem using the Microsoft Excel spreadsheet and an add-in that provides Genetic Algorithm which is capable of solving complex scheduling problems. The authors selected total weighted tardiness and sum of earliness and tardiness penalties as performance measures to determine the quality of the solution. The contribution of this paper is the fact that it demonstrates to the practitioners involved in complex scheduling problems that Microsoft Excel, which is mostly used as spreadsheet software, with appropriate add-ins can be used to solve such complex scheduling problems. Moreover, the paper uses a job-shop benchmark instance available in the OR-Library with some modification to show the capability of the proposed approach.