Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez,...

Eddie Kelly is running for reelection as mayor of a small town in Alabama. Jessica Martinez, Kelly’s campaign manager during this election, is planning 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 number of each is shown in the following table: In addition, Martinez has decided that there should be at least six ads on TV or radio or some combination of those two. The amount spent on billboards and newspapers together must not exceed the amount spent on TV ads. While fundraising 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?

Please answer in excel with solver and provide formulas

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Richard is the Mayor of Atlanta and is seeking reelection. His opponent is running on the...

Richard is the Mayor of Atlanta and is seeking reelection. His opponent is running on the platform of making the city safe and especially targeting the murder rate. The national average number of murders is 450. The number of murders in Atlanta has averaged 520 with a standard deviation = 75 (sample size=1,000) . Conduct a 5-step hypothesis testing process to determine if this is a significant difference between Atlanta and the population of 450 using a significance level of...

The mayor of a small town claims that in his town there is no significant difference...

The mayor of a small town claims that in his town there is no significant difference between the proportion of male and female (between the ages of 21 and 65) that have jobs. To test this claim, a statistician randomly sampled 30 male and 40 female residents and found that 25 males and 25 females have jobs. a. What are p^1and p^2? [ Sample answer: "phat1 = 0.262 ; phat2 = 0.635"] b. What is the Point Estimate for (p1−p2)?...

The town of Ferndale has four candidates running for mayor: the town barber, Darrell; the fire...

The town of Ferndale has four candidates running for mayor: the town barber, Darrell; the fire chief, Clough;the grocer, Abel; and a homemaker, Belle. A poll of 1000 of the voters shows the following results: DABC = 225 CABD = 190 CADB = 210 BADC = 375 Is there a winner using the plurality method? D A B C The seniors at Weseltown High School are voting on where to go for their senior trip. They are deciding on Angel...

Sabrina, Kris, and Kelly are the only three residents of the small town of Charleston. They...

Sabrina, Kris, and Kelly are the only three residents of the small town of Charleston. They are considering whether to hire a police officer to patrol the town. Sabrina values the police officer at $610 per week, Kris values the police officer at $230 per week, and Kelly values the police officer at $150 per week. The competitive wage for a police officer is $900 per week. a. If the protection provided by the police officer to one resident does...

A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the...

A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days pre- ceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 peo- ple. In planning the advertising campaign, the cam- paign manager would like to reach as many people as possible, but she has stipulated that at least 10...

Solve in EXCEL FORMAT, step by step. A candidate for mayor in a small town has...

Solve in EXCEL FORMAT, step by step. A candidate for mayor in a small town has allocated $40,000 for last-minute advertising in the days preceding the election. Two types of ads will be used: radio and television. Each radio ad costs $200 and reaches an estimated 3,000 people. Each television ad costs $500 and reaches an estimated 7,000 people. In planning the advertising campaign, the campaign manager would like to reach as many people as possible, but she has stipulated...

Subjects