Forecasting and Modeling

I am having trouble with the problems attached. I can't figure out the periods, smoothed forecasting and linear regression. I have attached the problem because the tables/graphs look better on a word document rather than in the full description section.

---------------------------------------------------------

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:
Money 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.

Attachments