# moving averages

donnas1977
Well-KnownRegistered 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

72I'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!

69(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 wrote

was meant to say "The monthly variation in January is 200 units"??

Nick

182thanks for your replies, I will go and have a go at another example and see if I can get this to work out..