Question

In: Math

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown

Constraint

Television Radio Newspaper

Audience per advertisement

100,000 18,000 40,000

Cost per advertisement

$2000 $300 $600

Maximum media usage

10 20 10

I NEED EXCEL FILE WHICH HAS EXCEL SPREADSHEET AND SENSITIVITY REPORT FOR THIS PROBLEM

Solutions

Expert Solution


Related Solutions

The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown. Constraint Television Radio Online Audience per advertisement 400,000 72,000 160,000 Cost per advertisement $2,000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 100000 18000 20000 Cost per advertisement $2000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown. Constraint Television Radio Online Audience per advertisement 200,000 36,000 80,000 Cost per advertisement $2,000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 110,000 18,000 30,000 Cost per advertisement $1,500 $250 $500 Maximum media usage 11 21 13 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 150,000   17,000   35,000   Cost per advertisement $1,500   $250   $500   Maximum media usage 12   18   11   To ensure a balanced use of advertising media, radio advertisements must not exceed 45% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Newspaper Audience per advertisement 100000 18000 40000 Cost per advertisement $1400 $190 $600 Maximum media usage 10 10 20 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 100000 18000 40000 Cost per advertisement $1400 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 100000 18000 40000 Cost per advertisement $1400 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Newspaper Audience per advertisement 100000 18000 20000 Cost per advertisement $2000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are...
The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Newspaper Audience per advertisement 100000 18000 20000 Cost per advertisement $2000 $300 $600 Maximum media usage 10 20 10 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT