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: 12. 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 B5:F6 Each type of lesson is scheduled at least once in the morning and once in the afternoon Each morning and afternoon class value is an integer Each type of lesson is scheduled 3 times per week or B5:F6 B7:F7 more Each type of lesson is scheduled 10 times per wek or B7:F7 less The total number of morning classes is 10 or less The total number of afternoon classes is 15 or less Total Morning Classes (G5) Total Afternoon_Classes (G6) 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: 12. 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 B5:F6 Each type of lesson is scheduled at least once in the morning and once in the afternoon Each morning and afternoon class value is an integer Each type of lesson is scheduled 3 times per week or B5:F6 B7:F7 more Each type of lesson is scheduled 10 times per wek or B7:F7 less The total number of morning classes is 10 or less The total number of afternoon classes is 15 or less Total Morning Classes (G5) Total Afternoon_Classes (G6)