ONLY NEED HELP WITH WORKING THROUGH HOW TO SOLVE B). The correct answer for B is shown but I need to know how to reach this solution using excel.

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown.

To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized.

(a) If the promotional budget is limited to $29,700, how many commercial messages should be run on each medium to maximize total audience contact? (correct answers shown)

(b)

By how much would audience contact increase if an extra $100 were allocated to the promotional budget? (Round your answer to the nearest whole number.)

How do I find 102.61 as a solution?? Using excel please. The data shown above with red numbers is what was given for the solution on the problem, I need to know how to generate this information on excel.

Constraint Television Radio Online Audience per advertisement 200,000 36,000 80,000 Cost per advertisement $2,000 $300 $600 Maximum media usage 10 20 10 Television 9 Radio 19 Online 10 What is the allocation of the budget among the three media, and what is the total audience reached? Television Budget 18000 Radio Budget 5700 Online Budget 6000 Total Audience 3284000 OPTIMAL SOLUTION Optimal Objective Value 3284000 Variable Value Reduced Cost T 0 9 19 R 0 0 10 0 Constraint 1 Slack/Surplus 0 1 2 3 1 Dual Value 102.6086 0 0 23652.17390 10434.78260 0 4 0 5 0 5.2 6 Objective Coefficient 200000 36000 80000 Allowable Increase 40000 Infinite Infinite Allowable Decrease 236000 6000 23652.17390 (b) The dual value for the budget constraint is 102.61. Thus, a $100 increase in budget should provide an increase in audience coverage of approximately 10,261. The right-hand-side range for the budget constraint will show this interpretation is correct