Units 8 & 9 Chapter 4 Help!
mi|kshake
Registered Posts: 70 Regular contributor ⭐
Hi,
Been stuck on this for a couple of days and am hoping someone can help! I'm sure it's fairly obvious but I can't see it!
Activity 4 asks you to calculate the forecast sales turnover using absolute seasonal variations, which looking at the example seems fairly easy to understand. Just work out the percentage and the ad to the sales right?
So here's what I've put for the first quarter:
Absolute Forecast % Forecast %
Qtr Season Trend Variance (absolute)Variance
17 A 2680000 350000 3030000 115 3082500
The actual answer for the forecast % is £3082000. I have also tried using the same method for the remaining quarters but am way out. Here is how I calculated the 3082500:
=3030000+(350000/100*15)
Any help greatly appreciated!
mi|kshake~
Been stuck on this for a couple of days and am hoping someone can help! I'm sure it's fairly obvious but I can't see it!
Activity 4 asks you to calculate the forecast sales turnover using absolute seasonal variations, which looking at the example seems fairly easy to understand. Just work out the percentage and the ad to the sales right?
So here's what I've put for the first quarter:
Absolute Forecast % Forecast %
Qtr Season Trend Variance (absolute)Variance
17 A 2680000 350000 3030000 115 3082500
The actual answer for the forecast % is £3082000. I have also tried using the same method for the remaining quarters but am way out. Here is how I calculated the 3082500:
=3030000+(350000/100*15)
Any help greatly appreciated!
mi|kshake~
0
Comments
-
Hi, we are using the Osborne book, but I did spot something about the figures.
2,680,000 x (115 / 100) = 3,082,000
This leads me to believe that the first figure is the trend to which you add 15 % to get the forecast for the quarter.
I don't know what the other figures are - could they be the actual variation and actual sales figures?
I would call this a "percentage seasonal variation" not an "absolute seasonal variation", so I am not sure why your activity is worded in the way you report it.
Hope this helps!0 -
mi|kshake
I have put the data into a spreadsheet (and found I can only upload word documents) so that is attached to this reply.
The 115 value appears to be a seasonal index, which definive.studies would quite rightly call a "percentage seasonal variation".
This means you have a single trend value of 2,680,000 and two different forecasts values depending on the way you adjust for the seasonality.
In your initial posting you saidActivity 4 asks you to calculate the forecast sales turnover using absolute seasonal variations
Incidentally, I divided the £3,082,500 forecast value (which would be multiplicative answer) by the £2,680,000 trend value and found that it is not exactly 15% higher than the trend, so the 115 index number is probably a rounded off amount. See the attached file for the unrounded index value.
As forecasting is inevitably imprecise, I would find a value of £3,082,500 no more useful than £3,082,000 in a practical sense so please do not be dragged into the numbers so much that you overlook the reason why we produce them.Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
Thanks for your help guys! I get it now! Dunno why I didn't try that before - not so hard to figure out when I think about it!
mi|kshake~0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 325 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 274 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 202 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