Job shop scheduling with Excel and SolverStudio
This workbook features a job shop model to find the optimal production plan. The objective is to minimize the makespan, i.e., the duration until all jobs are completed. The spreadsheet is populated with exemplary data to be replaced. The resulting schedule is visualized in a simple Gantt chart that is created with conditional formatting. To inspect the schedules for each job, sort first by start time and then by job, or, to inspect the schedules for each machine, sort first by start time and then by machine.