Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › Forecasting sales
- This topic has 7 replies, 2 voices, and was last updated 3 years ago by John Moffat.
- AuthorPosts
- December 4, 2020 at 1:35 pm #597631
Over an 18-month period, sales have been found to have an underlying linear trend of
y = 7.112 + 3.949x, where y is the number of items sold and x represents the month. Monthly deviations from trend have been calculated and month 19 is expected to be 1.12 times the trend value.
What is the forecast number of items to be sold in month 19?Sir I don’t understand how you get the figure for this question
I took the approach of
y=7.112+3.949(19)And I got the trend
Then I used the equation
Seasonal Variation = Sales-Trend
(82.143*7)+82.143= salesApparently this method is wrong sir and I want to ask why
How did this happen sirMy confusion is why have they assumed the seasonal variation to be the same as sakes because the question clearly asks
‘what is the forecasted number of items to be sold in month of 19’
How did they assume that sales forecast to be as seasonal variation
Isn’t it supposed to be the sales sir?December 4, 2020 at 2:26 pm #597642Y does equal 82.143.
However I have no idea at all how you got your next equation.
The question specifically says that month 19 is expected to be 1.12 times the trend value.
(Which is using the multiplicative approach to the seasonal variations).If the trend value is 82.143, then the forecast is 1.12 x 82.143.
December 6, 2020 at 2:35 pm #597879Sir I used the equation
Forecast= Sales+ Trend
Sir they have asked for the forecast and not the seasonal variation, yet they have used the seasonal variation instead
I’m confused because they specifically say the word
“Monthly deviations from trend ……”
Doesn’t this mean that to find the variation we multiply the trend by 1.12
However we actually need the forecasted figures instead right sir?
December 6, 2020 at 4:06 pm #597899I have no idea where you got your equation from, because it is wrong!!
With the multiplicative model, the forecast is the trend multiplied by the seasonal variation.
Have you watched the lectures on this?
December 6, 2020 at 5:22 pm #597912Oh shoot sorry sir
I meant the equation to be
Forecast =Trend* Seasonal Variation
Please Ignore the equation i earlier put in my previous reply…that was anyways wrong and I accidentally showed it for additive model instead
I understand clearly where i went wrong now..thank you very much sir…but i still have just one small doubt…
Sir how did you figure that this was a multipicative model
It’s because they said the word 1.12 ‘times’ isn’t it
‘Times’ is associated with multipication signs usually and that”s why we assumed it was multipiicative model( yes this concept sort of sounds dumb in regard to a technical formula but I’m just wondering whether this could be a possible reason)
Also in another scenario where the question asks for an additive model but do not directly ask it
How would the question usually be worded so that we know that it is askiing for an additive model?December 7, 2020 at 8:13 am #597965‘Times’ means multiply and so that is why this is the multiplicative model.
If it was the additive model then the variations would be given in units sold.
December 8, 2020 at 3:48 pm #598432I understood the question clearly now sir
Thank you so much for clearing the doubtsDecember 8, 2020 at 3:57 pm #598437You are welcome 🙂
- AuthorPosts
- The topic ‘Forecasting sales’ is closed to new replies.