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
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) |
Step by Step Solution
3.42 Rating (152 Votes )
There are 3 Steps involved in it
Solution EXCEL ANSWER FORMULAE FOR THE ABOVE SOLVER TAB ANSWER REPORT Result Solver found a solution ... View full answer
Get step-by-step solutions from verified subject matter experts
