Explore BrainMass
Share

Forecasting: weighted moving average

Historical demand for a product is

DEMAND
January 12
February 11
March 15
April 12
May 16
June 15

a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.

b. Using a simple three-month moving average, find the July forecast.

c. Using single exponential smoothing with α = 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish.

d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data.

e. Using the regression equation in d, calculate the forecast for July.

Thanks

© BrainMass Inc. brainmass.com July 19, 2018, 1:38 pm ad1c9bdddf

Solution Summary

Excel file shows a month's foretasted demand using:
a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.

b. Using a simple three-month moving average
c. single exponential smoothing

d. simple linear regression analysis

$2.19