Question

In: Operations Management

Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...

Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)?

A.0.00, 0.00,? 0.00, 1.00

B.?0.25, 0.25,? 0.25, 0.25

C.?1.00, 0.00,? 0.00, 0.00

D.0.10, 0.20,? 0.30, 0.40

E. ?0.40, 0.30,? 0.20, 0.10

Solutions

Expert Solution

There is a steady trend in decrease in sales. It is unknown whether rate of decrease in sales is constant, increasing or decreasing. However due to continuous declining trend, forecast for next period will be most influenced by sales of Last period , followed by sales of last to last period and so on .

In other words forecast for period t will be most influenced by sales of period t-1 , then t-2 , followed by t-3 and t-4

Thus maximum weightage should be given to period t-1, followed by t-2 , t-3 and t-4

With above logic, following are not to correct answers :

  1. 0, 0, 0, 1 : It gives no weightage to recent periods and makes sales forecast same as that remained 4 periods back. Therefore, it is not the correct choice
  2. 0.25 ,0.25,0.25.0.25 : This is an example of Moving average forecast and not 4 period WEIGHTED moving average forecast. Putting equal weights effectively means making average of last 4 periods
  3. 1, 0, 0, 0 : This makes forecast value same as last year and therefore there is no decrease
  4. 0.1, 0.2,0.3,0.4 : This is a case of weighted moving average. But it wrongly provides least weightage to recent period . as explained earlier, maximum weightage must be put on recent period due to steady declining trend in value over periods

The correct answer therefore is “E.. 0.4, 0.3, 0.2 , 0.1” which correctly provides maximum weight to immediate previous period and lesser weightage to periods previous to that

ANSWER : E ) 0.40, 0.3, 0.2 , 0.1


Related Solutions

Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
1) Using a 5 period simple moving average, the forecast for period 13 will be:
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
Forecasting methods studied in this class are quantitative techniques including moving average, weighted moving average, exponential...
Forecasting methods studied in this class are quantitative techniques including moving average, weighted moving average, exponential smoothing, linear regression, and exponential smoothing with trend component. You are given a set of past demand data and asked to forecast demand for the future. What would you FIRST do to decide which demand forecasting method to use and why? Please choose one of the forecasting methods listed above.
Of the three quantitative forecasting techniques (moving average, weighted moving average, and exponential smoothing), which do...
Of the three quantitative forecasting techniques (moving average, weighted moving average, and exponential smoothing), which do you think provides the most accurate forecast and why?
develop a? three-period moving average forecast for april 2019
A geneticist discovers a new mutation in Drosophila melanogaster that causes the flies to shake and quiver. She calls this mutation spastic (sps) and determines that it is due to an autosomal recessive gene. She wants to determine if the gene encoding spastic is linked to the recessive gene for vestigial wings (vg). She crosses a fly homozygous for spastic and vestigial traits with a fly homozygous for the wild-type traits and then uses the resulting F1 females in a...
Forecast the price index for Q3 2018 using a​ two-period simple moving average. (Round to two...
Forecast the price index for Q3 2018 using a​ two-period simple moving average. (Round to two decimal places) Calculate the MAD for the forecast in part a (Round to two decimal places) Forecast the price index for Q3 2017 using a​ three-period simple moving average. (Round to two decimal places) Calculate the MAD for the forecast in part c. (Round to two decimal places) Quarter Price Q1 2017 186.4 Q2 2017 190.5 Q3 2017 196.2 Q4 2017 196.2 Q1 2018...
How does a forecast based on a weighted moving average differ from that based on exponential...
How does a forecast based on a weighted moving average differ from that based on exponential smoothing?
Forecasting. Lakeside Hospital has used a 9 month, moving average forecasting method to predict drug and...
Forecasting. Lakeside Hospital has used a 9 month, moving average forecasting method to predict drug and surgical dressing inventory requirements. The actual demand for one item is as shown in table 4 -18. Using the previous moving average data, convert to an exponential smoothing forecast for month 33. Month 24 25 26 27 28 29 30 31 32 Demand 78 65 90 71 80 101 84 60 73
this passage require Analysis and breakdown Moving averages is a forecasting method that uses the average...
this passage require Analysis and breakdown Moving averages is a forecasting method that uses the average of the k most recent data values in the time series as the forecast for the next period (Anderson, Sweeney, Williams, Camm, Cochran, Fry, & Ohlmann). This approach can be used when the company requires immediately forecasting for a massive volume of data. Exponential smoothing a forecasting method that uses a weighted average of past time series values as the forecast; it is a...
When forecasting financial statements, the percentage of sales method of tying forecast variables to sales may...
When forecasting financial statements, the percentage of sales method of tying forecast variables to sales may not be appropriate when: a. The asset or liability does indeed vary as a constant percentage of sales b. There are economies of scale tied to certain assets such as inventory, where higher levels of sales may be supported with little change in the level of assets c. Property, plant, and equipment expenditures to support growth will be “lumpy” over the planning period d....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT