11. Go to the Webinars worksheet. DeShawn wants to determine the number of webinars the company can hold on Tuesdays and Thursdays to make the highest weekly profit without interfering with consultations, which are also scheduled for Tuesdays and Thursdays and use the same resources. Use Solver to find this information as follows: a. Use 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 number of Tuesday and Thursday sessions for the five programs as the changing variable cells. c. Determine and enter the constraints based on the information provided in Table 3. d. Use Simplex LP as the solving method to find a global optimal solution. e. Save the Solver model below the Maximum weekly profit model label. f. Solve the model, keeping the Solver solution. Table 3: Solver Constraints Constraint Cell or Range Each webinar is scheduled at least once on Tuesday and once on Thursday B4:F5 Each Tuesday and Thursday webinar value is an integer B4:F5 Each type of webinar is scheduled 1 time per week or more B6:F6 Each type of webinar is scheduled 3 times per week or less B6:F6 The total number of Tuesday webinars is 5 or less Total_Tuesday_Webinars The total number of Thursday webinars is 15 or less Total_Thursday_Webinars The total number of webinars per week is 13 Total_Weekly_Webinars The total number of Tuesday consultations is 2 or less Tuesday_Consultations The total number of Thursday consultations is 2 or less Thursday_Consultations The total number of consultations per week is 5 or less Total_Consultations

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter14: Game Theory

Section14.1: Two-person Zero-sum And Constant-sum Games: Saddle Points

Problem 4P

See similar textbooks

Related questions

Question

11. Go to the Webinars worksheet. DeShawn wants to determine the number of webinars the company can hold on Tuesdays and Thursdays to make the highest weekly profit without interfering with consultations, which are also scheduled for Tuesdays and Thursdays and use the same resources. Use Solver to find this information as follows: a. Use 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 number of Tuesday and Thursday sessions for the five programs as the changing variable cells. c. Determine and enter the constraints based on the information provided in Table 3. d. Use Simplex LP as the solving method to find a global optimal solution. e. Save the Solver model below the Maximum weekly profit model label. f. Solve the model, keeping the Solver solution. Table 3: Solver Constraints Constraint Cell or Range Each webinar is scheduled at least once on Tuesday and once on Thursday B4:F5 Each Tuesday and Thursday webinar value is an integer B4:F5 Each type of webinar is scheduled 1 time per week or more B6:F6 Each type of webinar is scheduled 3 times per week or less B6:F6 The total number of Tuesday webinars is 5 or less Total_Tuesday_Webinars The total number of Thursday webinars is 15 or less Total_Thursday_Webinars The total number of webinars per week is 13 Total_Weekly_Webinars The total number of Tuesday consultations is 2 or less Tuesday_Consultations The total number of Thursday consultations is 2 or less Thursday_Consultations The total number of consultations per week is 5 or less Total_Consultations

Expert Solution