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 between

and $3]$ for # of machines, # of jobs and their relevant processing times and setup durations.

Therefore, you should design very generic model for your project.

Please share your excel files, instructions $($if necessary$),$ any external codes, etc. with your TA$.$ If

you have any questions, please do not hesitate to contact with us$.$ please WR$$TE EXCEL FORMULAS $$N EXCEL