. A commercial store is planning to advertise in different outlets to maximize the number of...
*** Please show steps in excel*** Home Depot is trying to determine how to advertise in order to maximize their exposure. Their weekly advertising budget is $25,000. They are considering three possible media: tv, newspaper, and radio. Information regarding cost and exposure is given in the table below: Medium audience reached per ad cost per ad (4) maximum ads per week minimum ads per week TV 8,000 1,200 11 5 Newspaper 5,500 600 15 5 Radio 3,000 400 22 5...
2) 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 available are shown in the following table: Type of AD Maximum number Cost per AD...
Please Answer for Question 2 with complete work and answers
hand written
2) 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 available are shown...
An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and Internet ads. Information about each medium is shown below. Medium Cost Per Ad # People Reached Exposure Quality TV 1,000 20,000 35 Radio 600 10,000 45 Internet 300 60,000 5 The number of Internet ads should be at least one third of all ads. Also, the advertising budget is $18,000. Since this is a special program,...
Please answer question 2 with complete answers and
explanations. Hand written only
2) 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 available are shown...
An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TVtime, radio time and newspaper ads. Information about each medium is shown below.Medium Cost Per Ad # Reached Exposure QualityTV 500 10000 30Radio 200 3000 40Newspaper 400 5000 25If the number of TV ads cannot exceed the number of radio ads by more than 4, and if the advertising budget is $10000, develop the model that will maximize the number reached...
8。The Fashion Store has $12,000 available each month for advertising. Newspaper ads cost $600 apiece and no more than 30 can be run per month. Radio ads cost $300 each and no more than 40 can run per month. TV ads cost $1800 a piece, with a maximum of 6 available each month. Approximately 3000 women will see each newspaper ad, 1800 will hear each radio ad, and 15,000 will see each TV ad. How much of each type of...
Problem 4 Blue ocean insurance services Inc. is working on its advertising strategy and wants to consider four types of media: Internet, Radio, TV, and Newspaper. Their objective is to maximize total exposure to audiences (exposure means number of audiences reached through the ad). The cost of an ad and exposure per ad is provided in the following table Media type Cost per ad Exposure per ad $0.65 $1500 $5000 $3500 Internet 300 Radio 150,000 TV 350,000 Newspaper 200,000 The...
The Problem In this project your group will solve the following situation: A local business plans on advertising their new product by purchasing advertisements on the radio and on TV. The business plans to purchase at least 60 total ads and they want to have at least twice as many TV ads as radio ads. Radio ads cost $20 each and TV ads cost $80 each. The advertising budget is $4320. It is estimated that each radio ad will be...
Solve for the optimal solution and
sensitivity report with the information above and answer the
following questions:
1. What is the range of the number of exposures for TV spots
that the current optimal solution remains optimal?
2. If the unit exposure of TV spots increases by 500,000 and
that of SS (Sunday supplements) ads increases by 250,000 per
$1,000, would the current optimal solution remain optimal? Explain
why or why not and show your computation.
3. How much could...