Session 10b Decision Models -- Prof. Juran - PowerPoint Presentation

Session 10b

Decision Models -- Prof. Juran 2 Overview Marketing Simulation Models New Product Development Decision Uncertainty about competitor behavior Uncertainty about customer behavior Market Shares Modeling the dynamics of a 3-supplier market Customer loyalty Benefits of quality improvement Pricing Strategy American Airlines

Decision Models -- Prof. Juran 3 Marketing Example: New Product Development Decision Cavanaugh Pharmaceutical Company (CPC) has enjoyed a monopoly on sales of its popular antibiotic product, Cyclinol, for several years. Unfortunately, the patent on Cyclinol is due to expire. CPC is considering whether to develop a new version of the product in anticipation that one of CPC’s competitors will enter the market with their own offering. The decision as to whether or not to develop the new antibiotic (tentatively called Minothol) depends on several assumptions about the behavior of customers and potential competitors. CPC would like to make the decision that is expected to maximize its profits over a ten-year period, assuming a 15% cost of capital.

Decision Models -- Prof. Juran 4

Decision Models -- Prof. Juran 5 Customer Demand Analysts estimate that the average annual demand over the next ten years will be normally distributed with a mean of 40 million doses and a standard deviation of 10 million doses, as shown below. This demand is believed to be independent of whether CPC introduces Minothol or whether Cyclinol / Minothol has a competitor.

Decision Models -- Prof. Juran 6 CPC’s market share is expected to be 100% of demand, as long as there is no competition from AMI. In the event of competition, CPC will still enjoy a dominant market position because of its superior brand recognition. However, AMI is likely to price its product lower than CPC’s in an effort to gain market share. CPC’s best analysis indicates that its share of total sales, in the event of competition, will be a function of the price it chooses to charge per dose, as shown below. The Cyclinol product at $7.50 would only retain a 38.1% market share, whereas the Minothol product at $6.00 would have a 55.0% market share.

Decision Models -- Prof. Juran 7 Questions What is the best decision for CPC, in terms of maximizing the expected value of its profits over then next ten years? What is the least risky decision, using the standard deviation of the ten-year profit as a measure of risk? What is the probability that introducing Minothol will turn out to be the best decision?

Decision Models -- Prof. Juran 8 Income statement-like calculations for each of four scenarios 3 Forecasts: NPV in $millions for each decision Yes/No New Product Better U~(0, 1) (whether or not AMI enters market) N~(40, 10) (Total market demand)

Decision Models -- Prof. Juran 9

Decision Models -- Prof. Juran10

Decision Models -- Prof. Juran 11 Example: Market Shares Suppose that each week every family in the United States buys a gallon of orange juice from company A, B, or C. Let P A denote the probability that a gallon produced by company A is of unsatisfactory quality, and define P B and P C similarly for companies B and C.

Decision Models -- Prof. Juran 12 If the last gallon of juice purchased by a family is satisfactory, then the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, then the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C.

Decision Models -- Prof. Juran 13 Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. Thus, if a customer switches from brand A, there is probability B /( B + C ) that he will switch to brand B and probability C /( B + C ) that he will switch to brand C. Suppose that 1,000,000 gallons of orange juice are purchased each week. After a year, what will the market share for each firm be? Assume P A = 0.10, P B = 0.15, and P c = 0.20.

Decision Models -- Prof. Juran 14

Decision Models -- Prof. Juran 15

Decision Models -- Prof. Juran 16

Decision Models -- Prof. Juran 17 For brand A in week 2, this formula is calculated with: B7 - H7 + R7 + U7 = B8 For brand B in week 2, this formula is calculated with: C7 - I7 + V7 + O7 = C8 Brand C will have all of the total customers from the previous week minus the Brands A and B current customers, so =(SUM($B$7:$D$7)) - (SUM(B8:C8))

Decision Models -- Prof. Juran 18 Now recall that a binomial random variable X is an integer between 0 and n , viewed as the number of “successes” out of n “trials”. The binomial distribution assumes that there is a probability p of a success on any one trial, and that all trials are independent of each other. In this case, X is the number of gallons that are “bad”, n is the total number of gallons purchased of a particular brand, and p is the probability that any one gallon is “bad”.

Decision Models -- Prof. Juran 19

Decision Models -- Prof. Juran 20

Decision Models -- Prof. Juran 21 Note that we have used dollar signs in the cell references , so this can be copied down to the rest of the assumption cells in column H .

Decision Models -- Prof. Juran 22

Decision Models -- Prof. Juran 23 We can use the binomial distribution again here. The number of people who switch from Brand A to Brand B in any given week will be a binomial random variable, with n equal to the total number of people who abandon Brand A in that week, and p equal to the proportion of the non-Brand A market held by Brand B in that week, or B /( B + C ). (Recall that the problem asks us to “Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands.”)

Decision Models -- Prof. Juran 24 We’ll set up the n s for these binomial random variables in columns K, L, and M, using MAX functions as before to make sure that they never go below 1. In column N we calculate the proportion of non-A customers who buy B in the current week, once again using a MAX function to make sure this is never zero.

Decision Models -- Prof. Juran 25

Decision Models -- Prof. Juran 26 The number of A customers who switch from A to Brand C is calculated in column P; it is simply the difference between K7 and O7. We model the switching behavior of former B customers in columns Q, R, and S, and former C customers in columns T, U, and V. Finally, the various numbers of switchers are taken into account for the start of the next week in columns B, C, and D. All of the binomial assumptions (columns H, I, J, O, R, and U) get copied down through row 58, so we can model a 52-week year.

Decision Models -- Prof. Juran 27

Decision Models -- Prof. Juran 28 Suppose a 1% increase in market share is worth $10,000 per week to company A. Company A believes that for a cost of $1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of P A , P B , and P C as in part a.)

Decision Models -- Prof. Juran 29 There are a number of ways to approach this kind of issue. One elegant way is to run two simulations simultaneously, in which the only difference is (in this case) the different value for P A . We’ll run the same model as before, but add to it, in parallel, a second model in which P A = 0.05 instead of 0.10. The old model is in a worksheet called Part (a) and the new model is in a worksheet called Part (b).

Decision Models -- Prof. Juran 30

Decision Models -- Prof. Juran 31

Decision Models -- Prof. Juran 32

Decision Models -- Prof. Juran 33 Summary Marketing Simulation Models New Product Development Decision Uncertainty about competitor behavior Uncertainty about customer behavior Market Shares Modeling the dynamics of a 3-supplier market Customer loyalty Benefits of quality improvement Pricing Strategy American Airlines