Homework Answers
Using excel solver,we find the optimal solution as :
In excel ,
Objective function=Max Audience/Reach=H8=SUMPRODUCT(B3:D3,B5:D5)
Constraints :
B9=SUMPRODUCT(B3:D3,B6:D6) [budget constraint)
B10=SUMPRODUCT(B3:D3,B5:D5) [ customers reached ]
B11=B3 [ Number of television ad's]
When we try to solve this problem,the solver does not provide a feasible solution as shown in the excel snapshot because constraints 2 and 3 are not satisfied.
Add Answer to:
3. A company is considering three forms of advertising: television, radio, and newspaper. Each television spot...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The cos...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio 600 300 2,000 Cost per advert Audience per advert 100, 000 40,000 18,000 The local newspaper limits the number of weekly advertisements from a single company to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number of advertisements should...
Part II (50 marks) ad- The advertising alternatives for a company include television, radio, and newspaper vertisem...
Part II (50 marks) ad- The advertising alternatives for a company include television, radio, and newspaper vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio Cost per advert 2,000 600 300 Audience per advert 100,000 40,000 18,000 The local newspaper limits the number of weekly advertisements from a single company to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and est...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio Cost per advert 2,000 Audience per advert 100, 000 6600 300 40, 000 18, 000 The local newspaper to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number of advertisements should occur on the radio, and at least 10%...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and est...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio Cost per advert 2,000 Audience per advert 100, 000 6600 300 40, 000 18, 000 The local newspaper to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number of advertisements should occur on the radio, and at least 10%...
The advertising alternatives tor a company include television, radio, and newspaper ad- vertisements. The costs and est...
The advertising alternatives tor a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio 2,000 Cost per advert Audience per advert 600 300 100, 000 40, 000 18,000 The local newspaper limits the number of weekly advertisements from a single company to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number of advertisements...
Two Advertising medias are being considered for promotion of a product. Radio ads cost $750 each,...
Two Advertising medias are being considered for promotion of a product. Radio ads cost $750 each, while newspaper ads cost $900 each. The total budget is $12,000 per week. The total number of ads should be at least 14, with at least 4 of each type, and there should be no more than 20 ads in total. The company does not want the number of newspaper ads to exceed the number of radio ads by more than 20 percent. Each...
A company is planning an advertising campaign. They plan on purchasing ads on two different television...
A company is planning an advertising campaign. They plan on purchasing ads on two different television networks, with the goal of reaching viewers in three different geographic areas. Ad spots on Station A cost $260 each. Ad spots on Station B cost $340 each. Each ad spot on Station A is expected to reach 390 people in Region 1, as well as 220 people in Region 2, and 80 people in Region 3. Each ad spot on Station B is...
The Denver advertising agency promoting the new Breem dishwashing detergent wants to get the best exposure...
The Denver advertising agency promoting the new Breem dishwashing detergent wants to get the best exposure possible for the product within the $105,000 advertising budget ceiling placed on it. To do so, the agency needs to decide how much of the budget to spend on each of its two most effective media: (1) television spots during the afternoon hours and (2) large ads in the city's Sunday newspaper. Each television spot costs $3,000; each Sunday newspaper ad costs $1,250. The...
A company has $15,930 available per month for advertising. Newspaper ads cost $210 each and can't...
A company has $15,930 available per month for advertising. Newspaper ads cost $210 each and can't run more than 22 times per month. Radio ads cost $610 each and can't run more than 29 times per month at this price. Each newspaper ad reaches 5250 potential customers, and each radio ad reaches 6600 potential customers. The company wants to maximize the number of ad exposures to potential customers. Use n for number of Newspaper advertisements and r for number of...
Part II (50 marks) The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below Tele...
Part II (50 marks) The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below Television Newspaper Radio 300 600 Cost per advert 2,000 Audience per advert 100, 000 40,000 18,000 l newspaper limits the number of weekly advertisements from a single company nce the advertising amon The loca to ten. Moreover, in order no more than half of the total number of advertisements should occur...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio 600 300 2,000 Cost per advert Audience per advert 100, 000 40,000 18,000 The local newspaper limits the number of weekly advertisements from a single company to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number of advertisements should...
Part II (50 marks) ad- The advertising alternatives for a company include television, radio, and newspaper vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio Cost per advert 2,000 600 300 Audience per advert 100,000 40,000 18,000 The local newspaper limits the number of weekly advertisements from a single company to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio Cost per advert 2,000 Audience per advert 100, 000 6600 300 40, 000 18, 000 The local newspaper to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number of advertisements should occur on the radio, and at least 10%...
The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio Cost per advert 2,000 Audience per advert 100, 000 6600 300 40, 000 18, 000 The local newspaper to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number of advertisements should occur on the radio, and at least 10%...
The advertising alternatives tor a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below: Television Newspaper Radio 2,000 Cost per advert Audience per advert 600 300 100, 000 40, 000 18,000 The local newspaper limits the number of weekly advertisements from a single company to ten. Moreover, in order to balance the advertising among the three types of media, no more than half of the total number of advertisements...
A company is planning an advertising campaign. They plan on purchasing ads on two different television networks, with the goal of reaching viewers in three different geographic areas. Ad spots on Station A cost $260 each. Ad spots on Station B cost $340 each. Each ad spot on Station A is expected to reach 390 people in Region 1, as well as 220 people in Region 2, and 80 people in Region 3. Each ad spot on Station B is...
The Denver advertising agency promoting the new Breem dishwashing detergent wants to get the best exposure possible for the product within the $105,000 advertising budget ceiling placed on it. To do so, the agency needs to decide how much of the budget to spend on each of its two most effective media: (1) television spots during the afternoon hours and (2) large ads in the city's Sunday newspaper. Each television spot costs $3,000; each Sunday newspaper ad costs $1,250. The...
A company has $15,930 available per month for advertising. Newspaper ads cost $210 each and can't run more than 22 times per month. Radio ads cost $610 each and can't run more than 29 times per month at this price. Each newspaper ad reaches 5250 potential customers, and each radio ad reaches 6600 potential customers. The company wants to maximize the number of ad exposures to potential customers. Use n for number of Newspaper advertisements and r for number of...
Part II (50 marks) The advertising alternatives for a company include television, radio, and newspaper ad- vertisements. The costs and estimates for audience coverage are given in table below Television Newspaper Radio 300 600 Cost per advert 2,000 Audience per advert 100, 000 40,000 18,000 l newspaper limits the number of weekly advertisements from a single company nce the advertising amon The loca to ten. Moreover, in order no more than half of the total number of advertisements should occur...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago