Share
Explore BrainMass

Forecasting

Please help... b & c can be done with the attached template, but I do not know how to implement the data...

Historical demand for a product is:
Demand
Jan 12
Feb 11
March 15
APril 12
May 16
June 15

a. using weighted moving average with weights of .60, .30 and .10. What is July forecast?
b. Using a simple three month moving average, find July forecast?
c. Using single exponential smoothing with alpha= 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish.

Attachments

$2.19