Explore BrainMass

Forecasting using different methods

A manufacturer has experienced the following monthly demand for one of their products

Month Actual Demand (in cases)
Feb 1500
March 2860
April 2950
May 3490
June 3000
July 3200
Aug 3250
Sept 3100
Oct 3300
Nov 3375

Using below forecasters which would be the "best" to use for this manuf?

a. 3 month moving average
b. 2 month moving average
c. linear regression
d. exponential smoothing (.3)
e. exponential smoothing (.8)

Identify the MSE and the next period forecast.

Solution Summary

This posting provides forecasting of demand using different methods including moving average, linear regression and exponential smoothing.