# Forecasting Chicken Wing Demand

Exercise 1: Forecasting chicken wing demand

The following data represents the weekly demand for chicken wings at a local restaurant during the past six weeks:

 Week 1 2 3 4 5 6 Demand 650 521 563 735 514 596

Complete the following:

a.    Forecast the demand for week 7 using a five-period Moving average.

b.    Forecast the demand for week 7 using a three-period weighted moving average. Use the following weights to obtain your forecast:

o    W1 = 0.5

o    W2 = 0.3

o    W3 = 0.2

c.    Forecast the demand for week 7 using exponential smoothing.

o    Use an α value of 0.1

o    Assume that the forecast for week 6 was 600 units

d.    What assumptions are made in each of the forecasts?

Guidance: Calculate the forecasting values using Excel or manually.

Exercise 2: Forecasting tire demand

The following data represents demand for tires from the Easy fit tire store over a period of 14 days. Split the data into two equal parts of seven days each. Assume F1 = 198.

F1 is the first forecast

 Day Demand Day Demand 1 200 8 208 2 209 9 186 3 215 10 193 4 180 11 197 5 190 12 188 6 195 13 191 7 200 14 196

Complete the following:

a.    Develop a spreadsheet using the first seven days of demand to determine the best exponential smoothing model for values of α = 0.2, α = 0.3, and α = 0.4. Select the model with the smallest absolute deviation for seven periods.

b.    Develop another spreadsheet using the holdout sample for the second seven days to compare the best exponential smoothing model found in part a with a three-period moving average model. Compare the predictions on the basis of the total absolute deviation for the seven periods.

c.    What principles does this problem illustrate?