conjoint analysis and segmentation (data analysis+business report)

Data Summary Consumer stated preferences (in Kirin stated [login to view URL] file) The data consists of 317 consumers rating the importance of 21 different beer attributes, one attribute at a time on a 9-point scale (where 0 means “not at all important to me,” and 9 means “very important to me”). This data was obtained through traditional survey asking people to indicate the importance of product attributes. The worksheets in the file include: • Raw segmentation data: the ratings on 9-point scales. Please see the case Exhibit 1 for the list of attributes. • Discrimination data: each person also reported their beer consumption, demographics, and psychographic information (such as “I like to take chances”). Please see the case Exhibit 2 for the list of measures. Consumer Preferences revealed through Conjoint Analysis (in Kirin conjoint [login to view URL] file) The data consists of the estimated preference part-worths of the same 317 consumers. Please see the case Exhibit 4 for the attributes and levels in the conjoint study. The worksheets in the file include: • Conjoint Template: including the attributes and levels in the conjoint study (rows 4 thru 11), the estimated preference part-worths (rows 14 thru 331), existing product designs (rows 334 thru 341), and Kirin new product design (rows 344 thru 351). • Discrimination data: This is the same “Discrimination data” in the Kirin stated [login to view URL] file mentioned above. Questions about Kirin’s Marketing Strategy What is your strategy (segmentation and targeting) for introducing the new Ichiban Shibori concept into the US import beer market? More specifically, answer the following questions based on your analyses. Information given in the case is sufficient for you to address these questions. You do not need to do additional information research. 1. Consider segmenting import beer drinkers using generic needs information collected through traditional survey (Kirin stated [login to view URL]). a. How many clusters would you recommend? Justify your choice. b. Which segment would you consider to fit with the new Ichiban Shibori beer? Explain why. c. Would you agree that the import beer market could be segmented in a useful way using the traditional stated preferences data? Explain why or why not. 2. Consider segmenting import beer drinkers based on the revealed preferences from the conjoint study (Kirin conjoint [login to view URL]). Note: use the estimated part-worths preferences as the segmentation data (range A14-W331). a. Identify the appropriate number of segments. Justify your choice. b. Describe how different each segment is in terms of import beer preferences. c. Give the segments managerially useful names and note the size of each segment. Hint: you will need to know the characteristics of each segment in order to come up with names. The segment names can be given based solely on beer preferences if discriminant variables do not provide sufficient distinctions across different segments. d. Select which segment you would like to target with the new Ichiban Shibori beer concept. Explain your targeting decision. 3. Using the market simulator in conjoint analysis, predict market shares for the proposed new Kirin beer and another five alternative options that Kirin could consider varying the calorie and packaging designs. Note: use the “share of preference rule” under “Choice Rule” when running the market share simulation. a. Report the market shares for each of the six new product combinations. b. Report which combination maximizes Kirin’s total market share. c. Given the product design that maximize market share in point b, how would it affect the volume sales of the original Kirin beer? Treat the existing product profile “Sapporo/Kirin Old” as a representation of the original Kirin beer. The sales of the original Kirin is one million cases per year (page 5 of the case).