Discuss the Impact of Publicity in a Local Magazine or Over the Radio, or as a TV Spot on the Regional Channel

2. The small company, SilinkAja, launches a new product into a regional market and wishes to have a publicity campaign using different media. It therefore contacts a regional publicity agency, OneNews, that specializes in this type of regional campaign and completely hands over this task for a total budget of $ 250,000. The agency knows the market well, that is, the impact of publicity in a local magazine or over the radio, or as a TV spot on the regional channel. It suggests addressing the market for two months through six different media. For each medium, it knows the cost and the number of people on which this medium has an impact. An index of the quality of perception of the campaign is also known for every medium. 2. The small company, SilinkAja, launches a new product into a regional market and wishes to have a publicity campaign using different media. It therefore contacts a regional publicity agency, OneNews, that specializes in this type of regional campaign and completely hands over this task for a total budget of $ 250,000. The agency knows the market well, that is, the impact of publicity in a local magazine or over the radio, or as a TV spot on the regional channel. It suggests addressing the market for two months through six different media. For each medium, it knows the cost and the number of people on which this medium has an impact. An index of the quality of perception of the campaign is also known for every medium. The publicity agency establishes a maximum number of uses of every medium (for instance, not more than eight transmissions of a TV spot). The following table lists all this information. SiLinkAja wants the impact of the publicity campaign to reach at least 100,000 people. Which media should be chosen, and in which proportions to obtain a maximum index of perception quality? Perception of quality No. Media type People potentially Unit cost Maximum reached ($) use 1. Free weekly 12,000 1,500 4 weeks newspaper 2. Monthly magazine 1,500 8,000 2 months 3. Weekly magazine 2,000 12,000 8 weeks Radio spot 6,000 9,000 60 broadcasts 5. Billboard 3,000 24,000 4 boards TV spot 9,000 51,000 8 broadcasts Develop a spreadsheet-based (open) Solver to solve the problem. CON 6.