Hi
Has anyone used predictive forecasting in Excel, before?
If so, your thoughts would he appreciated here:
I need to answer two questions using the data below, which apparently has a predictable pattern that should be used to generate forecasts for the different food types.
i) which food type will sell the most in Q1 of 2015? and
ii) which food type will sell the most in the whole of 2015?
Has anyone done something like this before?
TIA
Has anyone used predictive forecasting in Excel, before?
If so, your thoughts would he appreciated here:
I need to answer two questions using the data below, which apparently has a predictable pattern that should be used to generate forecasts for the different food types.
i) which food type will sell the most in Q1 of 2015? and
ii) which food type will sell the most in the whole of 2015?
Has anyone done something like this before?
TIA
Food type | 2012 Q1 | 2012 Q2 | 2012 Q3 | 2012 Q4 | 2013 Q1 | 2013 Q2 | 2013 Q3 | 2013 Q4 | 2014 Q1 | 2014 Q2 | 2014 Q3 | 2014 Q4 | 2015 Q1 | 2015 Q2 | 2015 Q3 | 2015 Q4 |
Chocolate | 21,000 | 32,000 | 19,000 | 21,000 | 26,000 | 13,000 | 6,000 | 3,000 | 1,000 | 1,000 | 1,000 | 1,000 | ||||
Crisps | 29,000 | 44,000 | 27,000 | 30,000 | 36,000 | 18,000 | 9,000 | 5,000 | 3,000 | |||||||
Peas | 43,000 | 65,000 | 39,000 | 43,000 | 53,000 | 26,000 | 13,000 | |||||||||
Pizza | 58,000 | 87,000 | 52,000 | 57,000 | 69,000 | |||||||||||
China | 37,000 | 55,000 | 33,000 | 36,000 | ||||||||||||
UK | 28,000 | 42,000 | 25,000 | |||||||||||||
Japan | 22,000 | 33,000 | ||||||||||||||
Brazil | 21,000 | |||||||||||||||
Total | 21,000 | 32,000 | 19,000 | 50,000 | 70,000 | 83,000 | 101,000 | 136,000 | 186,000 | 198,000 | 186,000 | 201,000 |
| | | | | | | | | | | |