Maximize the number of new customers created by advertising

Assignment Help Operation Management
Reference no: EM13954214

Formulate on a spreadsheet and solve using solver, Explain formulas used in cells.

Carco has a $150,000 advertising budget. In order to increase automobile sales, the firm is considering advertising in newspapers and on television. The more Carco uses a particular medium, the less effective is each additional ad. Table 26 shows the number of new customers reached by ad. Each newspaper ad costs $1000, and each television ad costs $10,000. At most 30 newspaper ads and at most 15 television ads can be placed. How can Cargo maximize the number of new customers created by advertising?

                                    NO. OF ADS                NEW CUSTOMERS

Newspaper                 1 – 10                                     900

                                    11 – 20                                   600

                                    21 – 30                                   300

Television                   1 – 5                                       10,000

                                    6 – 10                                     5,000

                                    11 – 15                                   2,000

Reference no: EM13954214

Questions Cloud

Reduce birth rates, through its one-child policy : Many people outside of China believe that the country's effort to reduce birth rates, through its one-child policy, does not justify its methods. Do you agree? Can you think of any future, unintended consequences for China as a result of adopting ..
Human resource plan and cost and budget estimate : A major company has agreed to participate in the citywide Adopt-a-School program. You have been asked to lead the Book Bag drive sponsored by this company. Describe the resource requirements for the project and the roles and skills required of each t..
What kind of method should he use : To confirm whether composition is right or not, what kind of method should he use? (He wants to analyze without destruction of samples. Ferroelectrcs (Bi,La)4Ti3O12 is an insulator.
What is the probability that the auto dealer will order more : What is the probability that the auto dealer will need to order more new transmissions?
Maximize the number of new customers created by advertising : Carco has a $150,000 advertising budget. In order to increase automobile sales, the firm is considering advertising in newspapers and on television. The more Carco uses a particular medium, the less effective is each additional ad. How can Cargo maxi..
Explain the human resource planning process : Explain the Human Resource Planning Process. Describe each step (job analysis, HR inventory, HR forecasting, inventory, and forecasting comparison) and explain its importance.
Microbiology and industry in petroleum fuels : For project 1 you will do your background research. Specifically, you will choose a suitable topic, identify appropriate resources, and generate a brief outline of the article which you will write for Project 2. Your topic must fall under the foll..
Foundations of professional communication : Also called positive/neutral informative messages or routine announcements, Routine Informative Messages are a common type of Professional Communication. You are the human resources director for Easy to Be Green (EBG), an innovative new company that ..
Measurement in financial statements : What are two possible attributes to be measured when an item is to be included in financial state- ments? What unit of money is used to measure items in the United States?

Reviews

Write a Review

Operation Management Questions & Answers

  Most important step in the decision-making process

Why is identification of the real problem the first and most important step in the decision-making process? How does attribution theory explain mistakes that can be made as managers and employees work together to explain why the problem occurred?

  Define the type of organizational structure

Define the type of organizational structure you’ve chosen to investigate and briefly describe its pros and cons. Find an article (in the library or on the Internet) about a company that is structured this way. Chose a company that has sufficient info..

  Solve the lp relaxation of your model

Solve the LP Relaxation of your model in part (a). Solve for the optimal schedule of tellers. Comment on the solution.

  Handled by services in the neighboring community

The metropolis ambulance corporation owns 5 ambulances and services a portion of the metropolis area. on average, emergencies are reported every 20 minutes (the time between emergencies is exponentially distributed). What fraction of the emergencies ..

  How will potential scope changes

How will potential Scope Changes be addressed with regard to assessing the customers' needs in a competitive bid and remain competitive

  Consumer market using characteristics indentified in text

Describe your consumer market using the characteristics indentified in your text. Think about yourself and how you would describe yourself using these characterisitics. Are there other characterisitics that you could use to describe your "typical cus..

  Sub-contractor to assemble high technology product

Imagine that you have been assigned by senior management to select a sub-contractor to assemble a high technology product for the European market. Recommend a facility location. What type of manufacturing facility would you suggest? Also, explain the..

  Efficiency of the production operation

Research the process of producing an expensive product (assume that it is something that must cost at least $1,000). After learning the steps that must be accomplished to produce such a product, address the following:

  How consumers motivated to action

How are consumers motivated to action? Name a minimum of two motivational AND personality theories and evaluate the implication upon consumer behavior.

  Describe at least five ways in which social media

Describe at least 5 ways in which Social Media and digital technologies can give you the opportunity to expand your business opportunities at the global level.

  Project risks identification

Project Risks Identification, Thoroughly describe each project risk (at least 8), which includes the source for identifying the risk.

  Function and the interactions

Based on your observations of how the groups function and the interactions among the groups' members, answers to the following questions:

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd