Question: wewN D E F G H 1 Problem 21 The following tabulations are actual sales of units for six months and a starting forecast in

 wewN D E F G H 1 Problem 21 The following

wewN D E F G H 1 Problem 21 The following tabulations are actual sales of units for six months and a starting forecast in January 2 Actual Forecast 3 January 100 80 February 94 March 106 April 80 7 May 68 June 94 00 10. Calculate forecasts for the remaining five months using simple exponential smoothing with a=0.2. 12 23 Actual 100 Forecast 80 Insert your formula in the blue cells below. Remember that all formulas begin with a s. January February 94 15 March 106 26 April 888 May June 94 19 21 b. Calculate MAD for the forecasts. 22 23 Actual 24 January 100 25 February 94 Forecast Absolute Deviation 80 20 Insert your formula in the blue cells below. Remember that all formulas begin with a = ON #MUNGU 0 26 March 106 0 27 April 80 0 May 68 0 June 94 30 31 Sum of absolute deviations MAD- 32 33 +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!