Question

Prepare weekly forecasts for week 15 for each product using Moving Average forecasting technique using a 2 -6 period moving average. Then use error analysis or forecast accuracy techniques for the 2 - 6 period moving averages.

Week	Product 1	Product 2
1	50	40
2	54	38
3	57	41
4	60	46
5	64	42
6	67	41
7	90	41
8	76	47
9	79	42
10	82	43
11	85	42
12	87	49
13	92	43
14	96	44

Answer 1

Forecast and Error analysis for product 1 is following:

EXCEL FORMULAS:

For product 1, MAD (Mean Absolute Deviation) is the lowest for 2 period moving average (2-SMA) . Therefore, 2-SMA provides the most accurate forecast for product 1

-----------------------------

Forecast and Error analysis for product 2 is following:

For product 2, MAD (Mean Absolute Deviation) is the lowest for 4 period moving average (4-SMA) . Therefore, 4-SMA provides the most accurate forecast for product 2