Union_Airways - 1 1 82 >= 73 6pm-8pm 1 1 82 >= 82...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Union Airways Personnel Scheduling Problem 6am-2pm 8am-4pm Noon-8pm 4pm-midnight 10pm-6am Range Name Cells Shift Shift Shift Shift Shift CostPerShift C5:G5 Cost per Shift $170 $160 $175 $180 $195 MinimumNeeded J8:J17 Total Minimum NumberWorking C21:G21 Time Period Shift Works Time Period? (1=yes, 0=no) Working Needed ShiftWorksTimePeriod C8:G17 6am-8am 1 0 0 0 0 48 >= 48 TotalCost J21 8am-10am 1 1 0 0 0 79 >= 79 TotalWorking H8:H17 10am- 12pm 1 1 0 0 0 79 >= 65 12pm-2pm 1 1 1 0 0 118 >= 87 2pm-4pm 0 1 1 0 0 70 >= 64 4pm-6pm
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1 1 82 >= 73 6pm-8pm 1 1 82 >= 82 8pm-10pm 1 43 >= 43 10pm-12am 1 1 58 >= 52 12am-6am 1 15 >= 15 6am-2pm 8am-4pm Noon-8pm 4pm-midnight 10pm-6am Shift Shift Shift Shift Shift Total Cost Number Working 48 31 39 43 15 $30,610 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 18 19 20 21...
View Full Document

This note was uploaded on 04/21/2009 for the course BUS 338W-1 taught by Professor White during the Winter '09 term at University of Michigan-Dearborn.

Ask a homework question - tutors are online