moving averages
donnas1977
Registered Posts: 182 Dedicated contributor 🦉
Can someone advise on the following, struggling to get my head around moving averages . I had to complete the table below using a 3 point moving average based on the actual monthly sales volumes for the current year. I got this as my answers and it seemed to match the answers I was given.
Sales volume Trend Monthly variation
August 72,100
September 49,600 62,500 12,900
October 65,800 66,000 200
November 82,600 69,500 13,100
December 60,100
The monthly variation in October is 200 units.
We were then told the additional information
The selling price per unit has been set at £14.50.
Monthly purchases are estimated to be 30% of the value of the forecast sales.
Using the trend and the monthly variations identified in part (a) complete the table below to forecast the sales volume, sales value and purchase value for January ofthe next financial year.
The book answer was given as below. I don’t understand how they get the forecast trend figure?? I can work out the rest of the information
Forecast trend 76,500
variation 200
sales volume 76,700
forecast sales 1,112,150
forecast purchases 333,645
thanks.
donna
Sales volume Trend Monthly variation
August 72,100
September 49,600 62,500 12,900
October 65,800 66,000 200
November 82,600 69,500 13,100
December 60,100
The monthly variation in October is 200 units.
We were then told the additional information
The selling price per unit has been set at £14.50.
Monthly purchases are estimated to be 30% of the value of the forecast sales.
Using the trend and the monthly variations identified in part (a) complete the table below to forecast the sales volume, sales value and purchase value for January ofthe next financial year.
The book answer was given as below. I don’t understand how they get the forecast trend figure?? I can work out the rest of the information
Forecast trend 76,500
variation 200
sales volume 76,700
forecast sales 1,112,150
forecast purchases 333,645
thanks.
donna
0
Comments

Hi Donna
I've just been covering this in college and have worked through your figures and agree with most of the figures except: for Oct you show the variation as 200 and then below as +200. I agree with the 200.
...........S Vol.........Trend.........Var
Aug......72,100
Sept.....49,600.......62,500.......12,900
Oct.......65,800.......66,000......200
Nov......82,600.......69,500......13,100
Dec......60,100.......73,000......12,900
Jan......76,300........76,500......200
Dec  you know the variation is 12,900 and the sales vol is 60,100 so you can work out the trend.
You then need to work out the average increase in the trend:
=(last trend  1st trend)/number of trend movements
=(73,000  62,500)/3
=3,500
So Jan trend
= Dec trend + 3,500
= 73,000 + 3,500
= 76,500
As I think the variation should be 200, I think the sales volume should be 76,300
Hope I haven't confused you. If I'm wrong maybe someone can correct me!0 
I agree with Nia, although my method is slightly different. I would have done:
(69,500  62,500)/2
(Highest trend value calculated  lowest trend value calculated) divided by number of values less 1
I am not sure where the monthly variation figure for January came from unless where you wrotedonnas1977 wrote: »The monthly variation in October is 200 units.
was meant to say "The monthly variation in January is 200 units"??
Nick0 
yes meant to write that the monthly variation in october is 200 units.
thanks for your replies, I will go and have a go at another example and see if I can get this to work out..0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 318 NEW! Qualifications 2022
 156 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 56 AAT Level 3 Diploma in Accounting
 92 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.2K General accounting discussion
 201 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic 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