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

1 Expert Approved Answer
Step: 1 Unlock

Solution EXCEL ANSWER FORMULAE FOR THE ABOVE SOLVER TAB ANSWER REPORT Result Solver found a solution ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!