Go to the Webinars 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: Use Total weekly profit as the objective cell in the Solver model, with the goal of determining the maximum value for that cell. Use the number of Tuesday and Thursday sessions for the five programs as the changing variable cells. Determine and enter the constraints based on the information provided in Table 3. Use Simplex LP as the solving method to find a global optimal solution. Save the Solver model below the Maximum weekly profit model label. 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
Go to the Webinars 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: Use Total weekly profit as the objective cell in the Solver model, with the goal of determining the maximum value for that cell. Use the number of Tuesday and Thursday sessions for the five programs as the changing variable cells. Determine and enter the constraints based on the information provided in Table 3. Use Simplex LP as the solving method to find a global optimal solution. Save the Solver model below the Maximum weekly profit model label. 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
Chapter20: Queuing Theory
Section20.2: Modeling Arrival And Service Processes
Problem 3P
Related questions
Question
- Go to the Webinars 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:- Use Total weekly profit as the objective cell in the Solver model, with the goal of determining the maximum value for that cell.
- Use the number of Tuesday and Thursday sessions for the five programs as the changing variable cells.
- Determine and enter the constraints based on the information provided in Table 3.
- Use Simplex LP as the solving method to find a global optimal solution.
- Save the Solver model below the Maximum weekly profit model label.
- 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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L