Please design and develop a MS Excel tool to help decision makers in their scheduling problems. The proposed model should include such aspects;

• It should be a dynamic and generic model and users can decide on number of machines and jobs, setup durations, processing times, etc.
• It should automatically share possible make-span, number of tardy jobs and their relevant tardiness durations
• It should share GANTT Chart of the obtained solution.

Please design and develop a MS Excel tool to help decision makers in their scheduling problems. The proposed model should include such aspects; It should be a dynamic and generic model and users can decide on number of machines and jobs, setup durations, processing times, etc. It should automatically share possible make-span, number of tardy jobs and their relevant tardiness durations It should share GANTT Chart of the obtained solution. Please be careful about testing and validation of your models. The user can enter any value for # of machines, # of jobs and their relevant processing times and setup durations. Therefore, you should design very generic model for your project. (Hint: you can test your system in max. 5 machines - 5 jobs case) Please share your excel files, instructions booklet (if necessary), any external codes, etc. with your TA. If you have any questions, please do not hesitate to contact with us. Please design and develop a MS Excel tool to help decision makers in their scheduling problems. The proposed model should include such aspects; It should be a dynamic and generic model and users can decide on number of machines and jobs, setup durations, processing times, etc. It should automatically share possible make-span, number of tardy jobs and their relevant tardiness durations It should share GANTT Chart of the obtained solution. Please be careful about testing and validation of your models. The user can enter any value for # of machines, # of jobs and their relevant processing times and setup durations. Therefore, you should design very generic model for your project. (Hint: you can test your system in max. 5 machines - 5 jobs case) Please share your excel files, instructions booklet (if necessary), any external codes, etc. with your TA. If you have any questions, please do not hesitate to contact with us