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).

Készségek: Adatbevitel, Adatfeldolgozás, Excel

Bővebben: when to use conjoint analysis, creating a conjoint analysis, basic conjoint analysis, conjoint data, conjoint analysis attributes, conjoint analysis cards, conjoint analysis project, conjoint analysis regression, business analysis financial analysis data entry writing, business analysis, financial analysis, data entry, data entry , finance, business report , data entry and analysis data in excel, business analysis data analysis, business report data collection, data entry report analysis, data analysis business report excel findings, presentation layer business layer data layer report, mondrian analysis data cube, analysis data done qualitative research, search data php mysql use date range

A munkaadóról:
( 1 értékelés ) Minneapolis, United States

Projektazonosító: #16736228

5 szabadúszó tett átlagosan $133 árajánlatot erre a munkára


Hello SC0273, I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and can complete task within time with 100% accuracy.I am very re Több

$100 USD 3 napon belül
(426 vélemény)

Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things

$100 USD 3 napon belül
(5 vélemény)

Hello there, I am a marketing analytics consultant with more than 6 years of experience working with clients across the globe on segmentation related projects. With over 40 segmentation projects completed in pa Több

$200 USD 3 napon belül
(7 vélemény)

I am recently retired after being the Head of IT for a major fashion retailer. I worked in a high intensity environment working an average 60 hours per week. I needed to slow down, however I now find I still need to ke Több

$155 USD 3 napon belül
(2 vélemény)

I am an excel expert, good at data analysis and consolidation. I can get this job done in 1 day. Thank you for your consideration. Lu

$111 USD 1 napon belül
(1 Visszajelzés)