Details of this Paper

5-12 Develop a four-month moving average forecast for Wallace Garden

Description

solution


Question

5-12 Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD.;A 3-month moving average forecast was developed in the section on moving averages in the Table Below.;MONTH ACTUAL SHED SALES 3-MONTH MOVING AVERAGE;January 10;February 12;March 13;April 16 (10 + 12 + 13)/ 3 = 11.67;May 19 (12 + 13 + 16)/ 3 = 13.67;June 23 (13 + 16 + 19)/ 3 = 16.00;July 26 (16 + 19 + 23)/ 3 = 19.33;August 30 (19 + 23 + 26)/ 3 = 22.67;September 28 (23 + 26 + 30)/ 3 = 26.33;October 18 (26 + 30 + 28)/ 3 = 28.00;November 16 (30 + 28 + 18)/ 3 = 25.33;December 14 (28 + 18 + 16)/ 3 = 20.67;January ? (18 + 16 + 14)/ 3 = 16.00;Wallace Garden Supply decides to forecast storage shed sales by weighting the past 3-months as follows;WEIGHTS APPLIED PERIOD;3 Last month;2 Two months ago;1 Three months ago;3 ? Sales last month + 2 ? Sales two months ago + 1 ? Sales three months ago;6 Sum of the weights

 

Paper#33363 | Written in 18-Jul-2015

Price : $32
SiteLock