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% Deliverables

ONE EXCEL SHEET FOR EACH GROUP CONTAINING THE FOLLOWING:

1. Include team name and names of team member

2. Complete the following forecast for Week 15 and for all previous period as possible (20 points): a. Nave b. MA (3) c. MA (5) d. WMA e. Exponential Smoothing with a = 0.2 f. Exponential Smoothing with a = 0.4

3. Use the following Excel Functions at least once (10 points): a. Sumproduct() b. Locking Cells c. Average() d. Abs() e. Count()

4. Make a time series chart displaying your forecasts. The most appropriate graph is the line graph (5 Points).

5. Calculate the Mean Absolute Deviation (MAD) and Mean Squared Error (MSE) for each Forecast.

a. According to MAD, which is the most accurate forecast (10 points)?

b. According to MSE, which is the most accurate forecast (10 points)?

Sales Data

Week. Sales ($1000). Naiive. MA(3) MA(5). WMA. EXPO (a=0.2) EXPO(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