Please help me compute this spreadsheet.

Page | 1

Forecasting Case Study


Question 1 Create a spreadsheet template to encapsulate the Simple Moving Average (n=2), Weighted Moving Average (n=2) (0.4, 0.6 weights – higher weight to the most recent data), and exponential model (alpha = 0.3 and forecast for period 1 given at 100). Use the data shown below in data set 1.

Data

  • Month

Data Set 1 (frames)

Data Set 2 (frames)

  • Jan

  • 100

  • 80

  • Feb

  • 90

  • 90

  • Mar

  • 80

  • 85

  • April

  • 100

  • 140

  • May

  • 75

  • 100

  • June

  • 90

  • 90

  • July

  • 100

  • 85