Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 26QP
American Auto is evaluating their marketing plan for the sedans, SUVs, and trucks they produce. A TV ad featuring this SUV has been developed. The company estimates each showing of this commercial will cost $500,000 and increase sales of SUVs by 3% but reduce sales of trucks by 1% and have no effect of the sales of sedans. The company also has a print ad campaign developed that it can run in various nationally distributed magazines at a cost of $750,000 per title. It is estimated that each magazine title the ad runs in will increase the sales of sedans, SUVs, and trucks by 2%, 1%, and 4%, respectively. The company desires to increase sales of sedans, SUVs, and trucks by at least 3%, 14%, and 4%, respectively, in the least costly manner.
- a. Formulate an LP model for this problem
- b. Sketch the feasible region.
- c. What is the optimal solution?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
What sporting event is televised in 170 countries and has created a quasi–national holiday in the United States? The Super Bowl is considered by football fans as the ultimate game and known as the largest advertising opportunity for media companies that broadcast the game and companies that want to reach a large audience. The history of impactful advertising shown as part of Super Bowl viewing includes the famous 1984 Apple advertisement that “breaks” the PC wall. The ad was only shown once, but it is recognized as one of the most iconic moments in the history of advertising.
In recent years companies have used football’s popularity and the Super Bowl as a global program to get their message out to a worldwide audience. While the high cost of advertising during the Super Bowl may deter some advertisers, the impact of an ad like Clint Eastwood’s 2012 “Halftime in America” for Chrysler or the 2017 Heinz “Dachhund” ad has been hailed as dramatic and created buzz that ads running in…
Streaming service, Netflix has come up with a new ad film that highlights ‘Sabki pasand wala Netflix; Apni pasand wala Netflix’.The ad has been released shortly after Netflix reduced its subscription rates by up-to 60% for India market. The ad attempts to attract customer amidst growing competition from Amazon Prime, Hotstar etc.The ad film, whose set up is based on an arranged marriage meet. One of the boy’s family member asks the girl ‘Netflix pe kya dekhti ho? In a naughty manner the girl replies ‘Hum Saath Saath hain, Hum Aake Hain Kaun’. The family is delighted to hear the reply. All this while the boy conveys the impression that he is not impressed by her choice of movies. The girl then whispers to the boy ‘Stranger Things, Money Heist aur Narcos Bhi Dekhti hoon’.The ad finishes with tag line followed highlighting the new reduced Prices.The ad film intelligently provides the range of content available on Netflix i.e. Hindi movie content for Audience in the older age group 45 and…
Every Monday during the month of December salespeople who had the highest sales the previous week participated in a package surprise where each would receive a package containing either a $50 or a $100 bill. This short-term incentive is known as a
Chapter 2 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 2 - Prob. 1QPCh. 2 - Prob. 2QPCh. 2 - Prob. 3QPCh. 2 - Prob. 4QPCh. 2 - Prob. 5QPCh. 2 - Prob. 6QPCh. 2 - Prob. 7QPCh. 2 - Prob. 8QPCh. 2 - Prob. 9QPCh. 2 - Prob. 10QP
Ch. 2 - Prob. 11QPCh. 2 - Prob. 12QPCh. 2 - Prob. 13QPCh. 2 - Prob. 14QPCh. 2 - Prob. 15QPCh. 2 - Prob. 16QPCh. 2 - Prob. 17QPCh. 2 - Prob. 18QPCh. 2 - Prob. 19QPCh. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 2 - Prob. 1.1CCh. 2 - Prob. 1.2CCh. 2 - Prob. 1.3CCh. 2 - Prob. 1.4CCh. 2 - Prob. 1.5CCh. 2 - Prob. 1.6CCh. 2 - Prob. 1.7CCh. 2 - Prob. 1.8CCh. 2 - Prob. 1.9CCh. 2 - For the Lines They Are a-Changin (with apologies...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Mercedes-Benz introduced the C-class using a single, comprehensive advertising campaign, with the slogan "C-for yourself", developed by the agency BBDO France. This type of a campaign is the reflection of adaptive advertising strategy in the auto industry. True Falsearrow_forwardAfter a targeted segment of kids under twelve was chosen by a sugar cookie company, the company decided on its marketing mix to that segment. When deciding on a price strategy for its cookies, what questions should the company ask ? a. where does your segment look for or shop for your product? b. What do you want your segment to remember about your product ? c. How much is expensive or too cheap?arrow_forwardThe first step in implementing the marketing concept is to provide a product that satisfies customers; True or Falsearrow_forward
- After a targeted segment of kids under twelve was chosen by a sugar cookie company, the company had to decide on its marketing mix to that segment. When deciding on a price strategy for its cookies, what questions should the company ask?arrow_forwardJohn wants to promote his ketchup product that is a mix of Banana and Tomato flavors. Since he is just starting his business venture, he first considered the people of Davao City to be his target market. He set aside ₱ 100,000 from his savings to start his ketchup business, and planned to price his product at around ₱ 23 per bottle. Using the different promotional mix tool, what promotional mix tool can John use to promote his product? Choose two (2) and explain your answer.arrow_forwardMany insurance companies sell health insurance plans to companies. In these companies the em- ployees pick the plan, but the set of offered plans is determined by the company. Recently, Blue Cross–Blue Shield, a health insurance company, ran a television ad stating, “If your employer doesn’t offer you Blue Cross–Blue Shield cover- age, ask why.” Explain the promotional strategy behind the advertisement.arrow_forward
- Boy Bawang, Marty’s vegetable chicharron, and similar snacks became popular and successful via outdoor advertising, word of mouth, and product placement on different TV programs such as Wowowin and reality show without the usual tri-media (TV, radio, print ads) campaign. Some ads are on populous locations in EDSA, Quiapo, Espana, and Divisoria area. They also use transit ads such as RCGC bus, G liner, and other provincial buses to communicate their ads. This impact very well, especially on the mass market. W.L. Foods PRODUCTS is one of the biggest manufacturers of snack foods in the Philippines. The company was established in August 1986 and started in the production of good quality Cheez-Zum snack. Just like other small beginners, the company also experienced hard times penetrating the market at that time. With the successful results of this brand, we should investigate certain circumstances. Question:Why do some products of W.L. Foods do the same outdoor advertising and product…arrow_forwardJohn wants to promote his ketchup product that is a mix of Banana and Tomato flavors. Since he is just starting his business venture, he first considered the people of Davao City to be his target market. He set aside ₱ 100,000 from his savings to start his ketchup business, and planned to price his product at around ₱ 23 per bottle. Using the different promotional mix tool, what promotional mix tool can John use to promote his product?arrow_forwardBelow is an actual job description for a sourcing and procurement internship position that was available at Disney Consumer Products/Studios. Based on the information in the job description, create accountabilities, objectives, and standards for this position. TITLE Graduate Associate, Sourcing, & Procurement (Disney Consumer Products/Studios) THE POSITION Provide analytical support for sourcing projects impacting business units, specifically targeting Disney Consumer Products & Studios. Benchmark current pricing models and develop new approaches to pricing/buying various products and services that yield creative and business advantage. Support the continuing efforts to increase the percentage of spend influenced, specifically as it relates to business units where we have had only a minor impact. Assist in the development of spend profiles, key stakeholder lists, savings opportunities where existing contracts are leveraged, savings opportunities in commodity areas that…arrow_forward
- marketing material portfolio design a mock up of an instagram story that could in theory be published by amazon south africaarrow_forwardA hotel chain’s database has information on guests thatincludes demographics, number of visits, and roompreferences. Describe how the chain can use this information to develop several relationship marketing programs.How can it use a more general database to identify potentialcustomers and personalize its communications with them?arrow_forwardA product is anything that can be offered in a market for attention, acquisition, use, or consumption that might satisfy a need or want. Products can be classified into consumer products and industrial products. List and briefly explain the four classifications of consumer products and provide examples for each.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY