To determine the ideal smoothing constant to be used for a simple exponential smoothing forecasting, a...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Answer rating: 100% (QA)
ANSWER Lets break this down stepbystep Forecast 1 uses an exponential smoothing constant ... View the full answer
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date:
Students also viewed these finance questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
How to get a good answer using data and analysis tools in jmp 1 uses the other variables to predict "passion." passion would need to be aggregated into high/low first, and then you can use logistic...
-
Heather and Blake play a card game in which they take turns drawing a card from a shuffled deck of 52 cards. Heather wins the game if she draws a heart, and Blake wins the game if he draws a black...
-
You can develop your personal finance skills by conducting an Internet search for related articles. Find a recent online article about personal finance that reinforces one or more concepts covered in...
-
Craxton Engineering will either purchase or lease a new $756,000 fabricator. If purchased, the fabricator will be depreciated on a straight-line basis over seven years. Craxton can lease the...
-
For each of the following cost items (1 through 11), choose the graph (a through l) that best represents it. 1. The cost of utilities at a university. For low student enrollments, utility costs...
-
A ( n ) _ _ _ _ _ _ _ _ _ _ contains a specific piece of information within a record. Field Entity Row Database
-
Find all values of x in the inverval [0,27] for which the following functions are defined. (a) 1 f(x) = cosx V (b) f(x) = -sin x (A) (7) (B) [0,7] (C) (7,27) D) [0,3), (7,27] (E) [1,2] (F) [0,1,1,2]...
-
Write a program in Python that takes a list of numbers and returns a new list containing only the even numbers from the original list, sorted in ascending order. Example Input: Python [5, 3, 2, 8, 1,...
-
According to the journal entries, how many debits did the cash capital stock account have?
-
Stone Beauty, Inc. is a merchandiser of stone ornaments. The company sold 8,000 units during the year. The company has provided the following information: Sales Revenue Purchases (excluding freight...
-
Consider the planar manipulator given in Figure-2. Here, l, and la represent the constant link lengths and d and 8 respectively stand for the first and second joint variables. Find the Kinematic...
-
Revenues Costs and expenses Operating income Other income (expense)* $ 39,588 38,165 1,423 (77) Income before income taxes 1,346 683 $ 663 Income tax expense Net income *Includes $188 of interest...
-
A study was conducted in a school on how students travel to school. Following are the data collected for three methods students use to travel to school: Methods Number of People Carpool 35 Drive 14...
-
On 1 July 2018, Parent Ltd acquired all the shares of Son Ltd, on a cum-div. basis, for $2,057,000. At this date, the equity of Son Ltd consisted of: $ 1,000,000 Share capital 500 000 shares...
-
Reconsider the quadratic programming model given in Prob. 13.7-4. Beginning with the initial trial solution (x1, x2) = (1/2, 1/2), use the automatic procedure in your IOR Tutorial to apply SUMT to...
-
Use parametric linear programming to find an optimal solution for the following problem as a function of , for 0 30. Maximize Z () = 5x1 + 6x2 + 4x3 + 7x4, Subject to and xj 0, for j = 1, 2, 3,...
-
Reconsider Prob. 9.1-4. Starting with the northwest corner rule, interactively apply the transportation simplex method to obtain an optimal solution for this problem. In problem Consider the...
-
Classic LEGO plastic bricks have been fixtures in homes around the world for more than 70 years. Just 15 years ago, The LEGO Group (TLG) was near bankruptcy, spiraling downward and losing money at a...
-
For a sample of data where n = 7 given below: a. Calculate the mean, median, and mode. b. Calculate the range, variance, standard deviation, and coefficient of variation. c. Calculate the Z score....
-
For a sample of data where n = 6 given below: a. Calculate the mean, median, and mode. b. Calculate the range, variance, standard deviation, and coefficient of variation. c. Calculate the Z scores....
Study smarter with the SolutionInn App