Employee scheduling model Decision variables: number of employees starting their five-day shift on various days Mon 2 Tue 3 Wed 3 Thu 7 Fri 0 Sat 4 Sun 4 Employees requ 17 13 15 19 14 16 Mon 0 Tue 0 2 Wed 0 2 3 Thu 0 2 3 3 Fri 0 2 3 3 7 Sat 15 >= 14 15 >= 16 Employee's Schedules Mon Tue Wed Thu Fri Sat Sun 3 7 0 4 Constraint on employee availabilities Employees avai 14 >= Employees req 17 Objective to maximize Total employee 19 7 0 4 0 4 4 13 >= 13 9 >= 15 12 >= 19 2 3 3 7 0 Range names used Employees_ava=Model!$B$23:$H$23 Employees_req=Model!$B$25:$H$25 Employees_Sta=Model!$B$4:$B$10 Total_employe=Model!$B$28 11 Sun 3 3 7 0 4 17 >= 11