1. 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:
   1. Use the total weekly profit (cell G16, named Total_Weekly_Profit) as the objective cell in the Solver model, with the goal of determining the maximum value for that cell.
   2. Use the number of Tuesday and Thursday sessions for the five programs (range B4:F5) as the changing variable cells.
   3. Determine and enter the constraints based on the information provided in Table 3.
   4. Use Simplex LP as the solving method to find a global optimal solution.
   5. Save the Solver model in cell A26.
   6. Solve the model, keeping the Solver solution.

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

Webinar Worksheet :

12 X B H K L M N o P Q R Maxwell Training Webinar Schedule Orientation Tech Skills 0 0 Soft Skills Product Total - NM + inn Mandatory 0 0 0 0 3 4 Tuesday webinars 5 Thursday webinars 6 Webinars per week 0 0 0 0 0 0 0 0 0 0 0 0 8 Webinars - Profit Analysis Orientation Tech Skills Soft Skills Product $ 30.00 $ 55.00 $ 40.00 $ 30.00 $ $ $ $ Mandatory $ 45.00 $ Total 200.00 9 10 Profit per Tuesday webinar 11 Subtotal profit 12 13 Profit per Thursday webinar 14 Subtotal profit 15 16 Total weekly profit 17 25.00 $ 55.00 220.00 $ $ 35.00 $ $ 55.00 $ $ 50.00 $ $ $ $ $ $ $ $ $ 18 Consultations Tech 19 Total Management 0 0 0 0 0 0 20 Tuesday consultations 21 Thursday consultations 22 Consultations per week 23 0 0 0 24 25 Maximum weekly profit model 26 27 28 29 Webinars # 12 X B H K L M N o P Q R Maxwell Training Webinar Schedule Orientation Tech Skills 0 0 Soft Skills Product Total - NM + inn Mandatory 0 0 0 0 3 4 Tuesday webinars 5 Thursday webinars 6 Webinars per week 0 0 0 0 0 0 0 0 0 0 0 0 8 Webinars - Profit Analysis Orientation Tech Skills Soft Skills Product $ 30.00 $ 55.00 $ 40.00 $ 30.00 $ $ $ $ Mandatory $ 45.00 $ Total 200.00 9 10 Profit per Tuesday webinar 11 Subtotal profit 12 13 Profit per Thursday webinar 14 Subtotal profit 15 16 Total weekly profit 17 25.00 $ 55.00 220.00 $ $ 35.00 $ $ 55.00 $ $ 50.00 $ $ $ $ $ $ $ $ $ 18 Consultations Tech 19 Total Management 0 0 0 0 0 0 20 Tuesday consultations 21 Thursday consultations 22 Consultations per week 23 0 0 0 24 25 Maximum weekly profit model 26 27 28 29 Webinars #