Week

Patient Arrivals$/$Actuals

Forecast

$\backslash$table$[[1,400],[2,380],[3,411]]$

a$.$ Prepare a three week moving average forecast for Week $4$

b$.$ If the actual # of patient arrivals in week $4$ is $415,$ what is the forecast error for week $4.$

c$.$ What is the forecast for week $5$ using three week moving average? $($Use week $4$ Actual in Part b$)$

$\backslash$table$[[$Week$,$Patient Arrivals$/$Actuals$],[4,400],[5,380],[6,411]]$

Forecast

d$.$ Prepare a weighted moving average forecast for Week $7($using $\mathrm{.}50,\mathrm{.}30,\mathrm{.}20)$

e$.$ If the actual # of patient arrivals in week $7$ is $415,$ what is the forecast error for week $7.$

f$.$ What is the forecast for week $8$ using weighted moving average? $($Use week $7$ actual in Part e

Week

Patient Arrivals$/$Actuals

Forecast

$\backslash$table$[[1,400],[2,380],[3,411]]$

$390$

Calculate Forecast for week $4$ using exponential smoothing factor of $\mathrm{.}10$