{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lecture 5 Solved Spreadsheet - Inputs Demands Changing...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full Document Right Arrow Icon
SaturdaySunday 16 11 Sat Sun 2 3 3 7 7 1 1 3 3 1 16 15 >= >= 16 11
Background image of page 2
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
Background image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}