# What Is Moving Average And Is It Used And Applied?

October 14th, 2009 Comments off
Question:

I was asked by management to use moving average method to do the cash collection forecast.

Can you tell me:

(a) What is moving average

(b) How is it use and applied and who commonly uses it.

Suggested Answer:

(a)     What is Moving Average:

• A moving average is an average  that is being revised as new information is received.
• Accountants normally use the moving average to compute forecast as it represent the most recent observations.

Illustrated Example on how to compute Moving Average:-

Simply take the most recent observations to compute an average and update these observations continually as new data becomes available

Mr. A, the accountant has the following cash inflow data:

 Month Cash collection \$’000 March 30 April 40 May 50 Jun 20 July 30 August 60

Using the FIVE-month moving average, cash collection forecast in September is computed as follows:

(40+50+20+30+60)/5=40 = \$40,000

(b)  Hence, the moving average is a prediction model used commonly by forecasters. The forecasters can select the number of periods to use on the basis of the relative importance attached to old data versus current data.

### Related Posts

Comments are closed now.  