Answered step by step
Verified Expert Solution
Link Copied!

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, And Terry D. Warfield

13th Edition

9780470374948, 470423684, 470374942, 978-0470423684

More Books

Students also viewed these Accounting questions

Question

Examine the major components of a marketing plan.

Answered: 1 week ago