unit 15 - trend/seasonal variation help
lisnic
Registered Posts: 141 Dedicated contributor 🦉
ok i have 1 additional question to do on my unit 15 sim - i knew i had trashed this question!!! everything else on my feedback was pretty perfect!
ive been told it will be a totally different question wont be asked to do the same question again
ive looked in my notes as the sheet i received said revise trends and seasonal variations when you are given actual figures (ie sales) and the seasonal variations and asked to work out the trend and then forecasting future figures
how to i do i do this as in my notes i cant see any examples or anything doing as such?? i asked the marker where i went wrong and all i could be told was that id tried to do a moving average when infact it was a much simpler calculation
also i take it it will be the same sort of question asking similar to what was in sim not something totally different?
not great timng doing this tomorrow and 2 exams next week so having to stop my exam study for a morning today ahhh!
ive been told it will be a totally different question wont be asked to do the same question again
ive looked in my notes as the sheet i received said revise trends and seasonal variations when you are given actual figures (ie sales) and the seasonal variations and asked to work out the trend and then forecasting future figures
how to i do i do this as in my notes i cant see any examples or anything doing as such?? i asked the marker where i went wrong and all i could be told was that id tried to do a moving average when infact it was a much simpler calculation
also i take it it will be the same sort of question asking similar to what was in sim not something totally different?
not great timng doing this tomorrow and 2 exams next week so having to stop my exam study for a morning today ahhh!
0
Comments
-
ive looked in my notes as the sheet i received said revise trends and seasonal variations when you are given actual figures (ie sales) and the seasonal variations and asked to work out the trend and then forecasting future figures
how to i do i do this as in my notes i cant see any examples or anything doing as such?? i asked the marker where i went wrong and all i could be told was that id tried to do a moving average when infact it was a much simpler calculation
A much simpler calculation? I'm not 100% sure, but I have a hunch about what he was getting at.
What you have is two sets of figures: one for actual sales and one for the amount of seasonal variation, right? I think what you're supposed to do is subtract the seasonal variation from the actual sales for each month/week/quarter to give a deseasonalised sales figure (caution: may not be the right name).
Then you use the new figure to find a trendline without the seasonal figures getting in the way.
eg
Actual: 1Q: 9000 units 2Q: 9000 units 3Q: 5000 units: 4Q: 7000 units
Seasonal: 1Q: +5000 units 2Q: +4000 units 3Q: -1000 units: 4Q: +0 units
Deseasonal: 1Q: 4000 units 2Q: 5000 units 3Q: 6000 units: 4Q: 7000 units
Sorry, I couldn't get that to line up better,but if you look I've taken the seasonal variation off the actual sales, to give a deseasonal figure. You can tell from this that sales are increasing by 1000 units per quarter, which you couldn't tell from the actual figures.0 -
yeah i see that
so what would i then to forecast if say the last known figures are 2 or 3 quarters behind where i need to start my forecast0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership