For the questions below, concentrate only on developing forecasts for the periods 3-7. Provide numeric answers, so do not write formulas here. Make sure to not confuse excel cell contents (Periods) with row numbers.

1. What is the forecast for period 5 using the nave forecast method?

_______________________________________

2. What is the forecast for period 6 using the 2-period moving average forecast method?

_______________________________________

3. What is the average absolute error for the nave forecast for periods 3-7?

(Note: This is asking for the average absolute error of periods 3 through 7, not the total.)

_______________________________________

4. What is the average absolute error for the 2-period moving average forecast for periods 3-7? (Note: This is asking for the average absolute error of periods 3 through 7, not the total.)

_______________________________________

A B E D 2 Period Moving Average Forecast Absolute Error Nave Absolute Error Moving Ave 1 2 3 4 5 6 7 8 9 Period 1 2 3 4 5 6 7 Demand Units Nave (in 1000's) Forecast 57 95 58 99 89 89 98