Forecasting

HSM 260

Forecasting

Exercise 9.1

In the text, exercise 9.1 provides data for Palmdale Human Services. In this exercise it asks for the 20X5 figures using several forecasting models. The process of find 20X5 will include the use of moving averages, weighted moving averages, and exponential smoothing. The Palmdale Human Services personal expenses for the past four years are represented in the following data:

Fiscal Year Expense

20X1 5,250,000

20X2 5,500,000

20X3 6,000,000

20X4 6,750,000

For moving averages and weighted moving averages, use only the data for the past three fiscal years: Moving Averages

Fiscal Year Expenses

20X2 5,500,000

20X3 6,000,000

20X4 6,750,000

20X5 6,083,000

20X2-4 18,250,000...