Coca cola forecast

Disponible uniquement sur Etudier
  • Pages : 24 (5817 mots )
  • Téléchargement(s) : 0
  • Publié le : 20 juin 2010
Lire le document complet
Aperçu du document
Project Outline: Final submission Statistics Coca-Cola

David S

[pic]

Course Title: Statistic

Sommaire

I. INTRODUCTION: 5
II. Presentation and description of data (SEE APPENDIX 1) 6
III. ESTIMATION OF GROWTH IN PERCENTAGE CHANGE: 6
3.1. Sales: 6
3.2. Cost: 7
3.3. Net Profit: 9
IV. CENTRAL TENDENCY AND SPREAD DISPERSION: 11
4.1. Central tendency and spread dispersion for Sales11
4.2. Central Tendency and spread dispersion for cost 11
4.3. Central Tendency and spread dispersion for net profit 12
V. CORRELATION COEFICIENT: 13
5.1. Correlation between Costs and Net Profit : 13
5.2. Correlation between Sales and Net Profit: 14
VI. FORECAST 15
6.1. Forcasting explanation : 15
6.2. Forecasting Interpretation: 16
6.2.1. Graphical 16
6.2.2. Sales Forecast 17
6.2.3.Costs Forecast 17
6.2.4. Net Profit Forecast 18
6.3. Further comment: 19
VII. CONCLUSION: 20
List of Reference: 21
List of Appendix 23
Appendix 1 : Actual Sales, Costs and Net Profit of Coca-Cola 23
Appendix 2.1 : Correlation between Sales and Net Profit 24
Appendix 2.2 : Correlation between Costs and Net Profit 25
Appendix 3.1 : 5-Point Moving Average of Sales 26
Appendix 3.2 : 5-PointMoving Average of Costs 27
Appendix 3.3 : 5-Point Moving Average of Net Profit 28
Appendix 4.1 : Linear Regression Model for Sales 29
Appendix 4.2 : Linear Regression Model for Costs 30
Appendix 4.3 : Linear Regression Model for Net Profit 31
Appendix 5 : Linear Regression with Adjustment for Sales, Costs & Net Profit 32

I. INTRODUCTION:

We chose to gather and analyze the datarelated to the Coca-Cola Company, which is on their say “Lead the beverage industry with nearly 500 beverage brands -- including four of the world's top-five sparkling brands” (Coca-Cola Company). In our data selection, we decided to cover the company’s results for 16 periods of one year, starting from 1992. The main source of data related to the company’s financial results was found on thewebsite of Coca-Cola where diverse rapports and statements can be found and uploaded. Based on those documents, we putted together an ensemble of tables and graphs in order to present in a clear way costs, sales and net profits data. This data collection and organization allowed us to make critical analysis including calculating correlation analysis, and diverse averages that can help us understandingCoca-Cola’s behavior and evolution. The final aim is, by including external elements influencing the company’s context, to be able to forecast results for the years 2009 and 2010, and be able to explain which one to focus on to be as precise as possible.

II. Presentation and description of data (SEE APPENDIX 1)

Figure 1:
[pic]

III. ESTIMATION OF GROWTH IN PERCENTAGE CHANGE:1. Sales:

Figure 2 : Percentage change in Sales

|Year |Sales |% Change in Sales |
|1993 |12.527 |0.00% |
|1994 |14.570 |16.31% |
|1995 |16.283 |11.76%|
|1996 |16.635 |2.16% |
|1997 |16.611 |-0.14% |
|1998 |16.301 |-1.87% |
|1999 |16.767 |2.86% |
|2000|17.354 |3.50% |
|2001 |17.545 |1.10% |
|2002 |19.564 |11.51% |
|2003 |21.044 |7.56% |
|2004 |21.742 |3.32%...
tracking img