A B D E F G H I j K L M N 0 Part C 1 2 CLOROX 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: 3 4 Week 5 1 6 2 3 7 8 Actual no. of demand 48 63 52 65 62 70 4 5 9 10 6 11 12 CVS operations head Mark Devon wants you to forecast Wipes demand at the CVS store for week 7 by using above data. 13 As an operations head you decide to use a weighted moving average foracsting method to find this forecast for week 7. 14 Your method uses four actual demand levels, with weights of 0.30 on the present period, 0.25 one period ago, 0.25 two periods ago, and 0.20 three periods ago. 15 Based on your calculations answer the following questions. (Show your work on the Excel sheet and support your decision with calculation) 16 17 18 19 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.40, 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7? 21 22 23 24 25 26 27