This assignment will take much longer to prepare than the one in chapter $2.$ Allow yourself adequate time to complete this assignment. You may not want to wait to complete all at once; do each as you review the related material. Try it yourself first before you ask anyone else. Then feel free to contact me for a hint. We could meet online if necessary.

Use Excel to answer all of the following questions:

$1.$ ABC company records during the past six weeks indicate the number of jobs requests:

WEEK

$1$

$2$

$3$

$4$

$5$

$6$

Requests $($ACTUAL$)$

$45$

$38$

$36$

$42$

$46$

$43$

Required: Predict the number of requests for Week $7$ using each of the following methods:

a$.$ Na$$ve

b$.$ A four$-$period moving average.

c$.$ Exponential smoothing with a $=\mathrm{.}30.$ Assume that the forecast for Week $1=43.$