Lecture 5 Solved Spreadsheet - Inputs Demands Changing cells Monday Tuesday Wednesday hrusday Friday T 17 13 15 19 14 6 2 3 7 1 3 1 Starting on Mon Tue

Inputs Monday Tuesday Wednesda Thrusday Friday Demands 17 13 15 19 14 Changing cells Starting on # Mon 6 Tue 2 Wed 3 Thu 7 Fri 1 Sat 3 Sun 1 Objective function 23 Constraints Number of employess working on various days who started on varions days Working on Mon Tue Wed Thu Fri Mon 6 6 6 6 6 Tue 2 2 2 2 Wed 3 3 3 Started on Thu 7 7 7 Fri 1 1 1 Sat 3 3 3 Sun 1 1 1 1 Total 18 13 15 19 19 >= >= >= >= >= Needed 17 13 15 19 14

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

View Full Document

SaturdaySunday 16 11 Sat Sun 2 3 3 7 7 1 1 3 3 1 16 15 >= >= 16 11

Inputs Subject requirements Math214 IOE310 EECS280 IOE265 IOE373 IOE366 EECS283 Math 1 1 1 1 IOE 1 1 1 1 EECS 1 1 1 Prerequisites: Math214 for IOE310 IOE265 for IOE366 Also, credit not given for both EECS280 and EECS283 Changining cells Course Math214 IOE310 EECS280 IOE265 IOE373 IOE366 EECS283 Take/Not take 0 0 1 1 1 1 0 Objective Total courses 4 Constraints Have Need Math req. 2 2 IOE req. 3 3 EECS req. 2 2 EECS280/283 credit 1 Prerequisites specified within solver Formultion Variables Math214 IOE310 EECS280 IOE265 Binary variables, =1 if the corresponding course is taken, 0 otherwise IOE373 IOE366 EECS283 Mathematical model min Math214+IOE310+EECS280+IOE265+IOE373+IOE366+EECS283 Number of subject to