Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 7QP
Refer to question 19 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver.
19. 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
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Michael is the marketing executive of SHOPEE and he is planning to launch the 2.2.22 online SALE through price discounts, either 40% off or 20% off. He also learned that SHOPEE closest competitor LAZADA , is planning to promote also a 2.22.22 online SALE with price discounts , either 50% off or 30% off. If SHOPEE launches the 40% off, it will gain nothing. If LAZADA launches the 50% off or gain 8,000,000 if LAZADA launches the 30% off. If SHOPEE launches the 20% off, it will lose 2,000,000 if LAZADA launches the 50% off or lose 5,000,000 if LAZADA launches the 30% off.
1.Which strategy is dominated by SHOPEE depending on strategy of LAZADA?
A. 50% OFF
B. 40% OFF
C. 20% OFF
D. 30% OFF
E. NONE
2.What should be the strategy of LAZADA?
A. 50% OFF
B. 40% OFF
C. 30% OFF
D. 20% OFF
Emily works for a small software company and oversees software quality assurance. The company recently developed an inventory control system for a national clothing manufacturer. The system gathers sales information on an hourly basis from clothing retailers nationwide. This information is then used by all departments (including the accounting, shipping, and ordering departments) to control the functions of the clothing manufacturer.
Emily suspects that the inventory functions of the system are not sufficiently tested, although they have passed all their contracted (legal) tests. However, she is pressured by her employers to sign off on the software. Whilst she is only required to perform tests which have been agreed to in the original contract, her considerable experience in software testing has led her to be concerned over the quality of the system. Her employers say that they will go out of business if they do not deliver the software on time.
Emily knows that if any section of…
Please do not give solution in image formate thanku.
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
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
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forwardA product manager at Clean & Brite (C&B) wants to determine whether her company should market a new brand of toothpaste. If this new product succeeds in the marketplace, C&B estimates that it could earn $1,800,000 in future profits from the sale of the new toothpaste. If this new product fails, however, the company expects that it could lose approximately $750,000. If C&B chooses not to market this new brand, the product manager believes that there would be little, if any, impact on the profits earned through sales of C&B’s other products. The manager has estimated that the new toothpaste brand will succeed with probability 0.50. Before making her decision regarding this toothpaste product, the manager can spend $75,000 on a market research study. Based on similar studies with past products, C&B believes that the study will predict a successful product, given that product would actually be a success, with probability 0.75. It also believes that the study will…arrow_forwardNissan is introducing a new model, the 2022 Rogue, and wants to mail promotional material to potential customers that are most likely to buy. The Nissan brand manager has $50,000 for this campaign and each promotional mailer costs $1.25. Through its own data collection practices as well as data purchases, Nissan has a database of 120,000 people (each with a number of important attributes) who have received similar mailers in the past and whether or not an automobile purchase was made. Nissan has a second database (of potential customers) with the same attributes that they would like to market the new Rogue to. What is an appropriate business analytic technique to obtain new buyers in the most cost effective manner? classification tree analysis traditional regression analysis Omarket basket analysis O analysis of variancearrow_forward
- There are three types of Market coverage. Explain the type of market coverage applicable to Lorraine’s business.arrow_forwardA salesperson has been trying to create a competitive market analysis (CMA) for a potential listing. The immediate neighborhood has many bank owned foreclosure properties, which seem to have depressed the prices showing up in public records and on the MLS system. In this case, the salesperson A: Can seek similar properties from a neighborhood across town with fewer foreclosures to use as "comps" B: Cannot use a CMA since it will not show true market value. The broker should ask the sellers what they want for their home and list at that price. C: Should advise the sellers to rent their present home until the market improves. This way they can have an additional income to allow them to move up to a better home in a better neighborhood. The broker could then seek to sell the rented home to a house flipper as an investment. D: Should seek any non-foreclosure "arm's length" transactions for properties similar to her subject property in the same or nearby neighborhoods. Even if their prices…arrow_forwardOn Monday evenings in April 2015, each episode of WWE Entertainment was typically watched by 3.8 million viewers, while each episode of American Dad was typically watched by 1.5 million viewers.† Your marketing services firm has been hired to promote Gauss Jordan sneakers by buying at least 30 commercial spots during episodes of WWE Entertainment and American Dad. You have been quoted a price of $4,000 per spot for WWE Entertainment and $1,000 per spot for American Dad. Gauss Jordan, Inc.'s advertising budget for TV commercials is $130,000, and it would like at least 75% of the total number of spots to appear on WWE Entertainment. How many spots should you purchase on each show to maximize exposure? HINT [Calculate exposure as Number of ads ✕ Number of viewers.] (If an answer does not exist, enter DNE.) WWE ______ Spots American Dad _______ spotsarrow_forward
- Andy’s Bicycle Company (ABC) has the hottest new product on the upscale toy market—boys’ and girls’ bikes in bright fashion colors, with oversize hubs and axles; shell design safety tires; strong padded frames; chrome-plated chains, brackets, and valves; and non-slip handlebars. Due to the seller’s market for high-quality toys for the newest baby boomers, ABC can sell all the bicycles it manufactures at the following prices: boys’ bikes, $220; girls’ bikes, $175. This is the price payable to ABC at its Orlando plant. The firm’s accountant, V. R. Dondeti, has determined that direct labor costs will be 45% of the price that ABC receives for the boys’ model and 40% of the price received for the girls’ model. Production costs, other than labor but excluding painting and packaging, are $44 per boys’ bicycle and $30 per girls’ bicycle. Painting and packaging are $20 per bike, regardless of model. The Orlando plant’s overall production capacity is 390 bicycles per day. Each boys’…arrow_forwardThe Northwoods General Store in Vermont sells a variety of outdoor clothing items and equipment and several food products at its modern but rustic-looking retail store. Its food products include salmon and maple syrup. The store also runs a lucrative catalog operation. One of its most popular products is maple syrup, which is sold in metal half-gallon cans with a picture of the store on the front. Maple syrup was one of the first products the store produced and sold, and it continues to do so. Setting up the syrup-making equipment to produce a batch of syrup costs $450. Storing the syrup for sales throughout the year is a tricky process because the syrup must be kept in a temperature-controlled facility. The annual cost of carrying a gallon of the syrup is $15. Based on past sales data, the store has forecasted a demand of 7,500 gallons of maple syrup for the coming year. The store can produce approximately 100 gallons of syrup per day during the maple syrup season, which runs from…arrow_forwardDiscuss and explain 4 challenges a salesperson may encounter when prospecting for new customers. Describe how you will resolve the following scenario: You are a Salesperson for a local ticket company, and you have been given the task of selling seasonal tickets for upcoming games in your hometown. A middle-aged married couple has expressed interest in buying 2 tickets for a football game. However, they are concerned that they may be out of town on some weekends when there are home games and they do not want their tickets to go to waste. Based on your understanding of prospecting and qualifying, what solutions would you offer to the couple in an effort to overcome their objections?arrow_forward
- Marcus is a computer engineer who has recently developed an app which helps userskeep track of medical information, doctor’s appointments, and prescriptions.Information about the user is stored in this app, including what prescriptions they aretaking and how frequently they schedule doctor’s appointments. As the developers ofthe app, Marcus and his company have access to this information.The marketing department requests Marcus supply them with customer-specificinformation so they can better target ads and app suggestions to the users. Marcusunderstands that he is part of a company, but also feels that the privacy of the appusers should be protected. Additionally, Marcus feels that as an engineer, he should beresponsible to those who use his technology.Note that Marcus is not a healthcare provider, nor does he work for a medicalfacility. As you plan your answer, consider the current healthcare and legal climatesand concerns that may exist relating to individuals' healthcare choices. 1.…arrow_forwardA television station may either extend a current television show for another season or develop a completely new show for that time slot. It will cost $6M to develop the new show. The new show may be very successful, moderately successful, or not successful with associated advertising revenues of $25M, $15M, or $5M, respectively. If the station chooses to extend the current show, it will cost $2M. The extended show may be very successful, moderately successful, or not successful with associated advertising revenues of $15M, $10M, or $5M, respectively. Which of the following are true? A. There are a total of six branches in the entire decision tree. B. There are eight leaves or terminal nodes in the entire decision tree. C. There is one event node in the decision tree. D. None of the abovearrow_forwardExplain the importance of the Hamada equation.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License