Forecasting Group Assignment

Using the raw sales data provided in the Raw Sales Data Excel Sheet, complete each of the questions below.

For the Weighted Moving Average Forecast, please use the following weights:

• Most recent (n): 60%

• Next Most Recent (n-1): 20%

• Next Most Recent (n-2): 15%

• Remainder is 5% ---- WMA=100%

1. Complete the following forecast for Week 15 and for all previous period as possible

PERIOD	SALES ($1000)	NAIIVE	WMA	MA (3)	MA (5)	EXPO (a=0.2)	EXPO (a=0.4)
1	17
2	19
3	17
4	15
5	20
6	18
7	21
8	22
9	19
10	19
11	18
12	20
13	22
14	18
15