11.7 - 1 Constraints Cell Name Cell Value Formula Status...

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

View Full Document Right Arrow Icon
Samuel Chu BRONCO ID: 004814758 3 Workshift scheduling Problem 11.7 Start work on Day Sun Mon Tue Wed Thu Fri Sat # available Number proposed Sun 1 1 1 1 1 6 >= 6 Mon 1 1 1 1 1 4 >= 4 Tue 1 1 1 1 1 4 >= 4 Wed 1 1 1 1 1 4 >= 4 Thur 1 1 1 1 1 5 >= 5 Fri 1 1 1 1 1 6 >= 5 Sat 1 1 1 1 1 6 >= 6 # of deputies 1 0 1 2 1 2 0 Total # of deputis 7 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Samuel Chu BRONCO ID: 004814758 4 Workshift scheduling Problem 11.7 Start work on Day Sun Mon Tue Wed Thu Fri Sat # available Number proposed Sun 1 1 1 1 1 6 >= 6 Mon 1 1 1 1 1 4 >= 4 Tue 1 1 1 1 1 4 >= 4 Wed 1 1 1 1 1 4 >= 4 Thur 1 1 1 1 1 5 >= 5 Fri 1 1 1 1 1 6 >= 5 Sat 1 1 1 1 1 6 >= 6 # of deputie 1 0 1 2 1 2 0 Total # of de 7 A B C D E F G H I J K L M 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Background image of page 2
Samuel Chu BRONCO ID: 004814758 5 Microsoft Excel 12.0 Answer Report Worksheet: [11.7.xlsx]Workshift scheduling Report Created: 2/27/2011 12:08:16 PM Target Cell (Min) Cell Name Original Value Final Value $B$17 Total # of patrol Sun 7 7 Adjustable Cells Cell Name Original Value Final Value $B$15 # of patrol Sun 1 1 $C$15 # of patrol Mon 1 0 $D$15 # of patrol Tue 1 1 $E$15 # of patrol Wed 1 2 $F$15 # of patrol Thu 1 1 $G$15 # of patrol Fri 1 2 $H$15 # of patrol Sat
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 Constraints Cell Name Cell Value Formula Status Slack $J$7 Sun # available 6 $J$7>=$L$7 Binding $J$8 Mon # available 4 $J$8>=$L$8 Binding $J$9 Tue # available 4 $J$9>=$L$9 Binding $J$10 Wed # available 4 $J$10>=$L$10 Binding $J$11 Thur # available 5 $J$11>=$L$11 Binding $J$12 Fri # available 6 $J$12>=$L$12 Not Binding 1 $J$13 Sat # available 6 $J$13>=$L$13 Binding $B$15 # of patrol Sun 1 $B$15=integer Binding $C$15 # of patrol Mon 0 $C$15=integer Binding $D$15 # of patrol Tue 1 $D$15=integer Binding $E$15 # of patrol Wed 2 $E$15=integer Binding $F$15 # of patrol Thu 1 $F$15=integer Binding $G$15 # of patrol Fri 2 $G$15=integer Binding $H$15 # of patrol Sat 0 $H$15=integer Binding...
View Full Document

Page1 / 3

11.7 - 1 Constraints Cell Name Cell Value Formula Status...

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

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