Lecture 5 Spreadsheet - Inputs Demands Changing cells...

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

View Full Document Right Arrow Icon
Inputs Monday Tuesday WednesdaThrusday Friday Demands 17 13 15 19 14 Changing cells Starting on Number Mon 0 Tue 0 Wed 0 Thu 0 Fri 0 Sat 0 Sun 0 Objective function 0 Constraints Number of employess working on various days who started on varions days Working on Mon Tue Wed Thu Fri Mon 0 0 0 0 0 Tue 0 0 0 0 Wed 0 0 0 Started on Thu 0 0 0 Fri 0 0 0 Sat 0 0 0 Sun 0 0 0 0 Total 0 0 0 0 0 >= >= >= >= >= 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 DocumentRight Arrow Icon
SaturdaySunday 16 11 Sat Sun 0 0 0 0 0 0 0 0 0 0 0 0 >= >= 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 0 0 0 0 0 Objective Total courses 0 Constraints Have Need Math req. 0 2 IOE req. 0 3 EECS req. 0 2 EECS280/283 credit 0 Prerequisites specified within solver
Background image of page 3

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

View Full DocumentRight Arrow Icon
Inputs Cost to Cost to Pollutant 1 removed Pollutant 2 removed build treat 1 ton per ton treated per ton treated Site 1 $120,000.00 $20.00 0.3 0.3 Site 2 $60,000.00
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Lecture 5 Spreadsheet - Inputs Demands Changing cells...

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

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