Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Solution EXCEL ANSWER FORMULAE FOR THE ABOVE SOLVER TAB ANSWER REPORT Result Solver found a solution ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started