Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Collectible Investments For The High Net Worth Investor

Authors: Stephen Satchell

1st Edition

0123745225,0080923054

More Books

Students also viewed these Finance questions