3 INSTRUCTIONS 4 1-Create a new sheet named "Solution" 2-Create necessary places (cells or ranges) for your decision variables, objective function and 5 constraints in the "Solution" sheet 6 3-Calculate the objective function using the correct Excel formula in the "Solution" sheet 7 4-Calculate the total \# of assignments to each worker and each job in the "Solution" sheet 5- First solve the problem as a classical assignment problem, similar to what we have done in class 8 (each job is assigned to only 1 worker and record the optimal cost as 21 ) 9 6- For each special requirement, create the necessary formula in the "Solution" sheet 10 7-Open Solver and add the modify constraints for the special requirements 8-Solve your modified problem and find the optimal solution (z2), compare your new objective 11 function value (z2) with the previous one (z1). Are they different? Why? 9-Create a separate sheet named "Assignments". In this sheet you should have 12 rows showing the jobs and next to each row, you should display the list of workers who are assigned to these jobs from 12 your optimal solution Special Requirements ** Each job should be done by at least 2 workers ** No worker should have more than 4 job ** No worker should stay idle ** Worker 3 and 7 can not do job 7. ** Worker 10 can not do jobs 2,8,10. ** Job-4 should be done by exactly 4 workers ** no fractional assignments are allowed, all assignments should be binary ( 0 or 1 )