Quality Kitchens Mix Report
1
2
Table of Contents
Executive Summary ................................................................................................... 3 Challenge ................................................................................................................... 3 Data Analysis ............................................................................................................. 3
Variables identification .......................................................................................................................... 3 Scatter Plots .......................................................................................................................................... 4 Correlation ............................................................................................................................................. 4 Regression ............................................................................................................................................ 4 Answers to Questions ................................................................................................ 6
Appendices................................................................................................................. 7
Appendix 1: Scatter Plots ...................................................................................................................... 7 Appendix 2: Correlation ......................................................................................................................... 8
3
Executive Summary
Sally Franklin, who has recently joined AFP (amalgamated Food Products) as a meat loaf brand manager, is asked to prepare a sales forecast and a budget for promotion and advertising for the next year. She collected historical data over the past 24 quarters, which illustrates high sales variability as well as expenditures variations, as a consequence of many factors: general economic index,
2
Table of Contents
Executive Summary ................................................................................................... 3 Challenge ................................................................................................................... 3 Data Analysis ............................................................................................................. 3
Variables identification .......................................................................................................................... 3 Scatter Plots .......................................................................................................................................... 4 Correlation ............................................................................................................................................. 4 Regression ............................................................................................................................................ 4 Answers to Questions ................................................................................................ 6
Appendices................................................................................................................. 7
Appendix 1: Scatter Plots ...................................................................................................................... 7 Appendix 2: Correlation ......................................................................................................................... 8
3
Executive Summary
Sally Franklin, who has recently joined AFP (amalgamated Food Products) as a meat loaf brand manager, is asked to prepare a sales forecast and a budget for promotion and advertising for the next year. She collected historical data over the past 24 quarters, which illustrates high sales variability as well as expenditures variations, as a consequence of many factors: general economic index,