I am trying to do a solver constraints in excel and having a really hard time. The professor said to
This problem has been solved!
Do you need an answer to a question different from the above? Ask your question!
I am trying to do a solver constraints in excel and having a really hard time. The professor said to use this table, I know how to go in solver in excel but I don't know how to add the subject constraints in excel?
|Constraint||Cell or Range|
|Each type of lesson is scheduled at least once in the morning and once in the afternoon||B5:F6|
|Each morning and afternoon class value is an integer||B5:F6|
|Each type of lesson is scheduled 3 times per week or more||B7:F7|
|Each type of lesson is scheduled 10 times per week or less||B7:F7|
|The total number of morning classes is 10 or less||Total_Morning_Classes (G5)|
|The total number of afternoon classes is 15 or less||Total_Afternoon_Classes (G6)|
|The total number of classes per week is 20||Total_Weekly_Classes (G7)|
|Swim team morning classes are scheduled 6 times per week or less||Team_Morning_Classes (D21)|
|Swim team afternoon classes are scheduled 8 times per week or less||Team_Afternoon_Classes (D22)|
|The total number of swim team classes scheduled per week is 12 or less||Team_Total_Classes (D23)|
Create a free account to access the answer
Cannot find your solution?
Post a FREE question now and get an answer within minutes. * Average response time.
Posted Date: November 23, 2021 17:04:17