Forecasting Assignment - Excel

Forecasting Group Assignment (10% of Final Grade | 55 Points) Due on 10/12.

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. Complete the following forecast for Week 15 and for all previous period as possible (20 points):

a. Naïve b. MA (3) c. MA (5) d. WMA e. Exponential Smoothing with a = 0.2 f. Exponential Smoothing with a = 0.4

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

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

4. 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)?