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
Question
Chapter 3, Problem 12QP
Summary Introduction
To develop: A spreadsheet model for the problem and solve it using solver.
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
Management of the Toys R4U Company needs to decide whether to introduce a certain new novelty
toy for the upcoming Christmas season, after which it would be discontinued. The total cost required
to produce and market this toy would be $500,000 plus $15 per toy produced. The company would
receive revenue of $35 for each toy sold.
Assuming that every unit of this toy that is produced is sold, write an expression for the profit in terms
of the number produced and sold. Then find the break-even point that this number must exceed to
make it worthwhile to introduce this toy.
Now assume that the number that can be sold might be less than the number produced. Write an
expression for the profit in terms of these two numbers.
Formulate a spreadsheet that will give the profit in part b for any values of the two numbers.
Write a mathematical expression for the constraint that the number produced should not exceed the
number that can be sold.
A 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…
Chapter 3 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Prob. 7QPCh. 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 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 27QPCh. 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 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 45QPCh. 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_forwardPlease do not give solution in image formate thanku.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
- Explain the importance of the Hamada equation.arrow_forwardMarcus 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_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_forward
- A 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_forwardThere are three types of Market coverage. Explain the type of market coverage applicable to Lorraine’s business.arrow_forwardABC Corporation has recently given out a nine-month contract to a construction subcontractor. At the end of the first month, it becomes obvious that the subcontractor is not reporting costs according to an appropriate WBS level. ABC Corporation asks the subcontractor to change its cost reporting procedures. The subcontractor states that this cannot be done without additional funding. This problem has occurred with other subcontractors as well. What can ABC Corporation do about this?arrow_forward
- Innovative Automotive is an automobile accessories company that has been in business for 15 years. The company’s director of research and development (R&D) has been asked by the president to develop a new product: an after-market accessory that attaches to any windshield wiper and helps solve the problem of removing bugs from the front windshield. This product needs to be developed, tested, patented (or patent-filed), and brought to market in 12 months. The R&D director, who has an industrial engineering background and a track record of successfully leading projects of this nature, has assigned you as an in-house project manager (PM) to this project. As the project manager: List the 3 primary characteristics of this product development project that qualify it to be considered a project. Describe a project initiation force that caused this project to be initiated. Explain why you chose the specific type of project. Summarize the project life cycle that will likely follow this…arrow_forwardOn With Living (OWL) is a nonprofit organization dedicated to improving the physical and mental health of individuals age sixty-five and older. It is a local chapter of a national organization, the OWL Association, which had been in existence for nearly thirty years. Both the local chapter and the national organizational offer programs and services to help seniors stay healthy and fund research to find ways to prevent, treat, and cure diseases that affect people over sixty-five, such as Alzheimer’s disease, diabetes, and heart disease. Each local chapter is obligated to adhere to the positions of the national organization, and any modification or rejection of the national position is prohibited according to the statement of relationship signed by both parties. Any violation of this relationship agreement would result in disaffiliation from the national organization, which local chapters attempt to avoid at all costs. One position statement of the national organization took a firm…arrow_forwardThe Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 140,000 18,000 30,000 Cost per advertisement $1,500 $200 $550 Maximum media usage 15 19 12 To ensure a balanced use of advertising media, radio advertisements must not exceed 45% of the total number of advertisements authorized. In addition, television should account for at least 15% of the total number of advertisements authorized. (a) If the promotional budget is limited to $24,100, how many commercial messages should be run on each medium to maximize total audience contact? If your answer is zero enter "0". No of commercial Advertisement Alternatives messages Television Radio Online What is the allocation of the budget…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,