To determine the ideal smoothing constant to be used for a simple exponential smoothing forecasting, a...

 

Transcribed Image Text:

To determine the ideal smoothing constant to be used for a simple exponential smoothing forecasting, a data analyst randomly selected three exponential constants (0,2, 0,5, and 0,8) and produced the forecasts shown in the table of analysis below. Year 2010 2012 2011 9 2013 2014 2016 2017 Sales, (R millions) 2018 6 2019 2015 15 12 15 20 13 8 12 16 Forecast 1 (a = 0,2) Sales, (R millions) 6,6 7,68 9,14 M 12,05 N 11,39 11,51 Forecast 2 (a = 0,5) Sales, (R millions) 7,5 9,75 12,38 16,19 15,59 14,3 P 11,57 Forecast 3 (a=0,8) Sales, (R millions) 8,4 11,28 14,26 18,85 15,77 13,55 9,11 R 2020 18 2021 21 12,41 13,53 Determine the values represented by M, P and R in the table of analysis above? A. M = R12.39 million, P = R13.05 million, and R = 13.42 million B. M = R11.32 million, P = R11.15 million, and R = 11.42 million C. M = R11.32 million, P = R13.05 million, and R = 13.42 million D. M = R12.39 million, P = R11.15 million, and R = 11,42 million Q 15,89 15,08 S To determine the ideal smoothing constant to be used for a simple exponential smoothing forecasting, a data analyst randomly selected three exponential constants (0,2, 0,5, and 0,8) and produced the forecasts shown in the table of analysis below. Year 2010 2012 2011 9 2013 2014 2016 2017 Sales, (R millions) 2018 6 2019 2015 15 12 15 20 13 8 12 16 Forecast 1 (a = 0,2) Sales, (R millions) 6,6 7,68 9,14 M 12,05 N 11,39 11,51 Forecast 2 (a = 0,5) Sales, (R millions) 7,5 9,75 12,38 16,19 15,59 14,3 P 11,57 Forecast 3 (a=0,8) Sales, (R millions) 8,4 11,28 14,26 18,85 15,77 13,55 9,11 R 2020 18 2021 21 12,41 13,53 Determine the values represented by M, P and R in the table of analysis above? A. M = R12.39 million, P = R13.05 million, and R = 13.42 million B. M = R11.32 million, P = R11.15 million, and R = 11.42 million C. M = R11.32 million, P = R13.05 million, and R = 13.42 million D. M = R12.39 million, P = R11.15 million, and R = 11,42 million Q 15,89 15,08 S

Answer rating: 100% (QA)

ANSWER Lets break this down stepbystep Forecast 1 uses an exponential smoothing constant ... View the full answer