Calibri L36 11 pt x = 1 Month A B Forecast C Actual Sales 2 March 150 170 3 April 220 229 4 May 205 192 5 June 256 241 6 July 250 238 7 August 260 210 8 September 270 225 9 October 280 179 10 000 11 1. Plot the data and provide insights about the time series. 12 13 14 15 16 E F 17 18 19 2. What is the forecast for November, using a two-period moving average? 20 21 (n) Actual Sales (n-1)+Actual Sales (n-2)/2 Forecast Actual Sales Two period Moving Average 22 Month 23 March 24 April 150 220 + Sheet1 Sheet 1 of 11 Type here to search 170 229 PageStyle Sheet1 Ex De Calibri 11 pt BIU 4abc L36 A fx = B D E F 19 2. What is the forecast for November, using a two-period moving average? 20 21 (n) Actual Sales (n-1) + Actual Sales (n-2)/2 22 Month Forecast Actual Sales Two period Moving Average 23 March 150 170 24 April 220 229 25 May 205 192 199.5 26 June 256 241 210.5 27 July 250 238 216.5 28 August 260 210 239.5 29 September 270 225 30 October 280 179 31 32 33 225+179/2 = 404/2 = 34 35 36 37 3. What is the forecast for November, using a three-period moving average? 38 (n) =Actual Sales (n-1) + Actual Sales (n-3)/3 39 Error Actual-Forcast 40 Month Forecast Actual Sales Three period Moving Average 41 March 150 170 42 April 220 229 + Sheet1 Sheet 1 of 11 PageStyle Sheet1 Eng Type here to search O D Calibri 11 pt BI L36 - fx = A B C D E F 37 3. What is the forecast for November, using a three-period moving average? 38 (n) Actual Sales (n-1)+ Actual Sales (n-3)/3 39 Error Actual Forcast 40 Month Forecast Actual Sales Three period Moving Average 41 March 150 170 42 April 220 229 43 May 205 192 44 June 256 241 197 45 July 250 238 220.66 46 August 260 210 223.66 47 September 270 225 229.66 48 October 280 179 49 50 51 210+225+179/3 614/3= 52 53 54 55 56 57 58 59 60 + Sheet1 Sheet 1 of 1 Type here to search PageStyle Sheet1 Engle O D