In: Math
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