Problem:
Forecasting and Modeling
1. Given the following data on the number of pints of ice cream sold at a local ice cream store for a 6-period time frame:
Period Demand
1 200
2 245
3 190
4 270
5 280
6 300
Compute a 3-period moving average for period 4.
2. The following data summarizes the historical demand for a product
|
Month
|
Actual demand
|
|
March
|
20
|
|
April
|
25
|
|
May
|
40
|
|
June
|
35
|
|
July
|
30
|
|
August
|
45
|
Use a four period moving average and determine the forecasted demand for July and August.
3. The following data summarizes the historical demand for a product
|
Month
|
Actual demand
|
|
March
|
20
|
|
April
|
25
|
|
May
|
40
|
|
June
|
35
|
|
July
|
30
|
|
August
|
45
|
Use exponential smoothing with and the smoothed forecast for July is 32 and determine August and September's smoothed forecasts.
4. The following sales data are available for 1998-2003 inclusive:
|
Year
|
Sales
|
|
1998
|
7
|
|
1999
|
12
|
|
2000
|
14
|
|
2001
|
20
|
|
2002
|
16
|
|
2003
|
25
|
Determine a 4-year moving average forecast for each possible year.
5. Robert has the following accounts on money spent on gambling and winnings:
Monry spent Money won
1000 2500
1200 4000
11800 4500
2000 4600
2500 5000
2800 4800
3500 5600
4000 6000
4200 5800
7000 X
Using linear regression, predict x.