A company wants to forecast demand using the weighted moving average. If the company uses three prior yearly sales values (i.e., year 2015 = 230, year 2016 = 220, and year 2017 = 250), and we want to weight year 2015 at 30 percent, year 2016 at 30 percent, and year 2017 at 40 percent, which of the following is the weighted moving average forecast for year 2018?Group of answer choices
Question
A company wants to forecast demand using the weighted moving average. If the company uses three prior yearly sales values (i.e., year 2015 = 230, year 2016 = 220, and year 2017 = 250), and we want to weight year 2015 at 30 percent, year 2016 at 30 percent, and year 2017 at 40 percent, which of the following is the weighted moving average forecast for year 2018?Group of answer choices
Solution
To calculate the weighted moving average forecast for 2018, you would multiply each year's sales by its respective weight and then add those values together.
Here's how you do it:
- Multiply the sales of 2015 by its weight: 230 * 0.30 = 69
- Multiply the sales of 2016 by its weight: 220 * 0.30 = 66
- Multiply the sales of 2017 by its weight: 250 * 0.40 = 100
Then, add those values together: 69 + 66 + 100 = 235
So, the weighted moving average forecast for 2018 is 235.
Similar Questions
A manufacturing company has the monthly demand for its product as shown below.Month DemandFebruary 520March 490April 550May 580June 600July 420August 510September 610Calculate the 3-month weighted moving average forecast for the month of July with weights of 0.5, 0.3 and 0.2 for the most recent demand values, in that order. (answer in whole number)
(a) Calculate the 4-year moving average of the following data related to the sales in a department store.
Relative to a simple moving average, the advantage of a weighted moving average is that the forecast can be more reflective of the most recent observations in a time series.Multiple ChoiceFalseTrue
Consider the following time series: Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Sales 4 6 5 8 9 5 4 3 7 8 Calculate a three-year moving average (MA(3)) for the second subset of three years (i.e. 2011-2013). Round your final answer to two decimal places.
Which of the following uses a weighted average of past time series values as the forecast?Group of answer choicesThe qualitative methodExponential smoothingCorrelation analysisThe causal model
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.