I know it can be solved with excel but I cannot figure out the ob function and the constraints.

B) By how much would audience contact increase if an extra $100 were allocated to the promotional budget?

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 newspaper. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Newspaper Audience per advertisement 130000 16500 30000 Cost per advertisement $2350 $375 $450 Maximum media usage 11 8 15 To ensure a balanced use of advertising media, radio advertisements must not exceed 45% 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 $33350, how many commercial messages should be run on each medium to maximize total audience contact? What is the allocation of the budget among the three media? If required, round your answer to nearest integer: Let T = number of television spot advertisements R = number of radio advertisements N = number of newspaper advertisements What is the total audience reached? S