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.
-
Write a program to solve the Josephus problem, with the following
modification:
Sample Input:
./a.out n...
asked 1 hour ago -
At the start of a CD it is spinning at a rate of 525 rpm
(revolutions...
asked 2 hours ago -
4. Without doing any calculations, predict whether the observed
∆T would increase, decrease or remain the...
asked 3 hours ago -
Based on the range, which of the following sets of scores has
the greatest variability? 3,...
asked 4 hours ago -
Ripples in a pond travel at a velocity of 3 m/s with one peak
passing a...
asked 4 hours ago -
A man stands on the roof of a building of height 13.0 mm and
throws a...
asked 4 hours ago -
The extent to which assets are financed by borrowed funds and
other liabilities is indicated by:...
asked 5 hours ago -
Explain in detail
Germany is the fifth largest economy
explain what goods and services Germany specializes...
asked 5 hours ago -
The density of platinum is 21.45 g/mL. If a cube of platinum
with a mass of...
asked 6 hours ago -
Accounts Receivable
Sales
A/R Posting
Extended Sales Invoice
Packing Slip
Compare invoice to packing slip 2...
asked 6 hours ago -
Michaella, age 23, is a full-time law student and is claimed by
her parents as a...
asked 6 hours ago -
Why are polymers not typically casted into products?
asked 6 hours ago