Ask Question
24 May, 21:15

A company wants to forecast demand using the weighted moving average. If the company uses two prior yearly sales values (i. e., year 2012 = 110 and year 2013 = 130), and we want to weight year 2015 at 20% and year 2016 at 80%, which of the following is the weighted moving average forecast for year 2017? A. 126 B. 128 C. 133 D. 38 E. 142

+2
Answers (1)
  1. 24 May, 23:56
    0
    option (A) 126

    Explanation:

    Data provided in the question:

    Sales value for the year 2012 = 110

    Sales value for the year 2013 = 130

    Weight for the year 2015 = 20% = 0.20

    Weight for the year 2016 = 80% = 0.80

    Now,

    In the weighted moving average method of forecasting

    New forecast = ∑ (Previous forecasts * weights for the given year)

    thus,

    Forecast for the year 2017

    = (Sales in 2015 * weight for 2015) + (Sales in 2016 * weight for 2016)

    since,

    the sales value for 2012 and 2013 are taken for the years 2015 and 2016

    therefore,

    Forecast for the year 2017 = (110 * 0.20) + (130 * 0.80)

    = 22 + 104

    = 126.00

    Hence,

    The correct answer is option (A) 126
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “A company wants to forecast demand using the weighted moving average. If the company uses two prior yearly sales values (i. e., year 2012 = ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers