Sales Forcasting

Hello, I am struggling with a question regarding trends and I would be most grateful if someone could help me with this

I have the following information:
Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec
Turnover: 86.00 98.50 111.00 128.50 136.00 153.50 171.00 183.50 171.00
Seasonal adjustment -40.00 -30.00 -20.00 -5.00 0.00 15.00 30.00 40.00 25.00 10.00 0.00 -25.00
Turnover trend:
Growth:

I had to work out the turnover trend which I did but not sure if is correct: 86.00 + 40.00 = 126.00
Growth I worked it out and I came to the conclusion that the growth is 2.5

The second part of the question is to extrapolate the trend and use the seasonal adjustment figure given, forecast the likely turnover for 2018

Jul Aug Sept
Turnover:
Seasonal adjustment 30.00 40.00 25.00
Turnover trend
Growth

I would be really grateful if someone could put me in the right direction as to how to get my head around this. I seem to be having problems with understanding the forecast for future years.

Thank you

Comments

  • PeterC
    PeterC Registered, Tutor Posts: 245 Dedicated contributor 🦉
    See attached spreadsheet. I assume the figures given are for 2017.
  • jmh
    jmh Registered Posts: 42
    Thank you very much for your help. I hope I will get my head around this now.
  • PeterC
    PeterC Registered, Tutor Posts: 245 Dedicated contributor 🦉
    You're welcome
Privacy Policy