moving averages
donnas1977
Registered Posts: 182 ? ? ?
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
 18.9K For AAT students
 247 NEW! Qualifications 2022
 137 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 33 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.3K General accounting discussion
 193 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 589 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership