using the excel spread sheet answer question. will thumbs up!

8-6 Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez, Kelly's campaign manager during this election, is plan- ning the marketing campaign, and there is some stiff competition. Martinez has selected four ways to advertise: television ads, radio ads, billboards, and newspaper ads. The costs of these, the audience reached by each type of ad, and the maximum num- ber available are shown in the following table: COST TYPE OF AD PER AD AUDIENCE REACHED/AD MAXIMUM NUMBER TV $800 10 10 Social media Billboards Newspapers $400 $500 $100 30,000 22,000 24,000 8.000 10 10 In addition, Martinez has decided that there should be at least six ads on TV or social media or some combination of those two. The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. While fund- raising is still continuing, the monthly budget for advertising has been set at $15,000. How many ads of each type should be placed to maximize the total number of people reached? T s B B 30000 22000 24000 8000 Decision Variables Objective Function coefficient Constraints: Budget LHS Sign ce RHS 15000 400 800 -800 1 500 500 100 100 T 1 S B N 0