Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step 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