WorkerScheduling - 17 13 15 19 14 16 11 Extra required each...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Post Office scheduling model Decision variables: number of employees starting their five-day shift on various days Range names used: Mon 6.33 Employees_available =Model!$B$23:$H$23 Tue 5.00 Employees_required =Model!$B$25:$H$25 Wed 0.33 Employees_starting =Model!$B$4:$B$10 Thu 7.33 Total_employees =Model!$B$28 Fri 0.00 Sat 3.33 Sun 0.00 Result of decisions: number of employees working on various days (along top) who started their shift on various days (along side) Mon Tue Wed Thu Fri Sat Sun Mon 6 6 6 6 6 Tue 5 5 5 5 5 Wed 0 0 0 0 0 Thu 7 7 7 7 7 Fri 0 0 0 0 0 Sat 3 3 3 3 3 Sun 0 0 0 0 0 Constraint on worker availabilities Employees available 17.00 14.67 15.00 19.00 19.00 16.00 11.00 >= >= >= >= >= >= >= Employees required 17 13 15 19 14 16 11 Objective to maximize Total employees 22.33 A B C D E F G H I J K L 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Post Office scheduling model Decision variables: number of employees starting their five-day shift on various days Mon 6 Tue 6 Wed 0 Thu 7 Fri 0 Sat 4 Sun 0 Employees required (original values)
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 17 13 15 19 14 16 11 Extra required each day Result of decisions: number of employees working on various days (along top) who started their shift on various days (along side) Mon Tue Wed Thu Fri Sat Sun Mon 6 6 6 6 6 Tue 6 6 6 6 6 Wed Thu 7 7 7 7 7 Fri Sat 4 4 4 4 4 Sun Constraint on worker availabilities Employees available 17 16 16 19 19 17 11 >= >= >= >= >= >= >= Employees required 17 13 15 19 14 16 11 Objective to maximize Total employees 23 Sensitivity of total employees to extra required per day $B$30 23 2 25 4 28 6 31 A B C D E F G H I J K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37...
View Full Document

Page1 / 2

WorkerScheduling - 17 13 15 19 14 16 11 Extra required each...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online