Google Answers Logo
View Question
 
Q: quantitative/stats (25) ( Answered,   0 Comments )
Question  
Subject: quantitative/stats (25)
Category: Business and Money > Economics
Asked by: k9queen-ga
List Price: $15.00
Posted: 29 Oct 2003 22:15 PST
Expires: 28 Nov 2003 22:15 PST
Question ID: 271037
sales of Cool-Man air conditioners have grown steadily during the past
five years.

year      sales
----------------
1          450
2          495
3          518
4          563
5          584
6           ?


a)Using a three-year moving average forecasting model to forecast the
sales of Coll-Man air conditioners.
Answer  
Subject: Re: quantitative/stats (25)
Answered By: livioflores-ga on 30 Oct 2003 05:25 PST
 
Hi k9queen!!!

A moving average forecast model is based on a time series in which the
value for a given time period is replaced by the mean of that value
and the values for some number of preceding and succeeding time
periods.
Since the forecast value for any given period is an average of the
previous periods, then the forecast will always appear to "lag" behind
either increases or decreases in the past values.
This forescast method is useful when we can assume that market demands
will stay fairly steady over time.

n-period Moving average = Total demand in previous n periods / n .


In this case:

·three-year moving average forecast for year 4:
(450 + 495 + 518)/3 = 487.67

·three-year moving average forecast for year 5:
(495 + 518 + 563)/3 = 525.33

·three-year moving average forecast for year 6:
(518 + 563 + 584)/3 = 555.00

year      sales     3-year Moving Average Forecast    
---------------------------------------------------- 
1          450                 -
2          495                 -
3          518                 -
4          563               487.67
5          584               525.33  
6           ?                555.00


Note that for years 1, 2 and 3 is not possible to use this forecasting
model because we have not 3 previous periods to use in calculations.


I hope this helps you. Feel free to request for any clarification
needed.

Best regards.
livioflores-ga
Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy