Using the data from Instructions_SC_EX16_9a.docx https://www.coursehero.com/file/26222390/Instructions-SC-EX16-9adocx/?focusQaId=20445220

How do I put these constraints into the solver add in step by step? (12a-12c)

12. Go to the New Schedule worksheet. Louisa wants to determine the number of morning and afternoon classes the club can offer to make the highest weekly profit without exceeding the maximum legal pool capacities, meeting the swim team scheduling needs, and considering other practical conditions. Use Solver to find this information as follows:| a. Use cell G17 (Total_Weekly_Profit) as the objective cell in the Solver model, with the goal of determining the maximum value for that cell. b. Use the range B5:F6, which shows the number of morning and afternoon swim classes, as the changing variable cells. C. Use the constraints shown in Table 2 below. Table 2: Solver Constraints Constraint Cell or Range Each type of lesson is scheduled at least once in the B5:F6 morning and once in the afternoon Each morning and afternoon class value is an integer B5:F6 Each type of lesson is scheduled 3 times per week or B7:F7 more Each type of lesson is scheduled 10 times per week or B7:F7 less 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 Team_Morning_Classes week or less (D21) Swim team afternoon classes are scheduled 8 times per Team_Afternoon_Classes week or less (D22) The total number of swim team classes scheduled per Team_Total_Classes week is 12 or less (D23)