Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 19QP
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
A heavy truck parts maker is able to tender on a pre-production study contract of a new type of truck ventilator unit worth $25,000 net profit if it wins the contract. Tendering costs would be about $2,000. The chances of winning the contract are 50 percent. If the company wins the contract, it must decide on the level of marketing it should make to increase its chances of getting further production contract worth $55,000 net profit. Promotion at a high level costs $18,000 with a resulting probability of winning the contract of 0.8. At medium level promotion, it costs $12,000 with a probability of 75 percent and at a low level, it costs $8,000 with a probability of 60 percent. Should the initial study contract be lost, the company can still bid on the production contract at an additional tender cost of $6,000. The probability of winning the production contract from this stage is 30 percent.
a) Draw a decision tree to show the relationship between the various options which arise as the…
Imagine you run a small apparel shop in rural India and positive about sales of T-shirt
this year (2021) due to good monsoon. You ‘signed a contract’ with manufacturer to buy 100
T-shirt of four different colors of equal numbers at Rs 200 each and paid advance 5000 Rs for
it. Manufacturer supplied all the T-shirt of same color. Discuss the remedy you have in your
hand against the manufac
WHAT IS THE TARGET MARKET OF TOYOTA SEDANS, TOYOTA SUV, AND TOYOTA TRUCKS?
Chapter 2 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
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 - American Auto is evaluating their marketing plan...Ch. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - Prob. 26QPCh. 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 - Prob. 1.10C
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
- Mulling over M & M In the 1930s Spanish Civil War, Forrest Mars saw soldiers eating chocolate pellets with a hard shell to carry these chocolates easily without the risk of melting. This gave him an idea, and the M&M’s Plain Chocolate Candies were introduced in the USA market in 1941. The product was a hit with the American soldiers and U.S. Army became its first big customer as it gave the soldiers an option to carry chocolate in tropical climates without melting. In 1949, the brand introduced the tagline “Melt in your mouth, not in your hand,” and this led to a considerable increase in its sales because it delivered on a solid insight, especially from parents who did not like to see their children making a mess when eating chocolate. M&M’s are button-shaped chocolate-filled candies with hard shells surrounding a filling which varies depending upon the type of M&M’s. The product is available in various colors – red, yellow, orange, brown, green, and blue. Initially,…arrow_forwardMulling over M & M In the 1930s Spanish Civil War, Forrest Mars saw soldiers eating chocolate pellets with a hard shell to carry these chocolates easily without the risk of melting. This gave him an idea, and the M&M’s Plain Chocolate Candies were introduced in the USA market in 1941. The product was a hit with the American soldiers and U.S. Army became its first big customer as it gave the soldiers an option to carry chocolate in tropical climates without melting. In 1949, the brand introduced the tagline “Melt in your mouth, not in your hand,” and this led to a considerable increase in its sales because it delivered on a solid insight, especially from parents who did not like to see their children making a mess when eating chocolate. M&M’s are button-shaped chocolate-filled candies with hard shells surrounding a filling which varies depending upon the type of M&M’s. The product is available in various colors – red, yellow, orange, brown, green, and blue. Initially,…arrow_forwardExplain the term Divisibility?arrow_forward
- Generally, how will the Travel Management Agency will be greatly affected with the evolution of OTAs (Online Travel Agencies)?arrow_forwardDesign the elements of the marketing mix for the electric cars you want to launch and that you think the company should consider to launch the electric carsarrow_forwardWhat factors will increases demand of a product? What factors will decrease demand of a product? What factors will increase supply? What factors will decrease supply? Need answer in short 1-3 sentences if possiblearrow_forward
- Golden arches align interstate highways to alert customers when there is a McDonalds located at next exit. There is no mention of the name McDonalds on these golden arches. The general public, by in large, as well as their customers know that a golden arch represents McDonalds. This refer to: Registered Brand Registered Trademark Registered design Registered logoarrow_forwardTake a trip to a shopping centre, mall or district within your community. Choose a retail store within this centre, such as a department store, DIY store, clothing shops or supermarket. The store you choose must be one that has the products displayed on shelves and which would allow shoppers to enter and walk around the aisles to view the products close up. Alternatively, you can visit your favourite supermarket so long as it allows you to enter the store, walk around the aisle and pick up your own grocery. Step 2: Once you have identified the store, enter the store and choose a product category within the store. Visit the product category and choose one product from this category to answer the follow questions in relation to that product Your Tasks Answer the follow questions in relation to that product which is Chebe hair shampoo Questions (1) Describe the product that you have chosen (2) Comment on the information provided on label (Informational or promotional)…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 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_forwardImagine you run a small apparel shop in rural India and positive about sales of T-shirtthis year (2021) due to good monsoon. You ‘signed a contract’ with manufacturer to buy 100T-shirt of four different colors of equal numbers at Rs 200 each and paid advance 5000 Rs forit. Manufacturer supplied all the T-shirt of same color. Discuss the remedy you have in yourhand against the manufacturer.arrow_forwardDuring each stage of a product's life cycle, the types and levels of sales, profits, and competition rise, peak, and eventually decline. The product life cycle defines the stages that new products move through as they enter, are established in, and ultimately leave the marketplace. In their life cycles, products pass through four stages: introduction, growth, maturity, and decline. The product life cycle offers a useful tool for managers to analyze the types of strategies that may be required over the life of their products. Even the strategic emphasis of a firm and its marketing mix (4Ps) strategies can be adapted from insights about the characteristics of each stage of the cycle. Read each statement and categorize it by the market attributes and consumer types that characterize each product life cycle stage. Place each item in the correct box on the chart. Intense competition Jonas Winnie Niche segment Sylvie Francine Low sales Opportunities increase Marketing costs (e.g., promotion,…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
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
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY