Vodka Harvard Case Solution & Analysis

ADA # 2:  Final Group Project

Research Objective:

• To critically evaluate the affect of advertising variables i.e. News, Print, Broad and Outdoor on total sales of vodka industry.
• To identify factors that impact of price per unit on the total sales of the vodka company.
• To determine how tiers along with domestic versus non-domestic brands impact the vodka industry.
• To evaluate the impact of advertising dollars spent to predict sales of the company.

Research plan and Methodology:

It is important to analyze the approach you get to know the effects of one variable to another. This section of the report aids information about the procedure and test that has been used in the project. In order to find out the trends in the vodka industry, method of survey research has been used to find the affect of advertising variables on total sales of the vodka industry. Data has been collected through survey, and the findings will be calculated from the data that has been extracted from it. Furthermore, the data has been collected from 30 brands of vodka for around fifteen years. In addition to that, correlation and regression analysis have been done to find a relationship between one variable or another. The main function served by correlation analysis is to analyze whether the two variables are fluctuating with each other or not. In regression analysis, the dependence of one variable on another has been evaluated. Further, ANOVAs function in R has been used as well to analyze and compare the scores of two models or variables.

Various variables have been used to analyze the impact of the overall environment of the Vodka industry. These variables include total sales along with all advertising media variables i.e. Print, News, Broad and Outdoor. Furthermore, price per unit, GDP, domestic and non-domestic variables have been used to analyze their impact on total sales. Moreover, unit sales of tier1, tier2 and tier 3 have been used as well. Finally, dollar sales have been analyzed with all the advertising media.

Findings from the data:

Total sales predicted by Print, News, Broad and Outdoor:

Figure 1 model summary

Figure 2 Anova

Figure 3: coefficients

Figure 4: Residuals statistics

After removing news advertising variable:

Figure 5: model summary removing advertising variable

Figure 6: anova (after removing advertising variable)

Figure 7: coefficients (after removing advertising variables)

Figure 8: residuals (after removing advertising variables)

R-square predicts the dependence of dependent variable over other independent variable.  Regression analysis has been done to analyze the impact of advertising variables that are Print, News, Broad and Outdoor on total sales in the Vodka industry. R-square in the model summary is 0.611 that means 61% of the variables are correlated with each other. R square of 61.1% indicates that in case advertising media has changed by 61.1% then total sales will change by 61.1% as well.

From the Anova table, one can see that the connection between the predictors and dependent variable is very significant.

The four predictors used in the model ..................

This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.

Related Case Solutions & Analyses:

Thunderball (C) Diageo and East African Breweries Ltd.: Tapping New Markets for Social Good International Finance Kalamazoo Zoo Temasek’s Offer to Buy Olam International Sino-Forest (A) KKR: Leveraging Sustainability Enman Oil, Inc. (D) Fundamental Enterprise Valuation: Invested Capital Rockboro Machine Tools Corporation