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?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.