Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › Time series
- This topic has 5 replies, 2 voices, and was last updated 5 years ago by
John Moffat.
- AuthorPosts
- September 7, 2019 at 7:36 am #545397
The trend of a product has been calculated as a decrease in sales of 2 units/quarter
and seasonal variation of Q4 = -15
Sales for Q4 2017 is 320 units
using additive model what is predicted sales for Q4 2018 ?320 + (- 2* 4 quarter) + (-15) = 297 units
but answer says 312September 7, 2019 at 9:20 am #545413If you have typed it all out correctly then it seems that the answer is 297 units.
Does the answer in your book not show the workings also?
September 7, 2019 at 9:59 am #545421320- 15 + (- 2* 4 quarter) + (-15) = 312 units
this is the working
September 7, 2019 at 3:29 pm #545470My mistake – the answer is correct.
If the actual sales in Q4 2017 were 320, then because there is a seasonal variation of -15, the trend would be 320 + 15 = 335.
Therefore for Q4 2018, the forecast is 335 – (4×2) – 15 = 312
September 8, 2019 at 6:40 am #545528but that seasonal variation is what we are adjusting at the end isnt it ? why adjust it twice ?
September 8, 2019 at 9:13 am #545539The seasonal variation will occur in every Q4. So the actual sales in 2017 will include the effect of the seasonal variation.
- AuthorPosts
- You must be logged in to reply to this topic.