HSM 260 Week 5 checkpoint Forecasting

Forecasting

HSM/260

University of Phoenix

Resource: Ch. 9 in the text

Read & Complete Exercises 9.1 on p. 130 & 9.3 on p. 131.

Forecast personnel expenses and total revenues respectively, using weighted moving averages, moving averages, and exponential smoothing.

Explain how financial trends affect forecasting.

Post your final answers as a Microsoft Word attachment

Exercise 9.1

The following data represent total personnel expenses for the Palmdale Human

Service Agency for past four fiscal years:

20X1 5,250,000

20X2 5,500,000

20X3 6,000,000

20X4 6,750,000

Forecast personnel expenses for fiscal year 20X5 using moving averages, weighted

moving averages, exponential smoothing, and time series regression. For moving

averages and weighted moving...