QUESTION 23 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 2011 2013 2014 2012 12 2015 2016 2017 2018 2019 2020 Sales, (R millions) 2021 6 9 15 20 15 13 8 12 16 18 21 Forecast 1 (a = 0,2) Sales, (R millions) 6,6 QUESTION 25 7,68 9,14 M 12.05 N 11,39 11,51 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. MR11.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 Forecast 2 (a=0.5) Sales, (R millions) 7,5 9,75 12,38 16,19 15.59 14.3 P 11,57 Q 15.89 QUESTION 24 Determine the values represented by N, Q and S in the table of analysis in question 23? A. N=R11.52 million, Q = R15.08 million, and S= 118.12 million B. N=R12.24 million, Q = R13.79 million, and S= 17.42 million C. N = R12.38 million, Q = R13.85 million, and S= 18.17 million D. N=R11.51 million, Q = R14.15 million, and S= 17.83 million Forecast 3 (a=0,8) Sales, (R millions) 8,4 11,28 14,26 18,85 15,77 13,55 9.11 R 15,08 S Using the forecasts for the 2012-2021 period, determine the mean absolute deviation (MAD) of Forecast 1, Forecast 2 and Forecast 3. A. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 6.32, 4.16 and 3.76 respectively. B. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 6.32, 4.21 and 4.06 respectively. C. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 5.06, 4.21 and 3.76 respectively. D. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 5.06, 4.20 and 3.92 respectively.

Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter7: Integration
Section7.CR: Chapter 7 Review
Problem 88CR
icon
Related questions
Question
QUESTION 23
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
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
Sales, (R millions)
6
9
12
15
20
15
13
8
12
16
18
21
QUESTION 24
Forecast 1
(a = 0,2)
Sales, (R millions)
QUESTION 25
6,6
7,68
9,14
M
12,05
N
11,39
11,51
12,41
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. MR11.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
13,53
Forecast 2
(a = 0,5)
Sales, (R millions)
7,5
9,75
12,38
16,19
15,59
14,3
P
11,57
Q
15,89
Determine the values represented by N, Q and S in the table of analysis in question 23?
A. N = R11.52 million, Q = R15.08 million, and S=1f8.12 million
B. N = R12.24 million, Q = R13.79 million, and S = 17.42 million
C. N = R12.38 million, Q = R13.85 million, and S= 18.17 million
D. N = R11.51 million, Q = R14.15 million, and S= 17.83 million
Forecast 3
(a = 0,8)
Sales, (R millions)
8,4
11,28
14,26
18,85
15,77
13,55
9,11
R
15,08
S
Using the forecasts for the 2012-2021 period, determine the mean absolute deviation (MAD) of Forecast 1, Forecast 2 and Forecast 3.
A. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 6.32, 4.16 and 3.76 respectively.
B. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 6.32, 4.21 and 4.06 respectively.
C. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 5.06, 4.21 and 3.76 respectively.
D. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 5.06, 4.20 and 3.92 respectively.
(4
(4
(4
Transcribed Image Text:QUESTION 23 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 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Sales, (R millions) 6 9 12 15 20 15 13 8 12 16 18 21 QUESTION 24 Forecast 1 (a = 0,2) Sales, (R millions) QUESTION 25 6,6 7,68 9,14 M 12,05 N 11,39 11,51 12,41 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. MR11.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 13,53 Forecast 2 (a = 0,5) Sales, (R millions) 7,5 9,75 12,38 16,19 15,59 14,3 P 11,57 Q 15,89 Determine the values represented by N, Q and S in the table of analysis in question 23? A. N = R11.52 million, Q = R15.08 million, and S=1f8.12 million B. N = R12.24 million, Q = R13.79 million, and S = 17.42 million C. N = R12.38 million, Q = R13.85 million, and S= 18.17 million D. N = R11.51 million, Q = R14.15 million, and S= 17.83 million Forecast 3 (a = 0,8) Sales, (R millions) 8,4 11,28 14,26 18,85 15,77 13,55 9,11 R 15,08 S Using the forecasts for the 2012-2021 period, determine the mean absolute deviation (MAD) of Forecast 1, Forecast 2 and Forecast 3. A. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 6.32, 4.16 and 3.76 respectively. B. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 6.32, 4.21 and 4.06 respectively. C. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 5.06, 4.21 and 3.76 respectively. D. The MAD of Forecast 1, Forecast 2, and Forecast 3 are 5.06, 4.20 and 3.92 respectively. (4 (4 (4
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Recommended textbooks for you
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL