Additional homework problems are available at www$.$pearsonhighered.com$/$bozarth$.$ These problems use Excel to generate customized problems for different class sections or even different students.

$(*=$ easy; $**=$ moderate; $***=$ advanced$)$

Problems for Section $9\mathrm{.}5$: Time Series Forecasting Models$$Basic Problems

For problems $1$ through $3,$ use the following time series data:

PERIOD

DEMAND

$10$

$248$

$11$

$370$

$12$

$424$

$13$

$286$

$14$

$444$

$(*)$ Develop a three$-$period moving average forecast for periods $1315.$

$(*)$ Develop a two$-$period weighted moving average forecast for periods $12$ through $15.$ Use weights of $0\mathrm{.}7$ and $0\mathrm{.}3,$ with the most recent observation weighted higher.

$(*)$ Develop an exponential smoothing forecast for periods $11$ through $15.$ Assume that your forecast for period $10$ was $252.$

For problems $4$ through $6,$ use the following time series data: