1. Develop forecasts for months April to July using a moving average model with AP=3 and then...
Question:
1. Develop forecasts for months April to July using a moving average model with AP=3 and then calculated the overall Mean Absolute Deviation (MAD) and Tracking Signal (TS) for months April to June.
2. With an alpha value of 0.3 and a starting forecast in month January equal to actual in month January, develop forecasts for months February t oJuly using exponential smoothing and then calculate the overall MAD and TS for months February to June.
3. Develop a linear regression equation to forecast the sales of the units and then calculate the number of units for month July.
Month Sales
January 100
February 94
March 106
April 80
May 68
June 94
Introduction to Statistical Quality Control
ISBN: 978-1118146811
7th edition
Authors: Douglas C Montgomery