You work at an advertising firm and you're managing the account of a client. You're helping...

 

Transcribed Image Text:

You work at an advertising firm and you're managing the account of a client. You're helping them plan their advertising for the next month. They have a budget of $30,000 and want you to design an ad campaign that: Includes at least 10 TV commercials Reaches at least 50,000 people • Allocates no more than $18,000 to TV ads ● Maximizes the total Exposure Quality Units ● The following table shows the number of people reached per ad, the cost per ad, the number of available ads, and the Exposure Quality Units (which measures the ad's effectiveness) per ad for the four available types of media. Daytime TV Evening TV Daily Paper Radio Reach 1000 2000 1500 300 Cost 1500 3000 400 100 Available Exposure Quality Units 15 12 25 30 65 90 40 20 a) Write out the formulation of a linear optimization model to help you determine the number of each type of ad to purchase in order to maximize the total Exposure Quality Units of the campaign. b) What is the optimal solution, and what is the value of the objective function? Use Excel Solver to solve this problem. You work at an advertising firm and you're managing the account of a client. You're helping them plan their advertising for the next month. They have a budget of $30,000 and want you to design an ad campaign that: Includes at least 10 TV commercials Reaches at least 50,000 people • Allocates no more than $18,000 to TV ads ● Maximizes the total Exposure Quality Units ● The following table shows the number of people reached per ad, the cost per ad, the number of available ads, and the Exposure Quality Units (which measures the ad's effectiveness) per ad for the four available types of media. Daytime TV Evening TV Daily Paper Radio Reach 1000 2000 1500 300 Cost 1500 3000 400 100 Available Exposure Quality Units 15 12 25 30 65 90 40 20 a) Write out the formulation of a linear optimization model to help you determine the number of each type of ad to purchase in order to maximize the total Exposure Quality Units of the campaign. b) What is the optimal solution, and what is the value of the objective function? Use Excel Solver to solve this problem.

Answer rating: 100% (QA)

a Formulation of the linear optimization model Let x1 number of Daytime TV ads to purchas... View the full answer