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

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

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

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

View Full Document
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
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
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

## This note was uploaded on 10/19/2011 for the course TOM 453 taught by Professor Kumar during the Spring '11 term at Cal Poly Pomona.

### 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
Ask a homework question - tutors are online