Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How to put this in Problem Solver using excel a. b. Use cell G16 (Total_Weekly_Profit) as the objective cell in the Solver model, with the
How to put this in Problem Solver using excel
a. b. Use cell G16 (Total_Weekly_Profit) as the objective cell in the Solver model, with the goal of determining the maximum value for that cell. Use the range B4:F5, which shows the number of morning and afternoon music lessons, as the changing variable cells. Use the constraints shown in Table 2 below. C. Table 2: Solver Constraints Constraint Cell or Range B4:F5 Each type of lesson is scheduled at least once in the morning and once in the afternoon Each morning and afternoon lesson value is an integer B4:F5 B6:F6 Each type of lesson is scheduled 2 times per week or more B6:F6 Each type of lesson is scheduled 15 times per week or less The total number of morning lessons is 10 or less Total_Morning_Lessons The total number of afternoon lessons is 15 or less Total_Afternoon_Lessons The total number of lessons per week is 20 Total_Weekly_Lessons Ensemble morning lessons are scheduled 5 times per week or less Group_Morning_Lessons Ensemble afternoon lessons are scheduled 8 times per week or less Group_Afternoon_Lessons Ensemble morning lessons are scheduled 5 times per week or less Group_Morning_Lessons Ensemble afternoon lessons are scheduled 8 times per week or less Group_Afternoon_Lessons Shelly Cashman Excel 2016 | Module 9: SAM Project lb The total number of ensemble lessons scheduled per week is 15 or less Group_Total_Lessons O d. Use Simplex LP as the solving method. e. Save the Solver model in cell A26. f Solve the model keeping the Solver solution a. b. Use cell G16 (Total_Weekly_Profit) as the objective cell in the Solver model, with the goal of determining the maximum value for that cell. Use the range B4:F5, which shows the number of morning and afternoon music lessons, as the changing variable cells. Use the constraints shown in Table 2 below. C. Table 2: Solver Constraints Constraint Cell or Range B4:F5 Each type of lesson is scheduled at least once in the morning and once in the afternoon Each morning and afternoon lesson value is an integer B4:F5 B6:F6 Each type of lesson is scheduled 2 times per week or more B6:F6 Each type of lesson is scheduled 15 times per week or less The total number of morning lessons is 10 or less Total_Morning_Lessons The total number of afternoon lessons is 15 or less Total_Afternoon_Lessons The total number of lessons per week is 20 Total_Weekly_Lessons Ensemble morning lessons are scheduled 5 times per week or less Group_Morning_Lessons Ensemble afternoon lessons are scheduled 8 times per week or less Group_Afternoon_Lessons Ensemble morning lessons are scheduled 5 times per week or less Group_Morning_Lessons Ensemble afternoon lessons are scheduled 8 times per week or less Group_Afternoon_Lessons Shelly Cashman Excel 2016 | Module 9: SAM Project lb The total number of ensemble lessons scheduled per week is 15 or less Group_Total_Lessons O d. Use Simplex LP as the solving method. e. Save the Solver model in cell A26. f Solve the model keeping the Solver solutionStep by Step Solution
There are 3 Steps involved in it
Step: 1
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