Home For AAT student members AQ 2013 AAT Level 4 (Level 8 in Scotland)

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:

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
Seasonal adjustment 30.00 40.00 25.00
Turnover trend

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


Sign In or Register to comment.