Please use the table below for answering questions a$.,$ b$.,$ c$.,$ and d

weights

$0\mathrm{.}4$

alpha

$($n $=3)$

$0\mathrm{.}6$

$0\mathrm{.}4$

DAY DEMAND

Simple

Weighted

Exponential

$($t$)$

$($Dt$)$

Moving Avg Moving Avg

Smoothing

$1$

$497$

$2$

$496$

$497\mathrm{.}0$

$3$

$4$

$5$

$6$

$8$

$9$

$504$

$508$

$518$

$523$

$522$

$517$

$518$

$496\mathrm{.}6$

$499\mathrm{.}0$

$500\mathrm{.}8$

$499\mathrm{.}6$

$502\mathrm{.}7$

$506\mathrm{.}4$

$502\mathrm{.}9$

$510\mathrm{.}0$

A

$514\mathrm{.}0$

$509\mathrm{.}0$

$521\mathrm{.}0$

$514\mathrm{.}6$

$10$

$527$

$11$

$521\mathrm{.}0$

$520\mathrm{.}7$

$519\mathrm{.}0$

$520\mathrm{.}7$

$522\mathrm{.}4$

$519\mathrm{.}0$

$517\mathrm{.}5$

$5173$

$12$

$13$

$14$

$534$

$537$

$537$

$541$

$526\mathrm{.}3$

$532\mathrm{.}7$

$536\mathrm{.}0$

$15$

$538\mathrm{.}3$

B

$523\mathrm{.}4$

$531\mathrm{.}2$

$535\mathrm{.}8$

$537\mathrm{.}0$

$539\mathrm{.}4$

$517\mathrm{.}6$

$521\mathrm{.}4$

C

$530\mathrm{.}9$

$533\mathrm{.}3$

$536\mathrm{.}4$

Find the value for $\text{'}$A$\text{'}$ in the table $($please keep $1$ demical place$)$:

b$.$ Find the value for $\text{'}$B$\text{'}$ in the table $($please keep $1$ demical place$)$:

c$.$ Find the value for $\text{'}$C$\text{'}$ in the table $($please keep $1$ demical place$)$:

d$.$

If demand on Day $12($D$12)$ were changed and the spreadsheet updated accordingly, which

forecasts on day $15($F$15)$ would change? Select "Yes" for all that apply and $"$No$"$ for all that

does not.

The Simple Moving Average forecast

The Weighted Moving Average forecast

he Exponential Smoothing forecast