Coca cola forecast
5817 mots
24 pages
Project Outline: Final submission Statistics Coca-ColaDavid 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 Sales 11
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-Point Moving 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 data related 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 the