Question

The Park family would like to prepare next month’s family budget by forecasting its family expenses. One item of particular importance is the amount of money spent on food. The following data show the amount of money spent on food for the last 10 months. These data can also be found in the Excel file food expenditures.xlsx.
a. Forecast the family’s food expenditures next month using a three period simple moving average.
b. Forecast the family’s food expenditures next month using a three period weighted moving average with weights 0.7, 0.2, and 0.1.
c. Forecast the family’s food expenditures next month using exponential smoothing when α = 0.1.
d. Which forecast should you choose? Why?


$1.99
Sales0
Views54
Comments0
  • CreatedJuly 29, 2015
  • Files Included
Post your question
5000