Quantitative Analysis 2

profilembibey

 

Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. A three-month moving average forecast was developed in the table attached.

 

 

 

 

The four-month moving average forecast for Wallace Garden Supply is ___________. (Please round it to an integer and include no units.)

 

 

  
  
  
 

 

 

The Mean Absolute Deviation (MAD) for the above forecast is [removed]. (Please round it to two decimal points.)

The three-year moving average forecast for Wallace Garden Supply is [removed]. (Please round it to two decimal points and include no units.)

 

 

 

The Mean Absolute Deviation (MAD) for the above moving average forecast is [removed]. (Please round it to two decimal points.)

 

 

 

The three-year weighted moving average forecast for Wallace Garden Supply is [removed]. (Please round it to an integer and include no units.)

 

 

 

The Mean Absolute Deviation (MAD) for the above weighted moving average forecast is [removed]. (Please round it to two decimal points.)

 

Based on your previous calculation, which method do you think is the best?

 

 

 

 

Sales of Cool-Man air conditioners have grown steadily during the past 5 years as shown in the attached table. The sales manager had predicted, before the business started, that year 1’s sales would be 410 air conditioners. Please use exponential smoothing with a weight of  \f$\alpha = 0.30\f$to answer the following questions.

 

 

 

 

The starting /initial forecast for the sales of Cool-Man air conditioners is _________. (Please round it to an integer and include no units.)

 

 


   

 

 

 

The Year 2 forecast for the sales of Cool-Man air conditioners is [removed]. (Please round it to an integer and include no units.)

 

 

 

The Year 6 forecast for the sales of Cool-Man air conditioners is [removed]. (Please round it to two decimal points and include no units.)

 

 

 

The Mean Absolute Deviation (MAD) for the above exponential smoothing forecast is [removed]. (Please round it to two decimal points.)


 

    • 10 years ago
    • 5
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      answer.docx