A food company is considering three different salad dressings to introduce nationally, Dressing A, B, and C. They also have the option to not introduce any dressing this year. The profits from dressings A, B, and C are $1,144,712, $1,515,938, and $2,525,542 respectively if the national market is favorable. However, if the national market is unfavorable, the losses are $555,615, $758,875, and $912,435 respectively. Historical data shows a probability of 0.568 for a favorable national market. The company can test the market for salad dressings in selected geographic areas before introducing them nationally. The cost of the test market is $53,331. In the past, the probability of a negative test market was 0.354. Given a positive test market, a favorable national market was actually observed with a probability of 0.745. Given a negative test market, a favorable national market was actually observed with a probability of 0.304. Determine if the company should test the market before introducing their products nationally, using a decision tree (Make a decision tree). What is the EMV of the best decision?

A food company is considering three different salad dressings to introduce nationally, Dressing A, B, and C. They also have the option to not introduce any dressing this year. The profits from dressings A, B, and C are $1,144,712, $1,515,938, and $2,525,542 respectively if the national market is favorable. However, if the national market is unfavorable, the losses are $555,615, $758,875, and $912,435 respectively. Historical data shows a probability of 0.568 for a favorable national market. The company can test the market for salad dressings in selected geographic areas before introducing them nationally. The cost of the test market is $53,331. In the past, the probability of a negative test market was 0.354. Given a positive test market, a favorable national market was actually observed with a probability of 0.745. Given a negative test market, a favorable national market was actually observed with a probability of 0.304. Determine if the company should test the market before introducing their products nationally, using a decision tree (Make a decision tree). What is the EMV of the best decision?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

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?
If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.
Rand Enterprises is considering a number of investment possibilities. Specifically, each investment under consideration will draw on the capital account during each of its first three years, but in the long run, each is predicted to achieve a positive net present value (NPV). Listed here are the investment alternatives, their net present values, and their capital requirements, and all figures are in millions of dollars. In addition, the amount of capital available to the investments in each of the next three years is predicted to be $20 million, $12 million, and $20 million, respectively. Project One-PhaseExpansion Two-PhaseExpansion TestMarket AdvertisingCampaign BasicResearch PurchaseEquipment NPV 5.0 8.1 11.6 5.3 10.4 4.2 Year 1 Capital 3.6 3.0 7.2 2.4 6.0 1.2 Year 2 Capital 1.2 4.2 4.8 1.8 1.2 0.6 Year 3 Capital 4.8 4.2 6.0 2.2 4.8 1.1 In addition, the following constraints have to be met: a. The expansion investments are mutually exclusive and only one of…
Company A proposes a customer loyalty plan, and customers can get reward points for purchasing product A for $100. This reward point can be redeemed for product B for free, or purchase product C, product B and merchant C at a discounted price of $30 The normal stand-alone selling prices of the products are $20 and $50 respectively. Company A estimates that 60% of customers would choose to redeem B for free Commodity, 40% of customers will choose to purchase Commodity C at a discounted price of $30, then the transaction price should be shared among the rewards What is the amount of incentive points? (A)$10.71 (B)$16,67 (C)$19.35 (D)$24.24
A firm that plans to expand its product line must decide whether to build a small or a large facilityto produce the new products. If it builds a small facility and demand is low, the net present valueafter deducting for building costs will be $400,000. If demand is high, the firm can either maintainthe small facility or expand it. Expansion would have a net present value of $450,000, and maintaining the small facility would have a net present value of $50,000.If a large facility is built and demand is high, the estimated net present value is $800,000. If demandturns out to be low, the net present value will be – $10,000.The probability that demand will be high is estimated to be .60, and the probability of low demandis estimated to be .40.a. Analyze using a tree diagram.
A firm that plans to expand its product line must decide whether to build a small or a large facilityto produce the new products. If it builds a small facility and demand is low, the net present valueafter deducting for building costs will be $400,000. If demand is high, the firm can either maintainthe small facility or expand it. Expansion would have a net present value of $450,000, and maintaining the small facility would have a net present value of $50,000.If a large facility is built and demand is high, the estimated net present value is $800,000. If demandturns out to be low, the net present value will be – $10,000.The probability that demand will be high is estimated to be .60, and the probability of low demandis estimated to be .40. 1- Compute the EVPI 2- Determine the range over which each alternative would be best in terms of the value of P ( low demand )
A small strip-mining coal company is trying to decide whether it should purchase or lease a new clamshell. If purchased, the “shell” will cost $152,500 and is expected to have a $50,000 salvage value after 6 years. Alternatively, the company can lease a clamshell for only $16,000 per year, but the lease payment will have to be made at the beginning of each year. If the clamshell is purchased, it will be leased to other strip-mining companies whenever possible, an activity that is expected to yield revenues of $9,000 per year. If the company’s MARR is 13% per year, should the clamshell be purchased or leased on the basis of a future worth analysis? Assume the annual M&O cost is the same for both options. The future worth when purchased is $ The future worth when leased is $
Place-Plus, a real estate development firm, is considering several alternative development projects. These include building and leasing an office park, purchasing a parcel of land, and building an office building to rent, buying and leasing a warehouse, building a strip mall, and building and selling condominiums. The financial success of these projects depends on interest rate movement in the next 5 years. The various development projects and their 5-year financial return (in €1,000,000s) given that interest rates will decline, remain stable, or increase, are shown in the following image of the payoff table: a) Place-Plus is dissatisfied with the economist’s estimate of the probabilities of future interest rate movement, so it is considering having a financial consulting firm provide a report on future interest rates. The consulting firm can cite a track record which shows that 80% of the time when interest rates declined, it had predicted they would, whereas 10% of the time when…
A company is considering two options for supplying a product to three markets, Markets 1, 2, and 3, with uncertain demands. The demand in each of the three markets can be either 50 units (high demand) or 10 units (low demand). The probabilities for Market 1 to have high and low demands are equal to 0.5 and 0.5, respectively. The probabilities for Market 2 to have high and low demands are equal to 0.6 and 0.4, respectively. The probabilities for Market 3 to have high and low demands are equal to 0.25 and 0.75, respectively. With the first supply option, the company will use three local warehouses, one to supply each market (the decentralized strategy). Each local warehouse will keep 28 units of inventory. (Therefore, the total inventory under the first supply option is equal to 84 units.) With the second supply option, the company will use a central warehouse to supply the three markets (the centralized strategy). The central warehouse will keep 84 units of inventory (so that the two…
What combination of x and y will yield the optimum for this problem? Maximize $10x + $4y, subject to (1) 5x + 3y ≤ 15 and (2) 3x + 6y ≤ 18 and (3) x, y ≥ 0.
Debbie Gibson is considering three investment options for a small inheritance that she has just received-stocks, bonds, and money market. The return on her investment will depend on the performance of the economy, which can be strong, average, or weak. If the market is strong her returns are 9% for stocks, 6% for bonds and 4% for money market. If the market is average her returns are 5% for stocks, 4% for bonds and 6% for money market. If the market is weak her returns are -7% for stocks, 2% for bonds and 1% for money market. (Round values to the nearest hundredths of a percent). a) Create a decision table and a decision tree. b) Which investment should Debbie choose if she uses the maximax criterion? What are the returns? c) Which investment should Debbie choose if she uses the maximin criterion? What are the returns? d) Which investment should Debbie choose if she uses the equally likely criterion? What are the returns? e) Which investment should Debbie choose if she uses the…
During the year, Brownout Company experienced the following power outages:Number of Power Outages Per Month Number of Months 0 3 1 2 2 4 3 3 12Each power outage results in out of pocket costs of P400. For P500 per month, the company can lease an auxiliary generator to provide power during outages. If the company leases an auxiliarygenerator next year, the estimated savings (or…