Considering three advertising media possibilities

Assignment Help Operation Management

Reference no: EM131231569

The advertising director a large retail store in Columbus, Ohio, is considering three advertising media possibilities: (1) ads in the Sunday Columbus Dispatch newspaper, (2) ads in a local trade magazine that is distributed free to all houses in the city and northwest suburbs, and (3) ads on Columbus’ WCC- TV station. She wishes to obtain a new-customer exposure level of at least 50% within the city and 60% in the northwest suburbs. Each TV ad has a new-customer exposure level of 5% in the city and 3% in the northwest suburbs. The Dispatch ads have corresponding exposure levels per ad of 3.5% and 3%, respectively, while the trade magazine has exposure levels per ad of 0.5% and 1%, respectively. The relevant costs are $1,000 per Dispatch ad, $300 per trade magazine ad, and $2,000 per TV ad. The advertising policy is that no single media type should consume more than 45% of the total amount spent. Find the advertising strategy that will meet the store’s objective at minimum cost.

Please use excel and show step by step how to do this......i really want to learn basic steps to do this in solver (EXCEl)

Reference no: EM131231569

Questions Cloud

Sales promotions are expensive to administer : Sales promotions are expensive to administer and can be fraught with legal complications. Sales promotions yield their most positive results when carefully integrated with the overall advertising plan. Identify which of the sales promotion techniques..

What are the five major sources of interpersonal power : What are the five major sources of interpersonal power? Give a specific example for each of the five forms of interpersonal power. Briefly describe the major assumption for each of the traits, behavioral, and contingency theories of leadership? What ..

Preferred style of conflict resolution : Compare two leaders that you have followed or observed, or that you are currently following or observing. What is your preferred style of conflict resolution? Which style do you use for backup?

Explain leadership effectiveness in different contexts : To compare and explain leadership effectiveness in different contexts. Compare two leaders that you have followed or observed, or that you are currently following or observing. Discuss the leadership effectiveness of each of the two leaders. Who is m..

Considering three advertising media possibilities : The advertising director a large retail store in Columbus, Ohio, is considering three advertising media possibilities: (1) ads in the Sunday Columbus Dispatch newspaper, (2) ads in a local trade magazine that is distributed free to all houses in the ..

Consider organization as the anchor of supply chain : The introduction to the case explains that when we consider an organization as the anchor of a supply chain, we extend the boundaries of the organization itself. Brian Durkee, for example, manages the members of Numi’s supply chain, which are externa..

Often particularly interested in the subset of market : Marketers are often particularly interested in the subset of a market that contributes most to sales (for example, heavy beer drinkers or large-volume retailers). What type of sampling might be best in this type of situation? Why?

Explain how you can recognize plagiarism : Consumers must trust that the research that has gone into the manufacture of new drugs is safe. But it is hard to know if a conflict of interest between doctors, researchers, and the drug company stockholders has tainted the results. Explain how you ..

Define human resource management : Define "human resource management." Explain how a firm's human resources influence organizational performance. Explain why compliance with HR law is an important part of doing business. Explain why employees join unions. Describe the employment-at-wi..

User Account

All Pages