Part C

The actual demand for the Clorox Pre$-$Moistened Disinfecting Wipes $($in units$)$ at CVS $(2000$ Pennsylvania Ave NW$)$ near GWU for the first $6$ weeks of this year follows:$$

Week Actual no$.$ of demand

$148$

$263$

$352$

$465$

$562$

$670$

CVS operations head Mark Devon wants you to forecast Wipes demand at the CVS store for week $7$ by using above data.

As an operations head you decide to use a weighted moving average foracsting method to find this forecast for week $7.$

Your method uses four actual demand levels, with weights of $0\mathrm{.}30$ on the present period, $0\mathrm{.}25$ one period ago, $0\mathrm{.}25$ two periods ago, and $0\mathrm{.}20$ three periods ago.

Based on your calculations answer the following questions. $($Show your work on the Excel sheet and support your decision with calculation$)$

a$.$ What is the value of your forecast?

b$."$If instead the weights were $18,15,15,$ and $12,$ respectively,

how would the forecast change? Explain why $(2$ to $3$ lines max$)."$

c$.$ What if the weights were $0\mathrm{.}40,0\mathrm{.}30,0\mathrm{.}20,$ and $0\mathrm{.}10,$ respectively?

Now what is the forecast for week $7?$