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 ${|}_{{?}_{?}}0||$ and $3$